WebSocket API Integration for NSE Orders

# Trading Alerts Web Application - Project Brief

## Overview
Real-time trading alerts web app with 5paisa API integration, deployed on Google Cloud at amit-mehta.com. **Use any backend technology you're comfortable with.**

## Tech Stack (Your Choice)
- **Backend**: Any framework (Node.js, Python, Java, C#, PHP, etc.)
- **Database**: PostgreSQL/MySQL (Google Cloud SQL)
- **Frontend**: HTML/CSS/JavaScript, WebSocket for real-time updates
- **APIs**: 5paisa trading API, TradingView webhooks
- **Deployment**: Google Cloud Platform

## Core Features

### 1. Authentication (Google OAuth Recommended)
- Whitelist specific Gmail accounts only
- Role-based access: Admin/Trader/Viewer
- Session timeout, IP whitelisting, audit logging
- Alternative: Multi-factor authentication (SMS/Email OTP)

### 2. Database Schema
- **Alerts**: Strategy, symbol, action, quantity, P&L, order status
- **Positions**: Live positions with real-time prices from 5paisa
- **Strategy Config**: Per-strategy quantity settings, enable/disable
- **Users**: Authorized accounts with roles
- **Audit Log**: Security and trading activity

### 3. TradingView Integration
Parse webhook messages like:
```
"ChannelBreakOutStrategy (5): order buy @ 2 filled on NIFTY250731C25500. New strategy position is 1"
```

**Symbol Parsing**: `NIFTY250731C25500` =
- Index: NIFTY
- Expiry: 31-July-2025 (250731)
- Type: CALL (C)
- Strike: 25500

### 4. Four-Tab Dashboard
**Tab 1-3**: All Alerts, Call Alerts, Put Alerts
- Tabular display with 13 columns: Timestamp, Strategy, Index, Expiry, Type, Strike, Action, Qty, Entry Price, Live Price, P&L, Status, Position, Message
- Real-time P&L updates, filtering, sorting, CSV export
- Date range analysis

**Tab 4**: Strategy Configuration
- 13 strategy tiles in grid layout
- Per-strategy settings: quantity per lot, enable/disable, current position
- Live P&L per strategy, win rates

### 5. Advanced Position Management
**Reversal Trading Logic**:
- Current: +75 qty (long 1 lot)
- Short signal → Sell 150 qty (close 75 + short 75) → Net: -75
- Buy signal → Buy 150 qty (close -75 + long 75) → Net: +75
- Dynamic quantity: Change config to 225 → Future trades use 450 qty

### 6. 5paisa API Integration
- Automatic order placement from TradingView alerts
- Live price feeds for real-time P&L calculation
- Position tracking and order status monitoring
- Market data streaming for continuous updates

### 7. API Endpoints
- `POST /api/send_alert` - TradingView webhook (text) and JSON API
- `GET/PUT /api/strategies` - Strategy configuration management
- Real-time WebSocket for live updates

## 13 Supported Strategies
ChannelBreakOut, EMA Crossover, RSI Divergence, MACD Signal, Bollinger Bands, Stochastic, Williams %R, Volume Profile, Support/Resistance, Fibonacci, Ichimoku Cloud, ADX Trend, CCI Signal

## Security Features
- Google OAuth with email whitelist
- Role-based permissions
- Session management, IP restrictions
- HTTPS enforcement, audit logging
- API rate limiting

## Deliverables
1. Complete web application with database (any backend technology)
2. Google Cloud deployment with custom domain setup
3. SSL certificate configuration (amit-mehta.com)
4. Strategy configuration interface
5. 5paisa API integration with live data
6. TradingView webhook parser
7. Complete documentation and deployment guide

## Example Usage
```bash
# TradingView webhook
curl -X POST https://amit-mehta.com/api/send_alert \
-d "ChannelBreakOutStrategy (5): order buy @ 2 filled on NIFTY250731C25500. New strategy position is 1"
```

## Requirements
**Must Have Experience With**:
- Web application development (any backend language)
- Google OAuth or MFA implementation
- 5paisa API or similar trading APIs
- Options trading knowledge (CALL/PUT mechanics)
- Database design and management
- Real-time WebSocket implementation
- Google Cloud Platform deployment
- Text parsing for webhook integration
- Financial calculations and position management

## Timeline & Budget
- **Duration**: 12-16 days
- **Budget**: $1000-1500 USD
- **Support**: 30-day bug fixes included

## What I Provide
- Google Cloud project access
- Domain management access
- 5paisa API credentials
- TradingView alert examples
- Strategy configurations
- Testing and feedback

## Success Criteria
- ✅ Deployed at amit-mehta.com with SSL
- ✅ Google OAuth working with whitelisted accounts
- ✅ Four-tab interface with tabular display
- ✅ 5paisa integration with live prices
- ✅ TradingView webhook parsing accurate
- ✅ Strategy configuration tiles functional
- ✅ Position reversal logic working correctly
- ✅ Real-time P&L calculations
- ✅ CSV export and filtering features

**Apply with**: Portfolio of similar projects, detailed timeline, fixed price quote, and technical approach.