Lay bet with 5 ticks of profit

[gaspino72]

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?
Thank you

Giuseppe

[conduirez]

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?
Thank you

Giuseppe

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.

[gaspino72]

Thanks, but I need the formula to write in the cell of column 9 in the bet Angel spreadsheet. Thank you

[ODPaul82]

="LAY OFFSET:5 WITH_GREENING:TRUE"

[conduirez]

Thanks, but I need the formula to write in the cell of column 9 in the bet Angel spreadsheet. Thank you

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.

[gaspino72]

Thank you very mutch ODPaul82 e conduirez