Full list of equity tickers

MANUELES

Hi,

I'm trying to bulk download balance sheet data for all equities available in Datastream Web Services. For this purpose, I'm using Python.

My plan is as follows: I will loop through the list of all countries I want to include and retrieve the tickers of all equities available for each country. Then, I will loop through chunks of equities to obtain the desired balance sheet data.

However, I'm having trouble finding the right way to do this. I’ve tried using an “equity list” approach, but for instance, the following query does not work:

df = ds.get_data(tickers="FUSALLA|L",fields=["RIC"],start="2025-04-03",kind=0)

So I'm stuck in the first step of the process.

Jirapongse

@MANUELES

Thank you for reaching out to us.

The attached picture contains your DSWS password. Thus, please contact the Datastream Webservice support team directly via MyAccount to reset your password.

It looks like that you are using the old library. The new library is DatastreamPy.

import DatastreamPy as DSWS
…
ds = DSWS.DataClient(None, username = username, password = password)

I tested the code and it can return the data properly.

df = ds.get_data(tickers="FUSALLA|L",
                 fields=["RIC"],
                 start="2025-04-03",
                 kind=0)
df

Please reset the password and try the new DatastreamPy library.