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.
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
Yahoo! Price Quote Update Not Working
Yahoo! Price Quote Update Not Working
"Re-verify our range to target ... one ping only."
Re: Yahoo! Price Quote Update Not Working
Found it! From Bertilak (last November)
One Ping
Thanks,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.
One Ping
"Re-verify our range to target ... one ping only."
Re: Yahoo! Price Quote Update Not Working
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
It appears that the WEBSERVICE functionality doesn't work on the mac...
https://www.reddit.com/r/excel/comments ... orkaround/
-G