Thread: loops
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Capp Capp is offline
external usenet poster
 
Posts: 5
Default loops

I am a beginner programmer and I am trying to understand looping to optimize
a investment portfolio with 3 types of assets S, B & C. Does anyone have
experience with such a routine? I want to find the optimal weights for this
portfolio by changing each asset wieght. A portfolio cant hold more than
100%. In other words, what weights will optimize my return?

i.e. S = 70%, B = 25% and C = 5%

Total (S + B + C) cant exceed 100%.

Therefore I am looping 3 different variables. I have tried a couple of
methods but keep getting errors. Does anyone have a template for something
similar I can try to work through??

ANy help is much appreciate!

Capp