RTD Function Examples

Contains examples for using the adapter.

This function returns the latest Symbol field value from the TradingStation example without authentication:

=RTD("C8.RTD",, "STREAMURI", 
"ccl://localhost:6789/Stream/Default/TradingStation/StreamTrades", 
"FIELD", "Symbol")

This function retrieves the same data, but adds authentication as user "alice" and password "bob":

=RTD("C8.RTD",, "STREAMURI", 
   "ccl://alice:bob@localhost:6789/Stream/Default/
      TradingStation/StreamTrades", 
   "FIELD", "Symbol")

This function retrieves the same data, but instead uses the URI connection alias "trades" as defined via the URI Connection utility and contained in the registry. Note that lowercase option names are acceptable:

=RTD("c8.rtd",, "streamuri", "trades", "field", "Symbol")

This function retrieves the same data, but instead specifies an index of 1, and tells the adapter to retrieve the value from the most recent tuple:

=RTD("C8.RTD",, "STREAMURI", "trades", "FIELD", "Symbol", "INDEX", 1)

This function connects to the same stream, but instead specifies an Index of 2 in order to retrieve the value from the second most recent tuple:

=RTD("C8.RTD",, "STREAMURI", "trades", "FIELD", "Symbol", "INDEX", 2)

This function connects to the same stream, but instead retrieves the history based on the current row relative to cell A5:

=RTD("C8.RTD",, "STREAMURI", "trades", "FIELD", "Symbol", "INDEX", row()-row(A$5))

And finally, this example is updated with the latest price where the Symbol field value is equal to "DELL":

=RTD("C8.RTD",, "STREAMURI", "trades", "FIELD", "Price", "FILTER", "Symbol", "DELL")