2 Messages

Digest #3542

smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls Extracti by "Ron Spruell" hashky

Re: smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls Extr by "Randy Harmelink" rharmelink

Messages

1a

smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls Extracti

Sat Oct 24, 2015 2:57 pm (PDT) . Posted by:

"Ron Spruell" hashky

Randy -
Is there an easier way than this to retrieve the Date from the Ticker Symbol than the following? Seems like a lot of code to get a simple date.

Extracting Dates from Ticker Symbols
Ticker Symbol is in D6

=DATE(MID(D6,FIND(" ",D6,FIND("/",D6)),5),MID(D6,FIND(" ",D6,1),FIND("/",D6)-FIND(" ",D6,1)),MID(D6,FIND("/",D6)+1,FIND(" ",D6,FIND("/",D6))-FIND("/",D6)))
Ron Spruell

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: smfGetOptionQuotes-Example-ITM-OTM-Multiple-Expirations.xls Extr

Sat Oct 24, 2015 3:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would probably go with either:

=smfWord(D6,2," ")&"/"&smfWord(D6,3," ")
=SUBSTITUTE(smfStrExtr(D6," ","$")," ","/")

...but the expiration date is already in cell I6, so not sure why you'd
need to?

On Sat, Oct 24, 2015 at 2:54 PM, Ron Spruell hashky@...wrote:

>
> Is there an easier way than this to retrieve the Date from the Ticker
> Symbol than the following? Seems like a lot of code to get a simple date.
>
> Extracting Dates from Ticker Symbols
> Ticker Symbol is in D6
>
> =DATE(MID(D6,FIND(" ",D6,FIND("/",D6)),5),MID(D6,FIND("
> ",D6,1),FIND("/",D6)-FIND(" ",D6,1)),MID(D6,FIND("/",D6)+1,FIND("
> ",D6,FIND("/",D6))-FIND("/",D6)))
>
>
>