Defining Your Edge
Clarify what advantage you seek: lower fees, steadier dividends, stronger momentum, or diversified factor exposure. We craft a crisp one-sentence thesis, specify acceptable trade-offs, and set outcome metrics upfront, so every later filter either strengthens conviction, challenges assumptions, or gets retired without drama.
Choosing Data That Matters
Not every datapoint deserves a seat. We prioritize liquidity, average spread, assets under management, expense ratio, tracking difference, holdings concentration, and rebalancing cadence. By ranking sources and timestamping inputs, we reduce stale noise, prevent survivorship bias, and anchor results in evidence you can audit and explain.
Metrics That Actually Move Portfolios
Custom metrics unlock nuance no canned screener can match. We blend expense ratios with realized spreads, track dividend reliability with rolling growth volatility, score factor tilts using exposures, and estimate overlap across holdings to avoid hidden concentration. You will shape weights to your mandate, compare outcomes side by side, and document decisions that survive future you.
Liquidity, Costs, And Slippage
Screen for average daily dollar volume, effective spread percentiles, and depth around the inside quote. Pair that with expense ratio tiers and creation–redemption frictions. The goal is realistic execution assumptions, fewer regretful fills, and an honest understanding of what it truly costs to own positions.
Quality Behind The Ticker
Evaluate index methodology, reconstitution rules, and sector caps. For stocks, add earnings quality checks, accruals, and debt service coverage. For ETFs, inspect securities lending policies and sampling error. Intelligent quality filters help avoid optical bargains that crumble when cash flows tighten or volatility suddenly expands.
Hands-On Workshop Flow
Using a small universe, you will set a few decisive rules, run results, and reflect aloud. This short sprint builds momentum, reveals gaps in definitions, and proves that progress arrives faster when constraints are explicit, documented, and politely enforced by your own workflow.
We translate a factor idea into clean signals, define entry and exit discipline, and test robustness across regimes. Expect heatmaps, rolling windows, and walk-forward splits that keep you honest, highlight fragility, and inspire smarter revisions instead of seductive overfitting.
When a screen returns nonsense, we trace lineage, check units, and inspect winsorization. You will learn to diagnose look-ahead bias, reconcile holiday gaps, and patch survivorship issues, transforming frustration into a reliable troubleshooting ritual you can repeat under pressure.
Real Stories From The Trading Desk
Experience matters. Hear how a low expense ratio paired with tight spreads rescued a rebalancing day, or how overlap analysis prevented doubling exposure to semiconductors. These lived moments make ideas sticky, turn checklists into muscle memory, and remind us that practicality beats elegance when money is real.
The Day A Tiny Fee Saved Thousands
A pension committee planned to rotate into a glossy new fund. Our screen flagged identical exposure at half the fee and better liquidity. Over five years, those basis points compounded into scholarships, not slippage, and everyone finally respected boring math with grateful smiles.
Catching The Hidden Tracking Error
A seemingly perfect index fund kept lagging quietly. We traced sampling drift, thin constituents, and reconstitution timing. Adjusted screens caught the pattern early, avoided disappointment, and reshaped our conviction around replication methods that actually match indices when markets lurch sideways for months.
When Simplicity Beat Complexity
A complex multi-factor recipe dazzled in backtests but disintegrated live. A simpler, liquidity-first screen with broad diversification proved sturdier during stressed spreads and holiday gaps. The lesson: fewer moving parts, clearer intent, and ruthless documentation keep portfolios upright when the seas turn hostile.
Tools, Data Sources, And Automation
Whether you prefer spreadsheets or code, we help you build durable pipelines. We compare vendor data, validate fields against filings, and automate refreshes. Expect practical guidance on API limits, caching, reproducible notebooks, and dashboards that highlight risks rather than flatter your confirmation bias.
APIs And Pipes You Can Trust
We walk through rate limits, retries, schema changes, and logging. You will tag each dataset with provenance, units, and transformations, then schedule checks that alert calmly before failures cascade. Reliability frees attention for judgment rather than babysitting brittle, late-night scrapes.
Spreadsheet Power Without The Spaghetti
We harness named ranges, structured references, and disciplined documentation to prevent creeping chaos. With version control and input validation, your workbook becomes a transparent calculator rather than a rumor mill. The result is speed plus clarity, even when handoffs and audits appear suddenly.
Ethics, Risk, And Real-World Constraints
Great screens respect constraints. We discuss suitability, liquidity during stress, tax considerations, data licensing, and compliance boundaries. Through case studies, you will practice saying no, documenting rationale, and choosing patience over impulse, protecting clients, careers, and reputations when incentives whisper otherwise and shortcuts feel tempting.
Biases That Sneak Into Every Backtest
We expose look-ahead, survivorship, and selection biases with vivid, reproducible examples. You will build protections like timestamped joins, delisted constituents, and embargo windows. Honest methods feel slower, yet they save portfolios from seductive mirages that vanish the moment live capital arrives.
Designing For Friction And Capacity
We estimate impact using turnover, average daily volume ratios, and spread regimes. You will practice scaling in, capping position sizes, and modeling cash drag, understanding when a gorgeous idea cannot carry real dollars without bending, breaking, or disturbing the market you admire.
Setting Expectations Like A Pro
Performance is a distribution, not a promise. We teach forward-looking ranges, transparent caveats, and review cadences. Clients and teammates learn what success and failure look like, reducing surprise and building trust, especially when screens underperform during inevitable regime shifts or liquidity droughts.
All Rights Reserved.