Angel One Trading Journal - Auto Import

Angel One traders can import their executed orders into JournalPlus using the Trade Book CSV from the Angel One web portal, or through the Angel One SmartAPI for automated sync. With over 20 million registered clients and a client base concentrated in NSE F&O — Nifty 50 and BankNifty options dominate order volume — the integration addresses the specific workflow of Indian derivatives traders: accurate brokerage cost capture, product type classification, and multi-leg strategy tracking.

Key Features

Trade Book CSV Import

Angel One’s Trade Book export, accessible under Reports > Trade Book in the web portal, produces a CSV with columns for Symbol, Exchange, Product (CNC/MIS/NRML), Buy/Sell, Quantity, Price, and Order ID. JournalPlus reads this file and maps each column to the corresponding journal field without requiring manual header matching. Traders importing a full month of daily F&O activity can complete the process in under two minutes per session.

Product Type Mapping (CNC / MIS / NRML)

The Product field in Angel One’s export is the key to correct position classification. CNC marks equity delivery trades; MIS marks intraday positions auto-squared at market close; NRML marks overnight F&O positions. JournalPlus maps these values automatically on import — NRML trades appear as overnight F&O, MIS trades as intraday — so performance analytics segment correctly between trading styles without post-import editing.

Itemized Brokerage Cost Tracking

Angel One’s fee structure has several components that compound across active trading. For F&O orders: ₹20 flat brokerage per executed order, 18% GST on brokerage, STT at 0.0125% of premium value on the sell side, NSE exchange transaction charges at approximately 0.05% of turnover, and SEBI turnover fees. On a representative BankNifty trade — buy 2 lots (30 units) of BankNifty 48000 CE at ₹180 and sell at ₹310 — the gross P&L is ₹3,900. Total charges break down as: ₹40 brokerage (₹20 × 2 orders), ₹7.20 GST, ₹1.16 STT on sell, ₹4.65 NSE charges, and ₹0.17 SEBI fees — totaling approximately ₹53. Net P&L drops to ₹3,847, reducing the effective return from 72.2% to 71.2% gross. Across 12 round trips in a month, cumulative charges reach ₹640 — a figure JournalPlus surfaces in the cost dashboard so traders can evaluate whether trade frequency is justified by edge.

F&O Multi-Leg Strategy Grouping

Spread strategies on NSE — for example, buying a Nifty 23000 CE and simultaneously selling a Nifty 23200 CE to form a bull call spread — generate two separate rows in the Trade Book CSV. JournalPlus includes a Group Legs feature that links these rows into a single journal entry, calculating combined net P&L, max risk, and breakeven automatically. This is essential for traders running defined-risk structures where individual leg P&L is meaningless without the opposing position.

SmartAPI Order Sync

Angel One’s publicly documented SmartAPI (REST-based, documented at smartapi.angelbroking.com) allows executed order data to be fetched programmatically. Traders with technical experience can configure JournalPlus to pull order history directly using an API key generated from Angel One account settings, eliminating manual CSV downloads entirely. For the majority of traders, the CSV route is faster to set up and covers all the same data fields.

How to Connect Angel One

Step 1: Log In to Angel One Web Portal

Sign in to the Angel One web portal at angelone.in with your registered credentials. Navigate to the Reports section in the top navigation bar. From the dropdown, select Trade Book.

Step 2: Set Date Range and Download CSV

In the Trade Book screen, use the From and To date selectors to define the period you want to import — daily, weekly, or monthly ranges all work. Click Download and choose CSV format. The file includes all executed orders in the selected window with columns for Symbol, Exchange, Product, Buy/Sell, Quantity, Price, and Order ID.

Step 3: Upload to JournalPlus

In JournalPlus, go to Import > Broker Import and select Angel One from the broker list. Upload the CSV file. JournalPlus automatically recognizes Angel One’s column structure and maps each field — no manual header configuration is required before the preview step.

Step 4: Verify Product Type and Instrument Classification

Review the import preview before confirming. Check that NRML trades are classified as overnight F&O and MIS trades as intraday. Confirm F&O symbols are correctly identified as options or futures. Adjust any mismatches using the dropdown selectors in the preview table.

Step 5: Enter Brokerage Charges

For each trade, enter the total charges in the Charges field. Use the breakdown: ₹20 per executed order + 18% GST on brokerage + 0.0125% STT on sell-side premium (for options) + approximately 0.05% NSE exchange charges + SEBI turnover fees. JournalPlus calculates net P&L immediately on entry and updates the cost analytics dashboard.

