How to get block trade for NYMEX WTI 1 MONTH CALENDER SPREAD OPTION CHAIN when occurs via python api

Best Answer

  • Shadab Hussain
    Shadab Hussain
    Answer ✓

    Hi @fengyijin,

    I'm posting the resolution below so that community members with similar kind of question can get help from this:

    You may use the formula below

    =@TR($B$3:$B$2000,"BLKCOUNT;BLKVOLUM;BLKTRDVOL;BLK_DATE;BLK_PRC1","CH=Fd RH=IN",E2)

    B3 to B2000 is where the RICs are located.

    I hope this was helpful and do let us know if you have any further queries.


Answers

  • raksina.samasiri
    raksina.samasiri admin

    hi @fengyijin ,

    This forum is more for programming-type queries, rather than content queries. I would recommend you to contact the Eikon support team directly via MyRefinitiv. You can ask for the =TR formula in the Eikon Excel which can be used to retrieve this report and if the formula is available, we can apply it to the get_data method in Eikon Data API. That way a content specialist can work closely with you to find a way to get the required data.

    However, for this case, I've raised ticket number 11200932 to a content specialist team to confirm if it is possible to retrieve the data using Eikon Excel or Eikon Data API. I'll keep you updated

    Hope this could help.

Categories