Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
loops???? | Excel Worksheet Functions | |||
loops ... | Excel Programming | |||
Using For - Next Loops in VB | New Users to Excel | |||
for each loops | Excel Programming | |||
help with loops | Excel Programming |