Conventions in the Estimator

Background color indicates the purpose of individual cells within the Estimator. White cells can be changed. Cells shaded a light yellow contain calculated information or information that cannot be changed manually. For example, since the Historical Worksheet picks up the Asset Names and Descriptions from the Asset Returns Worksheet, those columns are in light yellow on the Historical Worksheet.

Numbers appear in blue, black, and red. Protected, light yellow cells, contain black numbers. White, editable cells contain blue numbers. Red numbers indicate negative values.  Red "N/A" indicates missing data. Light blue on the Asset Returns Worksheet indicates that a particular asset is not included in the current investment universe or is only included as a benchmark return series. Similarly, light blue contrasts are currently inactive; while bold contrasts are active.