Data, FAQs, Stock Model FAQs, VBA Code
The code isn’t broken. The error you’re getting can mean one of 4 things: 1/ you did not save the .csv files you downloaded with TICKER.csv in ALLCAPS (replace TICKER with your desired symbols) 2/ your list of ticker symbols in the Controls worksheet are not in...
Articles, Data, Spread Model FAQs, Spread Trading Model
< 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...
Articles, Data, Spread Model FAQs, Spread Trading Model
< 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...
Articles, Data, Spread Model FAQs, Spread Trading Model
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...
Articles, Data, Spread Model FAQs, Spread Trading Model
< 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...