Hi all
I spent a long time learning excel and VBA to develop a bot to use on the racing (but it can also be applied to other sports too). It works by gathering the price and amount data each designated refresh - and then if a particular pattern is met with that data it will place a particular bet (of course I have a database Sheet with the criteria for a named strategy) so basically if I have the refresh set to 1 second it will gather data for each second and cycle through the relevant strategies to see what bets, if any, it should place.
The problem is that because it takes over 1 second to cycle through the strategies (on excel), the refresh rate is interupted and the strategies malfunction. I have been through my VBA code and tweeked it to lower the time it takes and also to cut out any needless steps and calculations, but it still does not perform to my wishes. So I was wondering do individuals that use bots have them set for slower refreshes? I must say I would not have anticipated that, but perhaps using excel it is a logistical hurdle that has to be over come by using a slower refresh?
Would appreciate anyones suggestion in this matter...
All the best!
What refresh rate do you tend to use with bots?
-
marksmeets302
- Posts: 527
- Joined: Thu Dec 10, 2009 4:37 pm
Excel can be pretty cpu intensive, but converting it to a C++/java/whathaveyou program is not an easy task. Instead you might want to google the web for excel compilers. I honestly have no idea if they work, but being able to turn your excel spreadsheet into a standalone application without all the overhead of excel itself should give a nice performance boost.
I use java, and my vps is doing nothing 99% of the time. The refresh rate I set is 500 milliseconds, but I don't think it would matter if it was set to 3000. So that's another option
I use java, and my vps is doing nothing 99% of the time. The refresh rate I set is 500 milliseconds, but I don't think it would matter if it was set to 3000. So that's another option
-
RideTheLightning
- Posts: 136
- Joined: Fri Jul 03, 2009 1:08 am
Hi guys, cheers fir the replies and sorry for late response.
I have sorted my problems, had to further reduce certain calculations, and change the structure of the VBA procedure.
marksmeets302, I would perhaps look to do that in the future, but have no time to learn another language at present - might outsource it though, but would still have to test it etc....
burdo77, only 1 market was launched so that wasn't the issue!
I have sorted my problems, had to further reduce certain calculations, and change the structure of the VBA procedure.
marksmeets302, I would perhaps look to do that in the future, but have no time to learn another language at present - might outsource it though, but would still have to test it etc....
burdo77, only 1 market was launched so that wasn't the issue!
If you have a lot of if / then statements, try using select case instead, it's much quicker.
For example, if you have 100 if/then statements, even if the very first condition is met, the other 99 will still be assessed. With the select case, once a condition is met, the others will be ignored.
Try to minimize the use of select (Sheet1.Select, Range("A1").Select etc,etc) it's not necessary.
Some formulas are more resource hungry than others, once a condition has been met, try changing the formula to its value, and only re-enter it when necessary.
Lastly, if you have any code in as sheet events, make sure you turn the events off/on as necessary.
For example, if you have 100 if/then statements, even if the very first condition is met, the other 99 will still be assessed. With the select case, once a condition is met, the others will be ignored.
Try to minimize the use of select (Sheet1.Select, Range("A1").Select etc,etc) it's not necessary.
Some formulas are more resource hungry than others, once a condition has been met, try changing the formula to its value, and only re-enter it when necessary.
Lastly, if you have any code in as sheet events, make sure you turn the events off/on as necessary.
