question

Upvotes
Accepted
3 3 3 3

Options - Days to Expiration

I'm looking for the Refinitiv Excel code for "number of days to expiration date". I've built a formula which uses (Expiration Date minus current date), but the screen constantly updates and flickers when I do it. I'm guessing that's a weird anomaly of Excel.

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

Hello Cary,

you may try

=TR("AAPLA152109125.U","EXPIR_DATE")-RtToday()

In the future, please raise Excel related questions to Refinitiv Customer Support

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.