Hi,
Not really sure where to start with this one. I want to create a spreadsheet (excel 2010) in relation to betting on horse races. Say I start with a bank of $100. I want to work out if I had a strike rate of say 40% (winner 4 out of every 10 bets) how much the balance would be after say 100 bets. If I was to start with betting 2% of the bank balance each bet.
The average dividend would then affect this as I would need an average dividend of at least $2.5 to break square. And then of course my balance would still be $100. So then I would need a forecast percentage profit on turnover type figure.
So the columns I would want to use (to put in varying amounts) would be Starting Balance; Estimated Strike Rate; Bets per Year (I used 100 for an example); % Bet of Balance Each Bet; Estimate Turnover; Estimate Profit on Turnover.
Or maybe this is getting all to confusing, any suggestions would be welcome,
Regards, Paul
Not really sure where to start with this one. I want to create a spreadsheet (excel 2010) in relation to betting on horse races. Say I start with a bank of $100. I want to work out if I had a strike rate of say 40% (winner 4 out of every 10 bets) how much the balance would be after say 100 bets. If I was to start with betting 2% of the bank balance each bet.
The average dividend would then affect this as I would need an average dividend of at least $2.5 to break square. And then of course my balance would still be $100. So then I would need a forecast percentage profit on turnover type figure.
So the columns I would want to use (to put in varying amounts) would be Starting Balance; Estimated Strike Rate; Bets per Year (I used 100 for an example); % Bet of Balance Each Bet; Estimate Turnover; Estimate Profit on Turnover.
Or maybe this is getting all to confusing, any suggestions would be welcome,
Regards, Paul