General Betting
There is currently 1 person viewing this thread.
Hi all
I am sorry if title is not clear but I am trying to find a spreadsheet somewhere that will enable me to calculate profit on a bet similar to scenario that follows:
Back draw - $100 @ $3.40
Lay draw - $52 @$3.20
$52 @ $3.00
Profit $ (regardless of outcome)
This is easy to do for a two result game/event but I just cannot seem to work it out when you need to broaden results to 3 possible outcomes?
Thanks in advance
I am sorry if title is not clear but I am trying to find a spreadsheet somewhere that will enable me to calculate profit on a bet similar to scenario that follows:
Back draw - $100 @ $3.40
Lay draw - $52 @$3.20
$52 @ $3.00
Profit $ (regardless of outcome)
This is easy to do for a two result game/event but I just cannot seem to work it out when you need to broaden results to 3 possible outcomes?
Thanks in advance
sort by:
Show
per page
Replies: 1
|
By:
Ok.
You have a column with the Back amount. Then a column with the back price. Then a column that calculates the profit just for each back bet. Then a column that calculates the real return from the profit column and the back amount column. Then do exactly the same for Lay. Lay amount, then Lay price, then profit and then real return. Then put in a column for current position. Then add the real return for the back column, the real return for the lay colum and the current position. Do that for each of the three rows (match odds) and that will give you your what if. Then do a new sheet and put in links so you just have to put in current position amounts, back and lay prices and back and lay bets and it all looks neat and tidy. There may be a better way to do it, but that's how I did it. Oh and check that you've done it correctly by comparing with the betfair what if function. |