Maurice Calvert

Building a Real Time Data server: Changing the Excel RTD Throttle Interval, part 11

This is part 11 of the tutorial that describes the techniques necessary to build an Excel RTD server. If you have just come to this page, I suggest you read all parts in order, here is Building a Real Time Data for Excel, part 1.

By default, Excel won’t call RefreshData more often than every 2 seconds (the Throttle Interval). For financial data that’s arriving fast and furiously, this is reasonable, but for GeodesiX it makes the interface seem rather slow.

To improve this, GeodesiX changes the Throttle Interval to zero, which tells Excel to call RefreshData as often as possible. This is done in Geodesix.SetRealTime.SetRealTime #34#:

Changing the Throttle Interval to zero

This works and indeed speeds up the refresh, but you should note that it could cause other RTD applications to update too quickly.

The absolutely correct way would be to put back the throttle interval when Geodesix terminates. I couldn’t be bothered so we’ll leave it as an exercise…

Building a Real Time Data for Excel tutorial:

Post a comment

Have any questions? Ask us right now!