Selasa, 30 April 2019

[smf_addin] Digest Number 4531

5 Messages

Digest #4531
1a
Re: Source for Option Quotes & Other data by "Randy Harmelink" rharmelink
1c
Re: Source for Option Quotes & Other data by "Randy Harmelink" rharmelink
2a
Marketgrader by nelsonmuntz1000
2b
Re: Marketgrader by "Randy Harmelink" rharmelink

Messages

Mon Apr 29, 2019 8:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's not something I look at. Best bet would be to take a scan through the
element definition list.

I know the Yahoo Key Statistic page has something called "Leveraged Free
Cash Flow".

On Mon, Apr 29, 2019 at 5:26 AM alberto.ratti@... wrote:

>
> Could you list some items of the "various sources" (regardless the
> "definition" of Free Cash Flow we are interested in)?
>
> Just to let us deepen – on our own choice – the Free Cash Flow issue.
>
>
>

Mon Apr 29, 2019 8:57 am (PDT) . Posted by:

alberto.ratti

RANDY,
Thanks, once more, for your kindness.
I have followed your advice and the reach - for my purpose - was the
SMF-Template-Morningstar-Key-Ratios.xls template.
On the bottom:
Description
Element Definition
Operating Cash Flow Growth (YOY)
14354
Free Cash Flow Growth (YOY)
14365
Cap Ex as a % of Sales
14376
Free Cash Flow/Sales
14387
Free Cash Flow/Net Income
14398

For the first two items (element #14354, #14365) I get "0.0%", all the time, whatever ticker I enter.
Is it ok?

Mon Apr 29, 2019 10:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It looks like MorningStar isn't populating those two items:

https://quicktake.morningstar.com/stocknet/CashFlowRatios10.aspx?Symbol=MMM

Aside from that, I'm not sure how well they are updating those quicktake
pages...?

On Mon, Apr 29, 2019 at 9:09 AM alberto.ratti@... wrote:

>
> I have followed your advice and the reach - for my purpose - was the
>
> *SMF-Template-Morningstar-Key-Ratios.xls* template.
>
> On the bottom:
>
> *Description*
>
> *Element Definition*
>
> *Operating Cash Flow Growth (YOY)*
>
> 14354
>
> *Free Cash Flow Growth (YOY)*
>
> 14365
>
> *Cap Ex as a % of Sales *
>
> 14376
>
> *Free Cash Flow/Sales *
>
> 14387
>
> *Free Cash Flow/Net Income *
>
> 14398
>
>
>
> For the first two items (element #14354, #14365) I get "0.0%", all the
> time, whatever ticker I enter.
>
> Is it ok?
>
>
>

Mon Apr 29, 2019 8:19 pm (PDT) . Posted by:

nelsonmuntz1000

Hi Randy


Hope all is well


Your solution from Aug 2015 looked like it stopped accessing Marketgrader today. Direct link for a selected ticker looks like it takes you to a generic intro page and the add-in formula stopped extracting data. Looks like things may have changed.


Just a heads up.
29051Re: [smf_addin] MarketGrader Scores
Expand Messages


Randy Harmelink
Aug 26, 2015



It's no longer in a "div" tag. Try:

=smfConvertData(smfGetTagContent("http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol= http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol="&A1,"b",1,">Rating"))


To fix it, I had to look at the source code of the web page to see how it was coded.







Tue Apr 30, 2019 12:58 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. There's nothing there for the add-in to extract. I don't even see
ticker specific options for data.

On Mon, Apr 29, 2019 at 8:19 PM ccoupe300@.... wrote:

> Your solution from Aug 2015 looked like it stopped accessing Marketgrader
> today. Direct link for a selected ticker looks like it takes you to a
> generic intro page and the add-in formula stopped extracting data. Looks
> like things may have changed.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar