nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

lseg.data duplicate values and no date indicator?

YujiReda

I was downloading market cap information across countries using the line below: TR.F.MktCap(SDate=0,EDate=-25,Period=FY2025,Frq=FY)

However, some RICs provide repeated information and too many rows. The above linenormally provides 26 rows as per 26 years, however for 'SIG.AX' for example, it returns 50 rows with half of the values being duplicates.

This only happens when using the lseg.data python library and not when retrieving the data using excel.

Can someone explain how this works? How can I reliably retrieve TR.F.MktCap using python?

ld.get_data(['SIG.AX'], "TR.F.MktCap(SDate=0,EDate=-25,Period=FY2025,Frq=FY)")

Find more posts tagged with

workspace

#content

#technology

python api

Accepted answers

Jirapongse

@YujiReda

Thank you for reaching out to us.

Can you share the formula used in the Excel?

It works fine with this code:

df = ld.get_data(
    universe = ['SIG.AX'], 
    fields = ["TR.F.MktCap.Date","TR.F.MktCap"],
    parameters = {"SDate": 0, "EDate":-25,"Period":"FY0","Frq":"FY"})
df

All comments

Jirapongse

@YujiReda

Thank you for reaching out to us.

Can you share the formula used in the Excel?

It works fine with this code:

df = ld.get_data(
    universe = ['SIG.AX'], 
    fields = ["TR.F.MktCap.Date","TR.F.MktCap"],
    parameters = {"SDate": 0, "EDate":-25,"Period":"FY0","Frq":"FY"})
df

YujiReda

The period in your code is set to "FY0". However, since I want the
absolute date I set it to Period "FY2025" as you can see in the original
post. However, this introduces the same value repeated over and over.

The difference between FY[n] and FY[YYYY] is described below by refinitiv workspace:
Relative Periods:
- FY[n] Fiscal Year based on last reported Year.
Absolute Periods:
- FY[YYYY] Fiscal Year

My question boils down to how to use the below parameter correctly to accurately get the data for absolute dates in lseg.data?

Jirapongse

I used the same parameters in Workspace Excel and Python and got the same data.

Workspace Excel

=@RDP.Data("SIG.AX","TR.F.MktCap","SDate=0 EDate=-25 Period=FY2025 Curn=USD CH=Fd RH=IN,CalcDate,rfperiod",D10)

Python

df = ld.get_data(
    universe = ['SIG.AX'], 
    fields = ["TR.F.MktCap.CalcDate", "TR.F.MktCap.rfperiod", "TR.F.MktCap"],
    parameters = {"SDate": 0, "EDate":-25,"Period":"FY2025","Frq":"FY", "Curn":"USD"})
df

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code. You can also refer to the How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.

Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.

EXPLORE OUR SITES