Setting the RTD Throttle

Owned by Onn BenZvi
Jun 28, 2022
2 min read

The AddIn uses Excels RTD feature to update data into the cells.

Excel RTD has a throttle value that determines how often the cells are updated. The default value in Excel is 2000ms (2 seconds). That means the regardless of how fast the data arrives in real time, the cells will only refresh themselves every 2 seconds.

This value can be tuned to your specific needs (see below).

No free lunch - the faster you update the more cpu is consumed by Excel.

With low throttle levels Excel might start to become unresponsive. This depends on many factors such as the spreadsheet calculations and how heavy it is, your machine CPU and so on.

Experiment and see what works best.

Step-by-Step

In the example below we set the throttle to 100ms

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:
    Application.RTD.ThrottleInterval=100
    (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 100; then you know that your throttle interval is set correctly.

Source: Microsoft. Real-Time Data: Frequently Asked Questions. https://msdn.microsoft.com/en-us/library/aa140060(office.10).aspx

Â