How to get historical values for TRGBNBPWKD?

Options
lisa.mcentee
lisa.mcentee Newcomer
in Eikon Data APIs

Please can you list steps on how to get historical values (back till atleast 2018) for RIC 'TRGBNBPWKD'.

1. Is there a way to get it from TR GUI on EIKON in excel/csv format ? (preferrable)

2. If not, is there a way to retrieve it using RDP or DSS using Python?


Thanks

Tagged:

Best Answer

  • aramyan.h
    aramyan.h admin
    Answer ✓

    Hi @lisa.mcentee ,


    Since this forum is dedicated for developers consuming our data via APIs I will provide a solution using RD Libraries for Python API. Please find below a query returning historical prices for the requested asset:

    prices = rd.get_history('TRGBNBPWKD', start = '2018-01-01', end = '2023-03-22')
    prices

    screenshot-2023-04-21-at-135746.png

    Then, to save in excel you can run:

    prices.to_csv('prices')


    As for the Excel option, you may open a query via My Refinitiv.


    Hope this helps.


    Best regards,

    Haykaz

Categories