Interview Question: Count the Trades

Sample Question #200 (statistics – regressions)

What’s the right statistical (or econometric) model when the dependent variable is the number of trades in a given stock in a 5-minute period? For example, if a total of 5,000 trades were executed in MSFT this morning between 9:30 and 9:35, the dependent variable takes on the value of 5,000. Our dataset contains such counts for many stocks over many 5-minute periods. (Don’t worry about the right-hand side variables — you can imagine they’re already taken care of.)

(Comment: this is a very real-world modeling problem)

Advertisements
This entry was posted in Sample Qs. Bookmark the permalink.

One Response to Interview Question: Count the Trades

  1. Brett says:

    ANSWER
     
    It turns out that this is a very tricky question!
     
    The correct model to use does depend on what goes on the right-hand side. If the RHS variables (indpendent variables) have an influence on whether a stock has any trade at all in a 5-minute time window, then we need to use a censoring model for count data. This is so because when we see 0 in the dependent variable, that’s because the independent variables have a "latent" effect on this value.
     
    If, on the other hand, the RHS variables are purely random and do not in any way influence whether the LHS value is 0 or not, we can use a truncated model for count data.  It’s truncated because the count cannot be below 0.
     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s