Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Image Removed

Table of Contents
typeflat

...

Anchor
fx_forwards
fx_forwards
FX Forwards

Ticker Format: The letter X, then a colon (:), followed by the first currency, then the second currency, then an underscore ( _ ), followed by the maturity code.
Ticker Examples
X:EURUSD_10YEuro to U.S. Dollar 10-yearX:GBPUSD_5YBritish Pound to U.S. Dollar 5-year
X:AUDUSD_5MAustralian Dollar to U.S. Dollar 5-monthX:USDCAD_SNU.S. Dollar to Canadian Dollar Spot Next
X:USDHKD_ONU.S. Dollar to Hong Kong Dollar OvernightX:EURUSD_TNEuro to U.S. Dollar Tomorrow Next
Maturity Codes
ONOvernight9MNineMonth
SNSpotNext10MTenMonth
TNTomorrowNext11MElevenMonth
1WOneWeek1YOneYear
2WTwoWeek2YTwoYear
3WThreeWeek3YThreeYear
1MOneMonth4YFourYear
2MTwoMonth5YFiveYear
3MThreeMonth6YSixYear
4MFourMonth7YSevenYear
5MFiveMonth8YEightYear
6MSixMonth9YNineYear
7MSevenMonth10YTenYear
8MEightMonth

Forward-eligible Currency Pairs
AUDCHFAustralian Dollar to Swiss FrancEURZAREuro to South African Ran
AUDUSDAustralian Dollar to U.S. DollarGBPCHFBritish Pound to Swiss Franc
CADCHFCanadian Dollar to Swiss FrancGBPUSDBritish Pound to U.S. Dollar
DKKCHF

Danish Krone to Swiss Franc

JPYCHFJapanese Yen to Swiss Franc
EURAUDEuro to Australian DollarNOKCHFNorwegian Krone to Swiss Franc
EURCADEuro to Canadian DollarNZDUSDNew Zealand Dollar to U.S. Dollar
EURCHFEuro to Swiss FrancSEKCHFSwedish Krono to Swiss Franc
EURCNHEuro to Chinse Offshore RenminbiUSDCADU.S. Dollar to Canadian Dollar
EURCZKEuro to Czech KorunUSDCHFU.S. Dollar to Swiss Franc
EURDKKEuro to Danish KroneUSDCNHU.S. Dollar to Chinese Offshore Renminbi
EURGBPEuro to British PoundUSDCZKU.S. Dollar to Czech Korun
EURHKDEuro to Hong Kong DollarUSDDKKU.S. Dollar to Danish Krone
EURHUFEuro to Hungarian ForintUSDHKDU.S. Dollar to Hong Kong Dollar
EURJPYEuro to Japanese YenUSDHUFU.S. Dollar to Hungarian Forint
EURNOKEuro to Norwegian KroneUSDJPYU.S. Dollar to Japanese Yen
EURNZDEuro to New Zealand DollarUSDNOKU.S. Dollar to Norwegian Krone
EURPLNEuro to Polish ZlotycUSDPLNU.S. Dollar to Polish Zlotyc
EURRONEuro to Romanian New LeUSDRONU.S. Dollar to Romanian New Le
EURSEKEuro to Swedish KronoUSDSEKU.S. Dollar to Swedish Krono
EURSGDEuro to Singapore DollarUSDSGDU.S. Dollar to Singapore Dollar
EURTRYEuro to Turkish New LiraUSDTRYU.S. Dollar to Turkish New Lira
EURUSDEuro to U.S. DollarUSDZARU.S. Dollar to South African Ran



Futures (CME, ICE, NYMEX, etc) F futures root.International StocksTicker
futures

Anchor

futures

international_stocks
international_stocks
International Stocks

Ticker Format: The letter S, then a colon (:), followed by the ticker
If you wish to load a particular futures month/year, enter the ticker root followed by the month code and last 2 digits of the year.
Month Codes are: Jan: F; Feb: G; Mar: H; Apr: J; May: K; Jun: M; Jul: N; Aug: Q; Sep: U; Oct: V; Nov: X; Dec: Z
For example: the ticker for December 2020 Natural Gas is: F:NGEZ20
Futures Ticker Examples - Click for Full List
F:CLECrude Oil - NYMEXF:NGENatural Gas - NYMEX
F:GCEGold - COMEXF:SIESilver - COMEX
F:CTECotton #2 - ICE U.S.

