I just tried to place a bet in a live market but got an error.
I set these first: Odds 1000, Stake 2
Then in the Bet Rules cell: IF(G11<1.4,"Lay",) . G11 is the current Back price. This produced an Error.
Then I tried this Global Command and got an Error: Green_All .
What's wrong??
Formula syntax in Excel
Don't use triggered betting myself so not sure of the cell references and commands but you need to tell excel what to do if cell G4 is not <1.4
e.g IF(G11<1.4,"Lay","") this would tell excel to do nothing if G11 is not <1.4
Be careful as if you apply this to all runners it appears to me that you would be backing most losers and laying a large % of winners.
e.g IF(G11<1.4,"Lay","") this would tell excel to do nothing if G11 is not <1.4
Be careful as if you apply this to all runners it appears to me that you would be backing most losers and laying a large % of winners.
That's right. Excel was meant to Lay only if G11 is less than 1.4 . G11 was 1.2 when I typed in the If function and pressed enter. No bet was made.petexxxx wrote:Don't use triggered betting myself so not sure of the cell references and commands but you need to tell excel what to do if cell G4 is not <1.4
e.g IF(G11<1.4,"Lay","") this would tell excel to do nothing if G11 is not <1.4
Be careful as if you apply this to all runners it appears to me that you would be backing most losers and laying a large % of winners.
An earlier Lay bet on the same runner was successfully made with no formula. Is it possible that you can only make one Lay bet on each runner in the BetAngel_1 spreadsheet?
This is only a syntax test. It won't be applied to all runners...
I personally find it best to do all the formulas etc. in another cell (I use columns to to the right but it doesn't really matter) Then just put the relevant cell ref in the actual rules cell, I don't know whay but it seems to work better. I am not aware of any limit to the number of bets you can place in excel as long as you keep clearing the status cell
Hi
A couple of things I noticed:
1. Your formula does not have a false argument,but petexxxx formule is the correct syntax i.e. IF(G11<1.4,"Lay","")
2. With the betangel spreadshet I think you have to populate Odds & Stake cells (columns M & N) as well so it can trigger correctly.
Regards
Alan
A couple of things I noticed:
1. Your formula does not have a false argument,but petexxxx formule is the correct syntax i.e. IF(G11<1.4,"Lay","")
2. With the betangel spreadshet I think you have to populate Odds & Stake cells (columns M & N) as well so it can trigger correctly.
Regards
Alan
Hi,
You also need to start a formula with = ie
=IF(G11<1.4,"Lay","")
If you miss that it will generate an error. What I do is use other sheets within excel, pull the data into one, to do calculations such as implied IP etc. Then have another sheet to take the data and decide whether a bet should be placed, doing things like checking that the stake I want to place is available on all the runners I want to back. That way you can use one sheet for one type of betting and add another if you want to do a different type of betting. It takes a while to develop the code, learning VBA gives you a lot more control over what happens, means that you can set it to avoid incorrect bets. Always try and make your spreadsheets failsafe, so that if there is any knid of problem it will fail to place a bet, rather than blow all your pot in about 1/100 of a second.
Nic
You also need to start a formula with = ie
=IF(G11<1.4,"Lay","")
If you miss that it will generate an error. What I do is use other sheets within excel, pull the data into one, to do calculations such as implied IP etc. Then have another sheet to take the data and decide whether a bet should be placed, doing things like checking that the stake I want to place is available on all the runners I want to back. That way you can use one sheet for one type of betting and add another if you want to do a different type of betting. It takes a while to develop the code, learning VBA gives you a lot more control over what happens, means that you can set it to avoid incorrect bets. Always try and make your spreadsheets failsafe, so that if there is any knid of problem it will fail to place a bet, rather than blow all your pot in about 1/100 of a second.
Nic