Stock Trading Recommendations Management System

# System Description

Here's a comprehensive description of the system:

## Core Functionality

The system facilitates a workflow where TAs can submit stock trading recommendations that are reviewed by admins before being distributed to investors. It tracks TA performance, manages courses assigned to TAs, and handles monthly financial settlements.

## Key Components and Workflows

1. **User Management System**:
- Admin management with secure login
- TA registration with verification (NSIM number, Aadhar, certificates)
- TA status management (Active, Pending, Blocked, Declined)

2. **Stock Call Management**:
- TAs submit recommendations within their eligible "buckets"
- Each call includes buy/sell price, stop loss, and target
- Admin reviews calls and accepts/declines them
- System prevents duplicate calls from TAs

3. **Investor Management**:
- Admin uploads investor details via Excel
- System generates trade detail reports for investors
- Excel exports with trade and investor details

4. **Performance Tracking**:
- Tracks success/failure of calls for each TA
- Maintains counter of unsuccessful calls
- Automatically locks/unlocks buckets based on TA performance
- Can block TAs if they exceed failure thresholds

5. **Course and Financial Management**:
- Admin can create, update, and assign courses to TAs
- System tracks financial balances and transactions
- Monthly reconciliation process with acknowledgment
- PDF generation for financial settlements

6. **Stock Consistency**:
- Once a trading sheet is generated, stock information remains constant across all entries, ensuring consistency in the trade execution process.

The system includes various security features, including Aadhar-based verification, login attempt limitations, and secure processing of financial data. It's designed to create a structured framework for managing investment recommendations while maintaining accountability for the advice provided.