/
Legacy Option Format (Excel and Java)
Legacy Option Format (Excel and Java)
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 |
, multiple selections available,
Related content
Ticker Symbology
Ticker Symbology
More like this
Market Data Coverage
Market Data Coverage
Read with this
Excel Real Time Fields
Excel Real Time Fields
More like this
Option Chain
Option Chain
More like this
The Money.Net Ribbon
The Money.Net Ribbon
More like this
Excel Add-in Templates
Excel Add-in Templates
More like this