Skip to main content

CSV Import

If you have a history of trades from your broker, you can import them all at once using Metrifly's CSV import wizard. This saves hours of manual data entry and gets your portfolio up to date quickly.

Supported File Formats​

  • CSV (Comma-Separated Values) -- The most common export format from brokers
  • XLSX (Excel spreadsheet) -- Also supported
  • Maximum file size: 5 MB

Before You Start​

  1. Export your trade history from your broker's website or app. Look for options like "Export Trades", "Download Transaction History", or "Export to CSV".
  2. Open the file in a spreadsheet application (Excel, Google Sheets) to confirm it contains the columns you need.

Required Data​

Your file must contain these data points for each transaction:

DataDescriptionExample
Transaction typeBUY or SELLBUY
Ticker symbolThe stock's tickerCBA, AAPL
DateWhen the trade occurred2024-03-15
QuantityNumber of shares100
PricePrice per share105.50

Optional Data​

DataDescription
ExchangeStock exchange (ASX, NYSE, etc.)
Fee / BrokerageTransaction fee
CurrencyTrade currency
AmountTotal transaction value
NotesAny notes about the trade

Step-by-Step Import Process​

Step 1: Start the Import​

  1. Navigate to your portfolio page.
  2. Click Import (or navigate to the import page from the portfolio menu).
  3. You will see the import wizard.

Import wizard - upload step

Step 2: Upload Your File​

  1. Click Upload File or drag and drop your CSV/XLSX file onto the upload area.
  2. Metrifly reads the file and detects its structure.
tip

If your broker is supported, select the broker preset from the dropdown before uploading. This automatically maps columns to the correct fields, saving you from manual mapping. Supported presets include common brokers like CommSec, Interactive Brokers, SelfWealth, and others.

Step 3: Map Column Headers​

Metrifly needs to know which columns in your file correspond to which transaction fields.

  1. For each Metrifly field (Type, Ticker, Date, Quantity, Price, etc.), select the matching column from your file using the dropdown.
  2. If you selected a broker preset, most fields will be pre-mapped. Review them and correct any that are wrong.
  3. Fields marked with an asterisk (*) are required.

Import wizard - header mapping step

Column mapping tips:

  • Type column: Should contain values like "Buy", "Sell", "BUY", "SELL". Metrifly recognises common variations.
  • Date column: Supports most date formats (DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, etc.).
  • Price column: Can be the per-share price or the total trade value -- map accordingly.
  • If your file does not have a column for a field (e.g., no fee column), leave that mapping blank.

Step 4: Review Transactions​

After mapping, Metrifly validates every row in your file and shows a review screen with colour-coded rows:

ColourMeaningAction
GreenValid transaction, ready to importNo action needed
AmberPotential duplicate (matches an existing transaction by ticker, date, quantity, and price)Review -- uncheck if it is a genuine duplicate
RedInvalid data (missing required fields, unparseable date, etc.)Cannot be imported; fix in your source file and re-upload

Import wizard - review step

  1. Review the list of transactions.
  2. Uncheck any rows you do not want to import (e.g., duplicates or trades you want to skip).
  3. Check the summary at the bottom: total rows, valid rows, duplicates, and invalid rows.
  4. Click Import to proceed.

Step 5: Import Processing​

After clicking Import, Metrifly processes your transactions asynchronously:

  1. Transactions are saved to your portfolio.
  2. Holdings are created or updated for each ticker.
  3. Market prices are fetched for all tickers.
  4. Exchange rates are fetched for multi-currency transactions.
  5. Portfolio snapshots are generated.
  6. Benchmark data is collected (if benchmarks are configured).
  7. Dividend history is synced for your holdings.

This processing happens in the background and typically takes 30 seconds to a few minutes depending on the number of transactions and tickers.

Import wizard - success step

info

You can navigate away from the import page while processing is underway. Your portfolio will update automatically when processing completes.

Step 6: Verify Your Import​

After processing completes:

  1. Go to your portfolio page.
  2. Check that all expected holdings appear in the holdings table.
  3. Click on individual holdings to verify transaction counts and quantities.
  4. Review the portfolio summary cards for reasonable values.

Handling Import Issues​

Duplicate Detection​

Metrifly identifies potential duplicates by comparing:

  • Ticker symbol
  • Transaction date
  • Quantity
  • Price

If a row matches all four fields with an existing transaction, it is flagged as a duplicate (amber). You can still import it if it is genuinely a separate transaction (e.g., you bought the same stock twice on the same day at the same price).

Invalid Rows​

Common reasons for invalid (red) rows:

  • Missing ticker symbol
  • Unparseable date format
  • Non-numeric quantity or price
  • Unrecognised transaction type

Fix: Correct the issues in your source file and re-upload. Invalid rows are not imported but do not block valid rows from importing.

Partial Imports​

If some rows are invalid, Metrifly imports only the valid rows. You can fix and re-import the invalid rows separately.

Tips for a Smooth Import​

  1. Start with a small test -- Import a few transactions first to verify the mapping is correct before importing your full history.
  2. Check date formats -- If dates are being parsed incorrectly, adjust the format in your spreadsheet before uploading.
  3. One file per portfolio -- Each import goes into the currently selected portfolio. Switch portfolios before importing if you have trades for different portfolios.
  4. Include fees -- If your broker export includes brokerage fees, map that column so your cost basis is accurate.
  5. Currency column -- If your file has trades in multiple currencies, ensure the currency column is mapped correctly.

Troubleshooting​

ProblemSolution
File upload failsCheck that your file is under 5 MB and is a .csv or .xlsx file.
All rows show as invalidYour column mapping may be incorrect. Go back to the mapping step and verify each field.
Dates are wrongYour date format may not be auto-detected correctly. Try reformatting dates to YYYY-MM-DD in your spreadsheet.
Holdings are missing after importProcessing happens in the background. Wait 1-2 minutes and refresh the page.
Quantities or prices look wrongCheck if your broker uses total amounts vs per-share prices. Ensure the correct column is mapped to "Price".
Duplicate warning for new transactionsIf the ticker, date, quantity, and price all match an existing transaction, it is flagged. Import it if it is a separate trade.