Yahoo! Price Quote Update Not Working

Have a question about your personal investments? No matter how simple or complex, you can ask it here.
Post Reply
User avatar
Topic Author
One Ping
Posts: 1087
Joined: Thu Sep 24, 2015 4:53 pm

Yahoo! Price Quote Update Not Working

Post by One Ping »

I'm updating my asset allocation this morning and the spreadsheet where I pull the latest MF price quotes from Yahoo! isn't working. This is the function I'm using:

=NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&B17&"&f=l1"))

where cell B17 contains the ticker symbol. (& = ampersand, I don't know why it shows up the way it does)

I hit ctrl-alt-F9 to update and I get "#VALUE!" in the cells where there should be the latest prices. It's always worked every time I've used it before ... up until today. :confused

Anybody have any idea why it's not working or what I'm doing wrong or how to fix it? Advice would be appreciated ... but, please remember I'm not a programmer/coder though, so something simple and straightforward would be appreciated.

One Ping
"Re-verify our range to target ... one ping only."
User avatar
Topic Author
One Ping
Posts: 1087
Joined: Thu Sep 24, 2015 4:53 pm

Re: Yahoo! Price Quote Update Not Working

Post by One Ping »

Found it! From Bertilak (last November)
Bertilak wrote:Yeah, I know this has been discussed many times before. I have even solved this problem to my satisfaction but the solution depends on Yahoo's financial web page, specifically (for example) the following will get the latest quote for VTSAX. It can be used as an argument to Excel's WEBSERVICE function.
Thanks,
One Ping
"Re-verify our range to target ... one ping only."
Gumby252
Posts: 31
Joined: Sun Feb 19, 2017 1:36 pm

Re: Yahoo! Price Quote Update Not Working

Post by Gumby252 »

Anybody know how to do this on the Mac?

It appears that the WEBSERVICE functionality doesn't work on the mac...
https://www.reddit.com/r/excel/comments ... orkaround/

-G
Post Reply