Placing bet at specific price

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
rpadrela
Posts: 72
Joined: Sun Apr 25, 2010 9:19 pm

Hi,

How do I place a back/lay bet at a specific price ? I don't want to take the current price, I want to ask for a better price but how can I do that with the BACK/LAY command ?

Thanks
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

=IF(G9=5,"BACK","")

G9= what you want to back
You can replace the word BACK with LAY
rpadrela
Posts: 72
Joined: Sun Apr 25, 2010 9:19 pm

Thanks for your quick reply.

Suppose the current back price is 2.00. I want to put a back price at let's say 3.00. I can't see how I would do that with your example.

Cheers
rpadrela
Posts: 72
Joined: Sun Apr 25, 2010 9:19 pm

Ok, now I think I know how to do that.

I wasn't seeing the Odds and Stake columns... :shock:

cheers
culedavid
Posts: 3
Joined: Sat Jun 26, 2010 1:07 am

and to back at a lower odds as current odds??is that possible??back when a horse is coming at 1.10 for example in play and lay it at 1.07??Can i do this??
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

Yes you can ...
But you have to write a command in vb to clean your stats cell before you put the lay bet.
That formula you're supposed to put in the cell:
=IF(G9<1.15,"BACK",IF(H9<1.08,"LAY",""))
And in vb I'm not so good so you'll have to ask someone from the forum to help you
culedavid
Posts: 3
Joined: Sat Jun 26, 2010 1:07 am

and where do i must to write this formula??
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

this formula goes in L9 cell
or of course L11,L13
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”