Stock price data

numan.ulucay

Hi guys,
I have the following problem. I have about 1000 M&A deals from the M&A Deal Screener. I want to download the daily adjusted stock price data for a long period like 16 years. Which way would you guys advise me to use. I was thinking of using the PermID and Excel Datastream but im not quite sure if it can handle this amount and if there is a better option.
Thanks guys.

Jirapongse

@numan.ulucay

Thank you for reaching out to us.

Both Workspace and Datastream have APIs so you can use Python code with LSEG Data Library or Datastream Web Service library to retrieve data.

You can use PermIDs with the LD library to retrieve historical data. For example:

df = rd.get_data(
    universe = ['4295904307'],
    fields = ['TR.ClosePrice.Date','TR.ClosePrice'],
    parameters = {'Adjusted':'1','SDate':'-16Y','EDate':'0'})

df

I am not sure if the Datastream supports PermIDs. You need to contact the support team directly via MyAccount to confirm it. Moreover, for questions regarding Excel Datastream, please also contact the Datastream support team directly via MyAccount.