Hello everyone, Ok what I have a spreadsheet linked to betangel and it is a simple spreadsheet firing a back bet into the market when the odds are at a certain level. Once a back bet has been submitted is there any way to prevent the spreadsheet from firing another bet into the market on the same event.
I have looked through the forum posts and am still no further forward. If anyone knows what to do then help will be very appreciated.
I am assuming it will be some code in a box saying if bet made then stop any further bets or something like that.
I know it may be a simple bit code but for a simple girl like me its hard.
Thanks in advance.
Corine
Using excel to make one bet only.
-
WinLoseWinWin
- Posts: 17
- Joined: Sat Dec 29, 2012 11:41 pm
Hi Corine
In the standard Bet Angel Excel template there is a cell (F2) that shows your transaction count. If this value is greater than 0 then your bet has been matched, so you could modify either the formula or code you are using to only place a bet if cell F2 = 0.
In my case, I have added a new formula (=COUNTA(P9:P68)) in a seperate cell which is zero until a bet is placed. And then the formulae I use in command cells all refer to the above formula and can only place a new bet if no other bets have been placed - because in my case I even if the first bet is unmatched, I don't want to place another bet.
Hope this helps.
In the standard Bet Angel Excel template there is a cell (F2) that shows your transaction count. If this value is greater than 0 then your bet has been matched, so you could modify either the formula or code you are using to only place a bet if cell F2 = 0.
In my case, I have added a new formula (=COUNTA(P9:P68)) in a seperate cell which is zero until a bet is placed. And then the formulae I use in command cells all refer to the above formula and can only place a new bet if no other bets have been placed - because in my case I even if the first bet is unmatched, I don't want to place another bet.
Hope this helps.
Hi WLWW,
I have a spreadsheet that clears bets every second and fires in bets on a number of horses when certain conditions are met. Do you know if it's possible to prevent betting on a single horse, if it has already had one bet matched against it? The best I can do is to specify no bet if Profit & Loss >0. But if a number of horses have been matched, some of them may still show a loss if they win because of bets placed on the other horses. This would then mean a second bet was fired in on the horses showing a loss - which I do not want.
I have a spreadsheet that clears bets every second and fires in bets on a number of horses when certain conditions are met. Do you know if it's possible to prevent betting on a single horse, if it has already had one bet matched against it? The best I can do is to specify no bet if Profit & Loss >0. But if a number of horses have been matched, some of them may still show a loss if they win because of bets placed on the other horses. This would then mean a second bet was fired in on the horses showing a loss - which I do not want.
-
WinLoseWinWin
- Posts: 17
- Joined: Sat Dec 29, 2012 11:41 pm
Hi Wyndon
Surely this would be a simple case of modifying the formulae or code you are using to fire the bets to check the matched backs and/or matched lays columns in the spreadsheet against the respective horse/s and don't fire the bet if the count of matched bets is greater than zero?
Or am I missing something?
Surely this would be a simple case of modifying the formulae or code you are using to fire the bets to check the matched backs and/or matched lays columns in the spreadsheet against the respective horse/s and don't fire the bet if the count of matched bets is greater than zero?
Or am I missing something?
Dont understand why dont you just use guardian, its alot easierCorine wrote:Hello everyone, Ok what I have a spreadsheet linked to betangel and it is a simple spreadsheet firing a back bet into the market when the odds are at a certain level. Once a back bet has been submitted is there any way to prevent the spreadsheet from firing another bet into the market on the same event.
I have looked through the forum posts and am still no further forward. If anyone knows what to do then help will be very appreciated.
I am assuming it will be some code in a box saying if bet made then stop any further bets or something like that.
I know it may be a simple bit code but for a simple girl like me its hard.
Thanks in advance.
Corine
Hi everyone,
Thanks for all your replies and I will give that a try and see how I get on WLWW and I have looked at guardian Alpha322 but I did not know that could be done with that but I will try and update you all.
Thanks for all the advice and it is very appreciated, you guys are excellent.
Corine
Thanks for all your replies and I will give that a try and see how I get on WLWW and I have looked at guardian Alpha322 but I did not know that could be done with that but I will try and update you all.
Thanks for all the advice and it is very appreciated, you guys are excellent.
Corine
-
WinLoseWinWin
- Posts: 17
- Joined: Sat Dec 29, 2012 11:41 pm
Hi Wyndon.
You should still have the matched bet count in columns AB and AE though.
You should still have the matched bet count in columns AB and AE though.
There is a further complication in trying to place a restriction of one transaction on any horse for whom a bet is triggered. Because of the 1 second delay before a bet is placed when in-play, bets can still be fired in before it is known whether the original bet was matched or not. Does anyone no a way controlling the frequency at which bets are triggered? I thought perhaps limiting the data request to Betfair to 1 per second might achieve the required result, but this just seemed to clog things up.