Trading Performance Dashboard — Paste Your Broker Export
No retyping: paste a closed-trades export, map the headers once, and every stat and chart fills in.
Price: ₹999 (one-time purchase)
Format: XLSX (Excel + Google Sheets) + PDF guide
Delivery: Instant download after payment is confirmed.
Category: Trading Journals
Description
No retyping: paste a closed-trades export, map the headers once, and every stat and chart fills in. The problem: Manual entry is a common reason journals are abandoned. What's different: Formula-only mapping: dropdown of your own export headers, text dates (YYYY.MM.DD, DD/MM/YYYY, MM/DD/YYYY), '(123.45)' negatives, ignore balance/deposit rows. Features: • Raw sheet: paste up to 2,000 rows • Mapping sheet: pick headers from a dropdown • Handles text dates, currency symbols, thousands separators, bracket negatives • Ignores balance/deposit rows • Net or gross + costs • Dashboard, calendar, monthly, weekly, weekday breakdown Who it's for: Traders whose platform exports closed trades and who won't type trades manually. Works with: Microsoft Excel 2010 or later (Windows/Mac), Excel for the web, Google Sheets (upload → open → Save as Google Sheets), LibreOffice Calc 7+. No macros, no add-ins, works offline. How it was tested: every formula was recalculated in LibreOffice Calc and checked against independent Python calculations on the fictional sample data, including edge cases (blank rows, missing fees, invalid numbers, divide-by-zero). The files use only functions available in Excel 2010+ and Google Sheets; open them in your own spreadsheet app before relying on them. Your data stays on your device or in your own Google account — no account, no broker connection. Not affiliated with, endorsed or sponsored by any exchange, broker, index provider, app or educator named on this page; names are used only to describe compatibility or subject matter. Educational record-keeping tool — not investment, tax or legal advice. Trading involves risk of loss; no results are promised.
What's included
- Blank workbook (.xlsx) for your own data
- Sample-data workbook with fictional trades to learn from
- Quick Start Guide (PDF)
- README.txt + personal-use licence (TXT)
Frequently asked questions
Is this a subscription?
No. One-time purchase, instant download after payment. Your purchased version keeps working; free updates are not guaranteed.
Does it connect to my broker?
No. It is an offline file — your data stays on your computer or Google account. You type or paste trades; nothing is sent anywhere.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, open it with Google Sheets and choose File → Save as Google Sheets. Formulas, dropdowns and colours carry over; charts are converted by Google and can be restyled.
What's the difference between the Blank and Sample Data files?
They are identical except the Sample file is pre-filled with clearly labelled fictional trades so you can see every sheet working. Use the Blank file for your own trading.
What if the file doesn't open?
Contact DigiCools via digicools.com with your order email and product ID DC-TJ-11; we will help you open it or resend the file.
Tags: trading performance dashboard, trading journal dashboard excel, trading journal excel dashboard, trader performance dashboard, trading journal import csv, broker export dashboard, trading statistics spreadsheet, trading journal google sheets, pnl calendar spreadsheet, trading journal