The trade optimizer will calculate hundreds to thousands of strategies at once. The results are displayed in a spreadsheet where the strategies can be sorted, analyzed, and compares. This tab is very useful to help get a high level view of how the models perform and easily stress test a variety of strategies.
Basic Functions
- Parameter sliders. Use the slider to set the upper and lower bound of the related parameter. The optimizer will show the results of a strategy using all values between the upper and lower bounds.
- Enter one or more families. Type the family in the upper box, then press enter or “add” to move to lower box. All families displayed in the lower box are used in the optimization.
- Check one or more rebalance periods or enter any number of market days in the “# mkt days” box. Separate the market days with commas.
- Similar to the compare tab, the ranking period can be separated from the rebalance period. This allows for strategies like “monthly asset reallocation based on a quarterly family ranking”
- This basis is used for the sharpe ratio.
- This shows the number of combinations currently set to execute.
- Each row represents a different strategy. The first 8 columns describe the parameters used in the strategy.
- Right click on any row to display the colors of the compare tab. Click a color and this strategy will load in the corresponding color in the compare tab. This allows for easy workflow from the optimizer to the compare tab.
- In addition to sorting and ranking the spreadsheet, a filter can be applied to each column. The filters can exclude specific items like families or filters using greater than or less than logic.
- Left click the column head to sort ascending or descending.
- Soft recalculate. This button will recalculate the statistics of the spreadsheet strategies (light weight), but not recalculate the strategies themselves (heavy).
- The dates are the start and end dates used to calculate the statistics in the spreadsheet.