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
valstar avatar image
176 ●2 ●1 ●5

Retrieve last quotes from PRK-NGS-PIC

Using the Eikon API, how to retrieve the history (say 3 months) of last quotes from a RIC (for example PRK-NGS-PIC) when last quote is NOT the default field. In the snapshot you see that 'total market volume' is the default. So when i perform a get_timeseries call it gives me only that. get_date also doesnt work because the DIM (data item browser) doesnt have any fields related to timeseries. However, it must be possible, because in the snapshot you see that I can retrieve the prices in the eikon user interface when going to the chart. I have already tried 50+ different api calls with get_timeseries and get_data. Please get it working before posting an answer.

eikon.png

api
eikon.png (114.4 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.

zoya faberov avatar image   zoya faberov

Hello @valstar ,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

2 Answers

· Write an Answer
Upvote
Accepted
umer.nalla avatar image
25.3k ●87 ●12 ●25

Hi @valstar

Using the Eikon DATA API get_timeseries only returns daily Volume.

However, if I use the RDP library I can get a daily price as well (the following code snippet in Codebook)

import refinitiv.dataplatform as rdp
rdp.open_desktop_session('DEFAULT_CODE_BOOK_APP_KEY')
rdp.get_historical_price_summaries('PRK-NGS-PIC')

returns:

1642091003624.png


As mentioned previously, if this is not the price points you require, please raise a content type ticket - to speak to a content specialist.


1642091003624.png (46.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
umer.nalla avatar image
25.3k ●87 ●12 ●25

Hi @valstar

Looking at the Qoute object for PRK-NGS-PIC, I can see that the last price 151.280 maps to the real-time feed field PRIMACT_1.

prk-ngs-pic.png


Also, looking at the DIB, the Eikon field CF_LAST corresponds to the last value on the chart.

dib-prk-ngs-pic.png

and with get_data():

df, err = ek.get_data(['PRK-NGS-PIC'], [ 'PRIMACT_1','CF_LAST'])
df
.....
Instrument    PRIMACT_1 CF_LAST
0PRK-NGS-PIC  151.28    151.28

If neither of the above is the field you are looking for then I recommend you create a Content Ticket on My.Refinitiv - the moderators on this forum are not content experts.



prk-ngs-pic.png (16.8 KiB)
dib-prk-ngs-pic.png (39.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.

valstar avatar image valstar

Both fields would be fine, but I want to get some history. even if I add {'SDate':'0D', 'EDate':'-3AM'} I only get that single value.


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.