New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
cary avatar image
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
ksystof.rozmyslovic avatar image
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.