I have a spreadsheet to track Options Trades in the stock market. When I place a trade I get a copy of the order in the form of a string of text. (SOLD -1 VERTICAL NFLX 100 21 SEP 18 300/295 PUT @.76 CBOE).
I need to use a formula to bread this text into individual columns showing the following:
SOLD (transaction type)
1 (quantity of order)
VERTICAL (type option)
NFLX (Symbol)
100(# of shares in contract)
21 SEP 18 (Date of expiration)
300/295 (Cost of Vertical spread, two prices of $300 and $295
PUT(either a PUT or CALL)
@.76 (Net debit or credit)
CBOE (handling agent of transaction)
Solved by G. Y. in 20 mins