Profit / Loss column - details

[jokerjoe]

I was wondering if I could get some info on the P&L column in Excel.

- How often is it refreshed?
- Where does it come from, BA calculations of bets or the API function?
- Basically are there any reasons to not use it in continuous real-time triggers?

[GaryRussell]

It is refreshed as often as the prices. They are the same figures you can see on the grid interface in Betting Assistant. The figures are calculated from the list of bets retrieved from Betfair. The P&L function provided by Betfair is not used as the figures can occasionally be slightly behind the list of bets.

There's no reason not to use the figures in your triggers.

[jokerjoe]

Thanks Gary.

Quick question about the fill or kill bet references, do they behave like this:

Unfilled: Bet Ref , then CANCELLED (0 matched stake)
Part Filled: Bet Ref & "P", then Bet Ref (matched stake <> requested stake)
Fully Filled: Bet Ref (matched stake = requested stake)

[GaryRussell]

Correct except that after the bet has been killed there will not be a partially unmatched portion so in the 2nd scenario the bet ref will no longer have "P" appended.