How can I use NumXL to compute the expiry date of a given equity option?
In the US, the equity option contract expires (stop trading) on the 3rd Friday of the expiry month.
To compute the expiry date:
- Using the NxNWkDay function, compute the calendar date of the third (3rd) Friday of the contract delivery month.
- Using the NxAdjust function, adjust the returned date in (1) using the OBOE calendar and using "Following" for the business day convention.