I'm trying to increase or reset stakes based on what my highest recorded balance is. So if I start with £200 at £1 stakes. If my new balance after a bet is higher than the highest recorded balance then my stake will reset to £1. If my balance is decreasing, the stake is increased by £1 and then reset when the new balance is higher than the recorded balance.
I've managed to set it up so that it records the highest balance when I start the program (either current balance or a manual balance adjustment which I can enter in case the program resets) and I can record the highest balance after a win by using the initial balance amount and IF(current balance>highest balance, current balance, highest balance) but the problem comes after this because I need it to keep taking the new highest balance but not sure how to do this without making tons of variables for highest balance (max_bal1, max_bal2, max_bal3... so on) and then a long winded IF statement for increasing the stake. Any ideas on how I can record the highest balance and then if the highest balance is greater than the previous highest balance, stake = £1, if not then stake = previous stake + £1?? Below is a table of bets of what I'm looking to achieve. Cheers.
| Bet # | Date/Time | Market | Winning Bet | Max Balance | Unit Price | Units | Stake | Back Price | Lay Price | If Wins | If Loses | P/L (AC) | Starting Balance | Ending Balance |
| 1 | 01/01/2023 13:08 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Tramore / Tramore 01/01/2023 12:55 2m Mdn Hrd - 2m Mdn Hrd | Back | £200.00 | £1.00 | 1.00 | £1.00 | 1.25 | 1.26 | £0.25 | -£1.00 | £0.25 | £200.00 | £200.25 |
| 2 | 01/01/2023 13:20 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Cheltenham / Cheltenham 01/01/2023 13:10 2m4f Mdn Hrd - 2m4f Mdn Hrd | Back | £200.25 | £1.00 | 1.00 | £1.00 | 2.40 | 2.42 | £1.37 | -£1.00 | £1.37 | £200.25 | £201.62 |
| 3 | 01/01/2023 13:34 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Musselburgh / Musselburgh 01/01/2023 13:25 1m7f Juv Hrd - 1m7f Juv Hrd | Back | £201.62 | £1.00 | 1.00 | £1.00 | 2.67 | 2.69 | £1.64 | -£1.00 | £1.64 | £201.62 | £203.25 |
| 4 | 01/01/2023 13:47 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fakenham / Fakenham 01/01/2023 13:35 3m5f Hcap Chs - 3m5f Hcap Chs | Lay | £203.25 | £1.00 | 1.00 | £1.00 | 3.25 | 3.30 | £2.21 | -£1.00 | -£1.00 | £203.25 | £202.25 |
| 5 | 01/01/2023 14:00 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fairyhouse / Fairyhouse 01/01/2023 13:50 2m4f Mdn Hrd - 2m4f Mdn Hrd | Back | £203.25 | £1.00 | 2.00 | £2.00 | 3.60 | 3.65 | £5.10 | -£2.00 | £5.10 | £202.25 | £207.35 |
| 6 | 01/01/2023 14:16 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Tramore / Tramore 01/01/2023 14:05 2m6f Mdn Hrd - 2m6f Mdn Hrd | Lay | £207.35 | £1.00 | 1.00 | £1.00 | 1.82 | 1.83 | £0.80 | -£1.00 | -£1.00 | £207.35 | £206.35 |
| 7 | 01/01/2023 14:31 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Cheltenham / Cheltenham 01/01/2023 14:20 2m4f Grd2 Nov Chs - 2m4f Grd2 Nov Chs | Lay | £207.35 | £1.00 | 2.00 | £2.00 | 2.68 | 2.70 | £3.29 | -£2.00 | -£2.00 | £206.35 | £204.35 |
| 8 | 01/01/2023 14:44 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Musselburgh / Musselburgh 01/01/2023 14:35 2m4f Hcap Chs - 2m4f Hcap Chs | Back | £207.35 | £1.00 | 3.00 | £3.00 | 3.60 | 3.65 | £7.64 | -£3.00 | £7.64 | £204.35 | £211.99 |
| 9 | 01/01/2023 14:54 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fakenham / Fakenham 01/01/2023 14:45 2m5f Nov Hcap Chs - 2m5f Nov Hcap Chs | Lay | £211.99 | £1.00 | 1.00 | £1.00 | 4.40 | 4.50 | £3.33 | -£1.00 | -£1.00 | £211.99 | £210.99 |
| 10 | 01/01/2023 15:12 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fairyhouse / Fairyhouse 01/01/2023 15:00 3m Hcap Hrd - 3m Hcap Hrd | Lay | £211.99 | £1.00 | 2.00 | £2.00 | 5.30 | 5.40 | £8.43 | -£2.00 | -£2.00 | £210.99 | £208.99 |
| 11 | 01/01/2023 15:26 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Tramore / Tramore 01/01/2023 15:15 2m6f Grd3 Chs - 2m6f Grd3 Chs | Lay | £211.99 | £1.00 | 3.00 | £3.00 | 1.87 | 1.88 | £2.56 | -£3.00 | -£3.00 | £208.99 | £205.99 |
| 12 | 01/01/2023 15:41 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Cheltenham / Cheltenham 01/01/2023 15:30 2m4f Grd2 Hrd - 2m4f Grd2 Hrd | Lay | £211.99 | £1.00 | 4.00 | £4.00 | 4.40 | 4.50 | £13.33 | -£4.00 | -£4.00 | £205.99 | £201.99 |
| 13 | 01/01/2023 15:56 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Musselburgh / Musselburgh 01/01/2023 15:45 1m7f Hcap Hrd - 1m7f Hcap Hrd | Lay | £211.99 | £1.00 | 5.00 | £5.00 | 4.20 | 4.30 | £15.68 | -£5.00 | -£5.00 | £201.99 | £196.99 |
| 14 | 01/01/2023 16:11 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Catterick / Catterick 01/01/2023 16:00 3m1f Hcap Chs - 3m1f Hcap Chs | Lay | £211.99 | £1.00 | 6.00 | £6.00 | 2.40 | 2.42 | £8.23 | -£6.00 | -£6.00 | £196.99 | £190.99 |
| 15 | 01/01/2023 16:26 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Exeter / Exeter 01/01/2023 16:15 2m3f Hcap Chs - 2m3f Hcap Chs | Back | £211.99 | £1.00 | 7.00 | £7.00 | 5.10 | 5.20 | £28.13 | -£7.00 | £28.13 | £190.99 | £219.12 |
| 16 | 01/01/2023 16:41 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fakenham / Fakenham 01/01/2023 16:30 3m Hcap Chs - 3m Hcap Chs | Lay | £219.12 | £1.00 | 1.00 | £1.00 | 2.75 | 2.77 | £1.72 | -£1.00 | -£1.00 | £219.12 | £218.12 |
| 17 | 01/01/2023 17:24 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Fairyhouse / Fairyhouse 01/01/2023 16:45 2m INHF - 2m INHF | Lay | £219.12 | £1.00 | 2.00 | £2.00 | 1.79 | 1.80 | £1.55 | -£2.00 | -£2.00 | £218.12 | £216.12 |
| 18 | 01/01/2023 17:54 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 17:26 5f Nov Stks - 5f Nov Stks | Lay | £219.12 | £1.00 | 3.00 | £3.00 | 3.90 | 3.95 | £8.53 | -£3.00 | -£3.00 | £216.12 | £213.12 |
| 19 | 01/01/2023 18:24 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 17:56 5f Hcap - 5f Hcap | Lay | £219.12 | £1.00 | 4.00 | £4.00 | 4.70 | 4.80 | £14.50 | -£4.00 | -£4.00 | £213.12 | £209.12 |
| 20 | 01/01/2023 18:54 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 18:26 5f Hcap - 5f Hcap | Lay | £219.12 | £1.00 | 5.00 | £5.00 | 4.30 | 4.40 | £16.17 | -£5.00 | -£5.00 | £209.12 | £204.12 |
| 21 | 02/01/2023 13:21 | Horse Racing - Calendar / 2023 / January 2023 / 01 (Sun) / Southwell / Southwell 01/01/2023 18:56 1m3f Hcap - 1m3f Hcap | Back | £219.12 | £1.00 | 6.00 | £6.00 | 4.8 | 4.90 | £22.34 | -£6.00 | £22.34 | £204.12 | £226.46 |
| 22 | 02/01/2023 13:29 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Lingfield / Lingfield 02/01/2023 13:23 1m Hcap - 1m Hcap | Lay | £226.46 | £1.00 | 1.00 | £1.00 | 3.6 | 3.65 | £2.55 | -£1.00 | -£1.00 | £226.46 | £225.46 |
| 23 | 02/01/2023 13:43 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 13:30 2m4f Nov Chs - 2m4f Nov Chs | Back | £226.46 | £1.00 | 2.00 | £2.00 | 1.14 | 1.15 | £0.27 | -£2.00 | £0.27 | £225.46 | £225.74 |
| 24 | 02/01/2023 13:56 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Ayr / Ayr 02/01/2023 13:45 2m4f Nov Hrd - 2m4f Nov Hrd | Lay | £226.46 | £1.00 | 3.00 | £3.00 | 1.39 | 1.40 | £1.15 | -£3.00 | -£3.00 | £225.74 | £222.74 |
| 25 | 02/01/2023 14:13 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 14:00 2m Nov Hrd - 2m Nov Hrd | Lay | £226.46 | £1.00 | 4.00 | £4.00 | 1.7 | 1.71 | £2.74 | -£4.00 | -£4.00 | £222.74 | £218.74 |
| 26 | 02/01/2023 14:27 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Ayr / Ayr 02/01/2023 14:15 2m4f Hcap Hrd - 2m4f Hcap Hrd | Lay | £226.46 | £1.00 | 5.00 | £5.00 | 6.95 | 7.15 | £29.16 | -£5.00 | -£5.00 | £218.74 | £213.74 |
| 27 | 02/01/2023 14:43 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 14:30 2m4f Nov Hrd - 2m4f Nov Hrd | Back | £226.46 | £1.00 | 6.00 | £6.00 | 1.39 | 1.40 | £2.29 | -£6.00 | £2.29 | £213.74 | £216.03 |
| 28 | 02/01/2023 14:58 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Ayr / Ayr 02/01/2023 14:45 3m Hcap Chs - 3m Hcap Chs | Back | £226.46 | £1.00 | 7.00 | £7.00 | 2.68 | 2.70 | £11.52 | -£7.00 | £11.52 | £216.03 | £227.56 |
| 29 | 02/01/2023 15:13 | Horse Racing - Calendar / 2023 / January 2023 / 02 (Mon) / Plumpton / Plumpton 02/01/2023 15:00 2m4f Hcap Hrd - 2m4f Hcap Hrd | Lay | £227.56 | £1.00 | 1.00 | £1.00 | 3.25 | 3.30 | £2.21 | -£1.00 | -£1.00 | £227.56 | £226.56 |
Topic: recorded highest balance and placing bets based on this (Read 11 times)