Pulling numbers from Text, then arranging as date

Our take

Managing trade data efficiently is crucial for tracking performance, especially when dealing with options like SPX. If you're looking to extract expiration dates from a string format in Excel, there’s a solution that can streamline your workflow. By leveraging Excel’s text functions, you can dynamically pull out the YYMMDD dates from your symbols and convert them into a recognizable date format. This process not only enhances your data organization but also ensures that your workbook remains adaptable as you continuously add new trades.

Hey y'all.. I am hoping that someone smarter than I, can assist with this.. I've tried several ways (text to columns, TEXTJOIN) unsuccessfully. I run Excel for Mac (Version 16.107 (26030819)).

It'd be great if the solution was dynamic, as I am continually adding to the Sheet.

I trade options (specifically SPX), and my brokerage provides me with .csv's containing my transactions. I'm creating a workbook that tracks my trades. Column E (formatting is General) is the "symbol", which has the following syntax:

-SPXW251010P6200 or -SPX251017P6150 (notice missing "W" in second example)

What I am trying to accomplish is to pull out the expiration date - "251010" and "251017" in the examples above, which are YYMMDD - for each record, and placing it in its own cell as DD/MM/YY (formatted as Date).

Any suggestions?? TIA

submitted by /u/Interestingly_Quiet
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Pulling numbers from Text, then arranging as date

Related Articles