Home > Forum Home > Excel Portfolio Optimization Template > Questions about data input and date > Answers to your questions Share

Answers to your questions

Excel Help for Answers To Your Questions in Excel Portfolio Optimization Template


Forum TopicLogin

Answers To Your Questions

Rate this:
(3/5 from 1 vote)
Happy1) Any fixed order of the date? and Format? Could I just use 1-10 as the date?
Yes this column is not analyzed; however the model assumes chronological order.

2) If i haven't input date for corresponding price, will the system count this price?
Yes.

3) Could I pre-input the historial prices for many assets (e.g. 20) and select different assets combination (e.g. 3 of them) later? Could I just enter the prices and left the Name tag blank?
No.  If price data exists in the columns, it will taken into account in the analysis.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Answers to your questions in the