|
An introduction to Excel with Bet Angel Professional |
|
|
|
|
Page 1 of 2 
Excel - An introduction
With Bet Angel Professional
For those who are prepared to learn, Bet Angel Professional offers a powerful feature - the ability to integrate with Microsoft Excel. This is good news for those of us prepared to take Bet Angel to the next level!
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 two years 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 introduce some of the basic terms used when linking Excel to Bet Angel. 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 instruction 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.
|
|
Microsoft Excel
|