For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
23 0 0 2

Can not get LOW auction price for US bonds auction (ex US3MINV=RR)

If I use the following fonction

rates = ek.get_timeseries(["US3MINV=RR"],

start_date=startDate.isoformat(),

end_date=endDate.isoformat(),

fields = ["LOW","HIGH"])

ek returns a NAN for "LOW" field. Only the high rate is returned.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
3.8k 4 4 6

Hi @gabriel.manceau

I think that you can get it using sample below:

ek.get_data('US1MINV=RR',['TR.HIGHYIELD.date','TR.HIGHYIELD','TR.LOWYIELD'], {"Sdate":'2019-09-30', "Edate":'2019-09-03'})

That matches the results available on <USAUCTION10> page


ahs.jpg (158.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
18k 21 12 20

Hi @gabriel.manceau

You can remove fields = ["LOW","HIGH"]) to get all available fields.

However, only CLOSE and HIGH fields are available for this RIC.

I also re-confirm using Eikon Excel to check CLOSE field.

It is an invalid field on this RIC.


ahs.png (40.8 KiB)
ahs1.png (73.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea