Home > Forum Home > Excel Portfolio Optimization Template > Questions about data input and date > Answers to your questions | Share |
Forum Topic | Login |
Answers To Your Questions | Rate this: (3/5 from 1 vote) |
1) 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 Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Answers to your questions in the Excel Business Solutions Directory |