Industry and Market-Cap Neutralization of a Turnover Factor

Summary

The document presents a SQL example for constructing a turnover-related stock factor and neutralizing it for industry membership and company size. It calculates the logarithm of total market capitalization, a 20-day average of turnover, and a neutralized turnover field. The query joins stock factor data with industry-component data by date and instrument, filters for a specified date range in 2022, and limits the industry classification to the stated scheme.

This is a compact illustration of factor preprocessing: removing industry and size effects can help researchers compare stocks on a more like-for-like basis. However, the post is a request for correction and supplies no explanation of the neutralization function, model specification, or whether the query runs as written. It gives no output, validation, or investment results. Users would need to verify function argument order, data availability, missing-value handling, and the intended interpretation of the resulting residual before using it in research or portfolio construction.

Key ideas

• The query computes log market capitalization and a 20-day average turnover measure.
• It joins factor observations to industry classifications using date and instrument.
• It applies a neutralization operation using industry and market capitalization inputs.
• The example filters the data to a stated 2022 period and industry scheme.
• The document provides no query validation, factor results, or backtest evidence.

Tags

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.