question

Upvotes
Accepted
dinos avatar image
3 ●1 ●2 ●6

Nulls and 0's in Tick History prices

to Stefanos, aleksandra.kluczniak, bruno.touma, prajesh.manglani

After running a report for chart pricing I have noticed that we receive bad fields (0 values, or null values)

here is an example of 0 values in pricing 

#RIC,Domain,Date-Time,GMT Offset,Type,Open Bid,High Bid,Low Bid,Close Bid,Open Ask,High Ask,Low Ask,Close Ask
AAPL.OQ,Market Price,2018-09-11T08:00:00.000000000Z,-4,Intraday 1Hour,0,0,0,0,219.25,219.25,218.98,219.25 
ADBE.OQ,Market Price,2013-10-05T00:00:00.000000000Z,-4,Intraday 1Hour,0,0,0,0,0,0,0,0 
ADBE.OQ,Market Price,2013-10-07T22:00:00.000000000Z,-4,Intraday 1Hour,50.48,50.48,0,0,0,0,0,0 
ADBE.OQ,Market Price,2013-10-08T21:00:00.000000000Z,-4,Intraday 1Hour,0,0,0,0,50.71,50.71,50.71,50.71 
ADBE.OQ,Market Price,2013-10-08T22:00:00.000000000Z,-4,Intraday 1Hour,0,0,0,0,0,0,0,0

here are examples of null pricing

#RIC,Domain,Date-Time,GMT Offset,Type,Open Bid,High Bid,Low Bid,Close Bid,Open Ask,High Ask,Low Ask,Close Ask
ESNT.L,Market Price,2015-12-03T18:00:00.000000000Z,+0,Intraday 1Hour,,,,,873.5,1050,873.5,1050 
ESNT.L,Market Price,2015-12-24T14:00:00.000000000Z,+0,Intraday 1Hour,808,808,808,808,,,,

I have 99 of 114 different RIC codes i tried that have this problem.I have a csv with more examples but the file upload limit here is too small. here is a link to the file https://transfer.sh/kyQHM/badprices.csv

tick-history-rest-apihistoricalzero-values
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.

Jirapongse avatar image   Jirapongse

@dinos

Hi,

Please let us know if we have any update on this question.

Have you contacted TRTH support team to verify the content?

Regards,

AHS

wasin.w avatar image   wasin.w

<AHS Only>

I have contact DSS_SWAT team (Thomson-DSS_SWAT@thomson.com) to help the client on this question. Extend triage for 1 week.

David Thomas avatar image   David Thomas

@dinos

Did the TRTH Support team resolve your query?

Regards

AHS

zoya faberov avatar image   zoya faberov

Hello @Wasin Waeosri,

Could you please provide an update?

Thanks!

zoya faberov avatar image   zoya faberov

Hello @dinos,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Show more comments

5 Answers

· Write an Answer
Upvotes
Accepted
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

@dinos,

Introductory caveat

I'm not a data or GUI specialist, what follows is only the result of my trying to find a logical explanation to what you observe. If you want a validated answer, you really need to talk to a data specialist, as suggested previously.

Intraday bars calculation

You are making an Intraday Summary request. The intraday bars are calculated by our servers, based on the pricing data received from the exchanges.

Exchanges do not necessarily publish data in the same format, especially when markets close or open. There are exchanges who publish prices with a value of 0, as a reset signal, to indicate market open / close - this seems to be the case for Nasdaq. Others will not publish values if there is no price - this seems to be the case for LSE.

0 values

I guess our servers calculate the bars every time they receive numerical values, so when they receive 0 values from Nasdaq they assume data values are present, and use them in the calculation, which delivers a value of 0 that you see for ADBE.OQ. at market close.

Empty values

As LSE does not publish 0 values, you get empty results instead of prices = 0.

TimebarPersistence

For Intraday Summary the parameter TimebarPersistence has an influence. If true it returns more lines (because it persists calculation results from the previous interval, to ensure you have bars for all intervals). If false it returns bars only for the periods where there was some actual data published by the exchange (which can include 0 values, either for bid or ask, or maybe even for both).

Conclusion

Empty values (null pricing) are normal. They simply indicate that there was no available data for that particular field, which can happen for different reasons (out of market hours, holiday, inactive instrument, etc.). In your examples it seems related to out of market hours data. They come in different flavors (empty of 0 values). Your code needs to handle these different cases.

Side note

There are user preference settings that influence how null values are returned in some specific cases, but they do not apply to Intraday Summaries. You will find them in the GUI:

Hope this helps, even if it comes a bit late.


nullpreferences.png (32.1 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.

Upvotes
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

@dinos,

This forum is for software developers using Thomson Reuters APIs, and technical discussions.

For precise data queries, please directly contact TRTH support team via Contact Us. In the product field, select Thomson Reuters Tick History v2.

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.

Upvotes
dinos avatar image
3 ●1 ●2 ●6

I was told to use this forum for this issue and to raise the ticket here

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.

Upvotes
dinos avatar image
3 ●1 ●2 ●6

@jirapongse.phuriphanvichai no, unfortunately there is no solution to this yet.

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.

Upvotes
Rick Weyrauch Too avatar image
106 ●1 ●2 ●1

I agree with Christiaan in that this is a question that should go direct to the TRTH Support team. I can pre-caution you that in addition to the resulting csv file, they will also need the Notes file that comes with every extraction as that will include the TRTH Job Id that they will need to investigate the issue.

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.