Mean-variance portfolio optimisation requires estimates of risk and, in most cases, forecasts of return. The risk estimates may be either in the form of covariance matrices, or standard deviations and correlations.
POW! Toolbox is a set of tools designed to be used from Microsoft Excel that will use time-series to construct mean returns (if required) and risk matrices. Its primary purpose is to interface with POW! Frontier and generate automatically the selected model types, outputting the results to the destinations required by the chosen POW! Universe; but it also has many applications in its own right.
POW! Toolbox comes as a Wizard for Excel or as a programmable module, POW! Toolbox Automation.
POW! Toolbox Wizard allows the user to :
- collect time-series data from different worksheets;
- rearrange, convert and weight the series;
- deliver the selected output to a chosen destination;
- embed the settings in worksheets for retrieval at a later date.
see a complete list of features here...