The beauty of using Excel is that we can implement our own conditions that have to be met before a bet is placed.

For instance, let’s have a look at the ‘IF’ function of Excel.

The ‘IF’ function has the following function:

• IF (logical test IS true, then do this, else do this)

Select a clean worksheet and type the following into a cell B2

=IF(2+2=4,"Yes 2 plus 2 equals 4","I can't add")

You will see that the TRUE value is what appears in cell B2. But you can still see the IF test in the function area of the cell (at the top of the sheet).

So, how can we use this with Bet Angel?

Let’s say that in the previous race we want to BACK ‘Desert Lover’ but only if the price reaches 3.8 – two ticks than it is currently. We would type the following into cell J6 – the command cell for this selection:

=IF(F6=3.8,"BACK","")

Why F6? It so happens that cell F6 contains the current price available in the market for our selection. We would also enter the price and stake into the relevant cells also.

In the example above of course we would not need to enter the conditional IF statement as Bet Angel will fire the order in at 3.8 anyway – and the order will sit there until the price is reached. But it demonstrates an important technique.

Another useful function is ‘SUM’. This function will add together the values of two or more cells. One useful example of this would be to calculate the weight of money against a selection.

For example, if we would like to know the weight of money against a selection we need to add the monies available at each price across both sides of the book. Looking at the Bet Angel sheet again we can see that columns D through I contain money values against each price in the market. Three on the back side of the book and three on the lay side.

Switch to ‘Sheet1’ in the workbook and type the following into cell B2:

=SUM('Bet Angel'!D7:I7)

The 'Bet Angel'! bit in the formula above is saying ‘I want to reference the sheet called ‘Bet Angel’. In cell B1 you will now see a figure that shows the amount of money waiting to be matched in the market for the selection at the top.

(replacing D7 & I7 with D9 & I9 will show the amount of money waiting to matched for the next selection down and so on in steps of two.)

In cell C2 type the following:

=SUM('Bet Angel'!D7:F7)

This will show the amount of money waiting to matched on the BACK side of the book only.

Now type the following into cell C3

=C2/B2

This will now show a figure similar to this – 0.5364 – just highlight this cell and format it to show the figure as a percentage. Handily, Excel provides a way of doing this easily. Just click on the ‘%’ symbol in the top menu bar.

We can now see the weight of money in the market for our selection! Using these types of calculations together with the IF function really brings out the power of using Excel with Bet Angel Professional.

From what we have learned so far, you can see how you could structure this condition within Excel:

Enter this in the following way into cell C4 (still in Sheet1).

=IF(AND('Bet Angel'!F6=3.8,C3<30%),"BACK","")

This is saying IF cell F6 on the Bet Angel sheet is equal to 3.8 AND the weight of money is less than 30% then fill cell C4 with the word ‘BACK’ else fill it with nothing.

Although there are many, many more functions included with Excel, I do not intended to go into Excel to the ‘nth degree. However, you can find out how all the other functions work by clicking help within Excel. Try a few out!