DAYS Difference Keyword

Arun · September 11, 2021, 7:07am

How does DAY Difference kwyword work.

I want to take a trade of monthend expiry options on first Friday of the expiry.

any suggestions.

I have used day difference > 30 but it is not working.

Chandrahas · January 18, 2023, 6:49am

Share the screen shot of condition builder…Please

racha2068 · January 18, 2023, 5:21pm

Try this. Logic here is : This month expiry first Friday = Last Month Expiry Date + 1 Day

Chandrahas · January 20, 2023, 5:55am

and also add condition of [Week day (NSE)] == Number(5)

racha2068 · January 20, 2023, 6:23am

Yes we can but one catch here : if expiry happens on Wednesday instead of Thursday then it fails.

Chandrahas · January 20, 2023, 6:52am

So use AND of both condition
Dayd Difference D2-D1 >= 1
AND
Week day(NSE) == Number (4)

racha2068 · January 20, 2023, 6:58am

Number(4) …you mean Number(5)?

Chandrahas · January 20, 2023, 7:24am

Yes…5 for Friday…

racha2068 · January 20, 2023, 7:28am

It works. But as I mentioned earlier it fails in scenario of Wednesday expiry