question

Upvotes
Accepted
3 0 3 3

Options Expiration Month?

In Excel, is there a command to display the MONTH of expiration for an option contract? Thomson had this feature.

rdp-apirefinitiv-data-platformderivatives
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
61 0 0 0

The option expiration month can be retrieved using TR formula:

=TR("AAPLK272011700.U","CONTR_MNTH")

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea