KooCapital – Live Course
WD Gann Mastery Course
with Excel VBA & NSE Live Data
Master Time & Price Analysis, Gann Angles, Square of Nine and Market Technique with live practical training – all built in Excel.
WD Gann is one of the most powerful and least understood methods in market analysis. Most traders have heard of Gann theory but very few have ever learned it correctly – and even fewer know how to apply it using modern tools like Microsoft Excel and VBA automation.
At KooCapital we have built a complete WD Gann Mastery Course that teaches the entire Gann system from scratch using Excel formulas, VBA functions and live NSE market data – making it the most practical Gann course available in India today.
What Is the WD Gann Mastery Course?
The WD Gann Mastery Course is a 5-hour live 1-on-1 online training programme taught personally by Ajit Kumar – a WD Gann expert and Excel VBA specialist with over 10 years of market experience.
This is not a group class and not a pre-recorded video. Every session is conducted live with you personally, tailored to your own stocks and trading style, and scheduled at a time that suits you completely.
The course covers the complete Gann system – all implemented directly in Microsoft Excel using formulas and VBA automation so every concept is instantly clear and immediately usable.
What You Will Learn
Price Square in Excel
Square root any price, add or subtract fractions, resquare – instantly get exact support, resistance and vibration levels for any NSE stock using a simple Excel formula.
Time Square in Excel
Apply square root mathematics to time to predict future reversal dates weeks ahead. Fully automated in Excel with a VBA function – one input gives you the turning point date.
Square of Nine – Full Excel Build
Complete Square of Nine spiral grid built in Excel. Enter any price and get cardinal cross targets, diagonal vibration levels and degree conversions automatically.
Gann Angles with Excel Scaling
Calculate all major Gann Angles (1×1, 2×1, 1×2) using Excel coordinate formulas. Draw and use them as mathematically precise dynamic support and resistance on any chart.
NSE Live Data in Excel
Pull live NSE market prices directly into your Gann Excel sheet. All levels, angles and time targets update in real time every session – zero manual entry required.
Level Square
Square key price numbers to find hidden support and resistance zones that only Gann trained traders can identify – invisible to all conventional technical analysis tools.
Predict Up and Down Move Points
Spot exact time-price intersections where strong moves start – confirmed across Price Square, Time Square and Gann Angles simultaneously in Excel.
Excel VBA Automation
Every concept is automated with custom VBA functions. Enter a price or date and calculations appear instantly. All tools and workbooks are provided and yours to keep forever.
Master the Power to Predict Markets
Turn complex Gann geometry into clear, actionable predictions. After completing this course you will have eight powerful prediction abilities that give you an edge no conventional analyst possesses.
Course Details
| Format | Live 1-on-1 online training with Ajit Kumar personally |
| Duration | 5 hours total, scheduled at your convenience |
| Language | English with Hindi explanations wherever needed |
| Recording | Full session recording provided after every session |
| Tools Included | Custom Excel VBA workbooks and tools – yours to keep forever |
| Support | Post course WhatsApp support for follow up doubts |
| Markets | NSE stocks, Nifty, BankNifty, Forex, commodities, crypto |
| Course Fee | ₹85,000 – One time, all inclusive |
About Your Instructor – Ajit Kumar
Ajit Kumar is a WD Gann researcher, trader and educator who has spent over 10 years decoding Gann’s original methods into a practical, repeatable trading system built entirely in Excel.
His unique advantage is combining deep Gann knowledge with Excel VBA mastery – making him one of the very few Gann teachers in India who can show you not just the theory but the complete automated Excel implementation that works every trading day.
What Traders and Learners Say
“The Excel VBA tool for Square of Nine is incredible. I enter a price and all my Gann levels appear instantly. I will never go back to manual calculation.”
Rahul Mehta 🇮🇳 Swing Trader, Mumbai“Learning to pull NSE live data into my Gann Excel sheet was a game changer. My analysis is now fully automated and real time. Brilliant course.”
Neha Arora 🇮🇳 Intraday Trader, Delhi“The Time Square VBA function predicted the exact Nifty reversal date I was watching. The combination of Gann theory and Excel makes this course truly unique.”
Sanjay Verma 🇮🇳 Positional Trader, Pune“Two years of YouTube Gann videos did not help. One 1-on-1 Excel session with Ajit made everything click. Worth every rupee, 100 times over.”
Li Wei 🇸🇬 Forex Trader, SingaporeFrequently Asked Questions
Yes. The course is structured from beginner to advanced level. You need only basic awareness of stock markets and Excel. Ajit Kumar teaches step by step with live Excel demonstrations.
Yes. All 5 hours of live sessions are fully recorded and provided to you so you can review any formula, VBA function or chart demonstration as many times as you need.
All markets. Primary examples use NSE stocks and indices including Nifty and BankNifty. The same Excel formulas apply to Forex, commodities and cryptocurrency with no changes needed.
Microsoft Excel 2016 or newer with Windows recommended for full VBA support and any standard charting platform such as TradingView or Zerodha Kite. All VBA tools and workbooks are provided.
Yes. All enrolled learners receive post course WhatsApp support from Ajit Kumar for follow up questions on topics covered during the sessions.
Contact Ajit Kumar directly on WhatsApp at +91 96544 21288 or email koocapitals@gmail.com to confirm your seat, arrange payment and schedule your sessions at a time convenient for you.
Ready to Predict Markets With Excel Precision?
Traders and learners from India and worldwide now forecast time, price and turns using Gann in Excel. Get your complete automated system in 5 hours of live 1-on-1 training.
+91 96544 21288 | koocapitals@gmail.com
You must be logged in to post a comment.