Yahoo Finance stock info no longer available via Excel macro

[sxpeter]

Last week, Yahoo Finance apparently shut down the API that Excel macros use to pull stock data. I have tried using Google Sheets, which does work, but it's a manual process (Copy/Paste-Special from Google Sheets to my Excel worksheet). Has anybody developed a solution that automates the stock data download from Google Sheets, or found another way to automatically download free stock quote information?

 

[tonyyy]

sxpeter...

You might check out this post.

Cheers,

tonyyy

 

[AhoyNC]

Another post that may help.
https://www.mrexcel.com/forum/excel-questions/1005785-yahoo-finance-api-stock-quotes-changed-6.html

 

[sxpeter]

What I was after was either another source of free stock quotes that can be downloaded into Excel, or a way to automate the copy/paste operation from Google Sheets. Yahoo Finance has evidently permanently disabled the API, so no one, no matter what VBA code they use, can pull stock quotes directly into Excel from Yahoo. Google Sheets, which is a Google-developed basic spreadsheet, has a function named GoogleFinance, which will pull some stock info (Price, Earnings, 52wk hi & lo, market cap and outstanding shares) from Google Finance, in much the same way that the MSNStockPrice addin used to do for Excel. I'm not aware of any way to pull that info directly into Excel, so I have to copy/paste the data from my Google Sheets spreadsheet. I'm just looking to automate that process.

 

[Stiuart_W]

Another thread had a suggestion to do what you said re a Google doc AND publish that to the web then use a VBA query to pull that data

I searched "stock" earlier and it was near the top of the results

 

[AhoyNC]

Post #48 in the link above gives a work around. Here is the link it ref.
https://office-watch.com/2016/excel-stock-prices-from-google-finance/