Explore Built-in RTD DB Functions for Excel
The formula configuration table contains Excel-like formulas for retrieving data from RTD and DDE servers.
Built-in functions can update date and time fields when a server lacks these fields.
Example
| table_schema | table_name | column_name | rtd_formula |
|---|---|---|---|
| rtd | tos_historical_prices | symbol | |
| rtd | tos_historical_prices | date | =Date() |
| rtd | tos_historical_prices | time | =Time() |
| rtd | tos_historical_prices | last | =TOS|LAST![Symbol] |
| rtd | tos_historical_prices | change | =TOS|NET_CHANGE![Symbol] |
| rtd | tos_historical_prices | bid | =TOS|BID![Symbol] |
| rtd | tos_historical_prices | ask | =TOS|ASK![Symbol] |
The current time is adjusted to the table's time zone specified in the table configuration.
Additionally, built-in formulas can aggregate time intervals, such as 15 minutes. Use formulas like =DateTime15() or =Time15() to round up the current time.
Function List
| Function | Result |
|---|---|
| =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 up to 1 second |
| =DateTime1() | Returns the last data update datetime rounded up to 1 minute |
| =DateTime5() | Returns the last data update datetime rounded up to 5 minutes |
| =DateTime10() | Returns the last data update datetime rounded up to 10 minutes |
| =DateTime15() | Returns the last data update datetime rounded up to 15 minutes |
| =DateTime20() | Returns the last data update datetime rounded up to 20 minutes |
| =DateTime30() | Returns the last data update datetime rounded up to 30 minutes |
| =DateTime60() | Returns the last data update datetime rounded up to 60 minutes |
| =Date() | Returns the last data update date |
| =Time() | Returns the last data update time |
| =Time0() | Returns the last data update time rounded up to 1 second |
| =Time1() | Returns the last data update time rounded up to 1 minute |
| =Time5() | Returns the last data update time rounded up to 5 minutes |
| =Time10() | Returns the last data update time rounded up to 10 minutes |
| =Time15() | Returns the last data update time rounded up to 15 minutes |
| =Time20() | Returns the last data update time rounded up to 20 minutes |
| =Time30() | Returns the last data update time rounded up to 30 minutes |
| =Time60() | Returns the last data update time rounded up to 60 minutes |