You can find the date functions and detailed descriptions in this topic.
|
Name |
Function |
Description |
| BOfFiscalYear | BOfFiscalYear(secuirty,quarter) | Returns beginning date of the Fiscal Year of the selected security for the specified quarter. |
| BOfMonth | BOfMonth(day,source) | Returns the first day of the month for the given day. |
| BOfQuarter | BOfQuarter(quarter,security) | Returns the first day of the quarter for the given security. |
| BOfWeek | BOfWeek(day,source) | Returns the first day of the week for the given day. |
| BOfYear | BOfYear(day,source) | Returns the first day of the year for the given day. |
|
Day2Month |
Day2Month(date) |
Returns the corresponding month of the selected date. |
|
Day2Quarter |
Day2Quarter(day,security) |
Returns the quarter number for the given day and security. |
|
DayOfMonth |
DayOfMonth(day) |
Returns the month number for the given day. |
|
DayOfWeek |
DayOfWeek(day) |
Returns the week number for the given day. |
|
DaysInMonth |
DaysInMonth(month) |
Returns the number of the days in selected month. |
|
DbLastDay |
DbLastDay(security) |
Returns the last trade day of the exchange of selected security. Returns the last trade day of the application's default exchange, if no security selected. |
|
DbLastMonth |
DbLastMonth(security) |
Returns the last trade month of the security. |
|
DbLastQuarter |
DbLastQuarter(security) |
Returns the last quarter of the security. |
|
DbLastSession |
DbLastSession(security) |
Returns the last trade day and session of the security. |
|
DbLastSessionDay |
DbLastSessionDay(security) |
Returns the day of last trade session of the security. |
|
DbLastSessionNumber |
DbLastSessionNumber(security) |
Returns the last trade session of the security. |
| DividendFutureDate | DividendFutureDate(security, order no) | Returns the future date of closest dividend payment of the selected security and number. |
| EOfFiscalYear | EOfFiscalYear(security,quarter) | Returns end date of the Fiscal Year of the selected security for the specified quarter. |
| EOfMonth | EOfMonth(day,source) | Returns the last working day of the selected day. |
| EOfPrevMonth | EOfPrevMonth(day,source) | Returns the last working day of the previous month of the selected day. |
| EOfPrevQuarter | EOfPrevQuarter(day,source) | Returns the last working day of the previous quarter of the selected day. |
| EOfPrevWeek | EOfPrevWeek(day,source) | Returns the last working day of the previous week of the selected day. |
| EOfPrevYear | EOfPrevYear(day,source) | Returns the last working day of the previous year of the selected day. |
| EOfQuarter | EOfQuarter(quarter,security) | Returns the last working day of the selected quarter and security. |
| EOfWeek | EOfWeek(day,source) | Returns the last working day of the week of the selected day. |
| EOfYear | EOfYear(day,source) | Returns the last working day of the year of the selected day. |
|
FinancialAnnouncementDate |
FinancialAnnouncementDate(security,quarter, template,updateDate) |
Returns the announcement date of the financial table of the selected security for the selected quarter. |
|
FinancialAnnouncementQuarter |
FinancialAnnouncementQuarter (security,quarter,template) |
Returns the announcement quarter of the financial table of the selected security for the specified date. |
|
FirstDay |
FirstDay(security,date) |
Returns the first trade day of the security if not selecting any date. If selecting any working day; Returns the same working day. If selecting non-working day; Returns the following first working day. |
|
GroupPeriodicallyLast |
GroupPeriodicallyLast (group,template) |
Returns the date of the last updated data for specified group and template. |
|
GroupPeriodicallyPrev |
GroupPeriodicallyPrev(group,template,date,#ofperiods) |
Returns the date of previous updated data for specified group and template, according to selected date and # of periods. |
|
LastDay |
LastDay(security,date) |
Returns the last trade day of the security if not selecting any date. If selecting any working day; Returns the same working day.If selecting non-working day; Returns the previous first working day. |
|
LastMonth |
LastMonth(security) |
Returns the last trading month of the security. |
|
LastQuarter |
LastQuarter(security,template) |
Returns the last quarter of the security. |
|
LastSession |
LastSession(security) |
Returns the last trading session of the security. |
|
MissingQuarterCount |
MissingQuarterCount(security,quarter,character,template) |
Returns the character for each empty quarter(in which no financials announced) of the security. |
|
Month2End |
Month2End(date) |
Returns the last day of the month or month of the date. |
|
NextDay |
NextDay(day,numberOfDays,source) |
Returns the working day "n" days ahead the selected day. Default value is 1. |
|
NextMonth |
NextMonth(day,numberOfMonths,source) |
Returns the working day "n" months ahead the selected day. Default value is 1. |
|
NextQuarter |
NextQuarter(quarter,numberOfQuarters,security, template) |
Returns the quarter "n" quarters ahead the selected quarter. |
|
NextWeek |
NextWeek(day,numberOfWeeks,source) |
Returns the working day "n" weeks ahead the selected day. Default value is 1. |
|
NextYear |
NextYear(day,numberOfYears,source) |
Returns the working day "n" years ahead the selected day. Default value is 1. |
|
NewsLastDay |
NewsLastDay(source) |
Returns the date of the last news due to the selected source. |
|
PrevDay |
PrevDay(day,numberOfDays,source) |
Returns the working day "n" days back the selected day. Default value is 1. |
|
PrevMonth |
PrevMonth(day,numberOfMonths,source) |
Returns the working day "n" months back the selected day. Default value is 1. |
|
PrevQuarter |
PrevQuarter(quarter,numberOfQuarters,security, template) |
Returns the quarter "n" quarters back the selected quarter. |
|
PrevWeek |
PrevWeek(security, day, numberOfWeeks) |
Returns the working day "n" weeks back the selected day |
|
PrevWorkDay |
PrevWorkDay(security,day,numberOfDays) |
Returns the transaction day of the selected security "n" days back the selected day. |
|
PrevYear |
PrevYear(security, day, numberOfYears) |
Returns the working day "n" years back the selected day. |
|
Quarter2Day |
Quarter2Day(quarter,security) |
Returns the last working day for the selected quarter and security. |
|
QuarterEndPrevYear |
QuarterEndPrevYear(day) |
Returns the last quarter of the previous year of the selected day. |
|
QuarterOfYear |
QuarterOfYear(quarter) |
Returns the number of the selected quarter in the whole year. |
|
Today |
Today() |
Returns the current day in the current date format. |
| TradingDay | TradingDay(date,security) | Returns the next trading day succeeding the specified day for the selected security. |
| TradingDayCount | TradingDayCount(day1,day2,security) |
Returns the number of trading days between the specified two days. |
|
ValidateSecurityDay |
ValidateSecurityDay(date,security) |
Returns the last trading day of the selected security for the specified date. |
|
ValidateSecurityWorkDay |
ValidateSecurityWorkDay(date,forward,security) |
Returns the trading day of the selected security ahead (forward TRUE) or back (forward FALSE) from the selected day. For instance; if Friday is selected and forward is TRUE, then the result is Friday. If Saturday is selected and forward is TRUE, then the result is Monday. |
|
ValidateWorkDay |
ValidayWorkDay(day, forward,source) |
Returns the trading day ahead (forward TRUE) or back (forward FALSE) from the selected day. (Independent of the selected security) For instance; if Friday is selected and forward is TRUE, then the result is Friday. If Saturday is selected and forward is TRUE, then the result is Monday. |
|
Year |
Year(day) |
Returns the year of the selected day. |