SRAutoHedgeState

V8 Message Definiton

SpdrAutoHedgeState records are published by autohedge servers and describe the current state of an autohedge controller that is managing RiskGroup autohedge orders.

METADATA

Attribute	Value
Topic	5290-strategy-autohedge
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT
MLink Endpoint	MLink-Order

Table Definition

Field	Type	Key	Default Value	Comment
accnt	VARCHAR(16)	PRI	''
riskGroupId	CHAR(19)	PRI	'0000-0000-0000-0000'
hedgeSecKey_at	enum - AssetType	PRI	'None'	Execution Hedge SecKey from SpdrAutoHedgeControltargetSecKey
hedgeSecKey_ts	enum - TickerSrc	PRI	'None'	Execution Hedge SecKey from SpdrAutoHedgeControltargetSecKey
hedgeSecKey_tk	VARCHAR(12)	PRI	''	Execution Hedge SecKey from SpdrAutoHedgeControltargetSecKey
hedgeSecKey_yr	SMALLINT UNSIGNED	PRI	0	Execution Hedge SecKey from SpdrAutoHedgeControltargetSecKey
hedgeSecKey_mn	TINYINT UNSIGNED	PRI	0	Execution Hedge SecKey from SpdrAutoHedgeControltargetSecKey
hedgeSecKey_dy	TINYINT UNSIGNED	PRI	0	Execution Hedge SecKey from SpdrAutoHedgeControltargetSecKey
hedgeSecType	enum - SpdrKeyType	PRI	'None'	Execution Hedge SecType from SpdrAutoHedgeControltargetSecType can be None
clientFirm	VARCHAR(16)	PRI	''
groupingCode	CHAR(19)		'0000-0000-0000-0000'
ticker_at	enum - AssetType		'None'	ticker group eg ES ZN
ticker_ts	enum - TickerSrc		'None'	ticker group eg ES ZN
ticker_tk	VARCHAR(12)		''	ticker group eg ES ZN
securityDesc	TINYTEXT		''
ssaleFlag	enum - ShortSaleFlag		'None'
positionType	enum - PositionType		'None'
hedgeState	enum - HedgeGroupState		'None'
hedgeText	TINYTEXT		''
uPrc	DOUBLE		0	hedge target underlier price
hedgePrcLmt	FLOAT		0	price limit of the hedge order if hedge is using hedgeFillUMarkLmtPrc
isDeltaMixed	enum - YesNo		'None'
accumulatorError	TINYTEXT		''
grpDeltaBot	DOUBLE		0	option delta bot in ctrlDe units
grpDeltaSld	DOUBLE		0
grpDDeltaBot	DOUBLE		0	option delta bot using uMid at time of option fill
grpDDeltaSld	DOUBLE		0
lastGrpFillDttm	DATETIME(6)		'1900-01-01 00:00:00.000000'
ctrlDeltaBot	DOUBLE		0	hedge target delta units bot
ctrlDeltaSld	DOUBLE		0
ctrlDDeltaBot	DOUBLE		0	hedge target delta bot using actual fill price
ctrlDDeltaSld	DOUBLE		0
lastCtrlFillDttm	DATETIME(6)		'1900-01-01 00:00:00.000000'
absOptCn	INT		0	total number of option contracts executed in this hedge group
netDelta	DOUBLE		0	grpDeltaBot grpDeltaSld ctrlDeltaBot ctrlDeltaSld
netDDelta	DOUBLE		0	grpDDeltaBot grpDDeltaSld ctrlDDeltaBot ctrlDDeltaSld
openHedgeTime	FLOAT		0	size weighted average time in seconds hedge risk has been open executions to fills
hedgeTargetVol	FLOAT		0	implied expected today annualized volatility for hedge target
expectedPrcRange	FLOAT		0	SQRTavgHedgeTime x hedgeTargetVol cone
opnDeltaBot	DOUBLE		0	open risk delta bot in ctrlDe units
opnDeltaSld	DOUBLE		0
opnDDeltaBot	DOUBLE		0	open risk delta bot in ctrlDe units
opnDDeltaSld	DOUBLE		0
clsDeltaBot	DOUBLE		0	close risk delta bot in ctrlDe units
clsDeltaSld	DOUBLE		0
clsDDeltaBot	DOUBLE		0	close risk delta bot in ctrlDe units
clsDDeltaSld	DOUBLE		0
slippagePnL	FLOAT		0	opnDeltaBot clsDeltaPrcSld opnDeltaPrcBot opnDeltaSld opnDeltaPrcSld clsDeltaPrcBot
slippageUnitPnL	FLOAT		0	slippagePnL grpDeltaBot grpDeltaSld pnl unit share or fc
slippageNormPnL	FLOAT		0	slippageUnitPnL expectedPrcRange
minDDeltaBand	FLOAT		0
maxDDeltaBand	FLOAT		0
bParentNumber	BIGINT		0
bActiveSize	INT		0
bBrkrStatus	TINYTEXT		''
bBrkrError	TINYTEXT		''
sParentNumber	BIGINT		0
sActiveSize	INT		0
sBrkrStatus	TINYTEXT		''
sBrkrError	TINYTEXT		''
ddMult	DOUBLE		0
underliersPerCn	INT		0	future underliers per contract
underlierType	enum - UnderlierType		'None'	type of underlier affects greek calculations
pointValue	DOUBLE		0	NLV value of a single point change in display premium hedge target
pointCurrency	enum - Currency		'None'
liveHedgeMark	DOUBLE		0	hedgeSecKey live mark midmarket zero in SRSE
updtReason	VARCHAR(20)		''
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	SR system timestamp

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
accnt	1
riskGroupId	2
hedgeSecKey_tk	3
hedgeSecKey_yr	4
hedgeSecKey_mn	5
hedgeSecKey_dy	6
hedgeSecKey_at	7
hedgeSecKey_ts	8
hedgeSecType	9
clientFirm	10

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRTrade`.`MsgSRAutoHedgeState`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId'
  AND
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `hedgeSecKey_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */ 
    `hedgeSecKey_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `hedgeSecKey_tk` = 'Example_hedgeSecKey_tk'
  AND
    /* Replace with a SMALLINT UNSIGNED */ 
    `hedgeSecKey_yr` = 123
  AND
    /* Replace with a TINYINT UNSIGNED */ 
    `hedgeSecKey_mn` = 1
  AND
    /* Replace with a TINYINT UNSIGNED */ 
    `hedgeSecKey_dy` = 1
  AND
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */ 
    `hedgeSecType` = 'None'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SRAutoHedgeState' ORDER BY ordinal_position ASC;