Backtest with dutching stakes in excel formula ?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
bernal
Posts: 29
Joined: Mon Jan 30, 2017 6:14 pm

Hi i know how to backtest with flat stakes(back bets) BSP in excel, but i want to use dutching stakes I tried multiple formulas but it now work ! , thats my formula for flat stakes right now :

Code: Select all

=IF([@[WIN_LOSE]]=1,([@BSP]-1)*10*0.95,-10)
Thanks in advance :)
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Grouping the selections by race and working out the proportion of stake to use on each isn't a one-liner but you might get a more 'dutchy' outcome using liability staking. Ie replace your 10 stake with 10/(bsp-1).

You'll also get a better result using 0.98 instead of 0.95 ;)
User avatar
The Silk Run
Posts: 902
Joined: Mon May 14, 2018 12:53 am
Location: United Kingdom

Have you considered split stake, which is similar to Dutch betting.
Example: 1 point = £1.00 Back R1 0.50, R2 0.25, R3 0.25
User avatar
bernal
Posts: 29
Joined: Mon Jan 30, 2017 6:14 pm

ShaunWhite wrote:
Fri Jan 13, 2023 7:25 pm
Grouping the selections by race and working out the proportion of stake to use on each isn't a one-liner but you might get a more 'dutchy' outcome using liability staking. Ie replace your 10 stake with 10/(bsp-1).

You'll also get a better result using 0.98 instead of 0.95 ;)
thanks a lot ! all works good now :)
User avatar
bernal
Posts: 29
Joined: Mon Jan 30, 2017 6:14 pm

Any idea how to group selections by race, so can excel calculate commision and death heat properly for each race ? maybe somehow by event id ?
Anbell
Posts: 2007
Joined: Fri Apr 05, 2019 2:31 am

bernal wrote:
Wed Jan 18, 2023 11:54 am
Any idea how to group selections by race, so can excel calculate commision and death heat properly for each race ? maybe somehow by event id ?
Pivot table or sumif
Anbell
Posts: 2007
Joined: Fri Apr 05, 2019 2:31 am

ShaunWhite wrote:
Fri Jan 13, 2023 7:25 pm
Grouping the selections by race and working out the proportion of stake to use on each isn't a one-liner but you might get a more 'dutchy' outcome using liability staking. Ie replace your 10 stake with 10/(bsp-1).

You'll also get a better result using 0.98 instead of 0.95 ;)
10/p is usually 'better' for dutching
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”