question

Upvotes
Accepted
3 0 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 5.0 MiB each and 10.0 MiB total.

1 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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea