question

Upvotes
Accepted
germain.garnier avatar image
9 ●1 ●1 ●4

DSWS is there a way to use RIC in the requests?

Hi,

We are trying to get the ESG scores from DSWS.

My understanding is that to get a company ESG data items I need to specify one of this company's tickers in the instrument parameter.. Which is far from being practical, for instance RENAULT can have multiple Tickers (one per market). It would be much easier to use the RIC (which seems to be Refinitiv unique identifier for a company)

Is that possible ?

Is there a place where all the DSWS rest API parameters are listed ?


Below you can see we tried with the Python lib and the rest API

1629967321801.png


1629967487676.png


datastream-apidsws-api
1629967321801.png (39.8 KiB)
1629967487676.png (48.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
47.2k ●109 ●44 ●60

@germain.garnier

You can use RICs in the Datastream Webservice by enclosing them with Angle brackets.

ds.get_data(tickers='<VOD.L>,<RENA.PA>',
            fields=['NAME','ENSCORE'], 
            kind=0,start='LATESTDATE', 
            retName=True)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Alex Putkov.1 avatar image Alex Putkov.1

@germain.garnier

Since you stated that the reason you prefer to use RICs over Datastream mnemonics is that you're under the impression that a RIC is a Refinitiv unique identifier for a company, it may be worth noting that RICs are quote level identifiers. This means RICs identify both the instrument and the marketplace or trading venue. Typically there are multiple RICs referring to the same company. However, there's a primary RIC that refers to the company's primary issue (for public companies this is typically the ordinary share or the common stock) and the primary exchange or consolidated tape for the instrument. E.g. BARC.L refers to Barclays Plc stock traded on London Stock Exchange while BCS.N refers to Barclays Plc ADR traded on NYSE; RENA.PA refers to Renault stock traded on Euronext Paris while RNOp.CHI refers to Renault stock traded on CHI-X; and AAPL.O refers to the consolidated tape from all US trading venues for Apple Inc shares.