Tsx Dividend Stocks for Last 25 Years - Excel
Description
Tsx Dividend Stocks for Last 25 Years document sample
Document Sample


Exchange Instrument Region Daily History Daily O, H, Volume Open Interval History (1 Bar O, H,
L, C Interest minute Bars) 3 L, C, V
NYSE Composite Stock Americas Jan 1990-present X X n/a 60 trading days X
AMEX Composite Stock Americas Jan 1990-present X X n/a 60 trading days X
NASD Composite Stock Americas Jan 1990-present X X n/a 60 trading days X
NASD Bulletin Board & Stock Americas May 1998-present X X n/a 60 trading days X
OTC
Regional Stocks (Philly, Stock Americas Not Databased 60 trading days X
PSE, MSE, CSE, BSE,
NYSE, AMEX, THRD)
Major Market Index : DJ Index Americas June 1986-present 60 trading days
Industrial X n/a n/a X
Major Market Index : Index Americas Jan 1985-present 60 trading days
NASD Composite X n/a n/a X
Major Market Index : S&P Index Americas Oct 1985-present 60 trading days
500 X n/a n/a X
Major Market Index : Index Americas Jan 1993-present 60 trading days
Dollar Index X n/a n/a X
Market Index : Other Index Americas Jan 1993-present X On Some n/a 60 trading days X
Market Depth (Level II, Stock - Americas Not Databased Not Databased
ECNs, ViewSuite, Depth
OpenBook, etc.)
Mutual Funds & Money Funds Americas Jan 1994-present NAV only n/a n/a Not Applicable n/a
Market Funds
Unit Investment Trusts Funds Americas July 2001-present NAV only n/a n/a Not Applicable n/a
OPRA Options Americas Not Databased 1 Not Databased 2
CME Futures Americas Jan 1993-present X X X 60 trading days X
CBT Futures Americas Jan 1993-present X X X 60 trading days X
KCBT Futures Americas Jan 1993-present X X X 60 trading days X
MGE Futures Americas Dec 1994-present X X X 60 trading days X
NYMEX Futures Americas Jan 1993-present X X X 60 trading days X
COMEX Futures Americas Jan 1993-present X X X 60 trading days X
NYBoT Futures Americas Mar 1994-present X X X 60 trading days X
US Futures Exchanges Futures Americas Jan 2000-present X X X 60 trading days X
Globex / Access only
Session (=1)
US Futures Exchanges Futures Americas Jan 2000-present X X X 60 trading days X
Day only Session (=2)
US Futures Continuous Futures Americas Jan 1993-present X X X
Contracts
One Chicago Futures Americas Dec 2002-present X X X 60 trading days X
NQLX Futures Americas X X X
Winnipeg Commodity Futures Americas Jan 2000-present X X X 60 trading days X
Exchange
TSX Venture - CDNX Stock Americas May 1996-present X X n/a 60 trading days X
TSX - Toronto Stock Stock Americas May 1996-present X X n/a 60 trading days X
GTIS FX FX World Sep 1997-present X n/a n/a 60 trading days X (No Vol)
Garban Treasury Bonds Treasury Americas Nov 1998-present X 60 trading days X (No Vol)
Bonds n/a n/a
Athens Stock Exchange Stock EURMEA June 2002-present X X n/a 60 trading days X
Boerse Stuttgart Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Bolsa de Valores de EURMEA Jan 2000-present X X n/a 60 trading days X
Lisboa e Porto Stock
Budapest Stock Exchange EURMEA Jan 2000-present X X n/a 60 trading days X
Stock
Copenhagen Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Exchange Stock
Deutsche Boerse - EURMEA Jan 2000-present X X n/a 60 trading days X
Regional Stocks Stock
Euronext Stocks Stock EURMEA Jan 2000-present X X n/a 60 trading days X
FTSE Index Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Helsinki Stock Exchange EURMEA Jan 2000-present X X n/a 60 trading days X
Stock
Iceland Stock Exchange Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Irish Stock Exchange Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Italian Stock Exchange Stock EURMEA Jan 2000-present 5 X X n/a 60 trading days X
Johannesburg Stock Stock EURMEA Jan 2003-present X X n/a 60 trading days X
Exchange
LSE - UK Stock EURMEA Jan 2000-present 4 X (Mid also) X n/a 60 trading days X
LSE - INTL Stock EURMEA Jan 2000-present 4 X (Mid also) X n/a 60 trading days X
Madrid Stock Exchange Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Oslo Stock Exchange Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Stockholm Stock Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Exchange
STOXX Index Stock EURMEA Jan 2000-present X X n/a 60 trading days X
SWX Swiss Stock Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Exchange
Warsaw Stock Exchange Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Wiener Boerse Stock EURMEA Jan 2000-present X X n/a 60 trading days X
Eurex Futures EURMEA April 1996-present X X X 60 trading days X
Euronext Interest Rate Futures EURMEA April 1996-present X X X 60 trading days X
Futures
Euronext Commodities Futures EURMEA April 1996-present X X X 60 trading days X
IPE Futures EURMEA April 1996-present X X X 60 trading days X
Italian Deravites (IDEM) Futures EURMEA Jan 1998-present X X X 60 trading days X
LIFFE Futures EURMEA April 1996-present X X X 60 trading days X
LCE Futures EURMEA April 1996-present X X X 60 trading days X
LME Futures EURMEA April 1996-present X X X 60 trading days X
European Futures EURMEA Not Databased Not Databased
Continuous Contracts Futures
Austraila ASX Stock Asia /Pac Jan 1993-present X X n/a 60 trading days 5 X
New Zealand Stock Stock Asia /Pac Jan 1993-present X X n/a 60 trading days 5 X
Exchange
Hong Kong Stock Stock Asia /Pac Oct 2002-present X X n/a 60 trading days 5 X
Exchange
Singapore Stock Stock Asia /Pac Jan 1993-present X X n/a 60 trading days 5 X
Exchange
Sydney Futures Exchange Futures Asia /Pac Jan 1993-present X X X 60 trading days 5 X
Signapore INTL Montetary Futures Asia /Pac April 1996-present X X X 60 trading days X
Exchange (SIMEX)
Asian Futures Continuous Asia /Pac Not Databased Not Databased
Contracts Futures
Major Global Index: FTSE Index EURMEA July 1997-present X n/a n/a 60 trading days X
Major Global Index: DAX Index EURMEA Nov 1998-present X n/a n/a 60 trading days X
Major Global Index: Index X n/a n/a 60 trading days X
CAC40
Major Global Index: All Index Asia /Pac Feb 1980-present X n/a n/a 60 trading days X
Ordinaries
Notes:
1&2
Stock & Index Options Capture is planned for Q4 2003
3
Expansion of Interval Data back to Feb '03 is planned for Oct 2003 release
4
Expansion of LSE Data back to July 1995 is planned for Sep 2003 release
5
Expansion of Italian Stock Exchange back to Jan 1995 is planned for Sep 2003 release
Form T Tick History Trade, Bid / Ask TradeSize, Exchange Trade,
Afterhours (Time & Sales) BidSize / AskSize Exchange Ask /
Trades bid
X 10 trading days X X X
X 10 trading days X X X
X 10 trading days X X X
X 10 trading days X X Listed Exchange
X 10 trading days X X Listed Exchange
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
Not Databased
n/a Not Applicable n/a n/a n/a
n/a Not Applicable n/a n/a n/a
Not Databased 2
n/a 10 trading days X Electonic Only Listed Exchange
n/a 10 trading days X Electonic Only Listed Exchange
n/a 10 trading days X n/a Listed Exchange
n/a 10 trading days X n/a Listed Exchange
n/a 10 trading days X Electonic Only Listed Exchange
n/a 10 trading days X n/a Listed Exchange
n/a 10 trading days X n/a Listed Exchange
n/a 10 trading days X Electonic Only Listed Exchange
n/a 10 trading days X Electonic Only Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X n/a Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X (Bid / Ask only) n/a X (Quote
Contributor Only)
n/a X (Bid / Ask only) n/a
10 trading days n/a
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a X Listed Exchange
10 trading days TradeSize Only
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days X TradeSize Only Listed Exchange
n/a 10 trading days Not Available Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X Not Available Listed Exchange
n/a 10 trading days X Not Available Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X Not Available Listed Exchange
Not Databased
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X X Listed Exchange
n/a 10 trading days X Not Available Listed Exchange
Not Databased
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
n/a 10 trading days X (Last only) n/a n/a
Group Field Description Feed Real-Time Specific Use Source
Fundamental
Data 4
MarketGuide
2
52 Week High Yes n/a Stocks : US & European & Internal
MarketGuide
52 Week High Date Yes n/a Stocks : US & European 2 & Internal
MarketGuide
52 Week Low Yes n/a Stocks : US & European 2 & Internal
MarketGuide
52 Week Low Date Yes n/a Stocks : US & European 2 & Internal
Internal
Contract High 1 Yes n/a US Futures Database
Internal
Contract High Date 1 Yes n/a US Futures Database
Volume on Contract High Internal
Contract High Volume 1 Date Yes n/a US Futures Database
Internal
Contract Low 1 Yes n/a US Futures Database
Internal
Contract Low Date 1 Yes n/a US Futures Database
Volume on Contract Low Internal
Contract Low Volume 1 Date Yes n/a US Futures Database
Company Name Yes n/a US Stocks Only MarketGuide
Company Name Yes n/a European Stocks FTID via RDS
Cusip Number Yes n/a US Stocks Only MarketGuide
Description Yes n/a European Stocks FTID via RDS
Dividend Yes n/a US Stocks Only MarketGuide
Dividend Interval Yes n/a US Stocks Only MarketGuide
Calculated in RT
Dividend Yield Yes in eSignal US Stocks Only MarketGuide
Earnings per Share Yes n/a US Stocks Only MarketGuide
External File
used on Desktop Internal
Futures Name No for Display Futures : US & INTL Database
External File
used on Desktop Internal
Major Indexes Name No for Display Indexes Database
Calculated in RT
Market Capitalization no in eSignal US Stocks Only MarketGuide
Calculated in RT
PE Ratio Yes in eSignal US Stocks Only MarketGuide
Shares Outstanding Yes n/a US Stocks Only MarketGuide
Xdividend Date Yes n/a US Stocks Only MarketGuide
Fundamental
Data :
Expansion 3
Current ratio, fiscal year
ACURRATIO end
LT debt/equity, fiscal year
ALTD2EQ end
EPS primary/basic
including extraordinary
APEPSINCXORZ items, latest fiscal year
Price to Book, latest fiscal
APRICE2BK year
Revenue - most recent
AREV fiscal year
BETA BETA, Five Year Monthly
DIVGR% Growth rate%, dividend
Growth rate, # of years,
DIVGRYRS Dividend
Dividend growth rate, 5
DIVTRENDGR year
EPSTRENDGR EPS growth rate, 5 year
Growth rate%, adjusted
income available to
IACGR% common
Growth rate # of years,
adj. Income available to
IACGRYRS common
Revenue growth rate, 5
REVTRENDGR year
Cash Flow per Share
TTMCFSHR Trailing 12 months
Depreciation expense
TTMDEPSCF (SCF), trailing 12 month
TTMEBITD EBITD, trailing 12 month
Return on average assets,
TTMROA% trailing 12 month
Return on average
common equity, trailing 12
TTMROE% month
Volume, average trading
VOL10DAVG volume for last 10 days
Fundamental
Data :
Expansion 5
Symbol Ticker Symbol
Exchange Exchange Code
Uniqueness Uniqueness Code
IssuerName Issuer Description
IssueName Issue Description
CUSIP Number/User
CUSIP Number
IssueType Issue Type Code
Earnings Per Share -
EPSVal Basic
DivAnn Indicated Annual Dividend
DivAmt Dividend Amount/Rate
Ex-Distribution/Dividend
DivDt Date (mm/dd/yyyy)
DivPTC Payment Type Code
Payment Order/Scaling
DivPOSF Factor
Div2Amt Dividend Amount/Rate
Ex-Distribution/Dividend
Div2Dt Date (mm/dd/yyyy)
Div2PTC Payment Type Code
Payment Order/Scaling
Div2POSF Factor
Notes:
1
Planned release July 2003, with planned expansion to all futures
2
52 Week High / Low with Dates are being used from internal history databases for European Instruments, with planned expansion to supply all instruments
3
Planned expansion sourced by MarketGuide
4
MarketGuide sourced Fundamental data is for US Stocks only
5
Planned expansion sourced by FTID
to supply all instruments
TurboFeed (Data
Group Field Manager Only) eSignal Application Specific Use
Market Traded Information
Ask Price Yes Yes
Ask Size Yes Yes
Ask Change no Calculated
Ask Change (%) no Calculated
Ask Change from Open no Calculated
Ask Change (%) from Open no Calculated
Base Code Yes Yes
Base Code of Bid/Ask Yes Yes
Bid Price Yes Yes
Bid Size Yes Yes
Bid Change no Calculated
Bid Change (%) no Calculated
Bid Change from Open no Calculated
Bid Change (%) from Open no Calculated
Bid/Ask Spread no Yes
Bid Tick Yes Yes
Change Yes Yes
Change (%) no Calculated
Change from Open no Calculated
Change (%) from Open no Calculated
Comment no User Input Field
Currency Code Yes Yes European Stocks
Cusip Number Yes Yes Stocks
Date Yes Yes
Delay (minutes) Yes Yes
Description Yes Yes European Stocks
Exchange of Ask Yes Yes
Exchange of Bid Yes Yes
Exchange Listed Yes Yes
Exchange Traded Yes Yes
Special Flags (Noload, Xdiv, UPC,) Yes Yes
Last/Form T Last Yes Yes Stocks
Form T Change no Calculated Stocks
Form T Change (%) no Calculated Stocks
High Yes Yes
Kassa Price Yes Yes Duetsche Boerse
Last Trade Price Yes Yes
Low Yes Yes
Mid Price Yes Yes LSE
Name of Instrument Yes Yes
News Alert Count unused unused
News Alert Time unused unused
News Headline Count Yes Yes
Open Interest Options / Futures Yes
Opening Price Yes Yes
Opening Range, 2nd Yes Yes Futures
Previous Close Yes Yes
SOES Size Yes Yes Nasdaq
Tick/Closed/Settlement Yes Yes
Time of Update Yes Yes
bd5aefba-a9a2-41b7-8f03-e78fa8039a25.xls 9/24/02 Page 17
Date of Update Yes Yes
Time of Trade (BB only) Yes Yes
Trade Size Yes Yes
Up/Down Ticks Yes Yes
Volume, Average Yes Yes 20 day average
Volume, Cumulative Yes Yes
Total Ticks Yes unused
UPC Restriction Yes Part of Display Stocks
Fundamental Data
Dividend Yes Yes Stocks
Dividend Interval Yes Yes Stocks
Dividend Yield Yes Calculated in RT Stocks
Xdividend Date Yes Yes Stocks
Earnings per Share Yes Yes Stocks
52 Week High Yes Yes Stocks
52 Week High Date Yes Yes Stocks
52 Week Low Yes Yes Stocks
52 Week Low Date Yes Yes Stocks
PE Ratio Yes Calculated in RT Stocks
Shares Outstanding Yes Yes Stocks
Market Capitalization no Calculated Stocks
Mutual (MF), Money Market Fund (MM) & Unit Investment Trusts (UIT)
Fund Average Maturity Yes Yes MM
Fund Assets Yes Yes MM
Fund Net Asset Value Yes Yes MF,MM,UIT
Fund Yield, 7 Day Yes Yes MM
Fund Yield, Effective 7 Day Yes Yes MM
Fixed Income
Not authorized for
Coupon redistribution Yes Bonds
Not authorized for
Yield redistribution Yes Bonds
Not authorized for
Bid Yield redistribution Yes Bonds
Not authorized for
Ask Yield redistribution Yes Bonds
Not authorized for
Maturity Date redistribution Yes Bonds
Market Leaders
NYSE Volume Leaders Yes Part of Display Stocks
AMEX Volume Leaders Yes Part of Display Stocks
NASDAQ Volume Leaders Yes Part of Display Stocks
Stock Option Volume Leaders Yes Part of Display Options
NYSE Percentage Gainers Yes Part of Display Stocks
AMEX Percentage Gainers Yes Part of Display Stocks
NASDAQ Percentage Gainers Yes Part of Display Stocks
bd5aefba-a9a2-41b7-8f03-e78fa8039a25.xls 9/24/02 Page 18
Stock Option Percentage Gainers Yes Part of Display Options
NYSE Percentage Losers Yes Part of Display Stocks
AMEX Percentage Losers Yes Part of Display Stocks
NASDAQ Percentage Losers Yes Part of Display Stocks
Stock Option Percentage Losers Yes Part of Display Options
Options (Equity & Index)
Ask Edge no Calculated Options
Bid Edge no Calculated Options
Delta no Calculated Options
Gamma no Calculated Options
Implied Volatility no Calculated Options
Implied Volatility (Ask) no Calculated Options
Implied Volatility (Bid) no Calculated Options
Intrinsic Value no Calculated Options
Rho no Calculated Options
Premium no Calculated Options
Theoretical Value no Calculated Options
Theta no Calculated Options
Vega no Calculated Options
Expiration Date Yes Yes Options
Call / Put Indicator Yes Part of Display Options
Options Root Yes Part of Display Options
Strike Price Yes Part of Display Options
Exercise Style Yes unused Options
Exchange Codes planned use planned use Options
Leaps Identification Yes Yes Options
Position Limit Yes unused Options
NTPosition Limit Yes unused Options
Misc
oaSupport No 3rd party use
oaGrade No 3rd party use
HistRelPE No 3rd party use
epsTrendGF No 3rd party use
PEI No 3rd party use
PEIhigh No 3rd party use
PEIlow No 3rd party use
bd5aefba-a9a2-41b7-8f03-e78fa8039a25.xls 9/24/02 Page 19
Related docs
Get documents about "