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

eikon.user2
eikon.user2
in Eikon Data APIs

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?

eikon.png

Tagged:

Best Answer

  • jonathan.legrand
    jonathan.legrand
    Answer ✓

    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:


    1627027264492.png


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

Answers

  • eikon.user2
    eikon.user2

    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?

  • eikon.user2
    eikon.user2

    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
    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.

  • eikon.user2
    eikon.user2

    Hi @jonathan.legrand,

    Thanks for the reply.

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


  • jonathan.legrand
    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.

  • eikon.user2
    eikon.user2

    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.

Categories