Too many NaNs in time series data

renee.yao

Hi there

I am using eikon scripting API to download minute-by-minute data (such as open, close) for about 2000 US stocks. I was able to download the data OK, with commands like below:

ek.get_timeseries(chunk, fields=field, start_date=today, end_date=dt.datetime.utcnow(), interval='minute', corax='adjusted')

here 'chunk' is a list of 1000 RICs that corresponding to the US stocks of interest. However, the return data contain a lot of NaNs, even for stocks of high liquidity (such as 'AAPL.O'). For example, if the start time is 9:30 of a trading day, and the end time is 16:00 of the same day, most of the data before 15:00 are NaN.

Am I doing something wrong, such as passing too many RICs (1000 in current) case?

Thanks!

pf

Hi,

The TimeSeries response is limited to 3000 points, all values that are out of this limit are set to NaN.

If you want to stay under this limit (and avoid NaN values), you should decrease the RIC list and/or define a lower range of date.