How to ge NSE 500 bulk deals, block deals, short-selling data, and earnings surprise?

Question

Needed to download important data points with multiple requests I had few data downloading requests to start with I wanted to download bulk, block deals and Short selling data for stocks on the NSE specifically NSE 500, is there any way I can download this? it is available on NSE website but I cannot download the data in one go historically so I was wondering if there is any other way round that we get through LSEG? and I wanted to download earnings surprise % for stocks happening on respective dates historically

I am sure LSEG has that to avoid discrepancy between diluted eps and preferred eps is like reliance and Laurus labs

Could kindly share API script for the above

Jirapongse · Answer

For that formula, the LSEG Data Library for Python code looks like this:

df = ld.get_data(
    universe = ['RELI.NS'],
    fields = ['TR.EPSActSurprise.Date','TR.EPSActSurprise'],
    parameters = {
        'Period':'FQ0',
        'Frq':'CQ',
        'SDate':'2000-01-01',
        'EDate':'2024-12-31'})

df.dropna()

AbdulSamad · Answer

@Jirapongse thank you for the update below is the sample formula

=@RDP.Data("RELI.NS","TR.EPSActSurprise","Period=FQ0 Frq=CQ SDate=1QCY2000 EDate=4QCY2024 CH=Fd RH=IN;date")

Jirapongse · Answer

@AbdulSamad

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. You can also refer to the How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.

EXPLORE OUR SITES