I queried for the fields Trade-Date and Quote-Date for time and sales data from TRTH. However the dates in these fields are just the timestamp fields and not the actual trade dates.
36
●2 ●5 ●7
Wrong data in Trade Date field
Hello @sgan208
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hello @sgan208
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
78.8k
●250 ●52 ●74
Refer Tick History Data Content Guide,Trade - Date and Quote - Date are local dates transmitted with the first on-market trade or quote message of the day, respectively.
The following is a result from time and sales extraction.
The Date-Time field at column D is timestamp. The Date field at column S is Quote - Date or Trade - Date.
If your result is different from this, please share your request and result.
Re: Trade - Date and Quote - Date are local dates transmitted with the first on-market trade or quote message of the day, respectively.
Can you please clarify "local dates"? Did you mean the local date where the exchange is located? If that's the case, can you please explain the following for me?
FBU is traded on the NZX, timezone GMT+12. Why is date-time stamp is 2021-07-02T11:03:53.897807187+12 (NZ time) but the trade date is 2021-07-01 (1 day before)? If trade date is supposed to be local, why is trade date not same as the date-time stamp?
The exchange time is still 23:03:54. However, please contact the Refinitiv Tick History support team directly via MyRefinitiv to clarify the definitions of those fields.
