Selasa, 15 Agustus 2017

[smf_addin] Digest Number 4122

7 Messages

Digest #4122
1b
Re: Yahoo History messages by "Randy Harmelink" rharmelink
2c
Re: Morningstar's Five Year Growth Forecast? by "Randy Harmelink" rharmelink
3b
Re: 15013 returns error? by "Randy Harmelink" rharmelink

Messages

Tue Aug 15, 2017 7:03 am (PDT) . Posted by:

mjblauer

Randy can you explain these messages using the latest RCH beta


=RCHGetElementNumber("Version") returns


Stock Market Functions add-in, Version 2.1.2017.06.09 (C:\Program Files\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; ; 1)



=RCHGetYahooHistory("MMM",,,,,,,,"DHLC")
Returns the message "Date"


=RCHGetYahooHistory("ibm",2017,8,4,2017,8,4)
Returns the message "Date"



=smfGetYahooHistory("ibm")

Returns the message "Date"



=RCHGetYahooHistory("IBM",2017,8,4,2017,8,4,"d","A",0,1,0)


Returns the message "ERROR"



thanks in Advance



Tue Aug 15, 2017 9:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

First of all, the latest beta version is 2017.08.13, not 2017.06.09, so you
may want to update and get the most recent version of the Yahoo Historical
Quotes fixes. That may fix your "Error" returned value?

Secondly, all of the "Date" values returned are correct *IF* you are only
entering the function in a single cell. You need to array-enter the formula
over a range if you want more than just the single value returned. A
function can only return values to the cells it is given access to.

On Tue, Aug 15, 2017 at 7:03 AM, mblauer@
​...
wrote:

> Randy can you explain these messages using the latest RCH beta
>
> =RCHGetElementNumber("Version") returns
>
> Stock Market Functions add-in, Version 2.1.2017.06.09 (C:\Program
> Files\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; ; 1)
>
> =RCHGetYahooHistory("MMM",,,,,,,,"DHLC")
>
> Returns the message "Date"
>
> =RCHGetYahooHistory("ibm",2017,8,4,2017,8,4)
>
> Returns the message "Date"
>
> =smfGetYahooHistory("ibm")
>
> Returns the message "Date"
>
> =RCHGetYahooHistory("IBM",2017,8,4,2017,8,4,"d","A",0,1,0)
>
> Returns the message "ERROR"
>
>

Tue Aug 15, 2017 7:42 am (PDT) . Posted by:

jharlan

Hi,


On the sheet titled, "Automated Fair-Value Estimator" there is a line items for "Five Year Growth Forecast" that points to Morningstar with the following expression:


RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol="&$H1,1,">Five Year Growth Forecast", ">Stock")/100



That link does not work well, but what does work is:


http://financials.morningstar.com/valuation/earnings-estimates.html?t=MSFT http://financials.morningstar.com/valuation/earnings-estimates.html?t=MSFT


So, my question is how do I pull the data for the "Five Year Growth Forecast" that is located on that page?


Thanks, Jim

Tue Aug 15, 2017 8:09 am (PDT) . Posted by:

jharlan

Hi,

In attempting to answer my own question, I went to Yahoo! Finance in stead and the following formula works:


=RCHGetTableCell("https://finance.yahoo.com/quote/MSFT/analysts?p=MSFT",1,"Next 5 Years (per annum)")



I think the Morningstar site hides some code behind java scripting so I wasn't able to pull the cell.


FWIW,


Jim


Tue Aug 15, 2017 9:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Morningstar now builds its web pages dynamically, and the "print page" is
obsolete. They have the data stored on static web pages, which are used to
create the presented page, so you can access the data from them. Try
something like:

=RCHGetTableCell("
http://financials.morningstar.com/valuation/analyst-opinion-list.action?t=MMM",1,"Five-Year
Growth Forecast","<tr")

On Tue, Aug 15, 2017 at 7:42 AM, jharlan@
​...
wrote:

> On the sheet titled, "Automated Fair-Value Estimator" there is a line
> items for "Five Year Growth Forecast" that points to Morningstar with the
> following expression:
>
> RCHGetTableCell("http://quicktake.morningstar.com/
> stocknet/printreport.aspx?symbol="&$H1,1,">Five Year Growth Forecast",
> ">Stock")/100
>
> That link does not work well, but what does work is:
>
> http://financials.morningstar.com/valuation/earnings-estimates.html?t=MSFT
>
> So, my question is how do I pull the data for the "Five Year Growth
> Forecast" that is located on that page?​
>
>
On Tue, Aug 15, 2017 at 8:09 AM, jharlan@
​...
wrote:

>
> In attempting to answer my own question, I went to Yahoo! Finance in stead
> and the following formula works:
>
> =RCHGetTableCell("https://finance.yahoo.com/quote/MSFT/analysts?p=MSFT",1,"Next
> 5 Years (per annum)")
>
> I think the Morningstar site hides some code behind java scripting so I
> wasn't able to pull the cell.
>
>

Tue Aug 15, 2017 1:57 pm (PDT) . Posted by:

jharlan

Hi,


I tried =RCHGetElementNumber(Ticker,15013) on a lot of various stocks and keep getting an error.


Is it working?


(btw, I have the latest build)


Thanks,

Tue Aug 15, 2017 6:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's because Yahoo currently isn't populating the Enterprise Value/EBITDA
ratio on their Key Statistics web page. I see all "N/A" values.

On Tue, Aug 15, 2017 at 1:57 PM, jharlan@
​...
wrote:

> I tried =RCHGetElementNumber(Ticker,15013) on a lot of various stocks and
> keep getting an error.
>
> Is it working?
>
> (btw, I have the latest build)
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.32

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)