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
1 0 0 0

How can I get 'USDUNH' index value for '.MERHPC0'?

I would like to get the data within the red frame in the image below.

1695373157524.png


The code below got the same value.The parameter 'Curn' didn't seem to work.


1695373338506.png

eikon-data-api#content
1695373157524.png (73.6 KiB)
1695373338506.png (23.0 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
Accepted
80.1k 257 52 75

@n-shinagawa1

Thank you for reaching out to us.

That value is from the MID_PRICE field.

1695378486961.png

You can hover your mouse over a value to see a field name that provide that value. The field name of that value is MID_PRICE. Therefore, the code will be:

df, err = ek.get_data(".MERHPC0","MID_PRICE")
df

1695378615451.png



1695378486961.png (36.5 KiB)
1695378615451.png (3.3 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
1 0 0 0

Thank you for your response.

I was able to get it using the method you taught me.

Is there a way to get the same value as MID_PRICE in time series?

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
80.1k 257 52 75

@n-shinagawa1

You can try the Refinitiv Data Library for Python with the desktop.workspace session. The examples are on GitHub. This library also supports the get_data method.

The field could be USD_TRTN. The code is:

rd.get_history(universe=[".MERHPC0"], interval="daily",fields=["USD_TRTN"])

The output is:

1695804770923.png

If you don't specify fields, the output will contain all available fields.

You may need to contact the Elektron Data Platform - Historical Pricing API support team directly via MyRefinitiv to confirm this USD_TRTN field.


1695804770923.png (35.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.