question

Upvotes
Accepted
3 0 0 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 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
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 5.0 MiB each and 10.0 MiB total.

Upvotes
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 5.0 MiB each and 10.0 MiB total.

Upvotes
3 0 0 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 5.0 MiB each and 10.0 MiB total.

Upvotes
3 0 0 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 5.0 MiB each and 10.0 MiB total.

Upvotes
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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea