UpdateTradingDays
The UpdateTradingDays() function updates trading day information in the Quintessence database for a particular exchange.
This is typically used when trading calendars change – for example, when a new public holiday is declared.
Related functions: GetTradingDays
Syntax:
Qx.UpdateTradingDays(Data, [StartDay], Exchange, [ShowError])- In Excel with Quintessence add-in versions prior to 25.1, use:
UpdateTradingDays()
ⓘ See parameter descriptions
| Data | The range containing the data to upload (for example, a date and its new trading day flag). |
| StartDay (optional) | The start day of the week. |
| Exchange | The exchange whose trading day calendar should be updated. |
| ShowError (optional) | If set to TRUE, an error message will be displayed if the function fails. |
Remarks:
- Unless changed by the administrator, default parameter values are:
- StartDay:
Monday - ShowError:
TRUE
- StartDay:
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Updating trading days
Current data in the database:
| Exchange | Date | Trading day |
| StockExchange1 | 3 October 2015 | FALSE |
| StockExchange1 | 4 October 2015 | FALSE |
| StockExchange1 | 5 October 2015 | TRUE |
A new public holiday has been declared on 5 October, so the trading day status must be updated.
Update range (A1:B1):
| 5 October 2015 | FALSE |
Formula:
=Qx.UpdateTradingDays(A1:B1, , " StockExchange1")Use either the Upload Sheet or Upload Selected button in the Quintessence ribbon to apply the update to the trading day calendar. You can verify the change by calling GetTradingDays.