UpdateTradingDays
The UpdateTradingDays() function updates trading days in the Quintessence database for a particular exchange, for example after a new public holiday has been declared.
Syntax
UpdateTradingDays (Data, StartDay, Exchange, ShowError)
| Data | The range of Excel cells containing the data to upload. Note: This could also be an array of data. |
| StartDay | The week start for the particular exchange. |
| Exchange | The exchange to update, for example, StockExchange1 or StockExchange2. |
| ShowError | If ShowError is set to TRUE, an error message will be displayed if the function fails. |
Example
Consider the following data in the database:
| DATABASE | ||
| Exchange | Date | Trading day |
| StockExchange1 | 1 October 2015 | TRUE |
| StockExchange1 | 2 October 2015 | TRUE |
| StockExchange1 | 3 October 2015 | FALSE |
| StockExchange1 | 4 October 2015 | FALSE |
| StockExchange1 | 5 October 2015 | TRUE |
If a new public holiday was declared for 5 October, the data could be updated from Excel or Quintessence as follows:
The range to use as update values:
| EXCEL | |
| Date | Trading day |
| 5 October 2015 | FALSE |
| Function |
| =UpdateTradingDays(A3:B3, “Monday”,”StockExchange1″, True) |
| UPDATED DATABASE | ||
| Exchange | Date | Trading day |
| StockExchange1 | 1 October 2015 | TRUE |
| StockExchange1 | 2 October 2015 | TRUE |
| StockExchange1 | 3 October 2015 | FALSE |
| StockExchange1 | 4 October 2015 | FALSE |
| StockExchange1 | 5 October 2015 | FALSE |