NEPSE TMS Statement Import Guide: Turn Broker Exports into a Clean Trading Journal

If you trade on NEPSE, your broker's Trading Management System (TMS) already has the fill history you need for a proper journal. The hard part is getting that data out of TMS and into a tool that understands Nepali market fields (symbols, lot sizes, NPR P&L) without retyping every row.

This guide walks through exporting a TMS statement, what a good import should capture, and how to review the result so your journal stays trustworthy.

What a TMS statement actually contains

A typical NEPSE TMS trade export is a CSV or Excel file with rows for buys and sells: symbol, quantity, price, trade date/time, and often brokerage or settlement details. That raw history is enough to reconstruct round-trips if your journal can match opens and closes correctly.

What generic CSV upload tools miss:

• NEPSE symbol conventions and how brokers label instruments
• NPR as the native currency for P&L (not a forced USD conversion)
• Statement quirks: header rows, date formats, or columns that differ slightly by broker

A NEPSE-aware importer reads those fields instead of making you map everything by hand every time.

Export your trade history from TMS

1. Log into your broker's TMS portal with the account you actually trade.
2. Open the trade history / transaction / statement section (labels vary by broker).
3. Set a date range that covers the period you want in your journal. Start with the last 30-90 days if this is your first import.
4. Export as CSV when available (Excel works when CSV isn't offered).
5. Save the file somewhere you can find it. Don't edit columns before importing unless you know the journal expects a cleaned template.

Tip: keep the original export. If an import looks wrong, re-run from the untouched file instead of a spreadsheet you already modified.

Import into a NEPSE-compatible journal

In CandleTrace (or any tool with a dedicated NEPSE TMS adapter):

1. Open Import and drop the TMS file (or browse to it).
2. Confirm the broker/format was detected as NEPSE TMS, or select it manually if auto-detect misses.
3. Check currency is NPR for this account.
4. Review the preview: symbols, sides, sizes, and dates should match what you see in TMS.
5. Commit the import into the account you use for NEPSE so prop or Forex books stay separate.

Duplicate detection matters. Re-uploading the same statement should not create identical journal rows; preview and skip anything already present.

After import: a five-minute sanity check

Don't jump straight into fancy analytics. Verify the basics first:

• Trade count roughly matches the export for that date range.
• Biggest wins and losses look familiar. Wrong lots or prices show up here first.
• Open vs closed positions make sense if you still hold names.
• Equity / cumulative P&L direction matches how the period felt (not necessarily exact to the rupee until fees are modeled the way you want).

Then look at win rate versus average win/loss size. A high win rate with tiny winners and rare large losers is still a losing strategy. Your journal should make that obvious.

Common import pitfalls

• Wrong account selected: NEPSE fills land in a Forex or prop book and pollute both histories.
• Edited CSV before upload: renamed headers or deleted rows break parsers that expect TMS layout.
• Partial date range: you judge "performance" on an incomplete month and draw bad conclusions.
• Ignoring fees: if your statement includes brokerage columns, prefer an importer that can use them; otherwise note that net P&L may be slightly optimistic.

From statement to habit

A one-time TMS import is useful. Recurring imports are what make the journal real: export after the week, drop the file, review outliers, and tag why the biggest mistake happened. Pair that with behavioral checks (overtrading, size drift, revenge entries after a red day) so the journal explains why the curve looks the way it does, not only what happened.

CandleTrace is built for that loop: NEPSE TMS import, NPR P&L, and the same journal surface you use for Forex, crypto, US equities, and futures.