- How to edit the syntax so that it will reference an Excel file containing up to 250 RICs?
- How to edit the syntax so that it will display the financial period in the columns (e.g. FY2018Q1, FQ2018Q2, and so on). Tried adding 'CH': 'Fd,Fperiod' but it did not work.
This is what I am currently working on:
import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['ORCL.K'],
fields = [
'TR.RevenueActValue(Period=1FQ2018:1FQ2025,Curn=USD)',
'TR.EBITDAActValue(Period=1FQ2018:1FQ2025,Curn=USD)',
'TR.NetProfitActValue(Period=1FQ2018:1FQ2025,Curn=USD)'
],
parameters = {
'Curn': 'USD',
'CH': 'Fd,Fperiod'
}
)
display(df)
Thank you in advance!