Legacy Option Format (Excel and Java)

Owned by Zane Ullman (Unlicensed)
Last updated: Jan 27, 2021
1 min read

Options on US Equities

Ticker Format: The letter O, then a colon (:) followed by the ticker, then a backslash (\),
then the two-digit year, then the month code, then the day of the month, then a backslash (\), followed by the price with a space before the decimal point.
Ticker Examples
O:GOOG\14A18\485 .0
Google - Jan 18, 2014 - $485.00 Call
O:ORCL\15A17\40 .0
Oracle - Jan 17, 2015 - $40.00 Call
O:IBM\16M15\130 .0
IBM - Jan 15, 2016 - $130.00 Put
O:F\14R21\17 .0
Ford - Jun 21, 2014 - $17.00 Put
Month Codes
A
January - Call Option
M
January - Put Option
B
February - Call Option
N
February - Put Option
C
March - Call Option
O
March - Put Option
D
April - Call Option
P
April - Put Option
E
May - Call Option
Q
May - Put Option
F
June - Call Option
R
June - Put Option
G
July - Call Option
S
July - Put Option
H
August - Call Option
T
August - Put Option
I
September - Call Option
U
September - Put Option
J
October - Call Option
V
October - Put Option
K
November - Call Option
W
November - Put Option
L
December - Call Option
X
December - Put Option