Dates generated by get_timeseries function

Novotnyja

Hi,

i have problem with dates generated by get_timeseries function

The dates are in format -> year-month-day 00:00:00

If I do this command

ric_stoxx='.STOXX'

stoxx=ek.get_timeseries(ric_stoxx,fields='CLOSE', start_date='2020-01-03')

than the last date (today) is 2021-03-10 00:00:00

This date is not valid for the last day of that time series, because the last day has the latest value, and not value from 00:00:00. The other problem is that in this chart, the values looks really ugly

stoxx_differences=stoxx['CLOSE'].diff()

df = pd.DataFrame({

'Stoxx differences':stoxx_differences['2021-02-14':]

})

ax = df.plot.bar(stacked=True)

pyplot.tight_layout()

pyplot.gcf().set_size_inches(10, 6)

pyplot.axhline(y=0, color="maroon", linewidth=0.7)

pyplot.show()

Please how to repair it, for example how to change the labels to format year-month-day without 00:00:00 ?

Thank you very much

umer.nalla

Hi @Novotnyja

I am not a Python or Matplotlib expert - and there may better solutions - but the following works for me:

import matplotlib.pyplot as plt 

ric_stoxx='.STOXX'
stoxx=ek.get_timeseries(ric_stoxx,fields='CLOSE', start_date='2020-01-03')
stoxx_differences=stoxx['CLOSE'].diff()
df = pd.DataFrame({'Stoxx differences':stoxx_differences['2021-02-14':]})
df.index = pd.to_datetime(df.index).date
ax = df.plot.bar(stacked=True)
plt.tight_layout()
plt.gcf().set_size_inches(10, 6)
plt.axhline(y=0, color="maroon", linewidth=0.7)
plt.show()

The extra line being
df.index = pd.to_datetime(df.index).date

In terms of the last day being wrong, this is because you are probably seeing the current price since 2021-03-10 has not ended yet. I suspect the timestamp of 0:0:0 is superfluous for all days.

So, you could request data for one less day i.e.

stoxx=ek.get_timeseries(ric_stoxx,fields='CLOSE', start_date='2020-01-03', end_date='2021-03-09')

To be absolutely sure, about Content/data issues - you should raise a Content ticket with the Refinitiv Helpdesk -as the moderators on this forum are not generally Content experts.