How do i fetch seasonal historic data from api?

Jaja

Happy Holidays Team!

Posting this on behalf of our client:

Query: How do i fetch historic data from api? we could take this for an example: i want to get the seasonal data of TR.H.PE, TR.CompanyMarketCapitalization, TR.F.TotRevenue from 20231231 to 20250930 for ['688256.SS','600050.SS']

We have this sample code:

import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['688256.SS','600050.SS'],
fields = [
'TR.CompanyMarketCapitalization(Frq=D,SDate=2023-12-31,EDate=2025-09-30)',
'TR.TotalRevenue(Frq=D,SDate=2023-12-31,EDate=2025-09-30,Period=FS0)'
]
)

display(df)

We have the below code intervals that are useable in API such as:
FS- Fiscal Semi-Annual
FQ-Fiscal Quarter
FI-Fiscal Interim
CY-Calendar Year
CQ-Calendar Quarter
C-Calendar Days
F-Fiscal Periods
Y-Yearly
Q-Quarterly
M-Monthly

However, we cannot retrieve data for < TR.F.TotRevenue>, our specialist confirmed that this data item is valid and is working in Excel but unable to verify if this is supported in API, and was referred to your team to confirm if the same data item is supported in retrieving data in API, as when we tried it, there is no results found. I found alternative data item TR.TotalRevenue, but still no data result as well.

We are seeking for your help on this, thank you in advance.

We are looking forward to your positive response.

Jirapongse

@Jaja

Thank you for reaching out to us.

The code should be like this:

df = rd.get_data(
    universe = ['688256.SS','600050.SS'],
    fields = [       
        'TR.F.TotRevenue.Date',
        'TR.F.TotRevenue'
    ],
    parameters = {
        'Frq':'D',
        'SDate':'2023-12-31',
        'EDate':'2025-09-30',
        'Period':'FS0'
    }
)

df

If this doesn't answer the question, please share the Excel formula that can be used to retrieve the required data. Then, I can convert it to Python code.