| 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 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 |