question

Upvotes
Accepted
will.psomadelis avatar image
1 ●0 ●0 ●1

Extracting data from Datastream R API using Sedol

Hi,

I am using an R API call to extract historic returns from the datastream API from a dataframe of Sedols and Dates.

The API call works perfectly for ISIN's however for this dataset I only have Sedols.

I have noticed that the call only works on numeric Sedols and not alpha numeric Sedols.

I don't have a country code so am unable to append that to the Sedol as I've read on another thread.

Is there a simple way to achieve this ?


Thanks


WP

dsws-apisymbologyrsedol
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.

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

@will.psomadelis

Adding "UK" prefixed works.

ds.get_data(tickers="UKB60QWJ2,UKB60QWJ2,UKBVYVFW2, UKBF0CK44, UKBD3VFM7, UKB8KF9B4,UKBGDT3G2", fields=['P','SECD'],kind=0)

1660798455253.png

You can use R to add "UK" prefixed for alphanumeric Sedols.

You can contact the Refinitiv Datastream Web Service support team directly via MyRefinitiv to verify if there is another way to retrieve data from alphanumeric Sedols.


1660798455253.png (33.8 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.

Upvotes
Jirapongse avatar image
80k ●257 ●52 ●75

@will.psomadelis

Please check the answer on this thread.

Adding ‘UK’ before the SEDOL code may help.

If not, please share the SEDOL codes that you are using.

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.

will.psomadelis avatar image will.psomadelis

Hi,


Thanks for the response however the Sedols are from a multitude of countries and with 10k+rows its not feasible to manually enter country codes.

Examples are

6850856,0540528,3134865,4824778,5671735 which works

B60QWJ2,BVYVFW2, BF0CK44, BD3VFM7, B8KF9B4,BGDT3G2 which don't work.

Thanks

Will.


Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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