Accounts & Data

    Add and manage your broker accounts, import files, connect a brokerage, hide accounts from the numbers and clean up your data.

    Accounts & Data is where your data comes in and where you manage it. In MyTraderDash an account is one of your broker accounts (for example "Questrade TFSA" or "Schwab Margin"). Every trade belongs to one account.

    Two different things are called Delete Account. The one on this page deletes one broker account and its trades. Settings → Profile → Danger Zone → Delete Account deletes your whole MyTraderDash account. See Start over.

    Trading Accounts

    A table of your accounts, with a button bar at the top right.

    The table

    ColumnWhat it shows
    BROKERA short code for the broker
    ACCOUNTThe account's name, greyed out when the account is hidden (see Hide an account)
    TYPEThe account type (Margin, TFSA, RRSP, …) — what the Tax report goes by
    CURRENCYThe currencies it holds: USD, CAD, or USD · CAD
    STATUSOpen or Closed, with when it was opened and closed if you entered it
    SOURCEFile (you import its files) or Synced · provider, with the last sync time or Sync failed. Wide screens only
    ACTIVITYThe months of its first and last trade. Wide screens only
    TRADESHow many trades it holds, dividends not included
    DIVIDENDSHow many dividends it holds
    ACTIONSThe import and export buttons, the eye button and the ⋮ menu

    Account order

    Drag a row by its grip (the dotted handle at the left) to move it. The order you set is the order your accounts are listed in everywhere: the Accounts selector, the filters, and the Open tabs on Watchlists. With the keyboard: focus the grip, press Space, move with the arrow keys, press Space again. New accounts go last.

    Or click a column header (Broker, Account, Type, Currency, Status, Activity, Trades, Dividends) to sort by it; click it again to reverse. A sort is saved as your order, just like dragging, so you can sort first and then drag a few rows into place. Status sorts open accounts first, then by when they were opened.

    Row buttons

    ButtonWhat it does
    Import (up arrow)Opens the import window with this account already picked (see Import Data)
    Export (down arrow)Downloads this account's trades as a CSV file
    EyeHides this account's trades everywhere, or shows them again; crossed out while the account is hidden (see Hide an account). Off for the last visible account

    Add Account

    Opens Add New Account:

    • Account Name: any name you'll recognize, for example "Main Trading Account".
    • Broker: pick yours from the list (grouped by whether its files can be imported), or Other if it isn't there.
    • Account Type: Cash (Non-Registered), Margin, a Canadian registered account (TFSA, RRSP, FHSA, RESP, RDSP, LIRA, RRIF, LIF), a US retirement account (Traditional IRA, Roth IRA, 401(k), 403(b), 457(b), HSA, SEP IRA) or Other. Margin is picked to start with.
    • Currency: USD, CAD or both. An account holding both needs a currency column in the files you import.
    • Status: Open or Closed. A closed account's positions get no alerts, reminders or digest.
    • Opened and Closed (optional): as precise as you know: a year (2024), a month (2024-05) or a day (2024-05-14). Closed is there only for a closed account and can't be before Opened; reopening an account clears it.

    Click Add Account. When you have no accounts yet, the table shows Add Your First Account instead. The same form opens from + New account in Add Trade and from Add an account in the import window when you have none.

    The ⋮ menu

    ItemWhat it does
    Edit AccountChange the name, broker, type, currencies, status and dates, and switch Watch open positions on or off
    Disconnect BrokerageOnly on accounts linked to a brokerage connection (see Connect Brokerage)
    Drop TradesDeletes all trades and cash records in this account but keeps the account, then rebuilds your positions. It asks first
    Delete AccountDeletes this account and all its trades, then rebuilds your positions. It asks first

    Watch open positions (in Edit Account) gives the account's holdings their own tab on the Watchlists page, plus the swing alerts, reminders and digest described in Alerts.

    Delete Account keeps your journal entries; the ones linked to that account's trades show as Orphaned in the Journal. An account synced from a brokerage must be disconnected first: the dialog offers Disconnect Brokerage.

    Hide an account

    Hiding an account leaves its trades out of every page (listed below) until you show it again. Two ways:

    • the eye button on the account's row, one account at a time;
    • Account Filters in the button bar at the top right of the table, for several at once.

    To look at some accounts on one page only (for example the Dashboard of your TFSA), use the Accounts selector at the top of that page instead: it narrows that page and changes nothing else. Hidden accounts appear there greyed out, and can't be picked until you show them here. Ticks apply when you close the list. None clears every box so you can tick just the few you want; closing the list with nothing ticked leaves the page as it was. Only applies at once. The selector's choice stays in the page's address (a refresh or a bookmark keeps it); opening the page from the sidebar starts with all accounts.

    Account Filters

    Account Filters (top right of the table) chooses what the numbers across the app are based on:

    • Hidden accounts: tick the accounts to leave out of every page. Hide All / Show All ticks or clears them all. Hidden accounts are crossed out.
    • Date Range: the year buttons (this year and the four before) or a Start date and End date limit the numbers to that period.

    Save applies the filter; Clear All removes it.

    The filter applies to the Dashboard, the Trade Log (its table, performance cards and reports), Dividends, Ticker Reports, Strategies and Calendar. Data Quality still lists every account's trades, and the Tax report has its own account choice. Pages update by themselves when you save.

    Keep at least one account visible: Save stays off while every account is hidden.

    Connect Brokerage

    Links a brokerage login so trades come in by themselves. A window from the connection service opens; log in to your broker there. When you close the window, the brokerage's accounts are added to the table and their trades start syncing in the background.

    If the button shows Coming soon, brokerage connections aren't available yet; import a file instead. More in Connect a brokerage.

    Disconnect Brokerage (in the ⋮ menu) lists every account that shares the same brokerage login. Their trades are kept and the accounts stay as manual accounts; they just stop syncing. You can connect again later.

    Sync All

    Shown once an account is connected to a brokerage. Asks every connected brokerage for new trades; after a sync it shows Synced for a minute before you can sync again. The sync runs in the background: pages update by themselves when its trades arrive.

    Display Currency

    Shown only when you have trades in both US and Canadian dollars. The USD / CAD switch picks the currency every page opens with: position returns, profit and loss, dashboard numbers. Each page can then switch on its own with the USD | CAD toggle at its top, without changing this setting. Each trade keeps its own currency. See Currencies.

    Import Data

    Import Data on the card opens the import window; the import (up-arrow) button on an account's row opens it with that account picked.

    1. Pick the account under Select Account for Import (already picked when you came from a row's import button, or when you have only one account). Each account shows its broker, type and currencies. Closed accounts are listed only after Show closed accounts (you can still import into one).
    2. Drag your broker file onto the box, or click it to choose the file (CSV, XLSX, JSON or XML). Several files for the same account can go in at once: each gets a row with its counts and a Details button for its preview, and they're imported one after another (see Several files at once).
    3. Check the Import Preview: Will Import, Will Skip, Low Confidence (rows the app isn't sure about), Cash Records when the file has any (deposits, interest, fees, withholding tax: see Cash records), a Currency Breakdown and the Skipped Rows. Download Issue Rows saves the rows that won't import, so you can look at them.
    4. If shares were transferred in without a purchase, the preview asks whether you bought them (Long) or sold them (Short). Answer each one.
    5. Click Import N Trades. The result shows how many rows were Inserted, Updated and Skipped.

    Click Done. If prices still need to be fetched, a Loading Market Data page shows the progress and then brings you back here. Import Another starts over.

    Step by step: Import a broker file. How rows are read and matched: Imports.

    Download Template XLSX

    A spreadsheet to fill in when your broker isn't supported, or for trades you keep yourself. It has sample rows and a sheet explaining each column. Exchange and Market are optional; Currency tells US and Canadian listings of the same ticker apart. A Market or Exchange the app doesn't recognize is ignored and shown as a warning on that row in the preview.

    Clear Local Cache

    Clears what this browser has stored and reloads the page. Use it when the app looks wrong after an update. Your trades and settings saved with your account are not touched; things kept only in this browser (such as a folded sidebar) reset.

    Export Data

    Full Backup

    Download Full Backup saves a ZIP file with everything you created: accounts, trades, your own grouping and tags, watchlists and their alerts, open-position alert settings, stock lists, screener and journal templates, journal entries and stories, and your settings. Positions, strategies and prices aren't in it; they're rebuilt when you restore.

    To restore, drop the ZIP into the Import Data window (no account needed). A restore:

    • adds to what's in your workspace now and never deletes anything;
    • overwrites anything that matches the backup (same account, same trade, same watchlist…), so restoring an old backup undoes changes you made since then;
    • changes nothing the second time you restore the same file.

    The accounts you had hidden are hidden again after the restore; the others stay visible.

    Accounts that were synced from a brokerage come back as normal accounts; connect them again if you want them to sync. A backup made by an older version of MyTraderDash can't be restored.

    Export Trades and Export Journal

    Export Trades downloads your trades, for the accounts you pick, in the template's format: every column is always there (empty when it doesn't apply), and the file imports back as it is. Market is the country code (US, CA) and Exchange the listing code (TOR, NYQ, …). Export Journal downloads your journal entries. The line below shows how many trades, dividends and accounts you have.

    Demo Data

    Shown only while your workspace still holds the sample data. Clear Demo Data removes the demo trades, their journal notes and the DEMO account (kept if it holds trades of yours), then rebuilds your positions. Watchlists, screener templates and settings stay. It asks first; after that the section disappears. Step by step: Start over.

    Delete All Trades

    At the bottom of the export card. Deletes every trade, position and cash record in every account, your own included. Your accounts, settings and preferences stay, and so do journal entries (they show as Orphaned). It asks first, then reloads the page. This can't be undone. To remove only the sample data, use Clear Demo Data.

    Data Quality

    Lists trades that aren't part of any position, for example a sell with no matching buy because the buy happened before your oldest imported file. The header shows how many there are. When there are none, you see All trades are grouped.

    Importing older history from your broker usually fixes most of these.

    Filters and columns

    The filter bar has Date Range, Tickers, Types, Origins, Sources, Accounts, Brokers, Exchanges, Currency, To Currency, Opt Type, Synth Reason, Tags, Qty, Price and Category, plus Clear all. The Columns button chooses which columns and filters show.

    The CATEGORY column says why a trade isn't grouped:

    CategoryMeaning
    Orphan Buy / Orphan SellA buy or sell with nothing to match it
    Orphan DividendA dividend the app couldn't tie to shares you held
    Unmatched OptionAn option trade with no opening or closing side
    Partial UnmatchedOnly part of the trade was matched
    Transfer RemnantWhat's left of a transfer between accounts
    Journal SourceOne side of a move between the US and Canadian listing
    ReconciledAlready checked and settled
    OtherAnything else

    Click a sortable column header to sort. More rows load as you scroll.

    Fixing rows

    Tick rows to select them. The bar at the bottom offers Edit (one trade), Move to Group (one trade: put it into a position of the same ticker), Add Tag, Remove Trade Tag and Delete Trades. More in Find and fix data issues and Data issues.