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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
nathan.quinn avatar image
1 ●0 ●0 ●1

Pulling TR.CLOSEPRICE weekly

I'm trying to pull TR.CLOSEPRICE for a number of RICs on a weekly frequency. It works fine when on a daily frequency, but I need weekly as I'm getting a large history and it will take too long on daily, as well as the fact all my other variables are weekly.



As you can see Daily frequency works, while Weekly doesn't.



I've tested this on a number of RICs and a number of different weekly frequencies and date ranges and the same thing is happening. TR.PriceClose works on both frequencies but it does not work for old unlisted RICs (as per it's description) so I need to use TR.CLOSEPRICE.


Any help is greatly appreciated.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonerrorpricing
1611756089044.png (109.5 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.

1 Answer

Upvotes
Accepted
marcin.bunkowski avatar image
3.8k ●4 ●4 ●6

Hi @nathan.quinn

You can try this:

ek.get_timeseries(['PLD^F11'],'CLOSE', start_date = "1998-01-01", end_date = "2021-01-01", interval="weekly")
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.

nathan.quinn avatar image nathan.quinn

Thanks for the reply. Although get_timeseries works, I'm trying to pull many fields which you can't use get_timeseries for. Is there no way to get TR.CLOSEPRICE via get_data? All my other fields work with get_data but do not work with get_timeseries.

marcin.bunkowski avatar image marcin.bunkowski nathan.quinn

Hi @nathan.quinn I did follow up with the content team. I will keep you updated.

Click below to post an Idea Post Idea