MARKET.RTD Application Fields

MARKET.RTD Application Fields

Application fields allow getting information about application settings, downloads, and value changes using RTD formulas.

Server Fields

Formula format:

=RTD("market.rtd",,"<Data field>")

For example:

=RTD("market.rtd",,"rtd_server_Version")
=RTD("market.rtd",,"rtd_server_DataCacheDirectory")

Complete list of fields:

FieldMeaning
rtd_server_VersionThe MARKET.RTD version
rtd_server_RegistrationInformation about the registered edition and trial period
rtd_server_DataCacheDirectoryThe DataCacheDirectory configuration value
rtd_server_TimeZoneThe TimeZone configuration value
rtd_server_DateTimeThe current date and time adjusted to the server time zone
rtd_server_DateThe current date adjusted to the server time zone
rtd_server_TimeThe current time adjusted to the server time zone

Tick Fields

You may use special tick fields for number data fields. Add 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 ValueMeaning
1The value is changed up
0The value is unchanged
-1The value is changed down

Tick fields can be used for conditional formatting of the underlying fields or as independent columns.

Data Provider Fields

Use the following fields to get the information for data providers:

FieldMeaning
rtd_RefreshIntervalThe refresh interval (get and set)
rtd_LastUpdateThe date and time of the last update
rtd_LastUpdateDateThe date of the last update
rtd_LastUpdateTimeThe time of the last update
rtd_LastErrorThe last error code (see codes below)
rtd_LastMessageThe last error message

For example, if a data formula is

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")

you may 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")

Also, you may change the refresh interval (in seconds or as hh:mm:ss) using the formula like this (15 minutes):

=RTD("market.rtd",,"YahooFinanceQuotes","rtd_RefreshInterval",15*60)

Do not make a lot of requests to the website. Otherwise, the website may ban your IP.

LastError Codes

The rtd_LastError field returns the following codes:

ValueMember name Description
0SuccessNo error was encountered
14TimeoutNo response was received during the time-out period for a request
15ProxyNameResolutionFailureThe name resolver service could not resolve the proxy host name
400BadRequestThe request could not be understood by the server due to malformed syntax
401UnauthorizedThe request requires user authentication
403ForbiddenThe server understood the request but is refusing to fulfill it
404NotFoundThe server has not found anything matching the Request-URI
407ProxyAuthenticationRequiredThis code is similar to 401 (Unauthorized) but indicates that the client must first authenticate itself with the proxy
408RequestTimeoutThe client did not produce a request within the time that the server was prepared to wait
500InternalServerErrorThe server encountered an unexpected condition which prevented it from fulfilling the request
503ServiceUnavailableThe server is currently unable to handle the request due to a temporary overloading or maintenance of the server
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.