question

Upvotes
Accepted
1 0 0 1

How to add historical date when using the quick function, GRMEDIAN, from Workspace Excel to Python?

Refinitiv Data Platform (Workspace) - Python - Windows
How do we add a date as a row header from the code below? This produces historical data and the client asks if we could add dates for each data point.

import refinitiv.data as rd

rd.open_session()

df = rd.get_data(

universe = ['NVDA.O'],

fields = ['GRMEDIAN(TR.TRBCIndustry,TR.F.PriceToBookValuePerShr(SDate=2014-01-01,EDate=2024-05-21,Period=FI0,Frq=FQ),universe="EquityAll")/*RefinitivSectorPBMedian*/']

)


display(df)


pythonworkspace-data-api#technologyrdp-apipython apiparameters
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.

Upvotes
Accepted
18.2k 84 39 63

Hi @gianamadeus.garnace01

I think the best resource for this specific formula and how to specify a historical date field would be the helpdesk. Within Workspace, you can access the "Get Help & Support" (F1) feature and they will bring in a content specialist to determine if/how this can be done.

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.

Upvotes
1 0 0 1

@jason.ramchandani01 @nick.zincone Apologies for bothering you. I am hoping you can help me on this matter?

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.

@jason.ramchandani01 @nick.zincone following up on behalf of my colleague. Can you please help on this matter? Thank you!

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.