How to Download a Stock Price History
When a company wants to be listed on an exchange for the first time, the process they go through is called an initial public offering, or IPO. Once they go public, the exchange will track their price history, as will many other financial resource companies. Under the efficient market hypothesis, there are three different forms of market efficiency, each claiming different things influence current stock price. The semi-strong and strong forms take into account variables other than the historical stock prices and history of a company. However, the weak form of market efficiency relies totally on historical data.
Other People Are Reading
Instructions
-
Downloading Historical Stock Prices
-
1
Open an Internet browser and navigate to Yahoo.com.
-
2
Select the Finance link from the navigation pane titled “Yahoo! Sites” on the left side of the page. The link will have two stacks of gold coins on it as well as an upward-sloping green line.
-
-
3
Type in the symbol of the company whose stock price history you want to download. The text entry box will be in the upper-left corner of the page beneath the tab labeled “HOME.” If you do not know the symbol, type in the name of the company. A list of symbols from companies with a similar name will appear. Select the symbol of the appropriate company from that list. This will take you to the summary page of that stock.
-
4
Click on the “Historical Prices” link from inside the blue navigation pane on the left side of the page. The link is the fourth option in the “Quotes” section.
-
5
Fill in the desired date range on the Historical Prices page. Enter the start date, end date and select whether you want daily, weekly, or monthly prices. Click the “Get Prices” button on the screen.
-
6
Scroll to the bottom of the page. Click on the blue link “Download to Spreadsheet.” The link will automatically try to download to Microsoft Excel. Select whether you would like to save the file or open it. Excel will open automatically, displaying the historical prices in table format.
-
1
Tips & Warnings
Always consult a professional before investing.
References
- Photo Credit stock market analysis screenshot image by .shock from Fotolia.com
