download bond description via python API

I need to download us municipal bond details from eikon the result is very large 974,750 rows how can I download the data using python eikon data api(not excel) or through the GUI.

I cant use the solution the post as bond monitor does not allow more than 500 entries at a time.

Attaching snapshot for details.

Thanks!

Find more posts tagged with

python

eikon

bonds

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @ravi_ranjan

I think it is not feasible on Eikon Data API(Python).

First, bond search is not available on Eikon Data API(Python)

Second, to work around that, you have to import search result into a "list" and as you have seen that it only support 500 RIC at a time.

Third, even you manage to get all the RIC code for 974750 instruments, you will have to manage to break it down to a lot of smaller requests and you will hit API usage limitation in no time.

Limitation document is at https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs?content=49692&type=documentation_item

I saw that you have access to DSS/Tick History API (saw you asked questions about it)

I think it is possible to explore on how to extract RIC and information for the same universe using DSS product.

All comments

chavalit-jintamalit

Hi @ravi_ranjan

I think it is not feasible on Eikon Data API(Python).

First, bond search is not available on Eikon Data API(Python)

Second, to work around that, you have to import search result into a "list" and as you have seen that it only support 500 RIC at a time.

Third, even you manage to get all the RIC code for 974750 instruments, you will have to manage to break it down to a lot of smaller requests and you will hit API usage limitation in no time.

Limitation document is at https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs?content=49692&type=documentation_item

I saw that you have access to DSS/Tick History API (saw you asked questions about it)

I think it is possible to explore on how to extract RIC and information for the same universe using DSS product.

ravi_ranjan

Hello,

Could you explain how to extract this information on RIC with only the search criteria that I have ?

Thanks

EXPLORE OUR SITES