and how can i get history data via python or excel?
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
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.
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.