Serving the Quantitative Finance Community

 
User avatar
traderdeluxe
Topic Author
Posts: 0
Joined: February 2nd, 2009, 1:28 am

Tick data without milliseconds

February 25th, 2009, 11:43 pm

I am working on writing a historical intraday high frequency trade simulator, and I have encountered so far a couple of tick data sources that provide tick-level detail, but the timestamp is granular only down to the second. Am I missing something, or isn't it also necessary to have milliseconds to fully simulate what happened? Or is it that in practice that level of detail doesn't matter?
 
User avatar
tu160
Posts: 0
Joined: October 23rd, 2007, 1:14 pm

Tick data without milliseconds

February 26th, 2009, 3:07 am

Last edited by tu160 on December 9th, 2011, 11:00 pm, edited 1 time in total.
 
User avatar
traderdeluxe
Topic Author
Posts: 0
Joined: February 2nd, 2009, 1:28 am

Tick data without milliseconds

February 26th, 2009, 4:51 am

Trading long/short equity portfolios and equity market making.
 
User avatar
tu160
Posts: 0
Joined: October 23rd, 2007, 1:14 pm

Tick data without milliseconds

February 26th, 2009, 3:29 pm

Last edited by tu160 on December 9th, 2011, 11:00 pm, edited 1 time in total.
 
User avatar
Deve10per
Posts: 0
Joined: February 27th, 2008, 1:57 pm

Tick data without milliseconds

February 27th, 2009, 11:30 am

True in that the timestamps will match your prod systems but how do you deal with outages and backfilling should you need to? Those timestamps are unique to you...with regard to "but the timestamp is granular only down to the second" This depends on the market. Few markets have sequence numbers. Many do not. Hence without an accurate time stamp to understand the sequence of events, it could be difficult to understand the order of the ticks. Even if you are trading one instrument, the tricky part if cross comparing the instrument across multiple exchanges if there is no time stamp sync between exchanges. An example of this would be ADRs as compared to the issue.
 
User avatar
tu160
Posts: 0
Joined: October 23rd, 2007, 1:14 pm

Tick data without milliseconds

February 27th, 2009, 4:33 pm

Last edited by tu160 on December 9th, 2011, 11:00 pm, edited 1 time in total.
 
User avatar
quantumar
Posts: 1
Joined: March 26th, 2005, 10:26 am

Tick data without milliseconds

February 28th, 2009, 2:31 am

You may get how many milliseconds have passed since midnight from where the exchange is located as a time stamp that comes with data in equities. Once you have your internal time stamps added to the data table, the difference between your time stamp and the exchange/broker time stamp will be very stable. If your data is missing then you can use that timestamp difference to add outside data into your system.
 
User avatar
traderdeluxe
Topic Author
Posts: 0
Joined: February 2nd, 2009, 1:28 am

Tick data without milliseconds

February 28th, 2009, 2:34 am

What are some tick data capture tools out there? Is there anything that won't break the bank? Or is this pretty much a build-it-yourself kind of system?
 
User avatar
quantumar
Posts: 1
Joined: March 26th, 2005, 10:26 am

Tick data without milliseconds

February 28th, 2009, 2:43 am

You won't find tick capturing programs by themselves, they come with tick capturing solutions with tick databases which start from roughly $100,000.You can buy tick data say 6 months of all US Equities for $6,000 or buy 100 symbols for a $1,000. Easiest and cheapest way to go with it is to write a tick capture program and save data into flat files but you need lots of space and compression to store that data. Your daily all US equity tick data is around 150GB a day.One place you can use to get historical and real-time tick data is opentick, but they don't accept new users anymore. Also recently NYSE and ARCA have reduced their prices significantly that getting data from exchange became much cheaper than getting data from another data vendor. Cheapest solution is to write your own tick capturing program that collects data directly from the exchange.
Last edited by quantumar on February 27th, 2009, 11:00 pm, edited 1 time in total.
 
User avatar
traderdeluxe
Topic Author
Posts: 0
Joined: February 2nd, 2009, 1:28 am

Tick data without milliseconds

February 28th, 2009, 2:50 am

Which vendors would you recommend to check out?One of my issues is that some of the data I seek is in emerging markets. So far I have yet to encounter a vendor that provides that at all. So it pretty much seems that I would need to do my own capture. Luckily, the volume of data should be much smaller.
 
User avatar
quantumar
Posts: 1
Joined: March 26th, 2005, 10:26 am

Tick data without milliseconds

February 28th, 2009, 2:58 am

I don't deal with emerging markets so I don't know much about it but I know that Reuters has data for emerging equity markets but it might be expensive. I would contact the exchanges in those countries directly to get more information.
Last edited by quantumar on February 27th, 2009, 11:00 pm, edited 1 time in total.
 
User avatar
tu160
Posts: 0
Joined: October 23rd, 2007, 1:14 pm

Tick data without milliseconds

February 28th, 2009, 6:11 pm

Last edited by tu160 on December 9th, 2011, 11:00 pm, edited 1 time in total.
 
User avatar
naifwonder
Posts: 0
Joined: July 8th, 2008, 3:04 am

Tick data without milliseconds

March 7th, 2009, 6:18 am

tick data with milliseconds.. they should have what you are looking for:http://about.reuters.com/productinfo/tickhistory/