![]() You may want to poke around in the comments on the page, as some seem to indicate some trouble in getting the financial information they desired. This will initiate a download of Stock Prices from Yahoo Finance. This includes real time stock prices, dividends, 52-week highs, and historical data. One subscriber suggested the following site as a possibility: Excel 2007/2010/2013: Go to Developer->Macros, select the Download macro and click run. This article will show you how to pull Stock related data directly from Yahoo Finance into your Excel Spreadsheet. If you poke around on the sites, you may find that some data is offered in Excel format, as well. You might need to write your own code to access the data through the API, but it is available. There are also other sites that provide data and include an API. Once they are in a Sheets worksheet, you can then copy and paste them into your Excel worksheet. ![]() If you need just current prices, one approach is to rely on Google Sheets where you can use the GoogleFinance function to get a number of financial statistics. There are a few ways that the loss of the Yahoo! Finance data could be approached. Jack figures he can't be alone in needing to get stock information into his Excel worksheets, so he is wondering if there other services that folks with similar needs can suggest. For years Jack has used the Yahoo! Finance API to import stock information into his worksheets. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |