Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

anybody know how to construct a intraday stock price from NASDAQ TotalView-ITCH data?

I would need to know the price in millisecond, so I would need two rows: timestamp (for every millisecond) and price (best bid/ask)

Thanks for any help!

share|improve this question

To construct best bid/ask from ITCH you must build a book incrementally from the messages in the data. Every message, except for system oriented messages, and non-displayed Trades, represent an order or an action on an order. Process the data, build a book, and you will naturally be left with the best bid/ask at the top of each side.

share|improve this answer

No choice to construct the book. Now the decision you have to make is for how many stocks you want to compute the bid-ask spreads and for how many days. You can use SAS but it is slow - so it may be fine for a few stocks on one day. Otherwise, Python is the best alternative (or C++).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.