Built-in RTD.DB Functions
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

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