Home > Forum Home > Excel Portfolio Optimization Template > Daily data for portfolio optimization > Some problems solved Share

Some problems solved

Excel Help for Some Problems Solved in Excel Portfolio Optimization Template


Forum TopicLogin

Some Problems Solved

Rate this:
(3/5 from 1 vote)
HappyThank you for your sending through your template.   The issue was with the first row (row 7) with blank input data. 

The template cannot calculate with empty or any non-numeric cells. We understand that since your data is based on returns and this is therefore a likely input method.

In order to allow the model to run correctly, you need to move your data up one row to avoid the first row being without data.

Thank you for your patience, enthusiasm and custom.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Some problems solved in the