Skip to end of metadata
Go to start of metadata

The below table indicates fields will be available at each roll-up when making requests to listClearedOrders using the groupBy parameter.

listClearedOrders will 'hoist'  data into higher rollup levels whenever the value is unambiguous, this can occur when,

  • SIDE, RUNNER & MARKET level when only 1 bet is involved in the rollup - only 1 possible value for each field so they are all unambiguous (in particular, betId)
  • RUNNER level when all bets are on the same side - value of side is unambiguous, priceRequested and priceMatched can be averaged, sizeSettled can be totalled.
  • MARKET level when all bets are on the same selection/side combo - value of selectionId, handicap and side are unambiguous, priceRequested and priceMatched can be averaged, sizeSettled can be totalled.
  • PersistenceType and OrderType are only displayed above BET level if all bets in the rollup have the same type


*=fields that may be hoisted (if lower level fields are unambiguous or the rollup contains only 1 bet)

Rollup level:
BET
SIDE
MARKET
EVENT
EVENT_TYPE
EXCHANGE

Settled As

YYYYYY
Settled DateYMAXMAXMAXMAXMAX

Bet Count

YYYYYY
ProfitYSUMSUMSUMSUMSUM
Exchange IdYYYYYY
Event Type IdYYYYYN
Event IdYYYYNN
Market IdYYYNNN
Selection IdYYN*NNN
HandicapYYN*NNN
SideYYN*NNN
Price RequestedYAVGN*(AVG)NNN
Price MatchedYAVGN*(AVG)NNN
Size SettledYSUMN*(SUM)NNN
Price ReducedYYYNNN
CommissionNNYSUMSUMSUM
Bet IdYN*N*NNN
Placed DateYMAXMAXNNN
Persistence TypeYYYNNN
Order TypeYYYNNN
Regulator CodeYYYNNN
Regulator Auth CodeYYYNNN

Voided Date(where applicable)

YMAXMAXNNN
BetOutcomeYNNNNN