Assets Wizard

The Assets Wizard provides functionality to select return series subsets and sort assets in the Estimator. Access the Assets Wizard by clicking the Assets button in the NFA ribbon.

Exclude/include an asset from the estimation by removing the checkmark from the row of boxes.  

• This duplicates the functionality of the checkmarks at the top of the columns on the Asset Returns Worksheet.

• Unchecked assets remain hidden in the saved case, but will not be included in the Estimator's calculations.

• Excluded assets are not affected by importing or updating returns from outside sources.

• If you do exclude/include an asset's return series, it may be necessary to change the market portfolio weights.  

• Saving a case in Excel format removes any excluded assets permanently, which is one of the reasons that is not recommended to save cases in that format. Saving a case in NFA format keeps excluded assets in the Wizard so they can be returned to the investment universe at a later date.

Sort the assets by clicking on the column headings. For example, clicking on the Asset Name heading sorts the assets by name. This duplicates the sorting functionality found on the worksheets (double clicking on the Asset Name heading on the Historical Worksheet will also sort assets by name.) The difference is that here you can select an asset row and use the Move Up and Move Down Buttons to customize the sort. You can also save a particular sort by clicking on the Store Order Button. Clicking on the Restore Order Button at a later point will sort the assets according to that previous sort.