This is how a URL look like when navigating on Yahoo Finance’s Web site:.We give here some two examples of Yahoo’s URLs. Now, the first step before writing any line of code is to understand how the Yahoo Finance API for Historical Stock Data is working, which implies to first learn how URL (Uniform Resource Locator) are built and used to access content on the Web. A URL is a Web address that your browser uses to access a specific Web page. For example, this is a link to access Apple’s historical data, where you can directly use the Web interface to display or hide stock prices and volumes. It is of course possible to access Yahoo Finance’s historical stock data using a Web browser. 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.

Download yahoo finance