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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 1 0 0

Quote Historic Data AdvDecline

Hi. Im looking at the ticker ".AD.N" advance declines.

I can see the fields like VOLUME_ADV, VOLUME_DEC in the dataitem browser

Is it possible to get historic data for this? Seems I can only retrieve the last date.


I've tried:

df,err = ek.get_data('.AD.N',['VOLUME_ADV'],{'SDate':'2020-09-01','EDate':'2020-10-30'})

This only retrieves the latest day.


I've also tried:

df2 = ek.get_timeseries('.AD.N', fields='*',start_date='2020-09-01', end_date='2020-10-30', interval='daily')

This retrieves only the Volume difference (cant seem to find any other fields)


I would like historic data for fields like: 'VOLUME_DEC','ISSUES_DEC','ISSUES_ADV','VOLUME_ADV'


Thank you

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonpricing
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
18k 21 12 20

Hi @bchip

Per @jirapongse.phuriphanvichai's input.

You can use RDP Lib in Python.

1. Please install RDP Lib

pip install refinitiv.dataplatform

If you already have it installed, please update it to the latest version

pip install --upgrade refinitiv.dataplatform


2. You can follow this sample code:

import refinitiv.dataplatform as rdp
rdp.open_desktop_session('xxxx') # your valid app key

df = rdp.get_historical_price_summaries(
    universe = '.AD.N',
    interval = rdp.Intervals.DAILY,
    start = '20201001',
    end = '20201101',
    fields = ['ISSUES_ADV','ISSUES_DEC']
)

df.tail(10)


ahs.png (33.0 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 @bchip

The fields you are requesting data for, they do not support timeseries retrieval.

You can use Data Item Browser to check its supported parameters:



You can submit a ticket to Refinitiv Content Helpdesk to clarify if there is any fields carrying timeseries data on the fields you are interested in.

The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/

Please ask for the data field name(if any) so you can check them using "Data Item Browser" and with the API call.


ahs1.png (84.8 KiB)
ahs2.png (82.8 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
38.1k 71 35 53

@bchip

Otherwise, you can try Refinitiv Data Platform Libraries. The historical-pricing endpoint can return the following information.



1604292401672.png (64.2 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
5 1 0 0

Awesome, thanks so much for the responses!


I got this working

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