Extract announcement date of bond issuance in EKON API?

Question

Question by AleksandarPetreski · Feb 24 at 04:25 PM · api eikon bonds issuance date

Hi,

I am trying to extract the announcement date of new bond issuance.

I can see it on the screen, but I am not successful with extraction, although I am using the fields name from Quote app in Eikon:

fields=['TR.RIC','TR.FirstAnnouceDate','TR.AnnouceDate']

bonds, err = ek.get_data('list(LIST)',fields)

Thanks!

announcment-date.png (137.0 KiB)

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-02-24T17:08:22Z

Best Answer

Answer by chavalit.jintamalit · Feb 24 at 05:08 PM

Please note that you have a typo in your API call.

TR.FirstAnnounceDate (you missed an 'n')

This code works:

ahs.png (8.4 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2020-02-24T18:58:11Z

Answer by AleksandarPetreski · Feb 24 at 06:58 PM

Thanks!

Have lost 2 hours for such a trivial error :)

A

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2020-02-25T01:22:46Z

Answer by chavalit.jintamalit · Feb 25 at 01:22 AM

Quick tip: click on the small icon on the bottom left of DIB screen to copy the field formula to clipboard.

Cheers :)

ahs.png (101.0 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.