Using order_by to Rank Fundamental Stock Screen Results

Summary

The snippet demonstrates a fundamental stock screen built from valuation, income, growth, and profitability fields. It filters for a range of price-to-earnings values and minimum thresholds for earnings per share, net profit growth, and return on equity. The query then applies an ordering operation to sort qualifying records by weighted return on equity in descending order, before limiting the result set to 100 entries.

In this context, order_by determines the ranking of the rows returned by the query; descending order places higher return-on-equity values first. The example illustrates how a factor screen can prioritize candidates after applying eligibility filters. It does not explain the data provider's field definitions, update timing, or handling of missing values, and it provides no backtest or investment results. The displayed filter expression also appears to omit a separator between two conditions, so the snippet may need correction before it can run.

Key ideas

• The query filters stocks using valuation, earnings, growth, and return-on-equity conditions.
• The ordering operation ranks qualifying records by weighted return on equity.
• Descending order puts the highest values first before the result limit is applied.
• The snippet provides no evidence about the screen's historical performance.
• The displayed filter expression may contain a syntax issue that requires correction.

Tags

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