4 Messages
Digest #4002
Messages
Wed May 10, 2017 8:00 pm (PDT) . Posted by:
joelfp2000
Randy,
Thanks again so much for all of your help. Wow...I know you are working your fanny off keeping up with all the changes.
I'm trying to use the Morningstar website to retrieve 3 bits of data...the 3 year category standard deviation, the 3 year category Sharpe and the 3 year category Alpha. I've been able to bring in a lot of data from Morningstar but these three have me stumped.
Here is the formula I have been fiddling with for the standard deviation but can't get it to work.
=smfConvertData(smfStrExtr(smfGetTagContent("http://performance.morningstar.com/RatingRisk/fund/volatility-capture.action?t="&$A$2,"td",8,">"&$A$2),"~","<"))
What am I missing?
Thanks in advance for your help.
Joel
Thanks again so much for all of your help. Wow...I know you are working your fanny off keeping up with all the changes.
I'm trying to use the Morningstar website to retrieve 3 bits of data...the 3 year category standard deviation, the 3 year category Sharpe and the 3 year category Alpha. I've been able to bring in a lot of data from Morningstar but these three have me stumped.
Here is the formula I have been fiddling with for the standard deviation but can't get it to work.
=smfConvertData(smfStrExtr(smfGetTagContent("http://performance.morningstar.com/RatingRisk/fund/volatility-capture.action?t="&$A$2,
What am I missing?
Thanks in advance for your help.
Joel
Wed May 10, 2017 9:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The M* web page you are using in your function no longer exists. Try:
=smfGetTagContent("
http://performance.morningstar.com/ratrisk/RatingRisk/fund/volatility-measurements.action?y=3&ep=true&t=
"&$D6,"td",1,"Category:",,,,1)
=smfGetTagContent("
http://performance.morningstar.com/ratrisk/RatingRisk/fund/volatility-measurements.action?y=3&ep=true&t=
"&$D6,"td",3,"Category:",,,,1)
=smfGetTagContent("
http://performance.morningstar.com/ratrisk/RatingRisk/fund/mpt-statistics.action?y=3&ep=true&t=
"&$D6,"td",4,"Category:",,,,1)
On Wed, May 10, 2017 at 8:00 PM, joel.andrews@
...wrote:
> Thanks again so much for all of your help. Wow...I know you are working
> your fanny off keeping up with all the changes.
>
> I'm trying to use the Morningstar website to retrieve 3 bits of data...the
> 3 year category standard deviation, the 3 year category Sharpe and the 3
> year category Alpha. I've been able to bring in a lot of data from
> Morningstar but these three have me stumped.
>
> Here is the formula I have been fiddling with for the standard deviation
> but can't get it to work.
>
> =
>
> smfConvertData(smfStrExtr(smfGetTagContent("http://
> performance.morningstar.com/RatingRisk/fund/volatility-capture.action?t=
> "&$A$2,"td",8,">"&$A$2),"~","<"))
>
> What am I missing?
>
=smfGetTagContent("
http://performance.morningstar.com/ratrisk/RatingRisk/fund/volatility-measurements.action?y=3&ep=true&t=
"&$D6,"td",1,"Category:",,,,1)
=smfGetTagContent("
http://performance.morningstar.com/ratrisk/RatingRisk/fund/volatility-measurements.action?y=3&ep=true&t=
"&$D6,"td",3,"Category:",,,,1)
=smfGetTagContent("
http://performance.morningstar.com/ratrisk/RatingRisk/fund/mpt-statistics.action?y=3&ep=true&t=
"&$D6,"
On Wed, May 10, 2017 at 8:00 PM, joel.andrews@
...wrote:
> Thanks again so much for all of your help. Wow...I know you are working
> your fanny off keeping up with all the changes.
>
> I'm trying to use the Morningstar website to retrieve 3 bits of data...the
> 3 year category standard deviation, the 3 year category Sharpe and the 3
> year category Alpha. I've been able to bring in a lot of data from
> Morningstar but these three have me stumped.
>
> Here is the formula I have been fiddling with for the standard deviation
> but can't get it to work.
>
> =
>
> smfConvertData(
> performance.
> "&$A$2,
>
> What am I missing?
>
Thu May 11, 2017 7:20 am (PDT) . Posted by:
carmine288
Hi Randy,
What would be best way to grab the Dividend Declarations page from WSJ Market Data:
http://online.wsj.com/mdc/public/page/2_3022-dividends-20170503.html?mod=mdc_pastcalendar http://online.wsj.com/mdc/public/page/2_3022-dividends-20170503.html?mod=mdc_pastcalendar
Note that the page length varies from day-to-day.
Thanks,
What would be best way to grab the Dividend Declarations page from WSJ Market Data:
http://online.wsj.com/mdc/public/page/2_3022-dividends-20170503.html?mod=mdc_pastcalendar http://online.wsj.com/mdc/public/page/2_3022-dividends-20170503.html?mod=mdc_pastcalendar
Note that the page length varies from day-to-day.
Thanks,
Thu May 11, 2017 9:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can grab the whole table at once, with:
=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3022-dividends-20170503.html?mod=mdc_pastcalendar
",">INCREASED")
That web page is a week old, though?
On Thu, May 11, 2017 at 7:20 AM, carmine.nicoletta@
...wrote:
> What would be best way to grab the Dividend Declarations page from WSJ
> Market Data:
>
> http://online.wsj.com/mdc/public/page/2_3022-dividends-
> 20170503.html?mod=mdc_pastcalendar
>
> Note that the page length varies from day-to-day.
>
>
=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3022-dividends-20170503.html?mod=mdc_pastcalendar
",">INCREASED")
That web page is a week old, though?
On Thu, May 11, 2017 at 7:20 AM, carmine.nicoletta@
...wrote:
> What would be best way to grab the Dividend Declarations page from WSJ
> Market Data:
>
> http://online.wsj.com/mdc/public/page/2_3022-dividends-
> 20170503.html?
>
> Note that the page length varies from day-to-day.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar