Spaces
Apps
Templates
Create
Money.Net User Guide
All content
Space settings
Content
Components
Navigation
Excel Add-in User Guide
•
Market Data Coverage
Ticker Symbology
•
Legacy Option Format (Excel and Java)
•
CBOE Indices
•
Cryptocurrency Ticker Symbology
•
Government Bond Yields
Watchlist Downloads
•
Platform Updates
•
Partners
•
Firewall
Money.Net User Guide
/
Ticker Symbology
/
Legacy Option Format (Excel and Java)
Summarize
Legacy Option Format (Excel and Java)
Zane Ullman (Unlicensed)
Owned by
Zane Ullman (Unlicensed)
Last updated:
Jan 27, 2021
Loading data...
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
{"serverDuration": 39, "requestCorrelationId": "54fddfd49ec947f59d298b22fe5398ee"}