Equities4Profit — Making Stock Market Analysis Accessible to Every Indian Investor
HOME - case studies - equities4profit nse stock analysis saas
Equities4Profit — Making Stock Market Analysis Accessible to Every Indian Investor
Industry
FinTech & Capital Markets
Region
India
Project Type
SaaS Product Build
Timeline
2020 – 2021
Platforms
Web (Laravel + Vue.js)
Client Overview
The product owner behind Equities4Profit is an experienced Indian equity investor who identified a fundamental gap in the retail investor market. India has hundreds of millions of potential stock market participants, yet the tools available to them fall into two unsatisfactory extremes: complex charting platforms that require years of technical analysis study, or advisory services that demand blind trust in third-party recommendations without transparency into the underlying logic.
The owner's insight was rooted in years of personal equity investing: most retail investors are not opposed to doing their own analysis — they simply lack a tool that makes that analysis fast, repeatable, and honest about risk. Most advisory platforms are optimized for upside and are silent on the downside, which is precisely the scenario that destroys retail investor confidence and capital. The owner had developed methodology over years of manual analysis — a way of using a stock's own historical price behavior as its benchmark, rather than comparing it to indices, peers, or arbitrary targets. TTPL was engaged to turn that methodology into a production-grade SaaS platform.
Challenges & Problem Statement
Building Equities4Profit required solving several interlocked business problems that the existing market had left unaddressed:
- The time barrier: India's retail investors are typically employed professionals with limited time. Existing analysis tools require 30–60 minutes of daily engagement per stock. The product needed to compress a full analysis into 5–10 minutes across an entire watchlist — without sacrificing accuracy.
- The knowledge barrier: Technical analysis (RSI, MACD, Bollinger Bands, Fibonacci retracements) has a steep learning curve. The platform needed to produce investment signals that any numerically literate person could interpret immediately — without chart-reading skills.
- The risk orientation gap: Most advisory services and analysis tools are oriented toward maximizing gain signals. The platform needed to be explicitly risk-first — designed for investors who would rather miss an opportunity than lose capital.
- The data access barrier: NSE publishes daily Bhavcopy data publicly, but processing it into a queryable, per-symbol historical OHLCV database requires infrastructure that no retail investor has the technical skill to build for themselves. The platform needed to do this automatically and reliably.
- The monetization model: The product needed a self-sustaining subscription model that worked for Indian investors — with a free tier for onboarding and a paid tier for full access — using PayPal as the primary payment gateway to support both domestic and international subscribers.
Project Overview
TTPL designed and delivered Equities4Profit as a full-stack SaaS platform built on Laravel 7 (PHP) with a Vue.js 2 + TypeScript frontend, a MySQL database, and PayPal Checkout SDK for subscription management. The platform consists of two distinct Vue.js single-page applications — a public marketing portal and a private subscriber app — both served from the same Laravel backend through a unified routing layer.
The private app implements five distinct stock analysis views: Single Stock View (deep OHLCV analysis for one symbol), Portfolio Tracker (watchlist with tracker readings for all tracked symbols), Legends (color-coded interpretation guide per tracker type), Plans (subscription management and PayPal checkout), and an Admin Panel (user management, stats, messages, and plan configuration). The public site explains the Equities4Profit methodology and provides registration, login, FAQ, and contact surfaces.
The data layer is powered by an automated NSE Bhavcopy pipeline that downloads, extracts, and parses daily equity data into a normalized OHLCV store. Five tracker algorithms query this store in real time, comparing each stock's current reading against its own historical range to produce the percentage signals that drive every investment display in the platform.
Approach
TTPL's approach to Equities4Profit began with the algorithm, not the UI. Before any code was written, the team worked with the product owner to precisely specify the mathematical definition of each tracker type — what constitutes the "short range" and "long range" window, whether to use the most recent N trading days or a calendar date offset, and how percentage change should be calculated when the denominator is a historical value rather than a current price. This mathematical specification became the ground truth for the TrackerService implementation.
The data model was designed around the Bhavcopy record as the core entity: symbol, series, timestamp, open, high, low, close, prev_close, total_trade_quantity, total_trade_value, total_trades, isin, date. All tracker calculations are queries against this table — there is no separate derived data store. This kept the ingestion pipeline simple (upsert on symbol + series + timestamp) and made it easy to re-run historical data without a migration step.
The dual-portal architecture was resolved by treating the Laravel app as a pure API server for the private Vue.js app, and as a mixed server-rendered / SPA host for the public site. A single catch-all route serves both SPAs from their respective compiled bundles based on authentication state. Separate Blade layout files (private.blade.php, public.blade.php) load the appropriate JavaScript bundle, and Vue Router handles all in-app navigation from that point.
The subscription system was designed for reliability over simplicity. Rather than relying solely on the PayPal webhook, the platform maintains its own Order table with a full status progression and a background reconciliation cron. This means the platform can recover from any network or timing failure between PayPal's side and the application server without manual intervention.
Solution Delivered
Automated NSE Bhavcopy Pipeline with Format Resilience
The Bhavcopy ingestion system handles the complete lifecycle: scheduled or on-demand file download from NSE, ZIP extraction, CSV parsing with column normalization across legacy and new formats, and idempotent upsert into the OHLCV database keyed on symbol + series + timestamp. Laravel Jobs queue the processing to avoid request timeouts during bulk historical backfills. The SymbolService runs in parallel, maintaining a master symbol reference table that powers the real-time autocomplete search across all NSE equities in the subscriber app.
Five-Algorithm Proprietary Tracker Engine
TrackerService implements five independently calculated tracker types, each returning a consistent response object (name, prev_value, current_value, difference, percentage_change, state). The Low tracker compares today's low against the minimum low over the N-day window (offset by 1 to exclude the current day). The High tracker compares today's high against the maximum high. The Close tracker compares today's close against the minimum low. The Volume tracker compares today's total trade value against the maximum volume. The Gap tracker computes the High-Low spread as a percentage of the day's high. Every tracker supports independent short-range and long-range window configuration, giving subscribers two simultaneous time-horizon views for every symbol.
Configurable Legend System with Band-Level Risk Classification
The Legend module maps tracker percentage readings to investment signals through a database-driven band table, independently configurable per tracker type. Each band defines a percentage range, a color and direction icon, a risk classification (Conservative / Moderate / Aggressive), expected return range, investment term, probability of upswing, and probability of getting stuck. The Legend Summary table adds plain-language narrative explanations that appear below the legend table, ensuring even first-time users understand what each color means for their investment decision. Legend data is served through dedicated API endpoints (/api/legends/{trackerType} and /api/legends/{trackerType}/summary).
Dual-Portal SPA Architecture with Plan-Gated Middleware
Two independent Vue.js 2 + TypeScript single-page applications — public.ts and private.ts — are compiled by Webpack Mix into separate bundles and served from distinct Blade layout files. The private app is protected by Laravel's authentication middleware plus a custom check.plan middleware that validates the user's active subscription before allowing tracker API access. Route-level guards in Vue Router enforce the same protection on the frontend. The public site runs without any authentication dependency, ensuring marketing pages are always accessible regardless of session state.
Resilient PayPal Subscription with Plan Stacking
OrderService implements a full PayPal Checkout flow: order creation (OrdersCreateRequest), user approval, server-side capture (OrdersCaptureRequest), and plan assignment (PlanService::mapPlan). The Order table tracks every state transition with full request and response payloads for auditability. CronService::orderSync runs periodically to reconcile any orders stuck in CREATED or APPROVED state by re-querying PayPal's OrdersGetRequest — assigning plans for any COMPLETED payments that were missed. PlanService::mapPlan detects existing unexpired paid plans and chains new subscriptions to begin at their expiry, preventing coverage gaps.
Admin Panel with User, Plan, and Message Management
The admin portal (restricted to admin and super_admin roles via check.role middleware) provides a full operational control surface: live user list with activation toggle, plan assignment, plan extension, plan activation control, and password reset. The Stats API endpoint surfaces platform-level metrics for monitoring. The Messages module manages public contact form submissions — with per-message read/unread toggling and admin remarks capability. The Plan Management module enables creating new subscription plans, editing plan parameters (name, duration, amount), and toggling plan availability — all without code deployments or database access.
Result
Equities4Profit launched as a live SaaS platform serving Indian retail equity investors with a genuinely differentiated analysis methodology. The approach — measuring each stock against its own historical range rather than against indices or arbitrary price targets — produces a consistent, repeatable signal that investors can act on in under 10 minutes of daily engagement.
The automated NSE Bhavcopy pipeline ensures every registered NSE equity symbol has current OHLCV data updated daily, giving subscribers access to analysis across the full NSE universe with zero manual data effort. The five-tracker engine and color-coded legend system mean that investors with no technical analysis background can make informed, risk-calibrated buy and sell decisions from the same data that professional analysts use.
The subscription model — with free-tier access for onboarding and paid plans for full tracker access — provides a self-sustaining revenue structure. The fault-tolerant PayPal order sync ensures no subscriber loses their paid access due to network timing issues, and the plan stacking logic means loyal subscribers never lose unused subscription days when they renew early.
Client Benefits
Full NSE Analysis in 5–10 Minutes Daily
The Portfolio Tracker view shows every symbol in a watchlist simultaneously with both short-range and long-range tracker readings side by side — replacing 30–60 minutes of individual chart review with a single-screen overview that an investor can scan and act on in minutes.
No Technical Analysis Knowledge Required
The color-coded Legend system translates every mathematical tracker reading into a plain-language risk classification, return expectation, and opportunity description. Investors read the signal directly — no RSI, MACD, or Fibonacci knowledge needed.
Risk-First Investment Signals
Every tracker type surfaces the downside probability alongside the upside opportunity — a deliberate design choice that aligns the platform with the psychology of conservative investors who prioritize capital preservation over maximum return.
Full NSE Equity Coverage via Daily Bhavcopy
The automated Bhavcopy pipeline covers every NSE-listed equity series, giving subscribers analysis capability across thousands of symbols without any manual data sourcing or subscription to expensive market data feeds.
Reliable Subscription with No Coverage Gaps
PayPal's background order sync and plan stacking logic guarantee that subscribers never lose access due to payment callback failures, and that early renewals stack seamlessly onto existing active plans without losing unused days.
Proprietary Analytical Edge
The core tracker methodology — using a stock's own N-day historical range as its benchmark — is concept that provides an analytical framework not available in any mainstream charting or advisory platform in the Indian retail market.
Client Feedback
"TTPL understood the core idea from day one — that this wasn't just a data dashboard, it was a fundamentally different way of thinking about stock risk. They translated years of manual analysis methodology into a system that any investor can use in minutes. The Bhavcopy pipeline runs without any intervention, the tracker calculations are accurate, and the platform has been exactly what I envisioned for risk-averse investors who want to trade with confidence."
- Bhavesh Thummar, Founder, Equities4Profit
Technologies Used
