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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles


32 8 5 5

How do I constrain my ek.get_data() request to specific dates under the variable 'TR.RNSAnnouncedDate'?

I use the following code to download a csv of the previous 1 year's data for the instruments in my list and for the fields specified. My understanding is that using this method I am retrieving all of the data (unconstrained by dates) and then modifying that data so that a subset, constrained by 'TR.RNSAnnouncedDate', is downloaded as a csv. Is there a way I can only download the data for the previous year to make the request more efficient? In other words, can I apply a date parameter for 'TR.RNSAnnouncedDate' in my initial retreival?

The code:

#import packages

import eikon as ek # the Eikon Python wrapper package

import pandas as pd

import numpy as np

import datetime

from datetime import timedelta, date, datetime

from pandas.tseries.offsets import BDay

#connects to Bill's Eikon terminal


#retreive the RICs from Eikon

df_rics,e = ek.get_data("lists('Inv Trust List')","TR.RIC")

#convert that into a list and set as an object

ric_list = df_rics['Instrument'].tolist()

#Slice, loop and concatonate the retreival request - must be done in order to avoid a backend request timeout which

#happens when we use too many RICs. n can be toggled below.

n = 50

df = pd.DataFrame()

for ric_chunk in [ric_list[i:i + n]

for i in range(0, len(ric_list), n)]:

tmp_df, e = ek.get_data(ric_chunk,










df = tmp_df.append(df)

#set the dates for the csv file we wish to download

end_date =

start_date = end_date - timedelta(days=365)

end_date_str = datetime.strftime(end_date, "%Y-%m-%d")

start_date_str = datetime.strftime(start_date, "%Y-%m-%d")

df['RNS Announced Date'] = pd.to_datetime(df['RNS Announced Date'])

mask = (df['RNS Announced Date'] > start_date_str) & (df['RNS Announced Date'] <= end_date_str)

df = df.loc[mask]

df.rename(columns={'RNS AR Price (at Transaction) - £': 'RNS AR Price (at Transaction) GBP',

'RNS AR Market Value of Transaction - £': 'RNS AR Market Value of Transaction - GBP'},


#create file name and export as CSV

todays_date =

todays_date_str = datetime.strftime(todays_date, "%Y%m%d")

df.to_csv('Daily API Download_' + todays_date_str + '.csv')

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.

1 Answer

· Write an Answer
18.1k 21 13 21

Hi @bill39

In the general case, you can use "Data Item Browser" to check field supported parameters.

For example, I am checking TR.TURNOVER field to see any support parameters, or whether it supports timeseries, etc...

From this information, I could retrieve the data in several ways.

However, in this case, the TR.RNSAnnouncedDate does not show up on the "Data Item Browser"

So you have to contact Refinitiv Content Helpdesk ( to clarify what parameters are supported by this field. This is a content question and the moderators on this forum are not content experts.

ahs1.png (70.4 KiB)
7016-ahs.png (82.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.

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.