![]() 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. One subscriber suggested the following site as a possibility: 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. Entering a companys stock symbol or name for compilation helps you to display your sources. There are also other sites that provide data and include an API. This free app inserts the data in a table on your worksheet. If it does, this quick copy/paste method may be all we need. Depending on the webpage formatting, this may or may not work well. We could select the range on the web page, copy (Ctrl+C) the info, then open an Excel workbook and do a Paste or Paste Special. Once they are in a Sheets worksheet, you can then copy and paste them into your Excel worksheet. Now, there are a few ways to get data displayed on the web page into Excel. 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. Learn how to import and export QuickBooks data with MS Excel files.You can import and export various list and transaction types to and from QuickBooks. Stock market data used in my book, Irrational Exuberance Princeton University Press 2000, Broadway Books 2001, 2nd ed., 2005 are available for download. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |