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)


Best Answer

  • nick.zincone
    nick.zincone admin
    Answer ✓

    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.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.