In Excel, is there a command to display the MONTH of expiration for an option contract? Thomson had this feature.
The option expiration month can be retrieved using TR formula:
=TR("AAPLK272011700.U","CONTR_MNTH")