ISINs/CUSIPs full list

nicola.fiore

Where can I retrieve the full list of ISINs? and CUSIPs?

Gurpreet

Hi @nicola.fiore,

Which session are you using in the RD Library. If it is the platform session (i.e. an RDP customer), then there is a Client File Store (CFS) API which provides the ability to download the bulk files, and Symbology is one of the file types available in CFS.

Please note that CUSIP and ISIN are fee liable, and you will need appropriate permissions to access these identifiers.

raksina.samasiri

Hi @nicola.fiore ,

Could you please clarify more on the question, would you like to retrieve all of the ISINs and CUSIPs or do you have some input in other identifier type and want to retrieve the ISINs and CUSIPs of them? Plus, do you have any product you're using currently yet?

nicola.fiore

I would like to have the list of all CUSIPs/ISINs available, with company names, in a tabulat format (e.g., in Excel, or csv). So that I can search by company name. I already tried the "refinitiv-data" search function, within the Python API. But I would like to do a more "manual" search on a file

nicola.fiore

I would like to have the list of all CUSIPs/ISINs available, with company names, in a tabulat format (e.g., in Excel, or csv). So that I can search by company name. I already tried the "refinitiv-data" search function, within the Python API. But I would like to do a more "manual" search on a file

nicola.fiore

In Python I run the following command:

rd.open_session(app_key) with my own appkey generated through Refinitiv Workspace "APPKEY".
I did not know about the CFS API. It seems something I would benefit from. Could you tell me more about it, please?

wasin.w

Hello @nicola.fiore

You can find more detail about the RDP APIs CFS service from the followinng resources:

• CFS API User Guide document.
• Symbology and Reference Bulk for Company Data document

I also highly recommend you check with your Refinitiv Representative is the CFS - Symbology is the API that matched your requirement.

### About the CFS API ###

Basically, the CFS lets you download the bulk files that contain various information based on the Bucket name (Symbology information, ESG information, Green Revenues information, etc).

The HTTP API workflow is as follows:

Step 1: Get the list of packageIds from the Bucket bulk-symbology

GET /file-store/v1/file-sets?bucket=bulk-greenrevenue HTTP/1.1
Host: api.refinitiv.com
Authorization: Bearer <Access Token>

Step 2: Listing the Filesets of the bulk-symbology with the packageId

GET /file-store/v1/file-sets?bucket=bulk-greenrevenue&packageId={packageId} HTTP/1.1
Host: api.refinitiv.com
Authorization: Bearer <Access Token>

Continue in comment.

wasin.w

Step 3: Get the Bulk file URL on AWS S3

GET /file-store/v1/files/{fileId}/stream?doNotRedirect=true HTTP/1.1
Host: api.refinitiv.com
Authorization: Bearer <Access Token>

wasin.w

Hello @nicola.fiore

Additionally, since you are using the Refinitiv Data Library for Python you can see the TUT_3.2.01-EndPoint-Overview.ipynb example about how to use the RD Delivery Endpoint feature to call HTTP REST API request.

Gurpreet

You seem to be using a Desktop session. CFS is not available through Refinitiv Workspace. Please speak with your Refinitiv account manager about getting access to RDP.

Gurpreet

You seem to be using a Desktop session. CFS is not available through Refinitiv Workspace. Please speak with your Refinitiv account manager about getting access to RDP.