[smf_addin] Digest Number 4654

EXCEL Stock Market Functions Add-in Group

1 Message

Digest #4654

1a

Re: Historic financial data no longer retrieved from certain sources by "Randy Harmelink" rharmelink

Message

1a

Re: Historic financial data no longer retrieved from certain sources

Sun Dec 1, 2019 9:07 am (PST) . Posted by:

"Randy Harmelink" rharmelink

AdvFN no longer carries historical financial statements data.

I have no idea which Morningstar template you are referring to...but the
Morningstar CSV files are no longer available because they now require
credentials to be able to access them, if that's what you are referring to?

All of the data sources are making it more difficult to access data.

On Sun, Dec 1, 2019 at 1:48 AM jsawyermib@... wrote:

>
> The first template from: http://ogres-crypt.com/SMF/Templates/#All (
> SMF-Template-Yahoo-Analyst-Estimates.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Yahoo-Analyst-Estimates.xls>
> ) is accessing estimate data from Yahoo and an example includes
>
> =RCHGetElementNumber(Ticker,644)
> Using a ticker such as AMZM returns "$4.23"
>
>
> The second Template, (smfGetAdvFNElement-Template-All-Line-Items.xls
> <http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls>
> ) in cell D8, which used to retrieve historic P&L data
>
>
> =IF(OR(UPPER(Ticker)="NONE",COLUMNS($D:D)>rPeriods),"--",smfGetADVFNElement(Ticker,rAQ,COLUMNS($D:D),">"&$C8&"<",,"--"))
>
> this no longer returns any data, just "-" (Ticker used AMZN again)
>
>
> I'm also getting the same result or other templates, such as for the
> accounts summaries from Morningstar
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use