DownloaderXL Data Source: Yahoo
Yahoo! provides free historical end-of-day data for stocks, indices and mutual funds. Data is available for equities from the United States, Canada, United Kingdom, Germany, France, Italy, Australia, India and more*.
| Data Specifications | ||
|---|---|---|
| Data Source | Yahoo Finance | |
| Country Coverage | United States, Canada, United Kingdom, Germany, France, Italy, Australia, India and more *. | |
| Data Usage | Free for private use | |
| Adjustments | Not adjusted for dividends and splits | |
| First Date | Typically no earlier than 1970 | |
| Data Types | Equities, Indices, and Mutual Funds | |
| Fields: Equities | Open, High, Low, Close, Volume | |
| Fields: Indices | Open, High, Low, Close, Volume | |
| Fields: Mutual Funds | Net Asset Value | |
| Available Periodicity | Daily, Weekly, Monthly | |
* - Note: Other countries are also covered. To see if your country is covered, visit your local Yahoo! Finance and check if it provides historical data. If it does, then historical data for your country is available for downloading into Excel.
Symbol Lookup & Sample Tickers
| Country | Sample Tickers | Lookup |
|---|---|---|
| United States | MSFT - Microsoft Corp.QQQ - Nasdaq 100 Trust^DJI - Dow Jones Industrial Average Index^SPC - S&P 500 Index^IXIC - Nasdaq Composite Index |
Symbol Lookup |
| Canada | NT.TO - Nortel NetworksECA.TO - Encana Corp^GSPTSE - S&P/TSX Composite Index |
Symbol Lookup |
| United Kingdom | VOD.L - Vodafone GroupMT.L - Mytravel Group^FTSE - FTSE 100 Index |
Symbol Lookup |
| Germany | DAI.DE - Daimler AGDTE.DE - Deutsche Telekom AG^GDAXI - Xetra Dax Index |
Symbol Lookup |
| France | ALU.PA - Alcatel-LucentCS.PA - Axa^FCHI - CAC 40 Index |
Symbol Lookup |
| Italy | TIT.MI - Telecom Italia SpA |
Symbol Lookup |
| Australia | NCP.AX - News CorpBHP.AX - BHP Billiton^AORD - All Ordinaries Index |
Symbol Lookup |
| India | SATYAM.BO - Satyam Computer ServicesVISUALSOF.NS - Visualsoft Technologies L^BSESN - BSE SENSITIVE Index |