The XL Time Series study allows you to build models in Excel and import the outputs on a real-time basis into CQG for charting, auto trading and more. As the data in updates in the specified range of cells, the cell values in the model will update in real time in CQG as long as the worksheet is open and CQG is running..
The XL Time Series study is included in CQGIC subscriptions enabled for CQG Trading, or Spreader, as well as CQG Spreader systems. The XL Time Series Study is available to base CQGIC subscriptions at additional cost.
Excel Study Parameters
|
Parameter |
Description |
|
Workbook |
The exact name of your saved workbook (case sensitive), including extension.* |
|
Sheet Name |
The exact name of the sheet referenced from the workbook. |
|
Cell Ref |
The specific cell referenced from the sheet. |
|
Separate Date/Time |
Check this box if your Excel sheet has a separate column for date and a separate column for time. |