F:RUB

Rubber - TOCOM
F:CPOCrude Palm Oil - CMEF:RBERBOB Gasoline - NYMEX
F:MQISilver emiNY - COMEXF:MQOGold emiNY - COMEX
F:ZCECorn - CBOTF:DXEU.S. Dollar Index - ICEUS
F:EDANYSE EuroDollar - NLIFF:ULAUltra T-Bond - CBOT
Anchor
international_stocksinternational_stocks
Ticker Format: The letter S, then a colon (:), followed by the ticker, then a period (.), then the international exchange code.
, then a period (.), then the international exchange code.
Ticker Examples
S:VOW.XETRVolkswagenS:EG0.XSESJES International Holdings
S:VOD.XLONVodafoneS:EXN.XTSEExcellon Resources
S:EZY.XFRAMGM WirelessS:7974.XTKSNintendo Co Ltd
International Exchange Codes


ARCXNYSE ARCAXKOSKOREA EXCHANGE (KOSDAQ)
BATSBATS EXCHANGEXKRXKOREA EXCHANGE (STOCK MARKET)
BVMFBM_FBOVESPA S.A. - BOLSA DE VALORES, MERCADORIAS E FUTUROSXLIFNYSE EURONEXT LIFFE
CHIXCHI-X EUROPE LIMITED.XLIMBOLSA DE VALORES DE LIMA
ISECFIRST NORTH ICELANDXLISNYSE EURONEXT - EURONEXT LISBON
FNFIFIRST NORTH FINLANDXLITNASDAQ OMX BALTIC, VILNIUS
FNSEFIRST NORTH STOCKHOLMXLONLONDON STOCK EXCHANGE, THE
HSTCHANOI SECURITIES TRADING CENTERXMCEMERCADO CONTINUO ESPANOL
MISXMICEX Moscow ExchangeXMEXMEXICAN STOCK EXCHANGE
MTAABorsa Italiana - Milan Stock ExchangeXMODMONTREAL EXCHANGE / BOURSE DE MONTREAL
OOTCOTHER OTC/NBBXMUNBORSE MUNCHEN
PINXOTC PINK MARKETPLACEXMUSMUSCAT SECURITIES MARKET
RTSXSTANDARD-CLASSICA-FORTSXNAINAIROBI STOCK EXCHANGE
XAMSNYSE EURONEXT - EURONEXT AMSTERDAMXNASNASDAQ
XASENYSE MKT EQUITIESXNYSNEW YORK STOCK EXCHANGE, INC.
XATHATHENS EXCHANGE S.A. CASH MARKETXNZENEW ZEALAND EXCHANGE LTD.
XBARBOLSA DE BARCELONAXOSLOSLO BORS ASA
XBERBORSE BERLINXOTCOTC BULLETIN BOARD
XBKKSTOCK EXCHANGE OF THAILANDXPARNYSE EURONEXT - EURONEXT PARIS
XBOMBSE LTD.XPHSPHILIPPINE STOCK EXCHANGE, INC.
XBOTBOTSWANA STOCK EXCHANGEXPRAPRAGUE STOCK EXCHANGE
XBRABRATISLAVA STOCK EXCHANGEXRISNASDAQ OMX BALTIC, RIGA
XBSESPOT REGULATED MARKET - BVBXSGOSANTIAGO STOCK EXCHANGE
XBUDBUDAPEST STOCK EXCHANGEXSHESHENZHEN STOCK EXCHANGE
XCNQCANADIAN NATIONAL STOCK EXCHANGEXSHGSHANGHAI STOCK EXCHANGE
XCSENASDAQ OMX NORDIC, COPENHAGENXSTCVIETNAM STOCK EXCHANGE
XDUBIRISH STOCK EXCHANGE - ALL MARKETXSTONASDAQ OMX NORDIC, STOCKHOLM
XDUSBORSE DUSSELDORFXSTUBORSE STUTTGART
XETRXETRAXSWXSWISS EXCHANGE
XFNDFIRST NORTH DENMARKXTAETEL AVIV STOCK EXCHANGE
XFRADEUTSCHE BOERSE AG - FRANKFURTXTALNASDAQ OMX BALTIC, TALLINN
XGHAGHANA STOCK EXCHANGEXTAITAIWAN STOCK EXCHANGE
XHAMHAMBURG STOCK EXCHANGEXTKSTOKYO STOCK EXCHANGE
XHANHANNOVER STOCK EXCHANGEXTNXTSX VENTURE EXCHANGE - NEX
XHELNASDAQ OMX NORDIC, HELSINSKIXTSETORONTO STOCK EXCHANGE
XHKGHONG KONG EXCHANGES AND CLEARING LTDXTSXTSX VENTURE EXCHANGE
XICENASDAQ OMX NORDIC, ICELANDXVALBOLSA DE VALENCIA
XIDXINDONESIA STOCK EXCHANGEXVTXSWX EUROPE
XISTISTANBUL STOCK EXCHANGEXWARWARSAW STOCK EXCHANGE
XKLSBURSA MALAYSIAXWBOWIENER BOERSE AG
XBRUNYSE EURONEXT - EURONEXT BRUSSELS


