Home > Forum Home > Excel Portfolio Optimization Template > Question in setting up my optimization Share

Question in setting up my optimization

Excel Help for Question In Setting Up My Optimization in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Question In Setting Up My Optimization

Rate this:
(3/5 from 1 vote)
ConfusedI want to be able to apply leverage in my portfolio of stocks. What this means is that the total gross exposure from my positions will add up to greater than 100%. i.e. if I'm using 1.5x leverage, this should be 150%. Can you please tell me how to set up my optimization for that? Thanks.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Sad
Rate this:
(4/5 from 2 votes)
The weightings of the optimized portfolio will always sum to 100%.  To apply this to a different capital amount (say 150%), the only option would be to multiply the results accordingly (X 1.5).
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Question in setting up my optimization in the