Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
23 1 1 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

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

Hello @gabriel.manceau

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,


AHS


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 512.0 KiB each and 1.0 MiB total.

Upvotes
18.2k 21 13 21

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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