Connector for OneTick

The OneTick connector allows connection to OneMarketData OneTick tick history databases on a polled basis. In general, it is used to retrieve conflated time series data sets. The connector supports either:

• Execution of a specified OTQ
• Execution of a specified parameterized OTQ
• Execution of a custom SQL Query

1. Enter the Context (for example, REMOTE).
2. You can either select:
   • Show Local OTQs checkbox to display the local OTQs in the Selected OTQ drop-down list.
   • Show Remote OTQs checkbox to display the remote OTQs in the Selected OTQ drop-down list.

   An OTQ can be specified for execution, or a custom SQL query can be executed, through selection of the appropriate radio button:

   • OTQs
   • Query
3. Click Load   to populate the Selected OTQ drop-down list. Select an OTQ.

   The list of input parameters that the OTQ expects is displayed. In addition, the basic SQL query is generated allowing the OTQ to be executed and the input parameters specific to the selected OTQ. The following are generic to all OTQs:

   • Symbol List

     NOTE: This property will accept comma-separated values either hardwired or parameterized.

   • From
   • To

     These add additional filter criteria such as symbols, and time window onto the basic OTQ.

4. Select the Separate DB Name checkbox to generate a separate field for the database name.
5. Select the Show per symbol errors as warnings checkbox to proceed with warnings in the log if symbol errors are returned.

   The result is a fully generated OneTick SQL query. This can be edited as required.

6. Date/Time values of output data and Date/Time inputs, where supported, are by default unchanged.

   You can opt to define the Show in Timezone and Source Timezone settings.

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support