Carbon time series API (R)

Dear Community,

I am trying to get panel data (yearly 2008-2018) of carbon metric (TR.AnalyticEstimatedCO2Total) in R using CUSIPs (not RICs). Would very much appreciate any help on feasibility and code structure.

- is it possible to use CUSIPs straight or always need to get RICs through get_symbology?

- I assume there should be a way to combine the get.timeseries and get.data?

Best Answer

  • chavalit-jintamalit
    Answer ✓

    Hi @porubcova.m

    Beware the CUSIP may not be able to map to RIC on a 1 to 1 relationship.

    image

    From this sample, you can see that both TRI.N and TRI.TO RICs have the same CUSIP code.

    So using RIC code(native identifier) is preferred.


    Here is sample code to retrieve historical data in Eikon Data API(Python)

    image


    - is it possible to use CUSIPs straight or always need to get RICs through get_symbology?

    It depends on the CUSIP but using RIC is a preferred method, because of 1 to many relationship (CUSIP to RIC)


    - I assume there should be a way to combine the get.timeseries and get.data?

    You can use get_data as in the sample provided.


    Please note that Eikon R is not released by Refinitiv, it is a community version(release in github).