Confabulous
10th Oct 2005, 20:31
Hey all,
I have a challenge that my Excel skills don't seem to be up to. It involves inputting the odds (i.e 11/2), multiplying that result (i.e, 5.5) by the stake, which is 5% of the betting bank, adding the initial stake and getting the result, and THEn adding THAT result back onto the inital bank, increasing it, and therefore increasing the stake.
Example: Initial bank of €100, stake of 5%, i.e €5. Odds (to win) are 5/1. The horsey wins, and you get 5x5=25 + 5 (the initial stake) = €30. Now the bank has grown to €130 (100 + 30)
So on the next race 5% of €130 = €6.50, odds are 5/1, horsey wins again, therefore €6.50 x 5 = €32.50 + €6.50 (intial stake) = €39.
So €130 + €39 = €169, etc etc...
I've got to the point where I can get the result, but can't add it back to the initial sum - it creates a circular reference somewhere, and that's where my Excel skills end! Any Excel expert have a solution?
Confab
:ok: :D
I have a challenge that my Excel skills don't seem to be up to. It involves inputting the odds (i.e 11/2), multiplying that result (i.e, 5.5) by the stake, which is 5% of the betting bank, adding the initial stake and getting the result, and THEn adding THAT result back onto the inital bank, increasing it, and therefore increasing the stake.
Example: Initial bank of €100, stake of 5%, i.e €5. Odds (to win) are 5/1. The horsey wins, and you get 5x5=25 + 5 (the initial stake) = €30. Now the bank has grown to €130 (100 + 30)
So on the next race 5% of €130 = €6.50, odds are 5/1, horsey wins again, therefore €6.50 x 5 = €32.50 + €6.50 (intial stake) = €39.
So €130 + €39 = €169, etc etc...
I've got to the point where I can get the result, but can't add it back to the initial sum - it creates a circular reference somewhere, and that's where my Excel skills end! Any Excel expert have a solution?
Confab
:ok: :D