Questions about data input and date

Excel Help for Questions About Data Input And Date in Excel Portfolio Optimization Template

Questions About Data Input And Date

Rate this: (3/5 from 1 vote)

	Hi, I have few questions on data and date input, 1) Any fixed order of the date? and Format? Could I just use 1-10 as the date? 2) If i haven't input date for corresponding price, will the system count this price? 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?
	Posted by ivan on 21 Jun 2008

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	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 21 Jun 2008

Displaying page 1 of 1