Hi, I am looking for a formula that will calculate the place and win.
I am looking to find a calculation that will work out if it places 1,2,3 it also calculates the stake X PLACE BSP and the stake X BSP (if its 1st only) . And if its not 1,2,3 it minus' the win stake and a place stake.
So for example the first bet on the table below(Tying the knot), it calculates the win (position 1) Stake x BSP = £33.25. I want it to calculate stake X BSP AND place BSP. But for the next bet ( Jikala), I want to show a loss of -4, as i lost the place and win stake.
I hope this makes sense!
I am looking to find a calculation that will work out if it places 1,2,3 it also calculates the stake X PLACE BSP and the stake X BSP (if its 1st only) . And if its not 1,2,3 it minus' the win stake and a place stake.
So for example the first bet on the table below(Tying the knot), it calculates the win (position 1) Stake x BSP = £33.25. I want it to calculate stake X BSP AND place BSP. But for the next bet ( Jikala), I want to show a loss of -4, as i lost the place and win stake.
I hope this makes sense!
| Race Time | Course | Horse | Position | Won/Placed | Place BSP | BSP | Stake | Profit | Balance |
04/01/2023 13:30 | HEREFORD | Tying The Knot | 1 | wp | 3.1 | 18.5 | 2 | 33.25 | 131.25 |
04/01/2023 13:30 | HEREFORD | Jikala | 2 | p | 1.75 | 5.11430196 | 2 | -2 | 98 |
04/01/2023 14:00 | HEREFORD | Mr Katanga | 9 | 3.7 | 11.2464887 | 2.57 | -2.57 | 126.06 | |
04/01/2023 14:00 | HEREFORD | Fort Denison | 8 | 6.9487481 | 24.9357349 | 2.62 | -2.62 | 128.63 | |
04/01/2023 14:30 | HEREFORD | Christopher Wood | 2 | p | 2.13962701 | 3.9185813 | 2.52 | -2.52 | 123.54 |
04/01/2023 16:00 | HEREFORD | Rock On Rita | 5 | 9 | 30.4518127 | 2.86 | -2.86 | 139.92 | |
04/01/2023 16:00 | HEREFORD | Not Sure | 1 | wp | 3 | 9.2 | 2.47 | 19.24 | 142.78 |
16/01/2023 13:10 | HEREFORD | Tremwedge | P | 16.0384699 | 77.7954938 | 2.88 | -2.88 | 140.93 | |
16/01/2023 13:10 | HEREFORD | Madiba Passion | P | 3.75 | 11.987544 | 2.93 | -2.93 | 143.81 | |
16/01/2023 13:10 | HEREFORD | Greenrock Abbey | 1 | wp | 1.62823404 | 3.56550964 | 2.8 | 6.82 | 146.74 |
16/01/2023 13:40 | HEREFORD | Ramo | 3 | 1.82 | 3.65 | 2.82 | -2.82 | 138.11 | |
16/01/2023 14:10 | HEREFORD | Obsessedwithyou | 2 | p | 1.57 | 2.38 | 2.76 | -2.76 | 135.35 |
16/01/2023 15:10 | HEREFORD | Legendary Rhythm | 6 | 4.8 | 21.7470001 | 2.65 | -2.65 | 129.99 | |
16/01/2023 15:10 | HEREFORD | Heron Creek | P | 2.66530539 | 6.54379143 | 2.71 | -2.71 | 132.64 | |
16/01/2023 15:40 | HEREFORD | Fay Ce Que Voudras | 1 | wp | 1.81875639 | 4.4 | 2.55 | 8.24 | 135.63 |
16/01/2023 15:40 | HEREFORD | Doctor Dotty | P | 13.5 | 85 | 2.6 | -2.6 | 127.39 | |
16/01/2023 16:10 | HEREFORD | Pay The Pilot | P | 3.15 | 9.17694634 | 2.71 | -2.71 | 132.92 |
| | | | | | |
