DSS - How can I get a full list of equities in selected stock exchanges?

wmi

Hi, I hope this is the right place to raise this question. We have been unable to get a satisfactory answer from Customer Support, so I wanted to reach out here directly.

We are trying to retrieve all instruments (both active and inactive) per stock exchange (e.g., XOSL - Oslo Stock Exchange) in DSS (Datascope Select). However, it seems that the number of instruments is restricted to a maximum of 5,000, as shown in the attached image, and we need to retrieve the full list beyond this limit.

If a REST API-based solution is required, we are open to exploring that as well. Any suggestions or guidance would be greatly appreciated.

The goal is to get dividend data of these instruments. But I suppose we need to list the instruments of our interests.

Thank you in advance for your help!

Jirapongse

@wmi

Thank you for reaching out to us.

Yes, you can use the https://selectapi.datascope.lseg.com/RestApi/v1/Search/EquitySearch endpoint in the DSS REST API. Please refer to this REST API Tutorial 12: Search for an Equity tutorial.

The payload will look like this:

{

    "SearchRequest": {

        "AssetStatus": null,

        "AssetCategoryCodes": null,

        "SubTypeCodes": null,

        "CurrencyCodes": null,

        "CompanyName": null,

        "Description": null,

        "DomicileCodes": null,

        "ExchangeCodes": [ "OSL" ],

        "FairValueIndicator": null,

        "FileCodes": null,

        "GicsCodes": null,

        "OrgId": null,

        "Ticker": null,

        "Identifier": null,

        "IdentifierType": null,

        "PreferredIdentifierType": "Ric"

    }

}

Then, you need to specify the following value in the request's header.

Request Headers
Prefer: respond-async; odata.maxpagesize=10000