question

Upvotes
Accepted
1 0 0 0

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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
38.1k 71 35 53

@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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea