Home > Forum Home > Excel Portfolio Optimization Template > Entering Historical Returns Correctly Share

Entering Historical Returns Correctly

Excel Help for Entering Historical Returns Correctly in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Entering Historical Returns Correctly

Rate this:
(3/5 from 1 vote)
ConfusedI'm pulling monthly historical returns off Morningstar to build the database.  They are formatted as, for example, 1.23 or -1.23.  When I enter them, they are rounded to whole numbers.
 I set the risk-free and target return rates by dividing annual figures by 12.  When I run it, it looks right but I'm disconcerted by the rounding.
 Am I entering the historical data correctly?
 Thanks in advance.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Rate this:
(4/5 from 2 votes)
The Input data sheet formats the numbers for the first 100 rows with zero decimal places.  If you look in the address bar, you will see the exact value to the number of decimal places that it was entered.  This precise value is used for the optimization process and the results. It is simply a matter of refromatting the cells to your preference.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Entering Historical Returns Correctly in the