listClearedOrders - Roll-up Fields Available

Owned by Former user (Deleted)
Last updated: Jun 04, 2024 by Neil Thomas
1 min read

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

Rollup level:

BET
SIDE
MARKET
EVENT
EVENT_TYPE
EXCHANGE

Settled As

Y

Y

Y

Y

Y

Y

Settled Date

Y

MAX

MAX

MAX

MAX

MAX

Bet Count

Y

Y

Y

Y

Y

Y

Profit

Y

SUM

SUM

SUM

SUM

SUM

Exchange Id

Y

Y

Y

Y

Y

Y

Event Type Id

Y

Y

Y

Y

Y

N

Event Id

Y

Y

Y

Y

N

N

Market Id

Y

Y

Y

N

N

N

Selection Id

Y

Y

N*

N

N

N

Handicap

Y

Y

N*

N

N

N

Side

Y

Y

N*

N

N

N

Price Requested

Y

AVG

N*(AVG)

N

N

N

Price Matched

Y

AVG

N*(AVG)

N

N

N

Size Settled

Y

SUM

N*(SUM)

N

N

N

Price Reduced

Y

Y

Y

N

N

N

Commission

N

N

Y

SUM

SUM

SUM

Bet Id

Y

N*

N*

N

N

N

Placed Date

Y

MAX

MAX

N

N

N

Persistence Type

Y

Y

Y

N

N

N

Order Type

Y

Y

Y

N

N

N

Regulator Code

Y

Y

Y

N

N

N

Regulator Auth Code

Y

Y

Y

N

N

N

Voided Date(where applicable)

Y

MAX

MAX

N

N

N

BetOutcome

Y

N

N

N

N

N