question

Upvotes
Accepted
3 2 5 7

How to get historical values for TRGBNBPWKD?

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

eikonrefinitiv-dataplatform-eikonrdp-apidss#content
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvote
Accepted
7.2k 18 2 8

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


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.