For those who are prepared to learn, Bet Angel Professional offers a powerful feature - the ability to integrate with Microsoft Excel. In this series of articles, we have a look at how this can be done and introduce the basic concepts of Excel VBA to see how easy it is to build your own bot! Introduction
Bet Angel Professional is already a powerful application. With many features – some of them automated. It was pretty impressive when I started using it over a year ago. But then the guys over at Optic Ltd (the parent company of Bet Angel) added the ability to link into Microsoft Excel. Wow! Suddenly, the application offers an almost infinite number of ways to implement your own automation or strategies. You can write your own ‘bot’ and get that elusive ‘edge’ all traders are looking for! In this brief article, I shall attempt to look at how that can be done and hopefully, get you on your way to writing your own ‘bot’. For the purposes of this article we shall be looking at a horse race, but the principles will be the same for whichever market you wish to trade.
The above image shows the ‘Command Sheet’ that you get in the template provided to you when you buy Bet Angel Professional. Let’s investigate what we see here.
Column B shows the runners in the market.
Column C shows the current profit or loss against each selection.
Columns D-I show the prices and money available on either side of the book with Columns F&G being the currently available amounts.
Columns J-L are the command input cells. Bet Angel ‘reads’ these cells and acts according to the commands we place in there.
Coumn M is the STATUS column – more about this one later.
Columns N-Q will tell us after the commands are executed what happened!
In addition the following information is also available via this sheet:
Cell B1 tells us which market we are looking at.
Cell C2 shows us the amount matched so far.
Cell C3 tells us when the sheet was last updated.
Cells F1 & G1 tell us if the market has gone in-play or is suspended.
When writing a spreadsheet for Bet Angel it makes good sense to know what ALL the cells do and what information they give us.
