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
James.Perkins avatar image
644 ●4 ●7 ●8

How can I retrieve the historical values for RIC .AD.US using either the Eikon Data API, or the Historical Pricing API in CodeBook?

For RIC .AD.US I am able to bring in current values using Eikon Data API and RDP,, but not historical... can you please guide on best way to bring in any of these fields historically... It seems they are available via Eikon Excel; but when I try using ek.get_data() I am only able to retrieve the most recent value; ek.get_timeseries() does provide a time series of total volume but nother else. I really need the number of Avancers and decliners historically.

When I try using rdp.HistoricalPricing.get_summaries('AD.US') I get "None" as an output.


df, err = ek.get_data(['.AD.US'], ['ISSUES_ADV','ISSUES_DEC','ISSUES_UNC',

'TOT_ISSUES','NEW_HIGHS','VOLUME_ADV',

'VOLUME_DEC','VOLUME_UNC','TOT_VOLUME','NEW_LOWS'])

df


eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apihistorical
capture.png (17.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.

2 Answers

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

Function layer of RDP Library is easier to use (but less flexible) than Content Layer. So, the easiest way to retrieve this data is to use the function layer of RDP Library:

rdp.get_historical_price_summaries('.AD.US')

The above function returns pandas dataframe.

This said, you should be able to use Content layer, if you wish. On my end I do not reproduce rdp.HistoricalPricing.get_summaries('.AD.US') returning None. It returns an object of type "refinitiv.dataplatform.content.data.historical_pricing.HistoricalPricing.HistoricalPricingResponse". To extract the payload from this object you need to utilize object's properties and methods. E.g. to get the same result you get from rdp.get_historical_price_summaries function you can use

res = rdp.HistoricalPricing.get_summaries('.AD.US')
res.data.df


screen-shot-2021-01-07-at-62743-pm.png (87.5 KiB)
screen-shot-2021-01-07-at-62838-pm.png (117.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.

Upvotes
nick.zincone avatar image
17.1k ●80 ●39 ●63

Hi @James.Perkins,

You can use the Historical Pricing API.

Try this example retrieving daily values in the month of Dec 2020.

rdp.get_historical_price_summaries(
         universe = '.AD.US',
         interval = rdp.Intervals.DAILY,
         start = '2020-12-01',
         end = '2020-12-31'
)


1610062078011.png (277.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.

James.Perkins avatar image James.Perkins

thank you Nick.

James.Perkins avatar image James.Perkins James.Perkins

thank you again for the answer; why do none of the above solutions seem to work for RIC .IBBEU003D ?

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.