Where G90 is equal the ticker you want. Press Ctrl+alt+F9 to refresh.=NUMBERVALUE(WEBSERVICE("http://download.finance.yahoo.com/d/quotes.csv?s="&G90&"&f=l1"))
I fought this battle for quite a while...including using the above-mentioned formula in Excel. Said formula worked sporadically for me. I fixed it by converting all my spreadsheets to Google Sheets a few months back. Problem solved.
Well that s*cks. Does any one know of a substitute, or how does one conforms to the Terms of Service?
Check upstreamHere's a thread that should help:
http://www.early-retirement.org/for...o-refreshing-stock-prices-in-excel-87002.html
+1 Google sheets.
=GOOGLEFINANCE("JNJ","price")
I believe you'll have to switch from Excel to Google sheets if you want to do it with a formula in a cell. Yahoo has shut down their stock price service, and Google seems to be the only free alternative available.
If you really want to use Excel, you'll need to write some VBA code to do screen scraping or parse the results of a SOAP service.
Check upstream
Those are the solutions others here have come up with.The only info in your link relates to the formula I have been using and which no longer works, or using Google Sheets or using a VAB macro, which I am not familiar with. Did I miss something.
Those are the solutions others here have come up with.
No I'm not.So no other options if one uses excel. MRG are you suggesting their are other Excel options?
Does anyone feel like the internet is going backwards the last few years?
Lots of good stuff going away, usually because someone is taking advantage of the situation. Here, I think it was commercial interests misusing the quotes.