Hi guys. I am using automation to lay the field at a set price, 1 minute before the off to a set liability. If a horse is already below that price, hence gets layed immediately, I want to have the liability adjusted to that lower price.
Example.. If I am laying the field at 2.0 with a liabilty of $50, that means $50 will be placed on each runner as a lay. If a runner is at 1.5 when the bets are fired into the market 1 minute pre-off, it still only puts $50 on that runner because the bet is placed at 2.0, but matched at best odds, in this case 1.5, hence my liabilty is only $25. I want it to put $100 on the runner to keep my liability at $50 across all runners.
Can this be done by using excel or any special conditions???
Cheers
Lay field - Liability adjustment
The short answer is yes. Anything can be done on excel dependant on your skill level using it.
I have spent a long time developing a strategy using automation and excel and have had to do almost all of it myself. You will get some guidance and pointers from this forum but be prepared to do the legwork yourself. Sixth sense from bet angel seems to be the tech guy on this forum and he has been helpful in terms of advice and guidance but dont expect to be given exactly what you need. As i say anything is possible on excel so what you need definetly will be. I had to get some outside help to code what i wanted in visual basic as macros are not my thing.
Good luck !
I have spent a long time developing a strategy using automation and excel and have had to do almost all of it myself. You will get some guidance and pointers from this forum but be prepared to do the legwork yourself. Sixth sense from bet angel seems to be the tech guy on this forum and he has been helpful in terms of advice and guidance but dont expect to be given exactly what you need. As i say anything is possible on excel so what you need definetly will be. I had to get some outside help to code what i wanted in visual basic as macros are not my thing.
Good luck !
Excel is brilliant for things like that, as you can put allsorts of conditions & arguments into the equation
I think Excel works best for race by race traders & not sport traders. The reason I say that, is because when I have just 1 Excel sheet open, it works perfect, but when I start adding extra sheets, BA Excel becomes very sticky & doesn't update regularly
I think Excel works best for race by race traders & not sport traders. The reason I say that, is because when I have just 1 Excel sheet open, it works perfect, but when I start adding extra sheets, BA Excel becomes very sticky & doesn't update regularly
Le Tiss - i link every race each day to one workbook with up to 50 sheets. It works fine except when one race overlaps with another and then it slows right down. I have the maximum data calls per second set to 17 so i dont get charged and when 2 races overlap it jumps to 17 and stays there and slows right down. So i can only assume that i am trying to pull too much data from betfair at any one time and betangel then restricts this causing the slow down. it also gives me a problem when i am trying to trade say a tennis match and a horse race starts on automation and excel - again it slows right down
-
mandymoozle
- Posts: 15
- Joined: Sat Jun 18, 2011 2:12 pm
I run an excel sheet through guardian with about 40 tabs for different horse markets and to stop it slowing right down i restrict the refresh. The way I bet I can use 5 second intervals (mainly because I only make the market active shortly before the off) so it works fine but perhaps you need a quicker refresh. when the irish races overlap the times for the UK ones it can get difficult
i restrict refresh as well to 5 secs before the start of a race but if one meeting is delayed and 2 races go in running at the same time thats when more data calls per second are required than my setting of 17 and thats what slows it right down
Have a look at this fellas site.
http://exceltrader.net/984/benchmark_et ... r-traders/
He has free stuff...the benchmark software he gives is interesting...hope this helps
http://exceltrader.net/984/benchmark_et ... r-traders/
He has free stuff...the benchmark software he gives is interesting...hope this helps
Thx NUTS. I'm happy to have a go at it, but just wanted a quick heads up from 6thsense or one of the other gurus if:THENUTS wrote:The short answer is yes. Anything can be done on excel dependant on your skill level using it.
I have spent a long time developing a strategy using automation and excel and have had to do almost all of it myself. You will get some guidance and pointers from this forum but be prepared to do the legwork yourself. Sixth sense from bet angel seems to be the tech guy on this forum and he has been helpful in terms of advice and guidance but dont expect to be given exactly what you need. As i say anything is possible on excel so what you need definetly will be. I had to get some outside help to code what i wanted in visual basic as macros are not my thing.
Good luck !
a) there actually is a setting in automation I am missing
b) that it actually can be done
I'll play around with it.
Cheers