Assets Wizard

The Assets Wizard provides functionality to select and sort assets.  Access the Assets Wizard by clicking the Assets Button in the ribbon.

Add an asset

In general, it is wise to add an asset in the Estimator so that the impact of the new asset on the correlations matrix and any contrasts will be accounted for. If you add an asset in the Estimator, use NF copy to bring the case over to the Optimizer.

If you are not working with the Estimator, click the Add Button. A highlighted row will appear with a placeholder name (starting with A1). Click the OK Button to accept the change and close the Asset Wizard, then return to the Inputs Worksheet to fill in the columns pertaining to the new asset.

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 Inputs 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.

Exclude assets from the optimization by removing the checkmark in the appropriate row. Excluded assets remain as options in the Asset Wizard, but do not appear in the Optimizer. If you exclude an asset from the investment universe after optimization has already taken place, the portfolios do not total 100% until you optimize again. Return excluded assets to the investment problem by returning to the Asset Wizard and checking the appropriate asset. Saving a case in Excel format removes any excluded assets permanently. Saving a case in NFA format keeps excluded assets in the Asset Selector so they can be returned to the investment universe at a later date.