In this article
RTD pulls live values from a real-time data server, e.g. stock prices from a broker’s trading terminal add-in. You need the provider’s RTD server installed.
Advertisement
Syntax
=RTD(progID, server, topic1, [topic2], ...)| Argument | What it means |
|---|---|
arguments |
Depend on the DLL or RTD server |
Examples
Example 1
=RTD(progID, server, topic1, [topic2], ...)Result: (depends on the installed server). See the worked example table below for more cases.
RTD in practice
Where you will use it
- Live market feeds from a broker terminal (RTD)
- Developer integrations
- Auditing legacy files
Worked example
| Example | Formula | Result |
|---|---|---|
| see syntax | =RTD(progID, server, topic1, [topic2], ...) | (depends on the installed server) |
Needs external software, so it is not calculated here.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Expecting it to work out of the box | Needs the external server/DLL and trust settings |
| Security | Only use RTD servers and DLLs from trusted vendors |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong