Home > Forum Home > Excel Portfolio Optimization Template > Indexes and Returns Share

Indexes and Returns

Excel Help for Indexes And Returns in Excel Portfolio Optimization Template

Forum TopicPost Reply Login

Indexes And Returns

Rate this:
(2/5 from 2 votes)
Happy Hi

I am using returns and index data to test for optimal sharpe ratios. I do not own any units and have not invested capital. What should I set the units and capital values to in this instance?
 Posted by on
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(3.3/5 from 3 votes)
When testing with data we usually set the inital weightings equal.  

For returns this can one unit per asset. For index price we need to enter a nominal capital amount and then use the equal weighting button to calculate the units from the last known price to equalize the weightings.
 Excel Business Forums Administrator
 Posted by on
Rate this:
(4.3/5 from 3 votes)
I would like to use return data to test what weighting I should invest in each asset to maximise the sharpe ratio.

Basically I want to a wide variety of sharpe ratios for different weightings so I can get an idea of the diversification benefits. Does the spreadsheet offer this option?
 Posted by on
Rate this:
(4/5 from 2 votes)
When we start with weightings it can be existing portfolio structure or for testing just equal weights.

When the optimization process is run, it calculates sets of weightings that lie on the efficient frontier.  The one with the highest Sharpe ratio is the one that has the highest ratio of return to risk volatility.  However, we can also select and view any of the other weighting sets that were calculated during the optimization on the table with sort options to the right of the results.  A button is provided to load a selected weighting set which could, for example, reduce the return in order to have a lower level of risk (better diversification). The newly selected weightings are then loaded with all metrics and shown where that portfolio lies on the efficient frontier.

Short answer: Yes. 
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Indexes and Returns in the