File ID 438770
Lines 168-170 will give you an idea.
This spread sheet has a link to real time stock market data.
I would like the option symbol in A168-A329 to be able to change with fluctuations in the price and the expiry date of the stocks option.
where AA^^^^ - is the stock's code plus 3 filler characters ( NB this section needs to be total 6 characters ie stock code 1- 4 letters and remaining "^" character to total 6. eg2 AAPL^^14011800390000
140118 is the expiry date
C is the "call" or "put" status
00007 is the call strike ie 7.
remaining three 0's are for decimal places
Is this enough info?
Attachments are only available to registered users.
File ID 358168
I want to fill in column A based on some values that you can extract from columns C and E.
Perhaps some for of regular expression so the underlined regions express C and E