Retrieve more than 10000 rows from refinitiv workspace

Question

I'm trying to retrieve all the bonds from refinitiv workspace. I want to extract all the 250000+ bonds and actually I don't know how to do this. Here's the code I wrote:

import refinitiv.dataplatform as rdp
import refinitiv.dataplatform.eikon as ek

ek.set_app_key('mykey')
ddf = rdp.
df = rdp.search(

    view=rdp.SearchViews.FixedIncomeInstruments,

    filter="IsGreenBond eq false",

    select='Name, DocumentTitle, RIC, ISIN, AssetTypeDescription, MaturityDate, FaceOutstandingUSD, TrancheAmount, CouponClass, Currency, IssueDate, SeniorityTypeDescription, MaturityCorpModDuration, MaturityCorpYield, Price, SectorDescription',
    top=20000,
)

print(df)

I find out that there's a method from the refinitiv API that allows to do this, but only for the first (top) 10000.

score 0 · Answer 1 · answered Jul 28 '23 at 13:33

Please note that there's a Q&A Forum specifically for refinitiv and LSEG APIs.

But to answer your question: you'll have to narrow down your search into buckets, say per country, and put it in a loop. The following articles will help you find out how:

With that said, I think that maybe screener might be the better tool to use here?

If you need more help, please do not hesitate to ask in the Q&A Forum.

Retrieve more than 10000 rows from refinitiv workspace

1 Answers1