$$Excel-Macros$$ Re: How to generate codes for expired contracts?

2009-02-23 Thread Art
Chris, Thanks a lot. I would've spent weeks (not to say months) to figure this out. Tks again, Art. On Feb 21, 12:11 pm, Chris Spicer wrote: > Hi Art, > > Contract codes are always a pain.  The following functions generate > the previous n codes: > > Option Explicit

$$Excel-Macros$$ How to generate codes for expired contracts?

2009-02-20 Thread Art
Hello folks, been trying to generate contract codes for expired future contracts. For instance, let's say I want to retrieve all expired contracts which go back monthly (for the sake of simplification) for Light Crude (CL) starting from today... so today (February 20,2009) the first contract is