Step 6: Tag Strategies and Group Legs

Apply instrument tags (BankNifty options, Nifty futures) and strategy tags (directional, spread, straddle). For multi-leg trades imported as separate CSV rows, use the Group Legs feature to link the buy and sell legs into a single strategy entry. This produces accurate combined P&L and risk metrics visible in the options traders analytics view.

What Gets Imported

Data Field	Description
Trade Date & Time	Execution timestamp from Angel One’s order log
Symbol	NSE ticker or F&O contract name (e.g., BANKNIFTY48000CE)
Exchange	NSE or BSE
Product Type	CNC, MIS, or NRML — maps to position classification
Side	Buy or Sell
Quantity	Number of units (note: 1 lot = 30 units for BankNifty, 75 for Nifty 50, 40 for Finnifty — verify current SEBI-mandated sizes before trading)
Price	Execution price per unit
Order ID	Angel One’s internal order reference

Fields that require manual entry in JournalPlus include total brokerage charges (broken into components above), trade rationale, setup tags, and emotional state at entry. These fields feed the behavioral analytics section of the journal and are not available in broker exports.

Analytics & Insights

Once Angel One trades are imported, JournalPlus calculates P&L at both gross fill and net-of-charges level for every position. The cost drag dashboard tracks cumulative brokerage, STT, and exchange charges by month, instrument type, and strategy — making it visible when fees are consuming a disproportionate share of gross gains. A trader running 12 BankNifty round trips per month at ₹53 average charges pays ₹640 in transaction costs before any consideration of edge.

The Indian traders analytics view segments performance by product type — separating CNC equity delivery from NRML overnight F&O from MIS intraday — so traders can measure their actual edge in each category independently. Win rate, average winner, average loser, and expectancy are calculated per segment. This matters for Angel One users because NSE F&O intraday (MIS) and overnight (NRML) trades often have structurally different characteristics that aggregate metrics would obscure.

For tax reporting, JournalPlus trade log exports provide a structured record of F&O income classified as Business Income under Indian tax law. The export format includes net P&L per trade, total charges, and trade dates — the core inputs needed for ITR filing. Traders with high F&O volume can share the JournalPlus export directly with their CA to streamline the annual filing process. The SEBI 2023 study finding that 9 out of 10 individual F&O traders lose money points to discipline gaps — consistent journaling through JournalPlus is one of the few interventions with direct evidence behind it.

Frequently Asked Questions

Does JournalPlus support Angel One trade imports?

Yes. JournalPlus imports Angel One trades via the Trade Book CSV downloaded from the Angel One web portal under Reports > Trade Book. The CSV columns map directly to JournalPlus journal fields including symbol, product type, quantity, price, and order ID. Advanced users can also connect via the Angel One SmartAPI.

How do I export my trades from Angel One?

Log in to the Angel One web portal, navigate to Reports > Trade Book, select your date range, and download the CSV file. This file contains all executed orders for the selected period and is the standard import format for JournalPlus. The CSV export is available for any historical date range in your account.

What is the difference between CNC, MIS, and NRML in Angel One?

CNC (Cash and Carry) is used for equity delivery trades held beyond the trading session. MIS (Margin Intraday Square-off) applies to intraday positions that are automatically closed before market close. NRML (Normal) is the product type for overnight F&O positions — most Angel One options traders using weekly BankNifty or Nifty strategies use NRML. JournalPlus maps all three types automatically on import.

How does JournalPlus handle Angel One brokerage fees for F&O trades?

JournalPlus includes a charges field for entering the total cost per trade. The Angel One fee structure for F&O includes ₹20 flat brokerage per executed order, 18% GST on brokerage, STT at 0.0125% on the sell-side options premium, NSE exchange charges at approximately 0.05% of turnover, and SEBI turnover fees. Net P&L is calculated automatically and displayed alongside gross P&L in the trade dashboard.

Can I use the Angel One SmartAPI to sync trades automatically?

Yes. Angel One’s REST-based SmartAPI allows executed order data to be pulled directly into JournalPlus without manual CSV downloads. Setup requires generating an API key from your Angel One account settings — the SmartAPI documentation is publicly available. The API route is best suited for active traders comfortable with technical configuration. The CSV upload route covers the same data fields and is faster to set up for most traders.