Loading and Saving Relative Variance Tables
Saving and loading a lookup table for the rebalance test can save considerable time, allowing the user to bypass the lengthy simulation process normally involved in running the rebalance test, and simply use the rebalance portfolios feature to quickly recalculate the rebalance probabilities. This feature also allows the user to run a more precise test with more simulations, since the compute-intensive part of running the test can be precalculated.
Exporting/Saving a Relative Variance Table
In order to save a table, you must first run a rebalance test normally with the desired settings and number of simulations. Only then is it possible to export a file in comma-separated-value text format. This file will be saved with a .nfrv (New Frontier Relative Variance) extension. Under the Save Menu in the File Section of the Optimizer ribbon, select the icon labeled "export relative variances" to export the file. This file then can be loaded to bypass the usual rebalance test workflow and go straight to rebalancing portfolios, a compute-efficient procedure that consists of calculating the relative variance of the portfolios to the new optimal frontier, and comparing this calculation to the pre-loaded table rather than separately computing a new table for comparison.
Loading a Relative Variance Table
To load a previously saved .nfrv table, select the Load Relative Variances option from the Load Menu in the File section of the Optimizer ribbon. Then select the file in the dialog box and click the Open Button to load the file. The relative variance table will then be loaded and "rebalance portfolios" will be enabled in the rebalance menu.
A note about Asset Bound Confidence Intervals and Loading Tables
One by-product of the normal calculation of the rebalance test is to provide more accurate portfolio bounds than the quick computation that results from the optimization procedure. However, upon loading a relative variance table, these more accurate bounds are not available, so the bounds calculated from the optimization procedure are shown instead.