Files to look at:
How to implement a real-time data server and use the RTD function
This example demonstrates how to use the RTD function to retrieve data in real time from a COM Automation server.
In this example, we use a custom server that implements the IRtdServer interface. Our server provides data for stock prices, number of shares, and price change.
To run the project, start Microsoft Visual Studio as an administrator. Elevated permissions are required to register the COM server after it is built.
In v16.2.4 and higher, you can use the SpreadsheetControl.Options.RealTimeData property to specify whether to update data manually or to use a timer for automatic updates.