VBA developer

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
michaelg2708
Posts: 20
Joined: Fri Sep 02, 2016 3:08 pm

Hey everyone i am looking for a VBA developer. i have a spreadsheet with a lot of code in it that updates once every two seconds but for my strategy it needs to be quicker than this. i know it's not my computer speed because it has 8 cores. i have asked on excel vba websites but they don't understand the bet angel side, thanks in advance for your help, michael
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

michaelg2708 wrote:
Sat Jul 14, 2018 9:32 pm
Hey everyone i am looking for a VBA developer. i have a spreadsheet with a lot of code in it that updates once every two seconds but for my strategy it needs to be quicker than this. i know it's not my computer speed because it has 8 cores. i have asked on excel vba websites but they don't understand the bet angel side, thanks in advance for your help, michael
nigelk may be your best bet as he's done loads of BA related VBA. as you say, it's a niche field.

viewtopic.php?f=19&t=15708
michaelg2708
Posts: 20
Joined: Fri Sep 02, 2016 3:08 pm

Cheers for the reply but I've tried him already. Was sending him emails then he just stopped replying. I've sent a few messages in that link u sent but my last message didn't get a reply either
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

There's a few people who do it, incl me but the fly in the ointment is economics. Development to a standard to hand to someone else (ie without the usual foibles) isn't a 5 minute job. I've got 2 or 3 people I'd like to do work for because they've got interesting ideas, and I wouldn't charge them, but the problem is finding the time. Especially when time is precious.

Otherwise, if people (ie people on excel sites) are ify about the BA angle then I wouldn't bother using them anyway. BA just populates cells like any other DDE would, it's nothing special. If they've never seen that before then they're probably just a bedroom developer and not the calibre of person you'll go the extra yard for you.

If you've already got a lot of code you've written but it's just a bit slow, we're quite open to answering some questions or giving advice if you wanted to describe the methods you're using on the forum. Quite often it just takes a tweak than a rewrite to pep things up a bit. Disabling recalcs and screen updates, or using variables instead of cells to store things, different polling methods, putting some timers in to see where the bottleneck is etc etc. You won't find a coder who isn't a bit obsessive about efficiency and speed.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

michaelg2708 wrote:
Sat Jul 14, 2018 9:32 pm
Hey everyone i am looking for a VBA developer. i have a spreadsheet with a lot of code in it that updates once every two seconds but for my strategy it needs to be quicker than this. i know it's not my computer speed because it has 8 cores. i have asked on excel vba websites but they don't understand the bet angel side, thanks in advance for your help, michael
I'd agree with Shaun, if you've a decent pc and a bot already coded you just need to track down where it's slowing down as both ba and excel shouldn't be taking 2 seconds to execute the code. If someone coded it for you go back to them otherwise maybe start sticking in some timers to try and debug where your slowdowns are.
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1068

^VBA code for a micro-timer so you can see how long your total code takes to run, this is a little ahead of where I am with my system yet but I assume you can put it around smaller sections of your code too to find out where your slowest area of number crunching is happening.
michaelg2708
Posts: 20
Joined: Fri Sep 02, 2016 3:08 pm

Hey guys thanks for all your suggestions I'm getting more help now than I have looking round the net. As suggested I had already went back to the people that made the sheet but they say they can do nothing for me they say the more formulas the slower the sheet. Im very new to VBA and even excel i wouldn't even know where to put a timer in my code or how to make tweaks. I did download an add on that times the code and the formulas and when I ran it both were calculated in milliseconds I think it's when they run together the problem begins. I don't mind paying for the work that is required if anyone thinks they are up for the job.
Thanks, michael
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Do you have VBA on your sheet? If the formulas only take milliseconds it's likely they're just continually triggering the vba routine because events aren't turned off when the VBA runs
michaelg2708
Posts: 20
Joined: Fri Sep 02, 2016 3:08 pm

There is a lot of VBA but I didn't write any of it so I know it works and does what it is supposed to do (slowly) but don't know how it works. Sorry for being useless but my excel knowledge is very limited. I'm sure someone with knowledge of VBA could tell you in a few seconds
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

michaelg2708 wrote:
Sun Jul 15, 2018 10:08 pm
There is a lot of VBA but I didn't write any of it so I know it works and does what it is supposed to do (slowly) but don't know how it works. Sorry for being useless but my excel knowledge is very limited. I'm sure someone with knowledge of VBA could tell you in a few seconds
you'd be surprised at the fact that another developers intetions (unless well commented, structured and executed) will take definitely more than a few seconds to comprehend, analyse and fix.

this has always been my bugbear with taking on other devs work - it usually means a complete rework and unless MY work is of a certain standard, yet another dev will demand a similar *rework*. therefore, you need to almost be au fait to mandating developer guidelines and coding standards, otherwise, you're always in cowboy terrotory..
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

I agree with jimi about interpreting other people's work. The thing is it's just like any other language with verbs, nouns and adjectives, there's many ways to tell the same story and you can end up with anything from a rambling stream of consciousness to a limerick.

I tried to introduce rigid standards at work but you could still spot an individual's works as easily as seeing their handwriting. These days, because I'm the only one who sees it it's a lot less formal. But that's also because doing 'proper' coding takes so much longer and it's time you don't always want to commit to something that might not get beyond a prototype. And if it does end up being useful then, if it ain't broke, don't fix it.

Similarly it might be hard to give specific advice as it might not be relevant and tbh you do need some experience with the vba dev front-end to step through the code and put in some debug in to see what's going on.

Unless it contains something especially secretive, then if you made it available on Dropbox or similar then perhaps someone can give it a 5 minute look at to see if the basics are sound?
foxwood
Posts: 390
Joined: Mon Jul 23, 2012 2:54 pm

The first thing to check for support always used to be "is it turned on" so I'm going to be silly and go back to basics just in case your refresh rate is set at 2 seconds :D ...

1) is Excel connected to Guardian or to the main BA window ?
2) what is the refresh rate you are using for BA/Guardian ?
3) if you are using Guardian what are the restrict refresh time settings ?
4) are you linking multiple markets to Excel ?
5) if multiple markets, how many can be active in BA/Guardian at the same time ?
6) are you running watch lists at the same time ?
7) any other market/setup/timing oddities this might have made you think of ?
michaelg2708
Posts: 20
Joined: Fri Sep 02, 2016 3:08 pm

I took Shaun's advice and have uploaded my file to dropbox if someone could spare ten minutes to take a look at it to let me know does it need a tweak or a complete rewrite. i have removed my formulas as this would reveal my strategy. this is the file that i got made for me so the VBA code is not mine, i understand what it is doing but can't write it. first time using dropbox so if it doesn't work let me know. i always have the spreadsheet running off guardian with a 15 minute restrict on it so sometimes there are 3 races going at once and i always have it running at 20ms
cheers, michael

https://www.dropbox.com/s/cnc44yz76vtz9 ... .xlsm?dl=0
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

i'm sure i've seen this exact sheet somewhere before!!


https://www.youtube.com/watch?v=ivFozmCvqh0&t=5s
Last edited by MemphisFlash on Tue Jul 17, 2018 6:40 pm, edited 1 time in total.
michaelg2708
Posts: 20
Joined: Fri Sep 02, 2016 3:08 pm

its from excel betting bots but i paid to get a custom one with a few changes plus get multiple spreadsheets. can you see any ways to make it quicker?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”