1. The Data Architecture Challenge (Backtesting Foundation): To implement the Pilot Score and future backtesting features objectively, we had to move away from simple row-based reporting. We implemented a two-table architecture: separating the static Signal Event (when the trade was taken) from the dynamic Daily_OHLCV (the price reference). This separation allows us to query and calculate any holding-period return (5-day, 10-day, etc.) on demand without modifying the original signal data. This was crucial for objective performance tracking.
2. Pilot's Score Calculation & Core Inputs: The core of the new dialog is exposing the inputs used for the Pilot Score (currently being implemented). We display key metrics like Squeeze Momentum (SQZ: 20.36) and ADX State: ADX UP. The Pilot Score itself will be a weighted average where ADX trend strength and Multi-Timeframe EMA alignment carry the highest weight.
3. Multi-Timeframe Confluence (MTFA): The dialog clearly shows the MTFA snapshot: 1D: Bullish and 1W: Bullish are visible, while the 1H and 4H status are blurred for free users. This provides the technical evidence of our "Value Cliff"—you see the potential, but need Pro to confirm the short-term entry structure.
4. UI/UX and The Gating Strategy: The dialog is designed for rapid professional confirmation. For free users, we show the underlying inputs (EMA alignment, Trend continuation) but intentionally lock away the specific Trader Playbook, and the short-term confirmations (1H/4H) using blurring. This forces the serious trader to upgrade for high-conviction data.
What's Next: The primary focus this week is completing the backtesting integration, making the historical average return the next core metric displayed in the dialog.
The Technical Details / What We Solved:
1. The Data Architecture Challenge (Backtesting Foundation): To implement the Pilot Score and future backtesting features objectively, we had to move away from simple row-based reporting. We implemented a two-table architecture: separating the static Signal Event (when the trade was taken) from the dynamic Daily_OHLCV (the price reference). This separation allows us to query and calculate any holding-period return (5-day, 10-day, etc.) on demand without modifying the original signal data. This was crucial for objective performance tracking.
2. Pilot's Score Calculation & Core Inputs: The core of the new dialog is exposing the inputs used for the Pilot Score (currently being implemented). We display key metrics like Squeeze Momentum (SQZ: 20.36) and ADX State: ADX UP. The Pilot Score itself will be a weighted average where ADX trend strength and Multi-Timeframe EMA alignment carry the highest weight.
3. Multi-Timeframe Confluence (MTFA): The dialog clearly shows the MTFA snapshot: 1D: Bullish and 1W: Bullish are visible, while the 1H and 4H status are blurred for free users. This provides the technical evidence of our "Value Cliff"—you see the potential, but need Pro to confirm the short-term entry structure.
4. UI/UX and The Gating Strategy: The dialog is designed for rapid professional confirmation. For free users, we show the underlying inputs (EMA alignment, Trend continuation) but intentionally lock away the specific Trader Playbook, and the short-term confirmations (1H/4H) using blurring. This forces the serious trader to upgrade for high-conviction data.
What's Next: The primary focus this week is completing the backtesting integration, making the historical average return the next core metric displayed in the dialog.
Thanks for checking it out!