Pulling TR.CLOSEPRICE weekly

Question

Question by nathan.quinn · Jan 27 at 02:02 PM · eikon eikon-data-api workspace workspace-data-api refinitiv-dataplatform-eikon python error pricing

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.

1611756089044.png (109.5 KiB)

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2021-01-27T15:07:17Z

REFINITIV

Best Answer

Answer by marcin.bunkowski · Jan 27 at 03:07 PM

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")

0 Show 2 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nathan.quinn · Jan 27 at 03:52 PM 0

Share

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.

REFINITIV

marcin.bunkowski nathan.quinn · Jan 29 at 09:11 AM 0

Share

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

Pulling TR.CLOSEPRICE weekly

1 Reply

Watch this question

Related Questions