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

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