22nd January 2016, 01:21 AM
|
|
Member
|
|
Join Date: Nov 2013
Posts: 605
|
|
Quote:
|
Originally Posted by beton
Help
Please
I need some formulas for excel
|
I'm still around and had a go based on the descriptions of what you wanted (laying otherwise makes very little sense to me).
Brief explanation:
U3:U26 - liability for ranks 1 down to 24
Fill Down columns V & W
Fill Down columns Z through AI
If you're testing combinations of liabilities, use something like this: http://opensolver.org/. It can find the combos that maximise your return/minimise your loss.
No guarantee that it's predictive though. It might just describe the past, rather than forecast the future. |