Hi all
I have a financial derivative thats named - X 1012 the number refers to its date of expiry, I want to extract the exact date of expiry. 10 refers to the 10th month (October), 2 is the year 2012, the 1 in the middle (and this is my problem) refers to the first week of the 10 month of 2012. the exact expiry is always on the wednesday of that week.
Extracting the month and year is easy, my problem is finding exact date from the wednesday of the week number.
Any help is appreciated
Thank you
Bookmarks