General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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
Show More
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.
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.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539