Home >> Support Board

Support Board

Date/Time: Sat, 27 Jul 2024 05:50:40 +0000

How to Post a Message for Support

Trading day of month (TDOM) formula

View Count: 131

[2024-05-22 10:28:09] #1 [Go To First Post]
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] #2 [Go To First Post]
Sawtooth - Posts: 4051
=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: