Equities4Profit — NSE Stock Analysis SaaS for Risk-Averse Indian Investors
HOME - our portfolio - equities4profit nse stock analysis saas
Equities4Profit — NSE Stock Analysis SaaS for Risk-Averse Indian Investors
Industry
FinTech & Capital Markets
Built for
Web
Project Type
SaaS Platform
Region
India
Timeline
2020 – 2021
Project Description
Equities4Profit is SaaS stock analysis platform built by TTPL for Indian retail investors trading on the NSE. The platform simplifies equity analysis by converting raw NSE Bhavcopy data into a color-coded, visual intelligence layer — enabling risk-averse investors to make precision buy and sell decisions in as little as 5–10 minutes a day, without any background in technical analysis.
The system automatically processes daily NSE Bhavcopy CSV files — the official end-of-day OHLCV data published by the National Stock Exchange — and feeds it into five proprietary tracker algorithms: Low, High, Close, Volume, and Gap. Each tracker measures where a stock currently stands relative to its own historical price range, across configurable short and long date windows. The reading is then translated into a color-coded signal that communicates precise risk level and opportunity window without requiring the investor to understand a single formula.
Equities4Profit serves two distinct portals: a public marketing site that explains the methodology, and a private authenticated SaaS app where subscribers manage their tracked symbols, view personalized analysis, and access the full legend interpretation guide — all under a PayPal-powered subscription model with free and paid tiers.
Goal
The goal of Equities4Profit was to democratize equity analysis for India's large population of risk-averse retail investors — people who want to participate in the stock market intelligently but cannot allocate hours to technical chart reading, cannot afford private advisory fees, and cannot stomach significant capital losses. The product needed to encode a sound, repeatable analysis methodology into a digital tool that any investor could use in minutes.
- Automate daily NSE Bhavcopy data ingestion, parsing, and storage into a queryable OHLCV database
- Build tracker algorithm that measures each stock's current position relative to its own N-day historical range
- Implement a color-coded legend system that translates mathematical signals into plain-language investment guidance — no formula knowledge required
- Enable personalized portfolio tracking across five tracker types with configurable short and long date windows
- Build a subscription model with free and paid tiers, PayPal integration, auto plan assignment, and expiry management
- Deliver a clean two-portal architecture: public marketing site and authenticated SaaS app
Challenges
Bhavcopy Volume and Idempotent Processing: NSE's daily Bhavcopy files contain thousands of equity records per trading day, accumulated across years of historical data. Building an efficient download-extract-parse-upsert pipeline that could handle both date-specific and bulk backfill operations — without creating duplicates or corrupting historical data — required careful design around Laravel's job queue and Eloquent's updateOrCreate logic.
Proprietary Multi-Tracker Algorithm: The core product insight — that a stock's current price position relative to its own historical range is a more actionable signal than any absolute price target — required building five distinct calculation engines (Low, High, Close, Volume, Gap), each with its own logic, configurable date windows, and consistent output format. The algorithm had to return accurate percentage-change readings fast enough to power full-watchlist queries in real time.
Dual-Portal Architecture on a Single Laravel Codebase: Serving a public marketing Vue.js SPA and a private authenticated SaaS app from one Laravel backend — with two separate compiled JavaScript bundles, distinct route guards, role-based middleware, and plan-gating — required clean separation of concerns without code duplication across the two app surfaces.
Resilient PayPal Subscription Lifecycle: PayPal payment flows can fail at the redirect and callback stage even when payment is captured. Building a fault-tolerant order state machine with a background cron that re-syncs pending orders against PayPal's API — automatically assigning plans when payments are confirmed late — was critical for preventing revenue loss and subscription gaps for paying users.
Solutions
Automated NSE Bhavcopy Ingestion Pipeline
TTPL built a complete file management pipeline — download, ZIP extract, and CSV parse — for NSE daily Bhavcopy files, with dedicated routes for both single-date and bulk operations. Laravel jobs queue the processing, and BhavcopyService's upsert logic ensures idempotent ingestion: re-running any file produces no duplicates. The SymbolService maintains a parallel master symbol list enabling instant autocomplete search across all NSE equities. The system handles both the legacy and new NSE Bhavcopy CSV column formats, ensuring continuity as NSE updates its data publishing standards.
Multi-Tracker Analysis Engine
Five independent tracker types each implement a distinct calculation: the Low tracker compares today's low against the N-day lowest price; the Close tracker compares close against the N-day lowest; the High tracker compares today's high against the N-day highest; the Volume tracker compares today's volume against the N-day peak volume; the Gap tracker calculates the intraday High-Low spread as a percentage. Every calculation returns a direction, absolute difference, and percentage change — served through a unified TrackerService API supporting both single-symbol analysis and full-watchlist batch queries with independent short-range and long-range windows.
Color-Coded Legend Interpretation System
The Legend module converts raw tracker percentage readings into human-readable investment signals through a configurable band table. For each tracker type (Low, Close, Volume, High), percentage bands map to risk classifications, return expectations, investment terms, upswing probability, and getting-stuck possibility. Investors see a colored direction indicator — green, orange, red, or blue — that immediately communicates the opportunity profile of each position. Legend Summaries add plain-language explanations of what each band means in practice, making the platform genuinely usable by investors with no quantitative background whatsoever.
Personalized Portfolio Tracker with Multiple Watchlists
Each user maintains named watchlists mapped to one of the five tracker types, with up to 20 symbols per tracker. The Portfolio view displays all tracked symbols simultaneously — short-range and long-range tracker values side by side — enabling instant visual comparison across an entire watchlist. Symbols are added via an autocomplete dropdown fed from the master NSE symbol list. Bulk delete, real-time refresh, and tracker-type switching are available from the same view. A Single Stock View enables deeper analysis of any individual symbol with full OHLCV day-position data displayed alongside tracker readings.
PayPal Subscription with Fault-Tolerant Order Sync
Plan purchases flow through PayPal Checkout SDK with a full Order state machine: CREATED → APPROVED → COMPLETED → PLAN_ASSIGN_COMPLETED. A background cron job (CronService::orderSync) periodically reconciles pending orders against PayPal's API, catching cases where payment completed but the browser-side callback was interrupted. Once payment is confirmed, PlanService::mapPlan automatically assigns the plan and extends the active window beyond any existing paid subscription — preventing accidental coverage gaps. A second cron sends automated plan expiry reminder emails ahead of renewal deadlines.
Role-Based Admin Panel with Full Operational Control
Administrators access a complete management panel with user activation toggle, plan assignment, plan extension, and password reset — all from a live user list with real-time plan status. The Stats panel surfaces system-level metrics for platform health monitoring. The Messages module handles public contact form submissions with read/unread tracking and admin remarks capability. The Plan Management module allows creating and editing subscription plans, toggling plan availability, and reviewing all user-plan mappings — giving operators full control over the subscription catalog without code deployments.
