Ownership data Delisted companies for specific date

numan.ulucay

Hi guys,
I have a list of delisted companies that I got with the Deal Screener. It looks like this:

For these companies I would like to know the ownership structure before the delisting announcement date (for a specific date!). The problem I have is as follows. I can add the ticker, but if I want to use something like

ek.get_data('AC.TO',['TR.InvestorFullName','TR.PctOfSharesOutHeld','TR.SharesHeld','TR.HoldingsDate','TR.SharesHeldChange'],{'SDate':'2019-04-01','EndNum':'30'})

Adding the target ticker variable in there is not enough to extract the data. What identifier would you advise me to use and how do you download the ownership data? I basicaly need Information on the Shares Held of the biggest shareholders of a company for a specific Date.

Thanks alot!

Jirapongse

@numan.ulucay

Thank you for reaching out to us.

Typically, you can use the PermID with the ek.get_data method.

For example, the organization PermID of AC.TO is 4295863289. Therefore, the code will be:

df, err = ek.get_data('4295863289',
                      ['TR.InvestorFullName','TR.PctOfSharesOutHeld','TR.SharesHeld','TR.HoldingsDate','TR.SharesHeldChange'],
                      {'SDate':'2019-04-01','EndNum':'30'})
df

However, if you are unable to retrieve data with PermIDs, please contact the helpdesk team directly via MyAccount to verify what the problem is.