Broker P&L Console

Secure access · password required

Broker P&L Console

Firstock · AliceBlue

connecting…
signed in as

Sign in to Firstock

Enter your Firstock User ID, password (plain or SHA-256), and either your TOTP secret key or the current 6-digit code.

Firstock P&L

Pick a date range and segment. Excel ships a multi-sheet workbook (Summary · Charges · Trade Details). JSON returns the raw broker payload.

preview 

        

      

    


    
    

      

        

          

            
Firstock multi-user batch

            
Upload an XLSX (use the template) or a JSON list. Download returns a ZIP with one workbook per client plus a master Summary_Report sheet covering all clients.

          

          
        

        

          
          

            
              
            
            
Drop XLSX or JSON client list here

            
or  · file parsed in memory, then discarded

            

          

        

        

          

            
#User IDNameFromTo

            
          

        

        

        

          
          
          
        

        

          
        

      

    


    
    

      
        Firstock live log
        0 events
        live
      
      

        

          
            

              Time
              Level
              Message
            

          
          
            
waiting for Firstock events… kick off any action above to see live progress

          
        

      

    

  


  
  

    

      
      
      
        signed in as
        
        
      
    


    
    

      

        

          

            
Sign in to AliceBlue

            
Enter your AliceBlue User ID, password, and either your TOTP secret key (base32) or the current 6-digit code.

          

        

        

          
          
          
          

            
          

        

      


      

        

          

            
AliceBlue P&L

            
FNO + Equity + Charges + Heatmap fetched in one call. Ranges > 1 year auto-chunk and merge. Excel returns one workbook per requested segment.

          

        

        

          
          
          
        

        

          
          
          
        

        

        

          

            preview
            
          

          

        

      

    


    
    

      

        

          

            
AliceBlue multi-user batch

            
Upload XLSX or JSON. Each client gets one workbook per requested segment (FNO and/or CM), plus a master batch_summary sheet covering all clients in one ZIP.

          

          
        

        

          
          

            
              
            
            
Drop XLSX or JSON client list here

            
or  · file parsed in memory, then discarded

            

          

        

        

          

            
#User IDNameFromTo

            
          

        

        

        

          
          
          
        

        

          
        

      

    


    
    

      
        AliceBlue live log
        0 events
        live
      
      

        

          
            

              Time
              Level
              Message
            

          
          
            
waiting for AliceBlue events… kick off any action above to see live progress

          
        

      

    

  











  

  

    

      
How to use the Broker P&L Console

      
    

    


      

        
1 Pick a broker

        
Two tabs at the top: 01 Firstock and 02 AliceBlue. Each broker has its own session — you can be signed in to both at once, log out of one without affecting the other.

      


      

        
2 Single user — download your own P&L

        
    
          
  1. Stay on the Single user sub-tab (default).
    2. 
          
  2. Enter your broker User ID, password, and TOTP (either the 6-digit code or your base32 secret key).
    3. 
          
  3. Click Sign in. The download card appears.
    4. 
          
  4. Pick a date range and segment.
    5. 
          
  5. Preview shows the raw broker response. Download Excel ships a multi-sheet workbook (Summary · Charges · Trade Details). Download JSON gives the raw payload.
    6. 
        

      


      

        
3 Multi-user batch — download for many clients

        
    
          
  1. Switch to the Multi-user batch sub-tab.
    2. 
          
  2. Click Download template — opens an XLSX with column headers + 3 example rows.
    3. 
          
  3. Fill in your clients below the examples. Required: user_id, password, totp_access_key (the base32 secret, not the 6-digit code). Optional: name, per-row dates, notes.
    4. 
          
  4. Save the file. Drag-drop or click to upload it.
    5. 
          
  5. Set generic from/to dates + segment (used as fallback when a row's dates are blank).
    6. 
          
  6. Click Run batch & download ZIP.
    7. 
          
  7. The ZIP contains one workbook per client plus a master summary file (Summary_Report.xlsx for Firstock, batch_summary.xlsx for AliceBlue) listing every client's P&L, charges, and brokerage in one sheet.
    8. 
        

      


      

        
4 Where to find your TOTP secret

        
The TOTP secret is the long base32 string (~32 chars like JBSWY3DPEHPK3PXP…), not the rotating 6-digit code.

        
    
          
  1. In your broker's app, start the "Enable 2FA" or "Reset TOTP" flow.
    2. 
          
  2. On the QR-code screen, look for a "can't scan?" or "show key" link — that reveals the secret.
    3. 
          
  3. Copy that secret and paste it into the totp_access_key column (batch) or TOTP field (single-user).
    4. 
          
  4. Scan the QR into your authenticator app too, so normal login still works.
    5. 
        

        
Single-user login also accepts a current 6-digit code if you'd rather type that. Batch requires the base32 secret because the server mints a fresh code per client.

      


      

        
5 Segments

        
    
          
  • Firstock: CM (Cash Market / Equity) · FO (Futures & Options).
    • 
          
  • AliceBlue: CM · FO · both. The "both" option fetches Equity + F&O and ships one workbook per segment per client (so each client ends up with two .xlsx files in the ZIP).
    • 
        

      


      

        
6 Live log

        
Each broker panel has its own expandable Live Log at the bottom. It streams every step in real time — login attempts, retries, file builds, errors. When a batch finishes, a per-client summary table appears under the log showing P&L · Charges · Brokerage with a total row.

      


      

        
7 Lock the dashboard

        
Top-right Lock button drops you back to the login screen. Broker logins persist server-side in memory until you log out of each broker separately or the process restarts.

      


      

        
Tips

        
    
          
  • Nothing is written to the server's disk — credentials, uploaded client lists, and generated files all live in memory only.
    • 
          
  • Ranges > 1 year are auto-chunked into 364-day windows for AliceBlue (Firstock has no chunking limit).
    • 
          
  • Rows in the batch template whose user_id starts with EXAMPLE_ are silently skipped — you can leave the samples in.
    • 
          
  • Press Esc to close this help.
    •