Skip to main content
Version: 8.6.3.4

Schema: MLegOrderGateway (ID: 5155)

Records inserted, updated, or replaced into the MLegOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release.

See the SpiderRock Execution Engine concept guide for more details.

METADATA

AttributeValue
Topic5120-srse-gateway
MLink TokenInternal
MLink EndpointMLink-Live
SRSE ProductSRTrade

Note: The symbol = next to a field number indicates that it is a primary key.

BODY

#FieldTypeDefault ValueComment
10=tickerTickerKey
11=accntstring(16)Will automatically be set to the account associated with DB login
12=groupingCodelongClient supplied order
13=orderSideenum : BuySellBuy
14=clientFirmstring(16)
103spdrActionTypeenum : SpdrActionTypeAddReplace[Add (new order), AddReplace (add or replace order), Cancel (cxl existing), Replace (update existing only), Release (modify order active size)]
106altOrderIdstring(24)Alternate client order ID. This order ID will be copied to all execution reports.
109altAutoHedgeIdstring(24)alternate order ID for child autohedge orders (if any)
112altAccntstring(32)alternate (client assigned) "long" account string (optional) [used to map between client and SR account strings]
115altUserNamestring(24)alternate (client assigned) user name (optional) [used to map between client and SR account strings]
607execBrkrCodestring(16)(optional) override the default execBrkrCode for this order
121strategystring(36)Client strategy string. This value will appear on the SR Trade Monitor and in execution reports.
610strategyAccntstring(16)SR strategy account (option; if exists will be validated)
612visibleInSVenum : YesNoallow order to be visible in SV (do not use for high volume of orders)
127orderDttmDateTimeorder entry time (from client;if any)
130orderSizeint-1parent order size (contracts) [-1 = no change;used when spdrActionType=Release]
133orderActiveSizeint-1total activated size (total size released for execution) (-1 = all available size)
136addCumFillQuantityenum : YesNoNoIf Yes then OrderSize is calculated @ order arrival as requested OrderSize + existing 'CumFillQuantity'.
613exchMasklong0eligible exchanges (0 = all)
142maxExposureSizeint-1maximum simultaneous cumulative child order public size exposure (-1 = orderActiveSize) [order can overfill if > orderActiveSize and numMakeExchanges > 1]
145numMakeExchangesbyte1number of exchanges (1 - 4) on which to publish public making orders. Effective number might be less than requested number if sufficient exchanges are not available.
148publicSizeenum : PublicSizeHandlingNonepublic order size handling: None=use default size handling (usually limits public size to 'typical' market size); Randomize=randomize public size; MktSize=expose only 'typical' market size; FullSize=expose entire order size where possible
151randomizeSizeenum : YesNoYesrandomize public order size
154canOverlapCxlReplenum : YesNoNocan execution engines overlap cancel/replace operations [order can overfill if YES] (at most one active overlapping cxl/replace operation for each parent order)
157progressRuleenum : ProgressRuleNoneNone = all size immediately available;TWAP = size released in time intervals;VWAP = size released in volume intervals;
160twapSliceCntbyte4[ProgressSliceCnt] number of progress slices to use (default = 4 or 8) [max 20]
163progressExposeTimeint0minimum time (secs) to expose order (0 = no minimum; used to guarantee that the order is exposed at mid-market for some time before actively taking)
166auctionResponderenum : AuctionResponderNoneif set, parent order can be an auction responder
618atsVisibilityenum : AtsVisibilityNonefor BlockAuction orders, visibility (to responders) is neither, side only, or side + price
615includeSRNetworkenum : InclExclDiscloseNone
616noticeNumberlongrequired when parentOrderHandling = AtsResponse
617respSideenum : BuySell
169autoHedgeenum : AutoHedgeNone
172hedgeInstrumentenum : HedgeInstDefaultDefault=underlier (EQT or FUT) [Index Options use ETF]; FrontMonth=underlier (EQT) or front month (FUT) [Index Options use FM Fut]; Stock=hedgeSecKey; Future=hedgeSecKey
175hedgeSecKeyExpiryKey-EQT-NMS-2000-01-01auto-hedge instrument (either TickerKey or ExpiryKey)
178hedgeBetaRatiofloat1.0Portion of executed $money to auto-hedge (can be 1.0 / Beta for beta hedging) [-4.0 to +4.0]
181hedgeScopeenum : HedgeScopeRiskGroupAuto-hedge at the RiskGroup or Accnt level
596hedgeSessionenum : MarketSessionRegMkt
611hedgeFillUMarkLmtPrcenum : YesNoNoset a price limit on the autohedge order based on the most recent option fillUMark
187cxlUPrcRangeenum : UPrcCxlNonecancel parent order if/when outside min/max uPrc range [_Halt = also cancel if the security/underlier has been halted]
190minUBidfloat0[optional]
193maxUAskfloat0[optional] (< $0.01 = none)
196minMaxTypeenum : MinMaxTypePrcif Prc minUBid/maxUAsk are expressed as prices; if Pct then they are expresses as pct change since parent order arrival
199maxChildOrdersint1000maximum number of child orders that can be generated by this parent order [order will terminate if/when this cap is reached;zero or neg = unlimited]
202spdrStageTypeenum : SpdrStageTypeNoneSizeLock = stage pending modification (can reduce size); SizeModify = stage pending modification (can increase/reduce size)
597marketSessionenum : MarketSessionRegMkt
208startDttmDateTime2000-01-01[optional] (parent order start time)
211orderDurationint-1[optional] (number of seconds)
598activeDurationint-1
214goodTillDttmDateTime2000-01-01[optional] (default: 2000-01-01)
217startTypeenum : StartTypeNone[WaitTrigger]
223parentOrderHandlingenum : ParentOrderHandlingCobMaker
226parentBalanceHandlingenum : ParentBalanceHandlingPostLimit
229orderLimitTypeenum : SpdrLimitTypeMarketVarious (Prc, PrcDe, Rel, Market);establishes the primary LimitPrice for a parent order
232takeLimitClassenum : SpdrLimitClassSimpleSimple = LimitPrice, Surface = BEST(LimitPrice, SurfLimit), Probability = BEST(LimitPrice, ProbLimit)
235makeLimitClassenum : SpdrLimitClassSimpleSimple = LimitPrice, Surface = BEST(LimitPrice, SurfLimit), Probability = BEST(LimitPrice, ProbLimit)
238takeReachRuleenum : ReachRuleNoneNone = reach room immediately available; Delayed = available after [1-3] seconds; Passive = available if contra side aggresses; WeakOnly = only take if available size < avgMarketSize; ISOSweep = Intermarket Sweep [requires WaitTrigger]
241leadSideenum : BuySellNonefor legged orders, which side to lead with. (optional, None ok)
244maxCompletionSlippagedouble0Maximum price slippage to complete an open basket or a cross auction (face side slippage)
247orderPrcLimitdouble0Applies if LimitType = Prc[]
250takeSurfPrcOffsetdoubledefault=0
253takeSurfVolOffsetfloatdefault=0
256orderPrcOffsetdouble0default=0
259takeAlphaTypeenum : AlphaTypeNoneApplies if takeLimitClass = Probability
262makeAlphaTypeenum : AlphaTypeNoneApplies if makeLimitClass = Probability
265takeAlphaFactorfloat0[-2,+2] takeProbLimit = MAX(takeProbability, takeProbAvg + takeAlphaFactor * takeProbStd) [if takeAlphaType = Relative]
268makeAlphaFactorfloat0[-2,+2] makeProbLimit = MAX(makeProbability, makeProbAvg + makeAlphaFactor * makeProbStd) [if takeAlphaType = Relative]
271takeProbabilityfloat0takeProbLimit = takeProbability [if takeAlphaType = Static]
274makeProbabilityfloat0makeProbLimit = makeProbability [if makeAlphaType = Static]
277firmTypeenum : FirmTypeNoneUsed to override firmType in account config. Default: None (use SpiderRock account configuration).
280stockSideenum : BuySellNoneStock Orde Side (if any).
283ssaleFlagenum : ShortSaleFlagAutoUsed to determine stock auto-hedge flags.
608locateFirmstring(6)firm granting the locate if using an away locate source for this order
609locatePoolstring(16)locate pool @ firm granting the locate
286stockSharesint0Number of shares in spread package. Default: 0 (none).
289altStkLegIDstring(24)Optional stock leg ID.
292numOptionLegsbyteThe number of valid legs below. The first leg is required and the rest are optional. For each optional leg okey_ and mult_ must be valid values whereas side_, positionType_, and legID_ will be assigned default values.
295multihedgeenum : MultihedgeNone
298optionTypeenum : OptionTypeEquity
301underliersPerCnint100Default: 100.
304okey1OptionKeyOption symbol for leg #1. Must be a valid option symbol.
307mult1ushortMultiplier for leg #1. Must be greater than zero.
310side1enum : BuySellOrder side for leg #1.
313positionType1enum : PositionTypeAutoPosition type for leg #1.
316altLegID1string(24)ID for leg #1. If left blank will be assigned an auto-generated ID.
319okey2OptionKey-EQT-NMS-1900-01-01-100000-COption symbol for leg #2. Must be a valid option symbol.
322mult2ushort0Multiplier for leg #2. Must be greater than zero.
325side2enum : BuySellBuyOrder side for leg #2.
328positionType2enum : PositionTypeAutoPosition type for leg #2.
331altLegID2string(24)ID for leg #2. If left blank will be assigned an auto-generated ID.
334okey3OptionKey-EQT-NMS-1900-01-01-100000-COption symbol for leg #3. Must be a valid option symbol.
337mult3ushort0Multiplier for leg #3. Must be greater than zero.
340side3enum : BuySellBuyOrder side for leg #3.
343positionType3enum : PositionTypeAutoPosition type for leg #3.
346altLegID3string(24)ID for leg #3. If left blank will be assigned an auto-generated ID.
349okey4OptionKey-EQT-NMS-1900-01-01-100000-COption symbol for leg #4. Must be a valid option symbol.
352mult4ushort0Multiplier for leg #4. Must be greater than zero.
355side4enum : BuySellBuyOrder side for leg #4.
358positionType4enum : PositionTypeAutoPosition type for leg #4.
361altLegID4string(24)ID for leg #4. If left blank will be assigned an auto-generated ID.
364okey5OptionKey-EQT-NMS-1900-01-01-100000-COption symbol for leg #5. Must be a valid option symbol.
367mult5ushort0Multiplier for leg #5. Must be greater than zero.
370side5enum : BuySellBuyOrder side for leg #5.
373positionType5enum : PositionTypeAutoPosition type for leg #5.
376altLegID5string(24)ID for leg #5. If left blank will be assigned an auto-generated ID.
379okey6OptionKey-EQT-NMS-1900-01-01-100000-COption symbol for leg #6. Must be a valid option symbol.
382mult6ushort0Multiplier for leg #6. Must be greater than zero.
385side6enum : BuySellBuyOrder side for leg #6.
388positionType6enum : PositionTypeAutoPosition type for leg #6.
391altLegID6string(24)ID for leg #6. If left blank will be assigned an auto-generated ID.
394optPremiumfloat0The premium for the option legs, a contribution to the order premium. Valid range is [-9999.0, 9999.0]. Default: 0.
397orderRefUPrcfloat0The stock reference price, a contribution to the order premium. Default: 0.
400riskGroupIdlong0Default: 0 (none). Required to be non-zero if autoHedge is something other than None.
599reqAuxRiskGroupCtrlenum : YesNo
403refRMetric1Srcenum : RMetricSource
406refRMetric2Srcenum : RMetricSource
409refRMetric3Srcenum : RMetricSource
412refRMetric4Srcenum : RMetricSource
415refRMetric5Srcenum : RMetricSource
600refRMetric6Srcenum : RMetricSource
418refRMetric7Srcenum : RMetricSource
421orderRefRMetric1floatuser supplied RMetric1 value (used in RiskGroupID risk controls) [netRMetric1 = sum(fillQty * orderRefRMetric1 * underlierPerCn)]
424orderRefRMetric2floatuser supplied RMetric2 value (used in RiskGroupID risk controls) [netRMetric2 = sum(fillQty * orderRefRMetric2 * underlierPerCn)]
427orderRefRMetric3floatuser supplied RMetric3 value (used in RiskGroupID risk controls) [netRMetric3 = sum(fillQty * orderRefRMetric3 * underlierPerCn)]
430orderRefRMetric4floatuser supplied RMetric4 value (used in RiskGroupID risk controls) [netRMetric4 = sum(fillQty * orderRefRMetric4 * underlierPerCn)]
433orderRefRMetric5floatuser supplied RMetric5 value (used in RiskGroupID risk controls) [netRMetric5 = sum(fillQty * orderRefRMetric5 * underlierPerCn)]
601orderRefRMetric6floatuser supplied RMetric6 value (used in ExpDay risk controls) [netRMetric6 = sum(fillQty * orderRefRMetric6 * underlierPerCn)]
436orderRefRMetric7floatuser supplied RMetric7 value (used in SymDay risk controls) [netRMetric7 = sum(fillQty * orderRefRMetric7 * underlierPerCn)]
602expDayWtVegaOffsetfloat0max acct+symbol day wtVega offset (target)
603maxExpDayWtVegaLnfloat-1max accnt+expiration day (time weighted) vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)
604maxExpDayWtVegaShfloat-1max accnt+expiration day (time weighted) vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)
605maxExpDayRMetric6Lnfloat-1max acct+expiration day rMetric6 long (positive number;-1=no limit);risk limit = max limit - current net counter
606maxExpDayRMetric6Shfloat-1max acct+expiration day rMetric6 short (positive number;-1=no limit);risk limit = max limit + current net counter
481symDayDDeltaOffsetfloat0max acct+symbol day $delta offset (target)
475maxSymDayDDeltaLnfloat-1max acct+symbol day $delta long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)
478maxSymDayDDeltaShfloat-1max acct+symbol day $delta short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)
463symDayVegaOffsetfloat0max acct+symbol day vega offset (target)
457maxSymDayVegaLnfloat-1max acct+symbol day vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)
460maxSymDayVegaShfloat-1max acct+symbol day vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)
472symDayWtVegaOffsetfloat0max acct+symbol day wtVega offset (target)
466maxSymDayWtVegaLnfloat-1max acct+symbol day (time weighted) vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)
469maxSymDayWtVegaShfloat-1max acct+symbol day (time weighted) vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)
484maxSymDayRMetric7Lnfloat-1max acct+symbol day rMetric7 long (positive number;-1=no limit);risk limit = max limit - current net counter
487maxSymDayRMetric7Shfloat-1max acct+symbol day rMetric7 short (positive number;-1=no limit);risk limit = max limit + current net counter
493maxGrpDayDDeltaLnfloat-1max acct+riskGroup day $delta long (positive number;-1=no limit);risk limit = max limit - current net counter
496maxGrpDayDDeltaShfloat-1max acct+riskGroup day $delta short (positive number;-1=no limit);risk limit = max limit + current net counter
502maxGrpDayVegaLnfloat-1max acct+riskGroup day vega long (positive number;-1=no limit);risk limit = max limit - current net counter
505maxGrpDayVegaShfloat-1max acct+riskGroup day vega short (positive number;-1=no limit);risk limit = max limit + current net counter
508maxGrpDayVegaAbsfloat-1max acct+riskGroup day vega abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)
511grpDayVegaRatiofloat1.0target bot / sld ratio (eg ratio=2.0 means that neutral is bot vega = 2x sld vega)
562maxGrpDayContractsLnint-1max acct+riskGroup day opt contracts long (positive number;-1=no limit);risk limit = max limit - current net counter
565maxGrpDayContractsShint-1max acct+riskGroup day opt contracts short (positive number;-1=no limit);risk limit = max limit + current net counter
568maxGrpDayContractsAbsint-1max acct+riskGroup day opt contracts abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)
526maxGrpDayRMetric1Lnfloat-1max acct+riskGroup day rMetric1 long (positive number;-1=no limit);risk limit = max limit - current net counter
529maxGrpDayRMetric1Shfloat-1max acct+riskGroup day rMetric1 short (positive number;-1=no limit);risk limit = max limit + current net counter
532maxGrpDayRMetric1Absfloat-1max acct+riskGroup day rMetric1 abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)
535grpDayRMetric1Ratiofloat1.0target bot / sld ratio (eg ratio=0.5 means that neutral is bot rMetric1 = 0.5x sld rMetric1)
538maxGrpDayRMetric2Lnfloat-1max acct+riskGroup day rMetric2 long (positive number;-1=no limit);risk limit = max limit - current net counter
541maxGrpDayRMetric2Shfloat-1max acct+riskGroup day rMetric2 short (positive number;-1=no limit);risk limit = max limit + current net counter
544maxGrpDayRMetric3Lnfloat-1max acct+riskGroup day rMetric3 long (positive number;-1=no limit);risk limit = max limit - current net counter
547maxGrpDayRMetric3Shfloat-1max acct+riskGroup day rMetric3 short (positive number;-1=no limit);risk limit = max limit + current net counter
550maxGrpDayRMetric4Lnfloat-1max acct+riskGroup day rMetric4 long (positive number;-1=no limit);risk limit = max limit - current net counter
553maxGrpDayRMetric4Shfloat-1max acct+riskGroup day rMetric4 short (positive number;-1=no limit);risk limit = max limit + current net counter
556maxGrpDayRMetric5Lnfloat-1max acct+riskGroup day rMetric5 long (positive number;-1=no limit);risk limit = max limit - current net counter
559maxGrpDayRMetric5Shfloat-1max acct+riskGroup day rMetric5 short (positive number;-1=no limit);risk limit = max limit + current net counter
571symEmaCxlDDeltaLnfloat-1max acct+symbol 60s EMA $delta long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]
574symEmaCxlDDeltaShfloat-1max acct+symbol 60s EMA $delta short (positive number; <= 0 is no limit)
577symEmaCxlWtVegaLnfloat-1max acct+symbol 60s EMA wtVega long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]
580symEmaCxlWtVegaShfloat-1max acct+symbol 60s EMA wtVega short (positive number; <= 0 is no limit)
583traderNamestring(32)Name of the trader associated with the order
586userData1text1client supplied data field; passes through to parent and child executions and reports as well as FIX drops
589userData2text1client supplied data field; passes through to parent and child executions and reports as well as FIX drops
592childDatatext1client supplied data field; passes through to down stream child orders
595checksumbyteMust be set to 13. This helps detect some column/value misalignments.

