Detecting when an initially unmatched bet has been matched

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
leshi86
Posts: 5
Joined: Tue Jun 08, 2010 1:20 pm

Hi guys,

If the market for a runner is 1.67-1.68 and I put in a back at 1.68, BA spreadsheet will say the amount was fully unmatched at the time I entered the bet.

What I would like to know is, is there a way to detect/track that bet afterwards to know when it is partially/fully matched?

Note:
I can work this out by calculating change in the P&L figures but if things get messy (i.e. another bet is matched in the meantime) you won't be able to track it this way.

I also know that if the price moves against you then you know your bet got matched, but what if the market stays the same but you get matched?

Thanks
toptrader
Posts: 77
Joined: Sun Jan 31, 2010 9:58 pm

You can check the bet status cells (the right 4 columns in excel) to see if the bet has been matched
best thing is to build a timer in excel to check this every few seconds
leshi86
Posts: 5
Joined: Tue Jun 08, 2010 1:20 pm

Thanks toptrader....

That is exactly what I wanted to know however I have another question now....

If I use the offset function without fill or kill, it places 2 bets simultaneously....is there a way I can track both of them this way?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”