The next step in automating our weekend process is to transfer information about selected bets into a ‘database’ for record keeping and analysis.  There are no new VBA techniques in this video; everything we’ve covered before in this series, and certainly elsewhere in the Excel (VBA) for Football Traders community.  Does this mean you can skip this session?  No!  The techniques are high level and require practice.  Excel VBA is a skill so the more you practise, the better you get.  So, let’s get started …

First, we have to find the next row on the Selections sheet – a task we’ve seen before in this series.  So, stop the video and try to do it yourself before viewing Chris’s solution.  Note how Chris separates out this routine to allow it to be referenced from other macros, an example of ‘modulation’. 

With the destination for the data established, we can begin programming the data transfer.  We cover three approaches in the video: first, a single cell data transfer; then, transferring data from - and to - a range of cells.  Finally, a more dynamic transfer that selects an origin column depending on the type of bet – home, draw or away.  Cool!

The video concludes with the usual testing and discussion of where the series goes next.  It would be useful to integrate a mechanism to analyse the database of bets (and results) as it builds up – a kind of ‘Dashboard’ of progress to date.  What do you think?  With only a few videos left in this series, make sure you share your ideas with Chris.

Topics And Techniques