Request for NSTP report:
A report is required to extract open OTC trades for a month, covering both bank-side and broker-side data
Steps to extract the NSTP report for the Broker and Bank side data.
- Open MSSQL
- Go to the Query in the patch and double click the NSTP Broker and bank sql file- “NSTP Broker.sql”, “NSTP Bank.sql”
3. Verify the Query and click on execute.
4. For going forward please refer this query to extract the report by changing the period [MRTPERIOD] for the request month for both bank and broker side and please refer below image for changing the period.
Note: Please run it during off working hours and if there is any requesting with high priority, please reach to us.
Comments
0 comments
Please sign in to leave a comment.