RealTimeToExcel RTD Server Fields

Server Fields

RealTimeToExcel allows getting server information and values of RealTimeToExcel settings into Microsoft Excel.

Formula format:

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

For example:

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

Complete list of fields:

Field	Meaning
rtd_server_Version	RealTimeToExcel version.
rtd_server_Registration	Information about the registered edition and trial period.
rtd_server_DataProviderDirectory	The directory of data provider configuration.
rtd_server_DataCacheDirectory	DataCacheDirectory value.
rtd_server_RefreshTimerInterval	RefreshTimerInterval value.
rtd_server_DateTime	Current date and time adjusted to the server time zone.
rtd_server_Date	Current date adjusted to the server time zone.
rtd_server_Time	Current time adjusted to the server time zone.
rtd_server_TimeZone	TimeZone configuration value.
rtd_server_TraceDownload	TraceDownload configuration value.
rtd_server_LogFileName	LogFileName configuration value.
rtd_server_YahooConsumerKey	YahooConsumerKey value.
rtd_server_LastClosedTradeDate	Calculated date of the last closed trade date.
rtd_server_PrevClosedTradeDate	Calculated date of the previous closed trade date.

Tick Fields

You can use special tick fields for number data fields. Add the :tick suffix to the data field name.

Example:

=RTD("gartle.rtd",,"YahooFinanceWatchList","YHOO","Last")
=RTD("gartle.rtd",,"YahooFinanceWatchList","YHOO","Last:tick")

Tick values:

Tick Value	Meaning
1	The value is changed up.
0	The value is unchanged.
-1	The value is changed down.

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

Data Provider Fields

In addition to data provider-specific fields, you can use predefined fields to monitor the current status of data refreshing:

Field	Meaning
rtd_LastUpdate	DateTime of the last update.
rtd_LastUpdateDate	Date of the last update.
rtd_LastUpdateTime	Time of the last update.
rtd_LastError	The last error code. See WebException Status and HTTP Status Codes below.
rtd_LastMessage	The last error message.
rtd_DataProvider	A data provider name. The value is the same as called in the formula.
rtd_RowID	A row identifier based on the formula.
rtd_TopicCount	Unique ticker's data field count in all opened workbooks.
rtd_InQueue	True if the row in the download queue.
rtd_RefreshInterval	Data provider refresh interval.

For example, if a data formula is

=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","LastTradePriceOnly")

you can add formulas to monitor data status:

=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","rtd_LastUpdate")
=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","rtd_LastError")
=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","rtd_LastMessage")
=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","rtd_InQueue")

WebException Status Values

The rtd_LastError field can return WebException Status values.

See a complete description at

https://learn.microsoft.com/en-us/dotnet/api/system.net.webexceptionstatus?view=net-6.0

The most frequent statuses:

Value	Member name	Description
0	Success	No error was encountered.
7	ProtocolError	The response received from the server was complete but indicated a protocol-level error. The HTTP status code is shown instead. See below.
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.

HTTP StatusCode Values

The rtd_LastError field can return HTTP StatusCode values.

See complete descriptions at

https://learn.microsoft.com/en-us/dotnet/api/system.net.httpstatuscode?view=net-6.0

https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html

The most frequent status codes:

Value	Member name	Description
200	OK	The request has succeeded.
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 a temporary overloading or maintenance of the server.