Build Trading and Investing Models in Excel
Learn to design, code, construct and test Excel models that make money!
Excel Trading Models Design Process

Articles

Inflation Futures Contract Specifications and Tick Values

Futures contract specifications and tick values for the most liquid global inflation contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size Extended Consumer Price Index (IPCA) BM&F IAP BRL 1 Index value...

read more

FX Currency Futures Contract Specifications and Tick Values

Futures contract specifications and tick values for the most liquid global foreign currency contracts.  This table normalizes the confusing difference between American reference format of quote currency/base currency (e.g. CME, ICEUS, BM&F) and the European format...

read more

Volatility Futures Contract Specifications and Tick Values

Futures contract specifications and tick values for the most liquid global volatility contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size 10-Year U.S. Treasury Note Volatility CFE VXTY USD 1,000 Index...

read more

Metal Futures Contract Specifications and Tick Values

Futures contract specifications and tick values for the most liquid global metal contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size Aluminum LME AH USD 25 tonnes USD/tonne 0.5 Aluminum MCX ALUMINIUM INR...

read more

Agriculture Futures Contract Specifications and Tick Values

Futures contract specifications and tick values for the most liquid global agriculture contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size Azuki (Red Beans) TOCOM 204 JPY 80 bags (30 kg per bag) JPY/bag 10...

read more

Futures Contract Specifications

Click on the links below to view detailed futures contract specifications and tick values for most liquid futures contracts across the world's major exchanges. Agriculture Futures Contracts Carbon C02 Futures Contracts Energy Futures Contracts Equity Index Futures...

read more

FAQ: DownloaderXL Not Populating Data for One Stock

Question: DownloaderXL populates all of the tabs in the DATAv3.xlsm file except for the very first one, designated as AAPL. I cannot figure out why this is happening, especially when all of the other tabs are working fine. Answer: Regarding the AAPL price data issue,...

read more

FAQ: Ticker Symbol Excel VBA Mismatch Error

Question: When I attempt to run the model with AAPL and several other stocks, I get a type mismatch error from Excel, and then in attempting to debug the model code, this is what is displayed (see below.) I realize that it is not recognizing the indicator variables,...

read more