Can you convert market tick data to bars?

Learn the Secret

Get  our 2 Free Books

Get these now which land directly to their inbox.
Invalid email address
(Last Updated On: April 24, 2015)

Can you convert market tick data  to bars?

After the presentation by Dr Ernie Chan, I wonder if this was possible based on other conversations I have had with other people:

Here is how it played out:


Do you know of any simple calculation you know of to convert tick data minute bars?

Nowadays I typically let my partner handle the tick data processing.
But this generally requires a loop which keep track of the tick values and the time elapsed. Whenever the elapsed time reaches or exceeds the duration of a bar, you save the latest tick into an array, and reset the elapsed time to zero.
This of course assumes that the tick appear in time order. If not, it can get complicated.
I always thought there was some sort of average or mid point you needed to calculate among the ticks to create the bar. That was the info I was looking for.
If your ticks are trades, then there is no midpoint or average to compute. If your ticks are bid or ask quotes, then you have to find out whether it replaces the BBO quotes. A binary search tree would be useful here. But it depends on exactly what your tick data is: every quote, or just the BBO updates.

In no cases should you use average or midpoint.
NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
This entry was posted in Quant Analytics and tagged , , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at