4 Messages
Digest #3399
1b
Re: Morningstar Questions: Financial Health Rating, FCF/Net Income, by "Randy Harmelink" rharmelink
Messages
Mon May 4, 2015 8:19 am (PDT) . Posted by:
bozzboy1
Hi
First off massive thanks for this add-in - it's absolutely incredible and has already saved me huge amounts of time.
I have a few things I want to add to my spreadsheet, which I can't seem to get to work.
- Morningstar financial health rating.
In the help file says to use: http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=~~~~~;2;STOCK GRADES;FINANCIAL HEALTH; ; ;0;0;0;0
No idea how to use this formula however and element 884 doesn't seem to work either.
- Morningstar FCF/Net Income.
Only yesterday I was using element number 14388 but now this returns an error message. Any ideas?
- Morningstar FCF.
Again, yesterday 14355 was working but now returns an error message.
Any help would be massively appreciated!
First off massive thanks for this add-in - it's absolutely incredible and has already saved me huge amounts of time.
I have a few things I want to add to my spreadsheet, which I can't seem to get to work.
- Morningstar financial health rating.
In the help file says to use: http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=~~~~~;2;STOCK GRADES;FINANCIAL HEALTH; ; ;0;0;0;0
No idea how to use this formula however and element 884 doesn't seem to work either.
- Morningstar FCF/Net Income.
Only yesterday I was using element number 14388 but now this returns an error message. Any ideas?
- Morningstar FCF.
Again, yesterday 14355 was working but now returns an error message.
Any help would be massively appreciated!
Mon May 4, 2015 8:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
#884 is the Credit Rating, not the Financial Health rating, which is #883.
Initially, I was also getting "Error" results on the elements. However,
when I checked the web site, I found out they are doing a redirect of any
visit to their website for member verification. You need to visit the web
site with the EXCEL Web Query dialgo (alt+d+d+w) or with IE, to clear the
cookie setting so that MorningStar knows you have gone through their
verification process. This used to be something you needed to do once each
day, so I hope they haven't returned to that...
Once I did that and ran the smfForceRecalculation macro to reload the web
pages, the elements worked fine.
On Mon, May 4, 2015 at 4:53 AM, bozzboy1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> First off massive thanks for this add-in - it's absolutely incredible and
> has already saved me huge amounts of time.
>
> I have a few things I want to add to my spreadsheet, which I can't seem to
> get to work.
>
> - Morningstar financial health rating.
>
> In the help file says to use:
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=~~~~~;2;STOCK
> GRADES;FINANCIAL HEALTH; ; ;0;0;0;0
>
> No idea how to use this formula however and element 884 doesn't seem to
> work either.
>
> - Morningstar FCF/Net Income.
>
> Only yesterday I was using element number 14388 but now this returns an
> error message. Any ideas?
>
> - Morningstar FCF.
>
> Again, yesterday 14355 was working but now returns an error message.
>
> Any help would be massively appreciated!
>
>
Initially, I was also getting "Error" results on the elements. However,
when I checked the web site, I found out they are doing a redirect of any
visit to their website for member verification. You need to visit the web
site with the EXCEL Web Query dialgo (alt+d+d+w) or with IE, to clear the
cookie setting so that MorningStar knows you have gone through their
verification process. This used to be something you needed to do once each
day, so I hope they haven't returned to that...
Once I did that and ran the smfForceRecalculation macro to reload the web
pages, the elements worked fine.
On Mon, May 4, 2015 at 4:53 AM, bozzboy1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> First off massive thanks for this add-in - it's absolutely incredible and
> has already saved me huge amounts of time.
>
> I have a few things I want to add to my spreadsheet, which I can't seem to
> get to work.
>
> - Morningstar financial health rating.
>
> In the help file says to use:
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=~~~~~;2;STOCK
> GRADES;FINANCIAL HEALTH; ; ;0;0;0;0
>
> No idea how to use this formula however and element 884 doesn't seem to
> work either.
>
> - Morningstar FCF/Net Income.
>
> Only yesterday I was using element number 14388 but now this returns an
> error message. Any ideas?
>
> - Morningstar FCF.
>
> Again, yesterday 14355 was working but now returns an error message.
>
> Any help would be massively appreciated!
>
>
Mon May 4, 2015 9:40 am (PDT) . Posted by:
woodburydance
Thank you Randy,
That is much better. I get 14 groups with this element:
Aerospace Auto-Tires-Trucks Basic Materials Business Services Computer and Technology Consumer Discretionary Consumer Staples Error Finance Industrial Products Medical Oils-Energy Retail-Wholesale Transportation
Bruce
That is much better. I get 14 groups with this element:
Aerospace Auto-Tires-Trucks Basic Materials Business Services Computer and Technology Consumer Discretionary Consumer Staples Error Finance Industrial Products Medical Oils-Energy Retail-Wholesale Transportation
Bruce
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar