OPEN-SOURCE SCRIPT
Updated SPY / QQQ Reference Ladder (Cash Close Anchored)
Description:
This indicator overlays a dynamic reference ladder on futures charts by mapping SPY (for ES) and QQQ (for NQ) levels onto price.
The ladder is anchored using the previous regular trading hours (RTH) cash close:
• ES/MES → SPY
• NQ/MNQ → QQQ
A fixed ratio is calculated from the prior session close and remains constant throughout the trading day. This allows traders to view equivalent SPY or QQQ price levels directly on futures charts.
Key features:
• Fixed daily mapping based on prior RTH close
• Automatically detects ES or NQ charts
• Displays horizontal ladder levels aligned to futures price
• Labels positioned to the right for quick reference near the price ladder
• Fully customizable colors, spacing, and text size
• Optional display of ticker prefix (SPY / QQQ)
This tool is designed for traders who reference ETF levels while executing on futures, helping align decision-making across correlated instruments.
This indicator overlays a dynamic reference ladder on futures charts by mapping SPY (for ES) and QQQ (for NQ) levels onto price.
The ladder is anchored using the previous regular trading hours (RTH) cash close:
• ES/MES → SPY
• NQ/MNQ → QQQ
A fixed ratio is calculated from the prior session close and remains constant throughout the trading day. This allows traders to view equivalent SPY or QQQ price levels directly on futures charts.
Key features:
• Fixed daily mapping based on prior RTH close
• Automatically detects ES or NQ charts
• Displays horizontal ladder levels aligned to futures price
• Labels positioned to the right for quick reference near the price ladder
• Fully customizable colors, spacing, and text size
• Optional display of ticker prefix (SPY / QQQ)
This tool is designed for traders who reference ETF levels while executing on futures, helping align decision-making across correlated instruments.
Release Notes
Update v1.1:Improved label positioning using bar_index for consistent right-side extension.
No changes to calculation logic.
Release Notes
Added a top-right ratio box showing locked and live SPY↔ES / QQQ↔NQ ratios with previous closes for better level precision.Release Notes
Added more decimal to the table.Release Notes
Added decimal to tableRelease Notes
fix errorRelease Notes
updateRelease Notes
v2 — Visual Overhaul + Stability FixReplaced single line style with a 3-zone system: Center / Near / Far — each zone has its own color, width, opacity, and line style, all fully customizable in settings
All lines default to dotted, dark gray, 60% opacity for a clean look on dark charts without competing with price action
Center line toned down to match — subtle gray instead of bold white
Increased default levels from 12 to 15 above and below
Lines default longer (80 bars left, 50 bars right) so they anchor better across the visible chart
Added Extend Lines Left Infinitely toggle
Added Ratio Box position selector — move it to any corner
Fixed indicator disappearing on load — redraws on every real-time tick instead of only on the last bar, so it no longer requires removing and re-adding after other indicators load
Release Notes
Added Manual Close Override group with four individual price inputs (SPY, QQQ, ES, NQ). Enable the toggle and enter any close price manually — useful for using Yahoo Finance or other sources. Leave any field at 0 to keep auto-fetching that symbol. Switching charts retains all entered values.Release Notes
Added Manual Close Override group with four individual price inputs (SPY, QQQ, ES, NQ). Enable the toggle and enter any close price manually — useful for using Yahoo Finance or other sources. Leave any field at 0 to keep auto-fetching that symbol. Switching charts retains all entered values.Open-source script
In true TradingView spirit, the creator of this script has made it open-source, so that traders can review and verify its functionality. Kudos to the author! While you can use it for free, remember that republishing the code is subject to our House Rules.
Disclaimer
The information and publications are not meant to be, and do not constitute, financial, investment, trading, or other types of advice or recommendations supplied or endorsed by TradingView. Read more in the Terms of Use.
Open-source script
In true TradingView spirit, the creator of this script has made it open-source, so that traders can review and verify its functionality. Kudos to the author! While you can use it for free, remember that republishing the code is subject to our House Rules.
Disclaimer
The information and publications are not meant to be, and do not constitute, financial, investment, trading, or other types of advice or recommendations supplied or endorsed by TradingView. Read more in the Terms of Use.