question

Upvotes
Accepted
1 0 2 3

Get explorer list of CDS for specific tenor in Datastream API

Hi,

In the datastream explorer, one can find all Credit Default Swaps for a specific tenor and export this total list via excel (see example below). How do I request this list per tenor via the Datastream API in python?

E.g. CDS_list_6m=ds.get_data(......)


1634541999915.png


pythonapidatastream-apidatastream
1634541999915.png (89.9 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

· Write an Answer
Upvotes
Accepted
78.1k 246 52 72

@jeroen.kouwenberg01

The datastream web service has a symbol lookup but its feature is quite limited, as mentioned on this thread.

However, you can export a list to an excel file and then use the pd.read_html('file.xls') method to load a file into a list of DataFrame objects.

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.

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.