Our Products
Trading Models
Courses
Analysis & Data
Articles
FAQ: When I Try to Insert a Command Button for ‘Run Model’ I Get a ‘Cannot insert object’ prompt’
Save your model file as macro-enabled workbook (.xlsm) if you didn’t do that. If your file is saved as an .xlsm then this issue is caused by an MS Office Update. Here is the best (simplest) fix: 1. Close all your Office programs and files. 2. Open Windows Explorer...
How to Calculate Spread Trading Contract Legs: Case 3 Contracts Denominated in Different Currencies
< Back to Case 2 How to Equalize Spread Legs When the Securities are Denominated in Different Currencies This is the base case where both securities are denominated in different currencies and a currency transformation is required in addition to a Contract...
How to Calculate Spread Trading Contract Legs: Case 2 Contracts with Different Quote Units
< Back to Case 1 How to Equalize Spread Legs When the Securities Have Different Quote Units This is the base case where both securities are in the same currency and no currency transformation is required, but the two Quote Units are different. You cannot equalize...
How to Calculate Spread Trading Contract Legs
When spread trading futures, stocks, ETFs or other securities, it is important to equalize the dollar value of each side of the spread. The short position in Security #1 should be offset as closely as possible by a long position in Security #2. This series of case...
How to Calculate Spread Trading Contract Legs: Case 1 Simple Spread Equalization
< Back to Intro How to Equalize Spread Legs When Both Securities Are in the Same Currency and Have the Same Quote Units This is the base case where both securities are in the same currency, no currency transformation is required and the Quote Units of the two...
CRASH! Excel Chart of the U.S. Dollar (USD) vs Swiss Franc (CHF) January 2015
Here's a good Excel chart of the USD vs. CHF exchange rate crash after the Swiss National Bank decided to lift the cap on the CHF vs. EUR. Free currency data downloaded from http://www.global-view.com/forex-trading-tools/forex-history/index.html
Interest Rate Futures Contract Specifications and Tick Values
Futures contract specifications and tick values for the most liquid global interest rate and fixed income contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size 1 Month EONIA EUREX FE01 EUR 3,000,000 1M Euro...
Energy Futures Contract Specifications and Tick Values
Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size Anhydrous Fuel Ethanol BM&F ETN BRL 30 Cubic Meters BRL/Cubic Meter 0.5 Belgian Base Power EEX QBB EUR 1 MWh EUR/MWh 0.01 Brent Crude Oil IFEU B USD 1,000...
Carbon CO2 Futures Contract Specifications and Tick Values
Futures contract specifications and tick values for the most liquid global carbon CO2 contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size European Carbon Units (EUA) EEX F2PE, F2EA, FEUA EUR 1,000 EUA...
Real Estate Futures Contract Specifications and Tick Values
Futures contract specifications and tick values for the most liquid global real estate contracts. Contract Underlying Exchange Ticker Symbol CCY Contract Multiplier Contract Unit Units Quoted Tick Size Dow Jones US Real Estate Index CME RX USD 100 Index value points...