Hi, sorry for my English. Thanks in advance for your help
I would like to place a LAY bet and after it is matched, it closes green up with 5 ticks of profit. How should I write the formula in Excel?
Discussion regarding the spreadsheet functionality of Bet Angel.
6 posts • Page 1 of 1
I am assuming you wish to do a LAY bet at say 5 followed by a BACK bet at 5.5 which includes greening, this is easily done in Excel, the following formula gives you the stake you need to place on the Back Bet after you have placed £10 on the LAY bet.
[LAY bet price] x [LAY bet stake] / [BACK bet price] = [BACK bet stake]
so in Excel using the above figures
=5*10/5.5 the cell value would show 9.090909091 so you would need to place £9.09 on the BACK bet at 5.5
if the Back bet is also matched, this would net you £0.81 profit whether the selection wins or loses.
ODPaul as given you the formula, but it is in your own interest to read this page
https://www.betangel.com/user-guide/ins ... 3D&mw=MzIw
and subsequent pages.