Futures next expiry as of date

Hello,

I am using Datascope TimeAndSales TickHistory to download futures data. I am aware of using c1,c2 shorthand to get the next two expiries which works if downloading the data for T+1.

But if I want to do a backfill the API doesn't work out the next expiry as of historical date. Is there a way to do this?

Best,
Ryan

Best Answer

  • ryan.ohanlon
    ryan.ohanlon Newcomer
    Answer ✓

    Hello Jirapongse,

    Thank you for your response. c1, c2, . . . is short hand to get the next expiries for a future. However this doesn't work historically. i.e. if I were to query CLc1, CLc2 for 2023.01.02 the API doesn't return CLG3 and CLH3. However if I were to query for yesterday the 'Alias Underlying RIC' returns CLV3 and CLX3.
    Thanks for the above screenshot. I am a refinitiv newbie. How can I filter Futures & Options Search for just crude oil i.e. CLV3 and CLX3 etc.

    Edit:
    Is it possible to query timeandsales datascope api using the shorthand c1, c2 historically without using Futures & Options Search ?

Answers