Support Board
Date/Time: Sun, 24 Nov 2024 20:40:31 +0000
Post From: How to draw a vertical line at 3rd friday every month?
| [2022-04-20 15:50:49] |
| Sawtooth - Posts: 4120 |
|
I've been using this alert to mark OPEX dates for some time and just realized this month OPEX 4/15 isn't printing, thoughts?
4/15 was a market holiday (Good Friday), so there was no Daily bar, hence no alert.For this special situation, use this formula instead: =IF(BARDATE=DATE(2022,4,14),1,BARDATE=(DATE(YEAR(BARDATE),MONTH(BARDATE),1+7*3)-WEEKDAY(DATE(YEAR(BARDATE),MONTH(BARDATE),8-6)))) This will mark the Thursday 4/14/2022 bar, plus the 3rd Fridays of other months. Date Time Of Last Edit: 2022-04-20 19:36:17
|