The steps to download historical financial data on stock prices, crrencies, indices of financial markets from Yahoo are presented.
Step 1 - Use the internet and any browser to open Yahoo Finance page.
Step 2 - Type the symbol of the financial item such as a stock price, index ... in the search box and press search. In this example "AAPL" stands for Apple corporation stock price.
Step 3 - Click "Historical Data" on the summary page for the stock price (or index).
Step 4 - Examine summary page "Historical Data" and the three parameters that are to be set: Time Period, Show and Frequency.
Step 5 - Set the "Time Period" for the historical data you wish to download. In this example, the start date is 01/12/2015 and the end date is 01/12/2022.
Step 6 - Select "Historical Prices" or any other data needed. In this example, we wish to download the historical prices of the Apple stock over the period of time selected in step 5.
Step 7 - Select the frequency: Monthly, weekly or daily. In this example we select Monthly.
Step 8 - Check all three parameters entered above and if all of them are correct click "Apply", pause and then "Download".
Step 9 - Take note of the name and type of the file downloaded, then save the file in any folder. In this example, it was saved on the "Desktop"
You may download the file "AAPL(1).csv" at Apple historical price
Step 10 - Upload data to Excel file. Open an Excel file. Then click on "Open", "Browse", select the folder where the CSV file was saved in this case "Desktop", select the file name, in this example "AAPL(1).csv", then "Open".
Step 11 - Data to Excel file. If you follow this example, the data on an Excel should look like the one shown below.