In this article, we use the API for Historical Quotes only. VBA can be used to import data automatically into Excel files using these APIs. Yahoo has several online APIs (Application Programming Interface) that provides financial data related to quoted companies: Quotes and Currency Rates, Historical Quotes, Sectors, Industries, and Companies. You can find the whole code source of this tutorial on GitHub, or you can download the following Excel file that contains the VBA code together with the Dashboard and a list of stock symbols: yahoo-hist-stock.xlsm.
However, we hope to post other articles in a near future about more simple aspects of programming in VBA.
In this article, we are going to show you how to download historical stock prices using the Yahoo Finance API called “table.csv” and discuss the following topics that will allow you successfully import data in Excel from Yahoo in a simple and automatic way:īefore we delve into the details of this subject, we assume that you know how to program in VBA or, at least, that you have already some notions of programming, as we are not going to introduce any basic programming concepts in this article.
