How can I get sale dates and par amounts of all municipal bonds issued in a certain period?

Hello,

I am trying to get all the data on municipal bonds sold between 01/01/2015 and 12/30/2020. I am particularly interested in the sale dates and par amounts of municipal bond issuances. I have tried the following code in Python:

df = rdp.Search.search(
view = rdp.SearchViews.MunicipalInstruments,
top = 10000,
select = "IssuerName, IssueDate, SaleDate, IssuerState, ParAmount, CUSIP")

I get the data on issuer name, issue date, and CUSIP. But, I received the following warning: "3 invalid 'select' entries were ignored: [SaleDate, IssuerState, ParAmount]"

I tried to use a CUSIP number in order to get sale date and par value using get_data() command but it returns empty data frame.

Would you please guide me on how I can get sales date and par amounts of all municipal bonds sold in a certain period?

moredata,e = ek.get_data(['494134XF1'],["TR.FiTaxStatus", "TR.PJFRelMuniSaleDate", "TR.PJFRelMuniPrinicipalAmount"])

If I have CUSIPs of all municipal bond issuances, is there any way to scrape the description page of the relevant municipal bond to get sale date and total program amount?

Find more posts tagged with

eikon

bonds

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

jonathan.legrand

Hi @eikon.user2 ,

Have you tired the Data Item Browser? I looked for the fields you were after there and found, for example, the following:

Do loet me know if that was (or wasn't) the datapoint you were after.

All comments

jonathan.legrand

Hi @eikon.user2 ,

Have you tired the Data Item Browser? I looked for the fields you were after there and found, for example, the following:

Do loet me know if that was (or wasn't) the datapoint you were after.

Hi,

Thank you very much for the reply.

I am looking for the sale date, total program amount, and Par amount. While the first two are available in the description page of the municipal bond and the third one is available through New Issues-Muni, it seems that they cannot be directly downloaded. So I am wondering whether I can scrape the description pages of municipal bonds?

Hi @jonathan.legrand,

Thank you very much for the reply.

I am looking for the sale date, total program amount, and Par amount. While the first two are available in the description page of the municipal bond and the third one is available through New Issues-Muni, it seems that they cannot be directly downloaded. So I am wondering whether I can scrape the description pages of municipal bonds?

jonathan.legrand

Hi @eikon.user2 ,

I am afraid that there is no way to scrape Eikon Desktop description pages. I would advise looking into the Data Item Browser. It seems as though the question is becoming a content one, in which case I would advise inquiring bout your request on the Refinitiv Helpdesk.

Hi @jonathan.legrand,

Thanks for the reply.

I have web access too. Can I scrape the description pages through web access?

jonathan.legrand

Hi @eikon.user2 ,

I'm afraid that there are no licences sold allowing users to do this legally... Thus the Python Eikon Data API.

Hi @jonathan.legrand,

Thanks for the reply.

I want to mention that the data item

TR.MUNIAnnouncementDate

gives the sale date of a municipal bond. Maybe other users find this useful.

However, I am still trying to find the data item that gives the total program amount mentioned in the description page of each municipal bond.

Thanks.

Quick Links