Options - Days to Expiration

cary

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.

ksystof.rozmyslovic

Hello Cary,

you may try

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

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