|
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 |
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 * |
DCXGn.DE - Daimler
Chrysler AGDTEGn.DE - Deutsche
Telekom^GDAXI - Xetra Dax
Index
|
Symbol Lookup |
|
France * |
CGEP.PA - AlcatelAXAF.PA - Axa^FCHI - CAC 40 Index
|
Symbol Lookup |
|
Italy |
OLIV.MI - OlivettiTIM.MI - Tim^MIBTEL - Mibtel Index
|
Symbol Lookup |
|
Australia |
NCP.AX - News CorpBHP.AX - BHP Billiton^AORD - All Ordinaries
Index
|
Symbol Lookup |
|
India |
SATY.BO - Satyam Comp-AVISO.BO - Visualsoft-B1^BSESN - Sensex Index
|
Symbol Lookup |
For example, to find the valid Ticker
Symbol for DaimlerChrysler in Germany and France:
- Open Yahoo! Finance Germany (http://de.finance.yahoo.com/).
- Enter "Daimler" in the search box and select
"Name".
- Perform the search.
- In the resulting "Symbol Lookup Results
Table," right-click the first WKN/Exchange Code
(710000.DE) and select "properties".
- In the address (URL) field, the ticker will
be shown after the "?s=" - in this case, it
is "DCXGn.DE." This ticker can be used to download
data using BulkQuotesXL or DownloaderXL..
Note: For the France ticker repeat steps 4 and 5
but for the WKN/Exchange Code 710000.F.
|
