Explore Market RTD Application Fields for Excel Integration
Application fields provide access to information about application settings, downloads, and value changes using RTD formulas.
Server Fields
Formula format:
=RTD("market.rtd",,"<Data field>")
Examples:
=RTD("market.rtd",,"rtd_server_Version")
=RTD("market.rtd",,"rtd_server_DataCacheDirectory")
Complete list of fields:
| Field | Meaning |
|---|---|
| rtd_server_Version | The Market RTD version |
| rtd_server_Registration | Information about the registered edition and trial period |
| rtd_server_DataCacheDirectory | The DataCacheDirectory configuration value |
| rtd_server_TimeZone | The TimeZone configuration value |
| rtd_server_DateTime | The current date and time adjusted to the server time zone |
| rtd_server_Date | The current date adjusted to the server time zone |
| rtd_server_Time | The current time adjusted to the server time zone |
| rtd_server_Path | The Market RTD installation path |
| rtd_server_Stop_Download | Set 1 to stop downloads temporarily and 0 to enable them again |
Tick Fields
Use special tick fields for number data fields by adding the :tick suffix to the data field name.
Example:
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last:tick")
Tick values:
| Tick Value | Meaning |
|---|---|
| 1 | The value has increased |
| 0 | The value remains unchanged |
| -1 | The value has decreased |
Tick fields can be utilized for conditional formatting of the underlying fields or as independent columns.
Data Provider Fields
Use the following fields to retrieve information about data providers:
| Field | Meaning |
|---|---|
| rtd_RefreshInterval | The refresh interval (get and set) |
| rtd_LastUpdate | The date and time of the last update |
| rtd_LastUpdateDate | The date of the last update |
| rtd_LastUpdateTime | The time of the last update |
| rtd_LastError | The last error code (see codes below) |
| rtd_LastMessage | The last error message |
Example:
If your data formula is:
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")
You can add formulas to monitor data status:
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastUpdate")
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastError")
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastMessage")
You can also change the refresh interval (in seconds or as hh:mm:ss) using a formula like this (for 15 minutes):
=RTD("market.rtd",,"YahooFinanceQuotes","rtd_RefreshInterval",15*60)
Note: Avoid making excessive requests to the website, as this may result in your IP being banned.
LastError Codes
The rtd_LastError field returns the following codes:
| Value | Member Name | Description |
|---|---|---|
| 0 | Success | No error was encountered |
| 14 | Timeout | No response was received during the time-out period for a request |
| 15 | ProxyNameResolutionFailure | The name resolver service could not resolve the proxy host name |
| 400 | BadRequest | The request could not be understood by the server due to malformed syntax |
| 401 | Unauthorized | The request requires user authentication |
| 403 | Forbidden | The server understood the request but is refusing to fulfill it |
| 404 | NotFound | The server has not found anything matching the Request-URI |
| 407 | ProxyAuthenticationRequired | This code is similar to 401 (Unauthorized) but indicates that the client must first authenticate itself with the proxy |
| 408 | RequestTimeout | The client did not produce a request within the time that the server was prepared to wait |
| 500 | InternalServerError | The server encountered an unexpected condition which prevented it from fulfilling the request |
| 503 | ServiceUnavailable | The server is currently unable to handle the request due to temporary overloading or maintenance of the server |