Version: 8.4.10.2

ResponderMarkupVegaDir

METADATA

Attribute	Value
Topic	2450-liquidity-notice
MLink Token	SRATS
Product	SRTrade
accessType	SELECT,UPDATE,INSERT,DELETE

Table Definition

Field	Type	Key	Default Value	Comment
accnt	VARCHAR(16)	PRI	''
clientFirm	VARCHAR(16)	PRI	''
ticker_at	enum - AssetType	PRI	'None'
ticker_ts	enum - TickerSrc	PRI	'None'
ticker_tk	VARCHAR(12)	PRI	''
respSide	enum - BuySell	PRI	'None'	auction responder side your side
expiryGroup	INT	PRI	0
userName	VARCHAR(24)		''	username used for responding to auction notices
isDisabled	enum - YesNo		'None'	if Yes this autoresponder record is disabled
canIncludeFlex	enum - YesNo		'None'	if yes can respond to auction notices that include flex option legs
canIncludeStock	enum - YesNo		'None'	if yes can respond to auction notices that include a stock leg
cpFlag	enum - CallPut		'Pair'	if not Pair must match all option legs
minYears	FLOAT		0	both markupminYears and markupmaxYears must be between minYears maxYears
maxYears	FLOAT		10.0
minExpiry	DATETIME(6)		'1900-01-01 00:00:00.000000'	both markupminExpiry and markupmaxExpiry must be between minExpiry maxExpiry
maxExpiry	DATETIME(6)		'1900-01-01 00:00:00.000000'
minXDelta	FLOAT		-0.50	all leg xDelta must be between minXDelta maxXDelta
maxXDelta	FLOAT		+0.50
minStrike	DOUBLE		0	all leg strikes must be between minStrike maxStrike
maxStrike	DOUBLE		999999
minSurfEdgePrem	FLOAT		-99	spread surface edge in premium through surface behind surface
minSurfEdgeVol	FLOAT		-99	spread surface edge in vol 001 10 vol pts through surface behind surface
incFeesInResp	enum - YesNo		'None'	include all estimated responder fees in final response price
roundRule	enum - RoundRule		'None'
maxResponseSize	INT		0	maximum number of contracts per response will respond for 100 if auction size maxResponseSize
maxResponseVega	FLOAT		0	maximum total vega per response
totalResponseVega	FLOAT		0	maximum vega filled all day
totalResponseWtVega	FLOAT		0	maximum wtVega filled all day
autoHedge	enum - AutoHedge		'None'
hedgeInstrument	enum - HedgeInst		'None'	Defaultactual underlier EQT or FUT IndexOptions use ETF FrontMonthactual underlier EQT or front month FUT IndexOptions use FM Fut StockhedgeSecKeyTickerKey FuturehedgeSecKeyExpiryKey
hedgeSecKey_at	enum - AssetType		'None'	autohedge instrument can be a TickerKey stock or ExpiryKey future required for Stock and Future
hedgeSecKey_ts	enum - TickerSrc		'None'	autohedge instrument can be a TickerKey stock or ExpiryKey future required for Stock and Future
hedgeSecKey_tk	VARCHAR(12)		''	autohedge instrument can be a TickerKey stock or ExpiryKey future required for Stock and Future
hedgeSecKey_yr	SMALLINT UNSIGNED		0	autohedge instrument can be a TickerKey stock or ExpiryKey future required for Stock and Future
hedgeSecKey_mn	TINYINT UNSIGNED		0	autohedge instrument can be a TickerKey stock or ExpiryKey future required for Stock and Future
hedgeSecKey_dy	TINYINT UNSIGNED		0	autohedge instrument can be a TickerKey stock or ExpiryKey future required for Stock and Future
hedgeBetaRatio	FLOAT		0	portion of executed money to autohedge can be 10 Beta for beta hedging 40 to 40
hedgeScope	enum - HedgeScope		'None'	hedge group scope RiskGroup or Accnt
hedgeSession	enum - MarketSession		'None'	time in force for the autohedge order can be Day or ExtDay None defaults to pOrdertimeInForce
riskGroupId	CHAR(19)		'0000-0000-0000-0000'	Default 0 none Required to be nonzero if autoHedge is something other than None
numNotices	BIGINT		0
numNoticesPass	BIGINT		0
numResponses	BIGINT		0
qtyTraded	INT		0
vegaTraded	DOUBLE		0
modifiedBy	VARCHAR(24)		''	user who last modified this record
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
accnt	1
clientFirm	2
ticker_tk	3
ticker_at	4
ticker_ts	5
respSide	6
expiryGroup	7

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgResponderMarkupVegaDir` (
    `accnt` VARCHAR(16) NOT NULL DEFAULT '',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None',
    `ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None',
    `ticker_tk` VARCHAR(12) NOT NULL DEFAULT '',
    `respSide` ENUM('None','Buy','Sell') NOT NULL DEFAULT 'None' COMMENT 'auction responder side (your side)',
    `expiryGroup` INT NOT NULL DEFAULT 0,
    `userName` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'username used for responding to auction notices',
    `isDisabled` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'if Yes, this auto-responder record is disabled',
    `canIncludeFlex` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'if yes, can respond to auction notices that include flex option legs',
    `canIncludeStock` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'if yes, can respond to auction notices that include a stock leg',
    `cpFlag` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Pair' COMMENT 'if not Pair must match all option legs',
    `minYears` FLOAT NOT NULL DEFAULT 0 COMMENT 'both markup.minYears and markup.maxYears must be between [minYears, maxYears]',
    `maxYears` FLOAT NOT NULL DEFAULT 10.0,
    `minExpiry` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'both markup.minExpiry and markup.maxExpiry must be between [minExpiry, maxExpiry]',
    `maxExpiry` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    `minXDelta` FLOAT NOT NULL DEFAULT -0.50 COMMENT 'all leg xDelta must be between [minXDelta, maxXDelta]',
    `maxXDelta` FLOAT NOT NULL DEFAULT +0.50,
    `minStrike` DOUBLE NOT NULL DEFAULT 0 COMMENT 'all leg strikes must be between [minStrike, maxStrike]',
    `maxStrike` DOUBLE NOT NULL DEFAULT 999999,
    `minSurfEdgePrem` FLOAT NOT NULL DEFAULT -99 COMMENT 'spread surface edge (in premium) (+ = through surface; - = behind surface)',
    `minSurfEdgeVol` FLOAT NOT NULL DEFAULT -99 COMMENT 'spread surface edge (in vol) (0.01 = 1.0 vol pts) (+ = through surface; - = behind surface)',
    `incFeesInResp` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'include all estimated responder fees in final response price',
    `roundRule` ENUM('None','Exact','Fuzzy') NOT NULL DEFAULT 'None',
    `maxResponseSize` INT NOT NULL DEFAULT 0 COMMENT 'maximum number of contracts per response (will respond for 100% if auction size <= maxResponseSize)',
    `maxResponseVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'maximum total vega per response',
    `totalResponseVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'maximum vega (filled) all day',
    `totalResponseWtVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'maximum wtVega (filled) all day',
    `autoHedge` ENUM('None','Static','AutoMid','AutoCrx','AutoTrn','SpdrAuto','Spdr10S','Spdr30S','Spdr90S','Spdr5M','Spdr30M','SpdrDay','SmartFast','SmartNorm','FastCrx','FastDark','SlowDark','AlphaVwap1pct','AlphaVwap2pct','AlphaVwap5pct','AlphaVwap25pct','Custom','AwayAlgo') NOT NULL DEFAULT 'None',
    `hedgeInstrument` ENUM('None','Default','FrontMonth','Stock','Future') NOT NULL DEFAULT 'None' COMMENT 'Default=actual underlier (EQT or FUT) [IndexOptions use ETF]; FrontMonth=actual underlier (EQT) or front month (FUT) [IndexOptions use FM Fut]; Stock=hedgeSecKey.TickerKey; Future=hedgeSecKey.ExpiryKey',
    `hedgeSecKey_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'autohedge instrument (can be a TickerKey (stock) or ExpiryKey (future)) [required for Stock and Future]',
    `hedgeSecKey_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'autohedge instrument (can be a TickerKey (stock) or ExpiryKey (future)) [required for Stock and Future]',
    `hedgeSecKey_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'autohedge instrument (can be a TickerKey (stock) or ExpiryKey (future)) [required for Stock and Future]',
    `hedgeSecKey_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'autohedge instrument (can be a TickerKey (stock) or ExpiryKey (future)) [required for Stock and Future]',
    `hedgeSecKey_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'autohedge instrument (can be a TickerKey (stock) or ExpiryKey (future)) [required for Stock and Future]',
    `hedgeSecKey_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'autohedge instrument (can be a TickerKey (stock) or ExpiryKey (future)) [required for Stock and Future]',
    `hedgeBetaRatio` FLOAT NOT NULL DEFAULT 0 COMMENT 'portion of executed $money to auto-hedge (can be 1.0 / Beta for beta hedging) [-4.0 to +4.0]',
    `hedgeScope` ENUM('None','Accnt','RiskGroup') NOT NULL DEFAULT 'None' COMMENT 'hedge group scope [RiskGroup or Accnt]',
    `hedgeSession` ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') NOT NULL DEFAULT 'None' COMMENT 'time in force for the autohedge order (can be Day or ExtDay) [None defaults to pOrder.timeInForce]',
    `riskGroupId` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000' COMMENT 'Default: 0 (none).  Required to be non-zero if `autoHedge` is something other than None.',
    `numNotices` BIGINT NOT NULL DEFAULT 0,
    `numNoticesPass` BIGINT NOT NULL DEFAULT 0,
    `numResponses` BIGINT NOT NULL DEFAULT 0,
    `qtyTraded` INT NOT NULL DEFAULT 0,
    `vegaTraded` DOUBLE NOT NULL DEFAULT 0,
    `modifiedBy` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'user who last modified this record',
    `modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of last modification',
    CONSTRAINT nonnegative_riskGroupId CHECK(ASCII(riskGroupId) < 56),
    PRIMARY KEY USING HASH (`accnt`,`clientFirm`,`ticker_tk`,`ticker_at`,`ticker_ts`,`respSide`,`expiryGroup`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `accnt`,
    `clientFirm`,
    `ticker_at`,
    `ticker_ts`,
    `ticker_tk`,
    `respSide`,
    `expiryGroup`,
    `userName`,
    `isDisabled`,
    `canIncludeFlex`,
    `canIncludeStock`,
    `cpFlag`,
    `minYears`,
    `maxYears`,
    `minExpiry`,
    `maxExpiry`,
    `minXDelta`,
    `maxXDelta`,
    `minStrike`,
    `maxStrike`,
    `minSurfEdgePrem`,
    `minSurfEdgeVol`,
    `incFeesInResp`,
    `roundRule`,
    `maxResponseSize`,
    `maxResponseVega`,
    `totalResponseVega`,
    `totalResponseWtVega`,
    `autoHedge`,
    `hedgeInstrument`,
    `hedgeSecKey_at`,
    `hedgeSecKey_ts`,
    `hedgeSecKey_tk`,
    `hedgeSecKey_yr`,
    `hedgeSecKey_mn`,
    `hedgeSecKey_dy`,
    `hedgeBetaRatio`,
    `hedgeScope`,
    `hedgeSession`,
    `riskGroupId`,
    `numNotices`,
    `numNoticesPass`,
    `numResponses`,
    `qtyTraded`,
    `vegaTraded`,
    `timestamp`
FROM `SRTrade`.`MsgResponderMarkupVegaDir`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_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','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a ENUM('None','Buy','Sell') */ 
    `respSide` = 'None'
  AND
    /* Replace with a INT */ 
    `expiryGroup` = 5;

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRTrade`.`MsgResponderMarkupVegaDir` 
SET
    /* Replace with a VARCHAR(24) */ 
    `userName` = 'Example_userName',
    /* Replace with a ENUM('None','Yes','No') */ 
    `isDisabled` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `canIncludeFlex` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `canIncludeStock` = 'None',
    /* Replace with a ENUM('Call','Put','Pair') */
    `cpFlag` = 'Pair',
    /* Replace with a FLOAT */
    `minYears` = 1.23,
    /* Replace with a FLOAT */
    `maxYears` = 1.23,
    /* Replace with a DATETIME(6) */
    `minExpiry` = '2022-01-01 12:34:56.000000',
    /* Replace with a DATETIME(6) */
    `maxExpiry` = '2022-01-01 12:34:56.000000',
    /* Replace with a FLOAT */
    `minXDelta` = 1.23,
    /* Replace with a FLOAT */
    `maxXDelta` = 1.23,
    /* Replace with a DOUBLE */
    `minStrike` = 4.56,
    /* Replace with a DOUBLE */
    `maxStrike` = 4.56,
    /* Replace with a FLOAT */
    `minSurfEdgePrem` = 1.23,
    /* Replace with a FLOAT */
    `minSurfEdgeVol` = 1.23,
    /* Replace with a ENUM('None','Yes','No') */ 
    `incFeesInResp` = 'None',
    /* Replace with a ENUM('None','Exact','Fuzzy') */ 
    `roundRule` = 'None',
    /* Replace with a INT */ 
    `maxResponseSize` = 5,
    /* Replace with a FLOAT */ 
    `maxResponseVega` = 1.23,
    /* Replace with a FLOAT */ 
    `totalResponseVega` = 1.23,
    /* Replace with a FLOAT */ 
    `totalResponseWtVega` = 1.23,
    /* Replace with a ENUM('None','Static','AutoMid','AutoCrx','AutoTrn','SpdrAuto','Spdr10S','Spdr30S','Spdr90S','Spdr5M','Spdr30M','SpdrDay','SmartFast','SmartNorm','FastCrx','FastDark','SlowDark','AlphaVwap1pct','AlphaVwap2pct','AlphaVwap5pct','AlphaVwap25pct','Custom','AwayAlgo') */ 
    `autoHedge` = 'None',
    /* Replace with a ENUM('None','Default','FrontMonth','Stock','Future') */ 
    `hedgeInstrument` = 'None',
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `hedgeSecKey_at` = 'None',
    /* 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','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `hedgeSecKey_ts` = 'None',
    /* Replace with a VARCHAR(12) */ 
    `hedgeSecKey_tk` = 'Example_hedgeSecKey_tk',
    /* Replace with a SMALLINT UNSIGNED */ 
    `hedgeSecKey_yr` = 123,
    /* Replace with a TINYINT UNSIGNED */ 
    `hedgeSecKey_mn` = 1,
    /* Replace with a TINYINT UNSIGNED */ 
    `hedgeSecKey_dy` = 1,
    /* Replace with a FLOAT */ 
    `hedgeBetaRatio` = 1.23,
    /* Replace with a ENUM('None','Accnt','RiskGroup') */ 
    `hedgeScope` = 'None',
    /* Replace with a ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') */ 
    `hedgeSession` = 'None',
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId',
    /* Replace with a BIGINT */ 
    `numNotices` = 1234567890,
    /* Replace with a BIGINT */ 
    `numNoticesPass` = 1234567890,
    /* Replace with a BIGINT */ 
    `numResponses` = 1234567890,
    /* Replace with a INT */ 
    `qtyTraded` = 5,
    /* Replace with a DOUBLE */ 
    `vegaTraded` = 4.56,
    /* Replace with a DATETIME(6) */
    `timestamp` = '2022-01-01 12:34:56.000000'
WHERE
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_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','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a ENUM('None','Buy','Sell') */ 
    `respSide` = 'None'
  AND
    /* Replace with a INT */ 
    `expiryGroup` = 5;

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgResponderMarkupVegaDir`(
    /* Replace with a VARCHAR(16) */ 
    `accnt`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at`,
    /* 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','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts`,
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk`,
    /* Replace with a ENUM('None','Buy','Sell') */ 
    `respSide`,
    /* Replace with a INT */ 
    `expiryGroup`,
    /* Replace with a VARCHAR(24) */ 
    `userName`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `isDisabled`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `canIncludeFlex`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `canIncludeStock`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `cpFlag`,
    /* Replace with a FLOAT */
    `minYears`,
    /* Replace with a FLOAT */
    `maxYears`,
    /* Replace with a DATETIME(6) */
    `minExpiry`,
    /* Replace with a DATETIME(6) */
    `maxExpiry`,
    /* Replace with a FLOAT */
    `minXDelta`,
    /* Replace with a FLOAT */
    `maxXDelta`,
    /* Replace with a DOUBLE */
    `minStrike`,
    /* Replace with a DOUBLE */
    `maxStrike`,
    /* Replace with a FLOAT */
    `minSurfEdgePrem`,
    /* Replace with a FLOAT */
    `minSurfEdgeVol`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `incFeesInResp`,
    /* Replace with a ENUM('None','Exact','Fuzzy') */ 
    `roundRule`,
    /* Replace with a INT */ 
    `maxResponseSize`,
    /* Replace with a FLOAT */ 
    `maxResponseVega`,
    /* Replace with a FLOAT */ 
    `totalResponseVega`,
    /* Replace with a FLOAT */ 
    `totalResponseWtVega`,
    /* Replace with a ENUM('None','Static','AutoMid','AutoCrx','AutoTrn','SpdrAuto','Spdr10S','Spdr30S','Spdr90S','Spdr5M','Spdr30M','SpdrDay','SmartFast','SmartNorm','FastCrx','FastDark','SlowDark','AlphaVwap1pct','AlphaVwap2pct','AlphaVwap5pct','AlphaVwap25pct','Custom','AwayAlgo') */ 
    `autoHedge`,
    /* Replace with a ENUM('None','Default','FrontMonth','Stock','Future') */ 
    `hedgeInstrument`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `hedgeSecKey_at`,
    /* 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','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `hedgeSecKey_ts`,
    /* Replace with a VARCHAR(12) */ 
    `hedgeSecKey_tk`,
    /* Replace with a SMALLINT UNSIGNED */ 
    `hedgeSecKey_yr`,
    /* Replace with a TINYINT UNSIGNED */ 
    `hedgeSecKey_mn`,
    /* Replace with a TINYINT UNSIGNED */ 
    `hedgeSecKey_dy`,
    /* Replace with a FLOAT */ 
    `hedgeBetaRatio`,
    /* Replace with a ENUM('None','Accnt','RiskGroup') */ 
    `hedgeScope`,
    /* Replace with a ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') */ 
    `hedgeSession`,
    /* Replace with a CHAR(19) */
    `riskGroupId`,
    /* Replace with a BIGINT */ 
    `numNotices`,
    /* Replace with a BIGINT */ 
    `numNoticesPass`,
    /* Replace with a BIGINT */ 
    `numResponses`,
    /* Replace with a INT */ 
    `qtyTraded`,
    /* Replace with a DOUBLE */ 
    `vegaTraded`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    'Example_accnt',
    'Example_clientFirm',
    'None',
    'None',
    'Example_ticker_tk',
    'None',
    5,
    'Example_userName',
    'None',
    'None',
    'None',
    'Pair',
    1.23,
    1.23,
    '2022-01-01 12:34:56.000000',
    '2022-01-01 12:34:56.000000',
    1.23,
    1.23,
    4.56,
    4.56,
    1.23,
    1.23,
    'None',
    'None',
    5,
    1.23,
    1.23,
    1.23,
    'None',
    'None',
    'None',
    'None',
    'Example_hedgeSecKey_tk',
    123,
    1,
    1,
    1.23,
    'None',
    'None',
    'Example_riskGroupId',
    1234567890,
    1234567890,
    1234567890,
    5,
    4.56,
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRTrade`.`MsgResponderMarkupVegaDir` 
WHERE
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_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','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a ENUM('None','Buy','Sell') */ 
    `respSide` = 'None'
  AND
    /* Replace with a INT */ 
    `expiryGroup` = 5;

Doc Columns Query

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

METADATA​

Table Definition​

PRIMARY KEY DEFINITION (Unique)​

CREATE TABLE EXAMPLE QUERY​

SELECT TABLE EXAMPLE QUERY​

UPDATE TABLE EXAMPLE QUERY​

INSERT TABLE EXAMPLE QUERY​

DELETE TABLE EXAMPLE QUERY​

Doc Columns Query​

METADATA

Table Definition

PRIMARY KEY DEFINITION (Unique)

CREATE TABLE EXAMPLE QUERY

SELECT TABLE EXAMPLE QUERY

UPDATE TABLE EXAMPLE QUERY

INSERT TABLE EXAMPLE QUERY

DELETE TABLE EXAMPLE QUERY

Doc Columns Query