question

Upvotes
Accepted
3 3 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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an 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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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