Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm trying to create a 12 month portfolio return stream where I know the final return and I know the volatility. I want these two things, the return and the volatility, to be my constraints and then I want excel to randomly populate the 12M of data based upon that. I thought goal seek was the way to go, but there's no where to put a second constraint that I can see. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
goal seek | Excel Discussion (Misc queries) | |||
Goal seek gone | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) | |||
Goal Seek | Excel Worksheet Functions |