Unmatched bets and open positions for a particular selection

[Tom318]

Hello all,

Just started studying a few of the Excel templates (BetAngel_1, BetAngel-auto-trade-v2, BetAngel_auto trading bot).

(1) I notice that the test for unmatched bets is something along the lines of IF('Bet Angel'!C5 = 0). This would be true if we are only trading one selection, but what if we are trading more than one selection in the race? Is there a way of testing for unmatched bets for a particular selection?

(2) In the template BetAngel_auto trading bot.xls (download/file.php?id=380), the test for any open positions is IF('Bet Angel'!C15 = 0). I don't understand why it is C15 in particular, which happens to be the P&L for the 4th horse?

(3) If we have already opened and closed a position for this selection, then the P&L may not be 0 even though there are currently no open positions, so this may not be a valid test. More appropriate would be testing whether the Net Stake = 0 for a particular selection. Is this possible?

[6thSense]

Columns T through Y have unmatched bet information by individual market selection.

I just had a look at the sheet you refer to and the test for unmatched bets in that spreadsheet is looking at cell C5 in the Bet Angel sheet not C15. C5 is where the unmatched bet count is.

You may be able to work out the net stake position by looking at the matched bet information columns Z through AE.

[Tom318]

6th Sense, thank you for the prompt response. I just took a look at the templates again and your suggestions have provided the solutions to my questions. Much appreciated!!!

[Tom318]

If I have an unmatched bet and elect to take the SP price, will I see the matched bet information in columns Z through AE immediately once the market is in play? This will enable me to know what the BSP is and put in an appropriate offset order should I so wish.

Also is there any way of accessing all the BSP's during in play for that race via Excel?

[LinusP]

If I have an unmatched bet and elect to take the SP price, will I see the matched bet information in columns Z through AE immediately once the market is in play? This will enable me to know what the BSP is and put in an appropriate offset order should I so wish.

Also is there any way of accessing all the BSP's during in play for that race via Excel?

I don't think SP bets will show on excel but I might be wrong.

If you go to settings-excel there is a check box where you can get the BSP and predicted BSP to show in excel. It will show in column AF.

[Tom318]

Thanks Linus. I tried it in practice mode and once the market goes in-play, the SP bet does in fact show immediately in the matched bets section of the Excel sheet, and of course the corresponding pre-off unmatched bet disappears simultaneously.