RTD Function in Excel: Syntax, Examples and Free Practice
RTD is an Excel Lookup & Reference function. Retrieves real-time data from a program that supports COM automation.
RTD syntax
Arguments
prog_id: The name of the registered COM program to connect toserver: The name of the server the program is running ontopic1: The data item to request from the source
When to use RTD
RTD is used to pull matching data from one part of a workbook into another.
Practice RTD online, free
Open the live Excel-style spreadsheet and try RTD yourself. No Excel install or sign-up needed to start.
Practice RTD now →More Lookup & Reference functions
Frequently asked questions
What does the RTD function do in Excel?
Retrieves real-time data from a program that supports COM automation.
What is the syntax of RTD in Excel?
The syntax is =RTD(prog_id, server, topic1, ...). prog_id: The name of the registered COM program to connect to; server: The name of the server the program is running on; topic1: The data item to request from the source.
Where can I practice RTD online for free?
Open the free live spreadsheet on Cellgrids and try RTD yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts