Get last quarter data instead of annual data from ld.get_data?

I have 2 requirements:
1) Get last quarter data for a few metrics one of them is mentioned like Total Revenue
2) Get scaled version of the metrics like 'TR.F.DPSComGrossIssueByPrdEndDate(Scale=2), does adding Scale = x works everytime? I am hoping scale=2 divides by 10^2 or something.

for solving 1) I have tried to use the following, it failed can you help ?

consI_metrics = ["TR.CommonName", "TR.F.TotRevenue(Scale=6)"]

consI_df = ld.get_data(

universe=['RELI.NS','ADEL.NS','BRTI.NS']

fields= consI_metrics,

parameters = {'SDate': '0CQ', 'freq' : 'Q'} )

consI_df.head(10)

Find more posts tagged with

python

eikon-data-api

#content

Accepted answers

All comments

Jirapongse

@Hemant

Thank you for reaching out to us.

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.

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

Hemant

I have the answer in excel, but I need to find the answers from get data API please.
Clear query: Get quarterly data from ld.get_data api for TR.F.TotRevenue(Scale=6).

Jirapongse

Please share the formula used in excel.

Then, I can convert it to the Python code.

Jirapongse

The correct parameter is 'Frq'.

consI_metrics = ["TR.CommonName", "TR.F.TotRevenue(Scale=6)"]
consI_df = ld.get_data(    
    universe=['RELI.NS','ADEL.NS','BRTI.NS'],    
    fields= consI_metrics,    
    parameters = {'SDate': '0CQ', 'frq' : 'Q'}
)
    
consI_df.head(10)

You can use the Data Item Browser to check for fields and parameters.

Hemant

Thanks for the response. I am hoping to get the underlined numbers i.e. Quarterly numbers. What your query is pulling are annual numbers.

Jirapongse

@Hemant

I’m unable to answer content-related questions. It’s best to contact the helpdesk team directly via LSEG Support to obtain details about the TR.xxx fields and parameters needed to retrieve the required data. Once you have that information, I can help you convert it into Python code.

EXPLORE OUR SITES