Built-in RTD.DB Functions

Built-in RTD.DB Functions

The formula configuration table contains Excel-like formulas for getting data from RTD and DDE servers.

You can use built-in functions to update date and time fields if a server has no such fields.

For example:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULA
rtdQuoteDayHistoryTOSSymbol
rtdQuoteDayHistoryTOSDate=Date()
rtdQuoteDayHistoryTOSTime=Time()
rtdQuoteDayHistoryTOSLast=TOS|LAST![Symbol]
rtdQuoteDayHistoryTOSChange=TOS|NET_CHANGE![Symbol]
rtdQuoteDayHistoryTOSBid=TOS|BID![Symbol]
rtdQuoteDayHistoryTOSAsk=TOS|ASK![Symbol]

Note that the current time is adjusted to the table time zone specified in the table configuration.

The second application of built-in formulas is getting aggregated time intervals like 15 minutes.

Just use the formulas like =DateTime15() or =Time15() to round up the current time.

Function List

FunctionResult
=TimeStamp()Returns the current UTC datetime.
=UtcNow()Returns the current UTC datetime.
=Now()Returns the current datetime.
=TableNow()Returns the current datetime adjusted to the table time zone.
=DateTime()Returns the last data update datetime.
=DateTime0()Returns the last data update datetime rounded to 1 second up.
=DateTime1()Returns the last data update datetime rounded to 1 minute up.
=DateTime5()Returns the last data update datetime rounded to 5 minutes up.
=DateTime10()Returns the last data update datetime rounded to 10 minutes up.
=DateTime15()Returns the last data update datetime rounded to 15 minutes up.
=DateTime20()Returns the last data update datetime rounded to 20 minutes up.
=DateTime30()Returns the last data update datetime rounded to 30 minutes up.
=DateTime60()Returns the last data update datetime rounded to 60 minutes up.
=Date()Returns the last data update date.
=Time()Returns the last data update time.
=Time0()Returns the last data update time rounded to 1 second up.
=Time1()Returns the last data update time rounded to 1 minute up.
=Time5()Returns the last data update time rounded to 5 minutes up.
=Time10()Returns the last data update time rounded to 10 minutes up.
=Time15()Returns the last data update time rounded to 15 minutes up.
=Time20()Returns the last data update time rounded to 20 minutes up.
=Time30()Returns the last data update time rounded to 30 minutes up.
=Time60()Returns the last data update time rounded to 60 minutes up.