Learning VBA specifically for BA in a systematic way

Please post any questions regarding the program here.

Moderator: 2020vision

Learning VBA specifically for BA in a systematic way

Postby james-h » Wed Feb 03, 2021 4:41 pm

Hi,

I would be most grateful for any suggestions for a somewhat "systematic" way to learn VBA for the specific purpose of BA's Excel triggered betting and COM features. By way of background, I focus on long-term, slow-moving markets (e.g. winner of a league); what I am trying to do is to automate what I am now doing manually and/or with Excel formulas (taking advantage of volatility, do some thoughtful scalping, etc.).

I know there are many examples and resources in this Forum, but I was just hoping for something a bit more structured to try to be more efficient (if that is at all possible!). Specifically:
- Links to threads you have found useful (some examples below) would be great.
- Any other resources / ideas on how to approach this...

Cheers,
James

Resources:
1/ Basic reference guide Excel 2019 Power Programming with VBA: (https://www.amazon.co.uk/Excel-2019-Pow ... 1119514924)
2/ Found this video from the Gruss website quite useful as a starting point: https://www.gruss-software.co.uk/resour ... rren-power.
3/ Examples of some useful threads in the Forum (well-flagged so perhaps redundant):
Free VBA tutorials: https://www.gruss-software.co.uk/forum/ ... f=5&t=9741
BA VBA Basics!: http://gruss-software.co.uk/forum/viewt ... f=3&t=5132
james-h
 
Posts: 8
Joined: Mon Jun 15, 2020 4:29 am

Re: Learning VBA specifically for BA in a systematic way

Postby Captain Sensible » Fri Feb 05, 2021 2:27 pm

Think the easiest things is to set yourself some kind of flow chart and start thinking of all the problems you may encounter and how your code will handle them, outages etc. Put all your code into modules as it'll make life easier to read or change things and comment as much of your code as you can whilst starting over.

From the programming side there's actually very little you need VBA to do, most is simply looping thru the data then copying or pasting into the trigger columns so this forum or programming sites like stackoverflow are usually all that's needed. There's usually so many ways to do things with VBA you just need to tailor your app to be most efficient to what you're actually doing.
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Learning VBA specifically for BA in a systematic way

Postby james-h » Sun Feb 07, 2021 6:05 pm

Thank you very much indeed for that very sound advice Captain Sensible!
james-h
 
Posts: 8
Joined: Mon Jun 15, 2020 4:29 am


Return to Help

Who is online

Users browsing this forum: No registered users and 17 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.