Hello - Im new to BetAngel
Before I plunge in I want to know if BetAngel can satisfy my particular automation need.
What I want to automate is......
1) I set up a number of Betfair trades in one particular market e.g a horse race
2) When the first trade in the market matches, the rest of trades need to be cancelled. ie im looking for a particular price/return....when matched I want to cancel the others.
Can BetAngel be set up to automatically cancel the remaining trades after the first one in the race has taken ?
Can anyone tell me if this can be set up ? Its a bit labour intensive at the moment as I do this manually.
Thanks
New User - Advice please on a specific routine
BA should be able to help you setting up the type of trades you have specified in your example but you have to set them up through spreadsheet so you would need to be able to use what if formula and other formula and combination of them. for example
1) if you want to lay runners with less than 2.0 odd then you can have this formula =if(G9<1.99,"LAY","")
2) BA templates have column for matched bets so if you have placed a back bet and its matched then it show count in column V so you can have =if(V9=1,"CANCEl_ALL","")
You can do it but you will need to be proficient in excel formulae and combining and nesting lot of them depending on the complexity of what you're trying to do.
1) if you want to lay runners with less than 2.0 odd then you can have this formula =if(G9<1.99,"LAY","")
2) BA templates have column for matched bets so if you have placed a back bet and its matched then it show count in column V so you can have =if(V9=1,"CANCEl_ALL","")
You can do it but you will need to be proficient in excel formulae and combining and nesting lot of them depending on the complexity of what you're trying to do.
Please help me, if YOU can! 
(((Yeah, YOU! 
))
Here is a ladder:
LAY___ODDS___BACK
______3,60____250
______3,55____125
120___3,50____
43____3,45____
0_____3,40____ (absolutely zero, NOTHING)
323___3,35____
232___3,30____
121___3,25____
502___3,20____
I would like to place a lay bet, 4 ticks under the current price, IF the unmatched bets on the 5th + 6th ticks under the current price are >= than 500. So if the current price is 3,5; i'd like to place a bet on 3,3; IF the unmatched bets on 3,25 and 3,2 (121+502) are bigger than 500. Can i do this with guardian, or do i need excel?
((My biggest problem with excel: I can only see 6 odds (3lay+3back) on the gridder; can i see more?))
Thank you so much!)
(((Yeah, YOU! ))Here is a ladder:
LAY___ODDS___BACK
______3,60____250
______3,55____125
120___3,50____
43____3,45____
0_____3,40____ (absolutely zero, NOTHING)
323___3,35____
232___3,30____
121___3,25____
502___3,20____
I would like to place a lay bet, 4 ticks under the current price, IF the unmatched bets on the 5th + 6th ticks under the current price are >= than 500. So if the current price is 3,5; i'd like to place a bet on 3,3; IF the unmatched bets on 3,25 and 3,2 (121+502) are bigger than 500. Can i do this with guardian, or do i need excel?
((My biggest problem with excel: I can only see 6 odds (3lay+3back) on the gridder; can i see more?))
Thank you so much!
)
This sounds quite complicated so I would go down the excel route for this.
You can specify any price in Excel. Not sure why you think you may be restricted to the six you can see? All you would need is a reference column specifying all the odds available in the exchange and offset accordingly using a vlookup.
You can specify any price in Excel. Not sure why you think you may be restricted to the six you can see? All you would need is a reference column specifying all the odds available in the exchange and offset accordingly using a vlookup.
I'm not a BA subscriber at the moment. I read the user guide, and i only saw 6 odds on the gridder in excel. How can i add more odds column?6thSense wrote:This sounds quite complicated so I would go down the excel route for this.
You can specify any price in Excel. Not sure why you think you may be restricted to the six you can see? All you would need is a reference column specifying all the odds available in the exchange and offset accordingly using a vlookup.
Than it will be easy with IF function ( i think)
Thank you for your helpfulness.
You can't add more price columns to the main Bet Angel sheet.
But you could create a column containing the Betfair prices. Such as 1.01, 1.02, 1.03, 1.04 and so on to 800, 900, 1000
Then just refer to this using the Excel MATCH function to get the row for the current price then add 6 or however many ticks you wish and read off the column using the Excel OFFSET function.
If you are not familiar with these functions then I can recommend the Excel books at the bottom of this page - http://www.betangel.com/knowledge-base/ ... -bet-angel under 'Excel Resources'
But you could create a column containing the Betfair prices. Such as 1.01, 1.02, 1.03, 1.04 and so on to 800, 900, 1000
Then just refer to this using the Excel MATCH function to get the row for the current price then add 6 or however many ticks you wish and read off the column using the Excel OFFSET function.
If you are not familiar with these functions then I can recommend the Excel books at the bottom of this page - http://www.betangel.com/knowledge-base/ ... -bet-angel under 'Excel Resources'