[smf_addin] Digest Number 4611

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #4611

1a

SMFGetYahooHistory returns only 5 years for WFC-PL by "Tom Murphy" eremon9

1b

Re: SMFGetYahooHistory returns only 5 years for WFC-PL by "Randy Harmelink" rharmelink

2a

Reuters Updates by bihi_selow

2b

Re: Reuters Updates by danzig_36526

2c

Re: Reuters Updates by "Randy Harmelink" rharmelink

Messages

1a

SMFGetYahooHistory returns only 5 years for WFC-PL

Sat Sep 7, 2019 9:23 am (PDT) . Posted by:

"Tom Murphy" eremon9

Hi Randy,

I use your SMFGetYahooHistory function to retrieve 15 years of both daily
closing prices and daily dividend adjusted closing prices for stocks on my
watchlist. Thanks much for that. In recent months the function has been
returning only 5 years of data for WFC-PL. Is there a workaround for this?

{= smfGetYahooHistory("WFC-PL", DateStart, DatePriorClose, "d", "c", 0)}

I'm using Excel 2010 on Windows 10.

Thanks for all you do.

Tom

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

1b

Re: SMFGetYahooHistory returns only 5 years for WFC-PL

Sat Sep 7, 2019 9:52 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're getting all the data Yahoo has. Their historical quotes for WFC-PL
only go back to 2015-01-02.

On Sat, Sep 7, 2019 at 9:23 AM 'Tom Murphy' tamurphy@... wrote:

>
>
> I use your SMFGetYahooHistory function to retrieve 15 years of both daily
> closing prices and daily dividend adjusted closing prices for stocks on my
> watchlist. Thanks much for that. In recent months the function has been
> returning only 5 years of data for WFC-PL. Is there a workaround for this?
>
>
>
> {= smfGetYahooHistory("WFC-PL", DateStart, DatePriorClose, "d", "c", 0)}
>
>
>
> I'm using Excel 2010 on Windows 10.
>
>
>
>
>

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

2a

Reuters Updates

Sat Sep 7, 2019 10:06 am (PDT) . Posted by:

bihi_selow

It looks like the reuters feeds have recently been updated to remove many elements which use to be available for things like EPS and Analyst estimates



every link in smf-elements-5.txt is now broken


https://www.reuters.com/finance/stocks/analyst/ https://www.reuters.com/finance/stocks/analyst/VRNS.OMS

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

2b

Re: Reuters Updates

Sat Sep 7, 2019 11:51 am (PDT) . Posted by:

danzig_36526

ouch. I use a lot of these....any good alternatives?

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

2c

Re: Reuters Updates

Sat Sep 7, 2019 6:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They are definitely changing something. They're asking for feedback. Tell
them what the web pages are missing that you use (or want).

Unusable for me right now. I often get a blank web page.

On Sat, Sep 7, 2019 at 10:06 AM bhui_ipsg@... wrote:

> It looks like the reuters feeds have recently been updated to remove many
> elements which use to be available for things like EPS and Analyst estimates
>
> every link in smf-elements-5.txt is now broken
>
> https://www.reuters.com/finance/stocks/analyst/
> <https://www.reuters.com/finance/stocks/analyst/VRNS.O>MS
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use