Chinese Stock Screen Criteria and a Missing SQL Column Error

Summary

The post contains a proposed Chinese stock screen built from financial, valuation, price-action, and intraday-style indicators. Its filters include market-cap and asset thresholds, revenue growth and return on equity conditions, turnover and price-change constraints, and a MACD relationship. It also attempts to calculate shifted closing prices and MACD values from daily price history, then combine those measures into a final selection mask.

The reported failure occurs before the filtering stage: the SQL query requests a total-assets field from a financial-indicators table that does not contain a column by that name. The post provides the database binder error but does not resolve it or verify the rest of the script. Several filters also appear inconsistently mapped to financial quantities, and the requested history may not include enough prior observations for shifted prices or MACD calculations. As presented, this is an unvalidated screening proposal and an unresolved query error, not a tested strategy or evidence of investment performance.

Key ideas

• The proposed screen combines financial statement measures, valuation data, price changes, turnover, and MACD conditions.
• The immediate query error reports that the joined financial table lacks the requested total-assets column.
• The SQL failure prevents the displayed workflow from reaching its filtering and output steps.
• The post does not provide a fix, validation, or performance results.
• Historical lookback and the mapping of financial fields to screening rules require independent verification.

Tags

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