Yahoo Stock Data

Financial Analysis Solutions for Microsoft Excel

DownloaderXL > Yahoo Stock Data

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 Networks `ECA.TO` - Encana Corp `^GSPTSE` - S&P/TSX Composite Index	Symbol Lookup
United Kingdom	`VOD.L` - Vodafone Group `MT.L` - Mytravel Group `^FTSE` - FTSE 100 Index	Symbol Lookup
Germany *	`DCXGn.DE` - Daimler Chrysler AG `DTEGn.DE` - Deutsche Telekom `^GDAXI` - Xetra Dax Index	Symbol Lookup
France *	`CGEP.PA` - Alcatel `AXAF.PA` - Axa `^FCHI` - CAC 40 Index	Symbol Lookup
Italy	`OLIV.MI` - Olivetti `TIM.MI` - Tim `^MIBTEL` - Mibtel Index	Symbol Lookup
Australia	`NCP.AX` - News Corp `BHP.AX` - BHP Billiton `^AORD` - All Ordinaries Index	Symbol Lookup
India	`SATY.BO` - Satyam Comp-A `VISO.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.

Download Trial . Buy Online .

Real tools for real life, PPT

LAST CHANCE TEAM>