@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.

@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.

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

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

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.