ExcelFlux

RTD function

Retrieves real-time data from a program that supports COM automation.

Lookup and reference · Guided Excel example

Where can you use it?

Reporting and operations teams. Use functions in this group to retrieve a field from an item, employee or order list, select the right record, or move values into another report.

Scenario in the workbook

Use a registered COM server. Replace the example ProgID and topic fields with the provider’s values.

A worked example from the workbook

RowABC
6InputSecond inputThird input
7Your.RTD.ServerTemperatureLine1
8Your.RTD.ServerTemperatureLine2
9Your.RTD.ServerPressureLine1
Record 1
=RTD(A7,,B7,C7)

Illustrative outputServer value

See the inputs and instructions for all 3 examples

Worked examples

Use a registered COM server. Replace the example ProgID and topic fields with the provider’s values.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Input Second input Third input
7 Your.RTD.Server Temperature Line1
8 Your.RTD.Server Temperature Line2
9 Your.RTD.Server Pressure Line1
Trial Expression Sample output
Record 1 =RTD(A7,,B7,C7) Server value
Record 2 =RTD(A8,,B8,C8) Server value
Record 3 =RTD(A9,,B9,C9) Server value
Microsoft Excel reference