Market Data Export Module
This software* is intended for exporting online data from the QUIK server to the database through the ODBC.
Method of Operation
- The software is connected to the QUIK server in the same way as the QUIK workstation. To do so, an individual user with assigned access keys is created for the module on the QUIK server. Authentication and encryption of a communication channel are done by cryptographic tools by ARQA Technologies.
- Information will be exported to the ODBC-source formed on the user’s computer. Any type of data may be uploaded into one or more tables, the table fields and filter for each table being adjusted relative to QUIK classes. The ODBC-source name and the correspondence of data fields are set in the settings file.
- Registered as a service of OS Windows, the software enables operation in the automatic mode. Software actions are recorded in the log file. Sending email messages about some events (connection to the server, connection to the database, error messages) is also available.
Data Available for Export
- Quotes Table,
- Table of Orders,
- Table of Trades,
In addition to the table data, the margin value before and after the trade is exported as well. It might be values of the minimal, initial or corrected margin and the portfolio value if using the limiting scheme “by discounts” or margin level if using the limiting scheme “by leverage”. It should be noted that the margin value estimated in real-time in the course of trading may slightly differ from the actual value because of some mistiming between the state of current market prices for instruments in the trading system and that on the QUIK server.
- Time and Sales Table ,
- Security Limits Table,
- Cash Limits Table,
- Table of OTC orders,
- Table of Negotiated Deals Mode Orders/Reports,
- Table of Trades for Execution,
- Table of the Broker’s Cash Positions,
- Table of Current Positions for Securities,
- Table of Current Positions for Selected Accounts,
- Tables of Positions on Client Accounts (futures),
- Tables of Limits on Client Accounts (futures),
- Client Portfolio Table,
- Table of NDM Quotes,
- Stop Orders Table,
- Table of trade accounts,
- Table of Asset liabilities and claims (securities market),
- Table of Cash liabilities and claims (securities market),
- Table of Parameters of percentage risks (securities market),
- Table of Parameters of market risks (securities market),
- Table of liabilities of a market maker,
- Table of Commitments and demands on assets in the foreign exchange market,
- Table of Interest rate risk parameters in the foreign exchange market,
- Table of Market risk parameters in the foreign exchange market,
- Table of Individual risk parameters in the foreign exchange market,
- Accrued Interest Table,
- Table ‘Currency: interproduct spreads’,
- Algo orders Table,
- Table ‘Linked orders for Algo orders',
- Table ‘Linked trades for Algo-orders',
- 'Favorite' instruments description,
- Transactions Table,
- Settlement Codes Table,
- Table 'NCC Transfers',
- Prohibitions Table.
The market data export module features a special after-hours actuation mode. In this mode, the module revaluates the margin value post factum when all instruments in the client portfolio are estimated at market prices effective at the time of transaction.
Hardware and software requirements
Processor Intel Xeon E5504 or better.
2 GB RAM (4 GB is recommended).
1 GB available hard disk space.
OS Windows Vista/Server 2008/7/Server 2012/8/10/Server 2016.
|Purchase||Managed services / System backup||Hosting||Testing|