Minggu, 25 Oktober 2015

[smf_addin] Digest Number 3542

2 Messages

Digest #3542

Messages

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

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)))
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar