Why does RHistory not return any US data in the last trading hour during summer time in 2019?

sdittmar
sdittmar Explorer
in Eikon Data APIs

The following RHistory request does not return any data in the last trading hour up until the change from summer time to winter time on Nov 3, 2019. It looks like some bug related to a time zone conversion or aggregation of data. Please also see my other bug report under Bug in Excel RHistory interface. Maybe both are related.

This is a code snippet for replication:

=RHistory("AAPL.O","TRDPRC_1.Timestamp;"&"TRDPRC_1.Open;"&"TRDPRC_1.High;"&"TRDPRC_1.Low;"&"TRDPRC_1.Close;"&"TRDPRC_1.Volume","START:31-Oct-2019:01:00 END:04-Nov-2019:23:00 TIMEZONE:NYC TRADETIME:YES INTERVAL:30M",,"TSREPEAT:NO CH:Fd")

image

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @sdittmar

    RHistory is part of Eikon Excel product.

    You can report this issue to Refinitiv Helpdesk.

    The Refinitiv Helpdesk can be reached using Contact Us capability in your Eikon application.
    Or by calling the Helpdesk number in your country.
    Or at https://my.refinitiv.com/


Categories