Login Page - Create Account

Support Board


Date/Time: Mon, 17 Jun 2024 06:28:56 +0000



Trading day of month (TDOM) formula

View Count: 94

[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: 4024
=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:

Login

Login Page - Create Account