Support Board
Date/Time: Sun, 24 Nov 2024 18:04:01 +0000
Trading day of month (TDOM) formula
View Count: 224
| [2024-05-22 10:28:09] |
| Pjimmy - Posts: 14 |
|
Hi, I have been struggling trying to figure out how to create a simple alert condition for a specific trading day of the month. I found some examples that use EOMONTH code from Sawtooth user but nothing that would allow me to choose say the 22 TDOM.
|
| [2024-05-22 14:21:40] |
| Sawtooth - Posts: 4119 |
|
=WORKDAY(EOMONTH(A3,-1),22) returns the 22nd workday of the month, assuming M-F workdays. It returns the incorrect day if there are less than 22 workdays in a month, like in February. Also, you must include a list of holiday dates for the WORKDAY function to not count holidays as workdays. So it's possible to find a certain trading day of the month, but it's not straightforward. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WORKDAY_Function =WORKDAY(EOMONTH(A3,0) +1,-1) returns the last workday of the month. To find the last trading day of the month, you'd need to include a list of holiday dates. |
To post a message in this thread, you need to log in with your Sierra Chart account: