Is there a way to pull up monthly data

Aileeeeen

Client wants to pull up recent month data for below fields (Sample RIC LSEG.L)

Is there a way to return only the latest data using get_data, including a column for the date of that data point

These are the fields I'd like to get:
FIELDS = [
"TR.REVENUESMARTEST",
"TR.GPMMEAN",
"TR.F.RETURNAVGTOTASSETSPCT",
"TR.F.DIVPAYOUTRATIOPCT",
"TR.F.INTRCOVRATIO",
"TR.F.TOTREVENUE(CURN=EUR)",
"TR.F.INTRPAIDCFSUPPL",
"TR.F.INCBEFTAX",
"TR.F.QUICKRATIO",
"TR.F.INTANGNETPCTOFTOTASSETS",
"TR.NETDEBTACTVALUE",
"TR.F.NETDEBTTOEBITDA",
"TR.F.EBITDAMARGPCT",
"TR.REPEPSMEAN",
"TR.F.TOTLIAB",
"TR.F.TOTEQPCTOFTOTASSETS",
"TR.F.PPENETTOT",
"TR.F.LEVEREDFOCF",
"TR.F.RETURNAVGTOTASSETSPCTTTM",
"TR.F.COMEQTOT",
'TR.F.OriginalAnnouncementDate',
'TR.F.OriginalAnnouncementDate(StType=INC)',
'TR.F.OriginalAnnouncementDate(StType=BAL)',
'TR.F.OriginalAnnouncementDate(StType=CAS)',
'TR.F.OriginalAnnouncementDate(StType=All)',
"TR.F.StatementDate",
'TR.F.StatementDate(StType=INC)',
'TR.F.StatementDate(StType=BAL)',
'TR.F.StatementDate(StType=CAS)',
'TR.F.StatementDate(StType=All)'
]

Additionally, could you please confirm which function would be more appropriate for this requirement—rd.get_history or rd.get_data?

From get_data:

From get_history:

Jirapongse

@Aileeeeen

Thank you for reaching out to us.

Each field may have its own sub-field for date, such as TR.REVENUESMARTEST.Date and TR.F.DIVPAYOUTRATIOPCT.Date.

df = ld.get_data(
    universe = ['LSEG.L'],
    fields = ['TR.REVENUESMARTEST.Date','TR.REVENUESMARTEST',
                  'TR.F.DIVPAYOUTRATIOPCT.Date','TR.F.DIVPAYOUTRATIOPCT']
)
df

For TR.xxx fields, both ld.get_data and ld.get_history retrieve data from the same datagrid endpoint. The ld.get_history method simplifies historical data retrieval by allowing you to specify start, end, and interval parameters, which correspond to SDate, EDate, and Frq in the ld.get_data method.

For example, the following functions pull the same data.

df = ld.get_data(
    universe = ['LSEG.L'],
    fields = ['TR.PriceClose.Date','TR.PriceClose'],
    parameters = {
        'SDate':'2026-05-01',
        'EDate':'2026-05-10',
        'Frq':'D'}
)
df


df = ld.get_history(
    universe = ['LSEG.L'],
    fields = ['TR.PriceClose'],
    start = '2026-05-01',
    end = '2026-05-10',
    interval = 'daily')
df

Therefore, to pull latest data, the ld.get_data method should be enough.

Moreover, this question duplicates this one.