Predict Markets Using
WD Gann Theory
in Excel
Master Time & Price Analysis, Gann Angles, Square of Nine and Market Technique with live practical training.
Learn the complete Gann system - Price Square, Time Square, Square of Nine & Gann Angles - all built with Excel formulas & VBA functions. Includes NSE live data. Step by step, easy to understand.
with Excel VBA & NSE Live Data
Excel VBA & NSE Live Data
Master the Power to
Predict Markets
Turn complex Gann geometry into clear, actionable predictions. Eight powerful abilities you will develop through this course.
Predict Next Big Moves
Spot early market vibrations and forecast turning points before they appear - giving you an edge no conventional analyst has.
Predict Price Not to Move
Recognize time-price balance zones where the market takes a rest - avoid false breakouts and time your trades precisely.
Predict Price Will Move Faster
Identify acceleration phases using time compression and Gann angles - enter early before the explosive move begins.
Learn 45° Concept
Understand the equilibrium between time and price using Gann's 45° rule - the single most powerful line on any chart.
Predict Up Move Points
Locate the key angles and cycles where bullish moves begin - buy with confidence at mathematically proven support zones.
Predict Down Move Points
Detect timing and resistance levels before market corrections start - exit or short before the crowd even notices.
Price More, Time Less
Identify overextended price moves where correction or pause is near - know exactly when a rally is running out of fuel.
Time More, Price Less
Spot long-duration consolidations that signal powerful upcoming moves - position ahead of the breakout before it happens.
Complete Gann System -
Built in Excel, Easy to Apply
Eight powerful skills, each implemented live in Excel so every concept is immediately clear and ready to use every trading day.
Price Square in Excel
Square root any price, add/subtract fractions, resquare - instantly get exact support, resistance and vibration levels for any NSE stock.
Excel FormulaTime Square in Excel
Apply square root mathematics to time to predict future reversal dates weeks ahead - automated in Excel with a single input.
VBA FunctionSquare of Nine - Excel Built
Full Square of Nine spiral grid in Excel. Enter any price and get cardinal cross targets, diagonal vibrations and degree levels automatically.
Excel + VBAGann Angles with Excel Scaling
Calculate all major Gann Angle coordinates (1×1, 2×1, 1×2…) in Excel - draw and use them with mathematical precision on any chart.
Excel FormulaNSE Live Data in Excel
Connect your Gann sheet to live NSE prices. Levels, angles and time targets update automatically - zero manual entry every session.
Excel + NSE FeedLevel Square
Square key price numbers to find hidden support and resistance zones that only Gann-trained traders can identify on any market.
Excel FormulaPredict Up & Down Move Points
Spot exact time–price intersections where strong moves start - confirmed across Price Square, Time Square and Gann Angles in Excel.
Applied GannEasy to Understand - Step by Step
Live Excel demos with real NSE charts and plain language. Ajit Yadav explains the "why" behind every formula so nothing is ever confusing.
1-on-1 Live5 Hours. Every Tool. In Excel.
A structured path from Gann foundations to a fully automated Excel trading system with live NSE data.
Foundation - Time, Price & Vibration
Gann's square root law, vibration theory, and why price and time are mathematically linked.
Price Squares & Level Squares
Calculate support, resistance and vibration levels for any NSE price using Excel square root formulas.
Time Squares - Predict Reversal Dates
Apply root mathematics to trading days to forecast future turning points weeks and months ahead.
Square of Nine - Full Excel Implementation
Build the spiral grid in Excel. Calculate degree conversions, cardinal cross and diagonal targets automatically.
Gann Angles - Correct Scaling & Application
Calculate all major Gann Angles in Excel, plot correctly on NSE charts and use as dynamic support/resistance.
NSE Live Data + Full Live Application
Connect Excel to NSE live prices. Apply everything to your own watchlist stocks in real time.
Ajit Yadav
A market researcher, trader and educator who has spent 10+ years making WD Gann Theory practical through Excel. Ajit's unique advantage is combining deep Gann knowledge with Excel VBA mastery - so every learner walks away with fully automated tools that work every trading day.
KooCapital was built on this philosophy - automating NSE stock market data using Excel for traders. Every formula and VBA function in this course is used by Ajit personally in his daily NSE analysis.
Real Feedback from Real Traders
Traders and learners across India and the world - all transformed by learning Gann in Excel.
"The Excel VBA tool for Square of Nine is incredible. I enter a price and all Gann levels appear instantly. Never going back to manual calculation."
"Learning to pull NSE live data into my Gann Excel sheet was a game changer. My analysis is fully automated and real-time. Brilliant course."
"Ajit sir explains every formula step by step. I understood Price Squares in Excel on the first session - no confusion at all. Exceptional."
"The Time Square VBA function predicted the exact Nifty reversal date I was watching. Gann + Excel makes this course truly unique."
"Two years of YouTube Gann videos didn't help. One 1-on-1 Excel session with Ajit made everything click. Worth every rupee, 100 times over."
"NSE live data integration in Excel was unexpected from a Gann course. It's the most practical trading education I've ever received."
"Level Squares in Excel show hidden resistance levels my entire trading group can't see. Unfair advantage - in the best possible way!"
"Gold futures Square of Nine levels hit with stunning accuracy. Ajit gave me the theory and the automated Excel tools. Life-changing."
"Very easy to understand as a Gann beginner. The step-by-step Excel approach makes learning stick. Recordings helped me revise everything."
"As a chartered accountant I love that the Gann system is built on mathematical Excel formulas. I've had this trading edge for two years."
"The Excel VBA tool for Square of Nine is incredible. I enter a price and all Gann levels appear instantly. Never going back to manual calculation."
"Learning to pull NSE live data into my Gann Excel sheet was a game changer. My analysis is fully automated and real-time. Brilliant course."
"Ajit sir explains every formula step by step. I understood Price Squares in Excel on the first session - no confusion at all. Exceptional."
"The Time Square VBA function predicted the exact Nifty reversal date I was watching. Gann + Excel makes this course truly unique."
"Two years of YouTube Gann videos didn't help. One 1-on-1 Excel session with Ajit made everything click. Worth every rupee, 100 times over."
"NSE live data integration in Excel was unexpected from a Gann course. It's the most practical trading education I've ever received."
"Level Squares in Excel show hidden resistance levels my entire trading group can't see. Unfair advantage - in the best possible way!"
"Gold futures Square of Nine levels hit with stunning accuracy. Ajit gave me the theory and the automated Excel tools. Life-changing."
"Very easy to understand as a Gann beginner. The step-by-step Excel approach makes learning stick. Recordings helped me revise everything."
"As a chartered accountant I love that the Gann system is built on mathematical Excel formulas. I've had this trading edge for two years."
Everything You Need.
One Investment. For Life.
No subscriptions, no upsells. One payment gives you the complete Gann-Excel system, live training and all tools - forever.
with Excel VBA
- 5 hours live 1-on-1 online training with Ajit Yadav
- All Gann concepts taught using Excel formulas - easy to follow
- Complete Square of Nine built in Excel with VBA automation
- Price Square, Time Square & Level Square - Excel automated
- All Gann Angles - correctly scaled using Excel calculations
- NSE live data integration in your personal Excel Gann sheet
- Custom VBA tools & Excel workbooks - yours to keep forever
- Full session recording - review any formula anytime
- Post-course WhatsApp support for follow-up doubts
- Works across NSE, Forex, commodities and crypto markets
+91 96544 21288 · koocapitals@gmail.com
Completely 1-on-1
Private live training tailored to your stocks, your schedule and your exact level - not a group class, not pre-recorded.
Tools You Keep Forever
Every VBA macro and Excel workbook from the course is yours. Use them every trading day for the rest of your career.
NSE Live Data Included
Most Gann courses ignore real-time data. This course teaches you to connect NSE live prices directly into your Gann sheet.
WhatsApp Support After Course
Post-course access to Ajit Yadav on WhatsApp for follow-up doubts - because learning doesn't stop when the session ends.
Predict Markets With
Excel Precision
Traders and learners from India and worldwide now forecast time, price & turns using Gann in Excel. Get your complete automated system in 5 hours of live 1-on-1 training.
Contact via WhatsApp - ₹85,000+91 96544 21288 · koocapitals@gmail.com