Adjusting the RTD Interval Throttle in Microsoft Excel

CQG Integrated Client version 8.4 supports RealTimeData for sending data and other market information to Microsoft Excel®. This feature opens up many opportunities for creating custom displays and other ways to better manage your workflow. One consideration to keep in mind is that Excel has a throttle that manages how often it updates. You can set this throttle to whatever update rate you want. From a Microsoft FAQ, here are the steps to set the throttle to continuously update.

To set the throttle interval higher using the Excel object model:

  1. In Excel, go to the Visual Basic Editor by pressing ALT + F11.
  2. On the Immediate Window at the bottom of the display, type this code:
    (Note: If the Immediate Window is not open, press CTRL + G to display the window.)
  3. Make sure your cursor is on the line that you just typed and then press ENTER.
  4. To verify that it is set correctly, type this line of code on the Immediate Window:
    ? Application.RTD.ThrottleInterval
  5. Make sure your cursor is at the end of this line and then press ENTER. The window should display 0; then you know that your throttle interval is set correctly.

Source: Microsoft. Real-Time Data: Frequently Asked Questions.

To learn more about configuring the RTD throttle interval in Excel, visit the MSDN Real-Time Data: Frequently Asked Questions web page.



Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.