...

Anchor
preferred_stocks
preferred_stocks
Preferred Stocks

Ticker Format: The ticker followed by a minus sign (-), and then the letter of the series of preferred stock.
Ticker Examples
ALL-AAllstate Corp 5.625% Non Cum Preferred StockO-FRealty Income Corp 6.625% Monthly Preferred
ALL-DAllstate 6.625% Non Cumulative Perp PreferredO-ERealty Income Corp 6.75% Monthly Preferred
ALL-CAllstate Corp 6.75% Non Cum Perp Preferred StockWFC-OWells Fargo 5.125% Non Cum Redeem Preferred
JPM-AJP Morgan Chase 5,45% Non Cum PreferredWFC-PWells Fargo 5.25% Non Cumu Preferred
JPM-DJP Morgan Chase 5.5% Non Cum PreferredWFC-RWells Fargo 6.625% Fixed to Floating Non-Cum
JPM-BJPMorgan Chase 6.70% Non Cumulative PreferredWFC-JWells Fargo 8% Non Cum Redeem Preferred



Anchor
government_bond_yields
government_bond_yields
Government Bond Yields

Ticker Format: The letter Y, follow by a colon (:), followed by the ticker.
Ticker Examples - Click for Full List
Y:
BEL
AUS_
2M
1Y
Belgian
Australian Government
2-Month Money Market Rate
1-Year Bond YieldY:
USA
SGP_10Y
United States
Singaporean Government 10-Year Bond Yield
Y:BEL_2YBelgian Government 2-Year Bond YieldY:
USA
SGP_
1Y
20Y
United States
Singaporean Government
1
20-Year
Money Market Rate
Bond Yield
Y:
BEL
CAN_
3M
1Y
Belgian
Canadian Government
3-Month Money Market Rate
1-Year Bond YieldY:USA_
20Y
10YUnited States Government
20
10-Year Bond Yield
Y:JPN_2YJapanese Government 2-Year Bond YieldsY:
ZAF
USA_
3TO5Y
1Y
South African
United States Government
3to5
1-Year
Bond Yield
Money Market Rate
Y:JPN_30YJapanese Government 30-Year Bond YieldsY:
ZAF
USA_
5TO10Y
20Y
South African
United States Government
5to10
20-Year Bond Yield
Y:JPN_3YJapanese Government 3-Year Bond YieldsY:ZAF_
6M
10YSouth African Government
6-Month Money Market Rate
10-Year Bond Yield


Anchor
mutual_funds
mutual_funds
Mutual Funds

Ticker Format: A colon (:), followed by the ticker.
Ticker Examples
:DXHLXDirexion Mo China Bull 2X Inv:JNGLXJanus Global Life Sciences D Shs
:MINDXMatthews India Fd Investor Class:VHCIXVanguard Healthcare Fd Admiral S
:FSPHXFidelity Select Health Care:RYMTXRydex Srs Fds Managed Futures St

...