Skip to main content
Version: Upcoming

SR Control

Overview​

  • View and manage symbol and user supervisory trade risk controls
  • Manage borrow rates, locates, and restricted trading lists
  • Dynamically control algo configuration and delivery instructions
  • Integrated with SpiderRock GUI tools

SR Control Tables​

SR Control Tables

Query Examples​

Sample Query 1: To insert locates into the Away Stock Locate Gateway:

REPLACE INTO srcontrol.msgawaystocklocategateway
VALUES ('EQT','NMS','AAPL','SRCORE','GS','TEST',50000,'No',1234,NOW());

Sample Query 2: To insert a request for 50,000 Shares in AAPL:

VALUES ('EQT','NMS','AAPL','SRCORE','GS','TEST',50000,NOW());

Note: Only available if you have permission to programmatically request locates from your clearing firm.

Sample Query 3: To check available stock locates, refer to the AvailableStockLocates table:

SELECT * FROM srcontrol.msgavailablestocklocates
WHERE coreclientfirm = 'SRCORE';

Client Risk Control and Restricted Symbol Control​

Sample Query 4: To insert risk controls for a client firm:

REPLACE INTO srcontrol.msgsrriskcontrol
VALUES 
('EQT','NMS','BA','*','ClientFirm','SRCORE','Yes','Enable','Enable','Enable',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,'username','Saturn',NOW());

To update a restricted symbol, run this update message:

UPDATE srcontrol.msgsrriskcontrol
SET stkenabled = 'Disabled', futenabled = 'Disabled',optenabled = 'Disabled'
WHERE riskfirm = 'SRCORE' AND ticker_tk = 'BA' AND riskcontrollevel = 'ClientFirm' AND riskcontrolkey = '*';

Sample Query 5: To insert risk controls for an account:

REPLACE INTO srcontrol.msgsrriskcontrol
VALUES ('EQT','NMS','Z','T.ACCNT','Accnt','SRCORE','Yes','Enable','Enable','Enable',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,'username','Saturn',NOW());

To update a restricted symbol, run this update message:

UPDATE srcontrol.msgsrriskcontrol
SET stkenabled = 'Disabled', futenabled = 'Disabled',optenabled = 'Closeonly'
WHERE riskfirm = 'SRCORE' AND ticker_tk = 'Z' AND riskcontrollevel = 'Accnt' AND riskcontrolkey = 'T.ACCNT';

Sample Query 6: To insert risk controls for a user:

REPLACE INTO srcontrol.msgsrriskcontrol
VALUES ('EQT','NMS','DAL','user.name','USER','SRCORE','Yes','Enable','Enable','Enable',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,'username','Saturn',NOW());

To update a restricted symbol, run this update message:

UPDATE srcontrol.msgsrriskcontrol
SET stkenabled = 'CloseOnly', futenabled = 'Disabled',optenabled = 'Closeonly'
WHERE riskfirm = 'SRCORE' AND ticker_tk = 'DAL' AND riskcontrollevel = 'User' AND riskcontrolkey = 'user.name';

Sample Query 7: To insert user dividend override:

REPLACE INTO srcontrol.msguserdividendoverride
VALUES ('EQT','NMS','AAPL','SRCORE','Tooloverride',NOW(),'preference','Fullreplace',
'[{"divDate":"2025-05-12","divValue":0.26,"divCurrency":"USD","divKind":"Regular","divSource":"Forecast","divFreq":"None","divOverrideSource":"None"},{"divDate":"2025-08-11","divValue":0.26,"divCurrency":"USD","divKind":"Regular","divSource":"Forecast","divFreq":"None","divOverrideSource":"None"}]');

Sample Query 8: To insert user rate override:

SELECT * FROM srcontrol.doccolumns WHERE TABLE_NAME='msguserrateoverride'
ORDER BY ordinal_position ASC;SELECT * FROM srcontrol.msguserrateoverride
WHERE clientfirm = 'SRCORE';REPLACE INTO srcontrol.msguserrateoverride
VALUES
('SRCORE',NOW(),'TEST','[{"days":1,"rate":4.395},{"days":7,"rate":4.3878},{"days":30,"rate":4.3962},{"days":61,"rate":4.3825},{"days":91,"rate":4.3585},{"days":182,"rate":4.2213},{"days":365,"rate":3.9758},{"days":548,"rate":3.8259},{"days":730,"rate":3.7644},{"days":1095,"rate":3.7373},{"days":1825,"rate":3.7984}]');