Get Schema API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'MLegOrderGateway'

# Request Parameters for Get Schema Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getschema',
"msgType": MSG_TYPE,
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Msg API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'MLegOrderGateway'

# Replace with your pkey value for getting the specific message desired
PKEY = 'ReplaceThisValueForTheQueryToWork'

# Replace with your desired view. A "|" separated list of views can be provided
# If no view is provided, all views will be returned.
VIEW = 'spdrActionType|altOrderId|altAutoHedgeId|altAccnt|altUserName|execBrkrCode|strategy|strategyAccnt|visibleInSV|orderDttm|orderSize|orderActiveSize|addCumFillQuantity|exchMask|maxExposureSize|numMakeExchanges|publicSize|randomizeSize|canOverlapCxlRepl|progressRule|twapSliceCnt|progressExposeTime|auctionResponder|atsVisibility|includeSRNetwork|noticeNumber|respSide|autoHedge|hedgeInstrument|hedgeSecKey|hedgeBetaRatio|hedgeScope|hedgeSession|hedgeFillUMarkLmtPrc|cxlUPrcRange|minUBid|maxUAsk|minMaxType|maxChildOrders|spdrStageType|marketSession|startDttm|orderDuration|activeDuration|goodTillDttm|startType|parentOrderHandling|parentBalanceHandling|orderLimitType|takeLimitClass|makeLimitClass|takeReachRule|leadSide|maxCompletionSlippage|orderPrcLimit|takeSurfPrcOffset|takeSurfVolOffset|orderPrcOffset|takeAlphaType|makeAlphaType|takeAlphaFactor|makeAlphaFactor|takeProbability|makeProbability|firmType|stockSide|ssaleFlag|locateFirm|locatePool|stockShares|altStkLegID|numOptionLegs|multihedge|optionType|underliersPerCn|okey1|mult1|side1|positionType1|altLegID1|okey2|mult2|side2|positionType2|altLegID2|okey3|mult3|side3|positionType3|altLegID3|okey4|mult4|side4|positionType4|altLegID4|okey5|mult5|side5|positionType5|altLegID5|okey6|mult6|side6|positionType6|altLegID6|optPremium|orderRefUPrc|riskGroupId|reqAuxRiskGroupCtrl|refRMetric1Src|refRMetric2Src|refRMetric3Src|refRMetric4Src|refRMetric5Src|refRMetric6Src|refRMetric7Src|orderRefRMetric1|orderRefRMetric2|orderRefRMetric3|orderRefRMetric4|orderRefRMetric5|orderRefRMetric6|orderRefRMetric7|expDayWtVegaOffset|maxExpDayWtVegaLn|maxExpDayWtVegaSh|maxExpDayRMetric6Ln|maxExpDayRMetric6Sh|symDayDDeltaOffset|maxSymDayDDeltaLn|maxSymDayDDeltaSh|symDayVegaOffset|maxSymDayVegaLn|maxSymDayVegaSh|symDayWtVegaOffset|maxSymDayWtVegaLn|maxSymDayWtVegaSh|maxSymDayRMetric7Ln|maxSymDayRMetric7Sh|maxGrpDayDDeltaLn|maxGrpDayDDeltaSh|maxGrpDayVegaLn|maxGrpDayVegaSh|maxGrpDayVegaAbs|grpDayVegaRatio|maxGrpDayContractsLn|maxGrpDayContractsSh|maxGrpDayContractsAbs|maxGrpDayRMetric1Ln|maxGrpDayRMetric1Sh|maxGrpDayRMetric1Abs|grpDayRMetric1Ratio|maxGrpDayRMetric2Ln|maxGrpDayRMetric2Sh|maxGrpDayRMetric3Ln|maxGrpDayRMetric3Sh|maxGrpDayRMetric4Ln|maxGrpDayRMetric4Sh|maxGrpDayRMetric5Ln|maxGrpDayRMetric5Sh|symEmaCxlDDeltaLn|symEmaCxlDDeltaSh|symEmaCxlWtVegaLn|symEmaCxlWtVegaSh|traderName|userData1|userData2|childData|checksum'

# Replace with your desired where clause.
# a string in the form "field1:eq:valuse" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Request Parameters for getmsg Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getmsg',
"pkey": PKEY,
"msgType": MSG_TYPE,
# Optional Parameters
"view": VIEW,
"where": WHERE
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Msgs API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'MLegOrderGateway'

# Replace with your desired view. A "|" separated list of views can be provided
# If no view is provided, all views will be returned
VIEW = 'spdrActionType|altOrderId|altAutoHedgeId|altAccnt|altUserName|execBrkrCode|strategy|strategyAccnt|visibleInSV|orderDttm|orderSize|orderActiveSize|addCumFillQuantity|exchMask|maxExposureSize|numMakeExchanges|publicSize|randomizeSize|canOverlapCxlRepl|progressRule|twapSliceCnt|progressExposeTime|auctionResponder|atsVisibility|includeSRNetwork|noticeNumber|respSide|autoHedge|hedgeInstrument|hedgeSecKey|hedgeBetaRatio|hedgeScope|hedgeSession|hedgeFillUMarkLmtPrc|cxlUPrcRange|minUBid|maxUAsk|minMaxType|maxChildOrders|spdrStageType|marketSession|startDttm|orderDuration|activeDuration|goodTillDttm|startType|parentOrderHandling|parentBalanceHandling|orderLimitType|takeLimitClass|makeLimitClass|takeReachRule|leadSide|maxCompletionSlippage|orderPrcLimit|takeSurfPrcOffset|takeSurfVolOffset|orderPrcOffset|takeAlphaType|makeAlphaType|takeAlphaFactor|makeAlphaFactor|takeProbability|makeProbability|firmType|stockSide|ssaleFlag|locateFirm|locatePool|stockShares|altStkLegID|numOptionLegs|multihedge|optionType|underliersPerCn|okey1|mult1|side1|positionType1|altLegID1|okey2|mult2|side2|positionType2|altLegID2|okey3|mult3|side3|positionType3|altLegID3|okey4|mult4|side4|positionType4|altLegID4|okey5|mult5|side5|positionType5|altLegID5|okey6|mult6|side6|positionType6|altLegID6|optPremium|orderRefUPrc|riskGroupId|reqAuxRiskGroupCtrl|refRMetric1Src|refRMetric2Src|refRMetric3Src|refRMetric4Src|refRMetric5Src|refRMetric6Src|refRMetric7Src|orderRefRMetric1|orderRefRMetric2|orderRefRMetric3|orderRefRMetric4|orderRefRMetric5|orderRefRMetric6|orderRefRMetric7|expDayWtVegaOffset|maxExpDayWtVegaLn|maxExpDayWtVegaSh|maxExpDayRMetric6Ln|maxExpDayRMetric6Sh|symDayDDeltaOffset|maxSymDayDDeltaLn|maxSymDayDDeltaSh|symDayVegaOffset|maxSymDayVegaLn|maxSymDayVegaSh|symDayWtVegaOffset|maxSymDayWtVegaLn|maxSymDayWtVegaSh|maxSymDayRMetric7Ln|maxSymDayRMetric7Sh|maxGrpDayDDeltaLn|maxGrpDayDDeltaSh|maxGrpDayVegaLn|maxGrpDayVegaSh|maxGrpDayVegaAbs|grpDayVegaRatio|maxGrpDayContractsLn|maxGrpDayContractsSh|maxGrpDayContractsAbs|maxGrpDayRMetric1Ln|maxGrpDayRMetric1Sh|maxGrpDayRMetric1Abs|grpDayRMetric1Ratio|maxGrpDayRMetric2Ln|maxGrpDayRMetric2Sh|maxGrpDayRMetric3Ln|maxGrpDayRMetric3Sh|maxGrpDayRMetric4Ln|maxGrpDayRMetric4Sh|maxGrpDayRMetric5Ln|maxGrpDayRMetric5Sh|symEmaCxlDDeltaLn|symEmaCxlDDeltaSh|symEmaCxlWtVegaLn|symEmaCxlWtVegaSh|traderName|userData1|userData2|childData|checksum'

# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Replace with your desired limit of how many messages you receive. The default limit is 500
LIMIT = 500

# Order clause eg. "(field1:DESC | field1:ASC | field2:DESC:ABS | field2:ASC:ABS" (default is unordered; default is faster)
ORDER = 'spdrActionType:ASC'

# Request Parameters for getmsgs Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getmsgs',
"msgType": MSG_TYPE,
# Optional Parameters
"view": VIEW,
"where": WHERE,
"limit": LIMIT,
"order": ORDER
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Aggregate API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'MLegOrderGateway'

# Replace with fields you want to see aggregate values for. A "|" separated list of measures should be provided
MEASURE = 'spdrActionType|altOrderId|altAutoHedgeId|altAccnt|altUserName|execBrkrCode|strategy|strategyAccnt|visibleInSV|orderDttm|orderSize|orderActiveSize|addCumFillQuantity|exchMask|maxExposureSize|numMakeExchanges|publicSize|randomizeSize|canOverlapCxlRepl|progressRule|twapSliceCnt|progressExposeTime|auctionResponder|atsVisibility|includeSRNetwork|noticeNumber|respSide|autoHedge|hedgeInstrument|hedgeSecKey|hedgeBetaRatio|hedgeScope|hedgeSession|hedgeFillUMarkLmtPrc|cxlUPrcRange|minUBid|maxUAsk|minMaxType|maxChildOrders|spdrStageType|marketSession|startDttm|orderDuration|activeDuration|goodTillDttm|startType|parentOrderHandling|parentBalanceHandling|orderLimitType|takeLimitClass|makeLimitClass|takeReachRule|leadSide|maxCompletionSlippage|orderPrcLimit|takeSurfPrcOffset|takeSurfVolOffset|orderPrcOffset|takeAlphaType|makeAlphaType|takeAlphaFactor|makeAlphaFactor|takeProbability|makeProbability|firmType|stockSide|ssaleFlag|locateFirm|locatePool|stockShares|altStkLegID|numOptionLegs|multihedge|optionType|underliersPerCn|okey1|mult1|side1|positionType1|altLegID1|okey2|mult2|side2|positionType2|altLegID2|okey3|mult3|side3|positionType3|altLegID3|okey4|mult4|side4|positionType4|altLegID4|okey5|mult5|side5|positionType5|altLegID5|okey6|mult6|side6|positionType6|altLegID6|optPremium|orderRefUPrc|riskGroupId|reqAuxRiskGroupCtrl|refRMetric1Src|refRMetric2Src|refRMetric3Src|refRMetric4Src|refRMetric5Src|refRMetric6Src|refRMetric7Src|orderRefRMetric1|orderRefRMetric2|orderRefRMetric3|orderRefRMetric4|orderRefRMetric5|orderRefRMetric6|orderRefRMetric7|expDayWtVegaOffset|maxExpDayWtVegaLn|maxExpDayWtVegaSh|maxExpDayRMetric6Ln|maxExpDayRMetric6Sh|symDayDDeltaOffset|maxSymDayDDeltaLn|maxSymDayDDeltaSh|symDayVegaOffset|maxSymDayVegaLn|maxSymDayVegaSh|symDayWtVegaOffset|maxSymDayWtVegaLn|maxSymDayWtVegaSh|maxSymDayRMetric7Ln|maxSymDayRMetric7Sh|maxGrpDayDDeltaLn|maxGrpDayDDeltaSh|maxGrpDayVegaLn|maxGrpDayVegaSh|maxGrpDayVegaAbs|grpDayVegaRatio|maxGrpDayContractsLn|maxGrpDayContractsSh|maxGrpDayContractsAbs|maxGrpDayRMetric1Ln|maxGrpDayRMetric1Sh|maxGrpDayRMetric1Abs|grpDayRMetric1Ratio|maxGrpDayRMetric2Ln|maxGrpDayRMetric2Sh|maxGrpDayRMetric3Ln|maxGrpDayRMetric3Sh|maxGrpDayRMetric4Ln|maxGrpDayRMetric4Sh|maxGrpDayRMetric5Ln|maxGrpDayRMetric5Sh|symEmaCxlDDeltaLn|symEmaCxlDDeltaSh|symEmaCxlWtVegaLn|symEmaCxlWtVegaSh|traderName|userData1|userData2|childData|checksum'

# Replace with fields you want to see aggregated. A "|" separated list of fields should be provided
GROUP = 'spdrActionType|visibleInSV|addCumFillQuantity|publicSize|randomizeSize|canOverlapCxlRepl|progressRule|auctionResponder|atsVisibility|includeSRNetwork|respSide|autoHedge|hedgeInstrument|hedgeScope|hedgeSession|hedgeFillUMarkLmtPrc|cxlUPrcRange|minMaxType|spdrStageType|marketSession|startType|parentOrderHandling|parentBalanceHandling|orderLimitType|takeLimitClass|makeLimitClass|takeReachRule|leadSide|takeAlphaType|makeAlphaType|firmType|stockSide|ssaleFlag|multihedge|optionType|side1|positionType1|side2|positionType2|side3|positionType3|side4|positionType4|side5|positionType5|side6|positionType6|reqAuxRiskGroupCtrl|refRMetric1Src|refRMetric2Src|refRMetric3Src|refRMetric4Src|refRMetric5Src|refRMetric6Src|refRMetric7Src'

# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Request Parameters for getaggregate Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getaggregate',
"msgType": MSG_TYPE,
"measure": MEASURE,
"group": GROUP,
# Optional Parameters
"where": WHERE,
}

response = requests.get(MLINK_PROD_URL, params=params)

Get Count API Call

import requests 

# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'

# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'

# Replace with your desired MsgType.
MSG_TYPE = 'MLegOrderGateway'

# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = 'accnt:eq:ExampleString'

# Request Parameters for getCount Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getcount',
"msgType": MSG_TYPE,
# Optional Parameters
"where": WHERE,
}

response = requests.get(MLINK_PROD_URL, params=params)