Specifications for the "Yahoo" data source for BulkQuotesXL

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

For example, to find the valid Ticker Symbol for DaimlerChrysler in Germany and France:

  1. Open Yahoo! Finance Germany (http://de.finance.yahoo.com/).
  2. Enter "Daimler" in the search box and select "Name".
  3. Perform the search.
  4. In the resulting "Symbol Lookup Results Table," right-click the first WKN/Exchange Code (710000.DE) and select "properties".
  5. 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.

Please see also software products of AnalyzerXL, LLC

Home

  More Software     More Car Software   Excel Spreadsheets