Selasa, 05 Mei 2015

[smf_addin] Digest Number 3399

4 Messages

Digest #3399

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!



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!
>
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar