GetTradingDays
GetTradingDays() lists all dates in a specified date range and indicates whether the day was, or is, a trading day, taking into account weekends and public holidays of the securities exchange or country under consideration.
Syntax
GetTradingDays (Start, End, Exchange, ShowError)
| Start | The start date delimiting the range |
| End | The end date delimiting the range |
| Exchange | The code of the exchange to use, for example XLSE for the London Stock Exchange. |
| ShowError | If ShowError is set to TRUE, an error message will be displayed if the function fails. |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Example
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example. Return a range of dates, and flag whether they are/were trading days
| Function |
| =GetTradingDays(“01 Jan 2015″,”7 Jan 2015″,”XStockExchange1”,True) |
| Output | |
| 2015/01/01 | FALSE |
| 2015/01/02 | TRUE |
| 2015/01/03 | FALSE |
| 2015/01/04 | FALSE |
| 2015/01/05 | TRUE |
| 2015/01/06 | TRUE |
| 2015/01/07 | TRUE |