📈 ASX Options Analytics – Full Dashboard Overview
A 20-Year View of Australia’s Options Market
Welcome to your one-stop hub for exploring historical ASX options data. This multi-page Power BI report offers a deep dive into market trends, sectoral movements, and trading behavior across nearly two decades.
🧹 Data Source & Preparation:
All data was collected from the ASX website, then meticulously cleaned, categorised by industry, and enriched for analysis. Sector classifications allow for meaningful comparisons and easier filtering across time.
🧭 What’s on Offer:
🟦 Page 1 – Total Option Volume
Track the total contracts traded over time, sliced by sector and across nearly 20 years of ASX trading history. Use chiclet slicers and interactive timelines to pinpoint periods of activity.
Visualize relative sector contributions with a 100% stacked view.
🟨 Page 2 – Notional Traded
This view shifts focus to dollar value, not just contract count. Use the same intuitive slicers and timeline navigation to track big-money movements over time.
🟩 Page 3 – Open Positions
Explore open interest across sectors and months — see where investors continue to hold exposure and how positioning has evolved. A stacked view and time filters make it easy to contrast activity through time.
📊 Pages 4–6 – Leaderboards
Get a quick snapshot of:
🔼 Most traded sectors and stocks by volume
💰 Top sectors and stocks by notional value traded
📌 Open interest by sector and stock
🔍 What You’ll Discover:
The sharp rise in XJO index options over time — now dominating volume
The decline of single stock options, reflecting changing hedging behavior
How some sectors (like Financials and Materials) remain core players
Periods of market stress (e.g. 2008–09, COVID era) visible in trading volumes and open positions
📌 Built in Power BI, this dashboard uses:
Power Query for data import and transformation
Custom visuals and chiclet slicers for intuitive filtering
Bookmarks and toggles to shift perspectives
A sleek, responsive layout for interactive exploration
Whether you’re a trader, analyst, or just curious — this platform lets you explore how Australia’s options market has evolved.
