How to get historical values for TRGBNBPWKD?

lisa.mcentee

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

aramyan.h

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

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