Import Transactions

You can easily import your transactions from your broker or anywhere else. Here's how you do it.

App

Open Profile and select the Settings icon in the top right. Select Data, then Import Transactions.

You can import CSV- and Excel-Files

CSV-Files have to be delimited by either , (comma) or ; (semicolon). Excel files have to be .xlsx-files and the data you want to import has to be on the first sheet.

Import into currently selected Watchlist

The transactions will be imported into your currently selected watchlist. Existing transactions in that watchlist will not be affected.

Existing transactions will get matched

To avoid duplicate transactions and to give you the ability to import your transactions over and over again, we will try to match existing transactions. If there is an existing transaction with the same symbol, date, price and quantity, we will not import it again.

Import Format

Use the column order shown below for the default Stock Events format. Start with Symbol, Date, Quantity and Price so Stock Events recognizes the template. You can also use Shares instead of Quantity and Amount instead of Price. Use positive quantities for buys and negative quantities for sells. If you include fees, keep the preceding columns in place, even when their cells are empty.

Symbol Date Quantity Price Price Currency Fees Percentage Fees Amount Fees Currency To Cash
AAPL 2020-10-01 5 116.96 USD 5.0 0.0 USD TRUE
AAPL 2020-10-05 -2.3 124.40 USD 0.0 5.34 USD TRUE
MSF.F 2020-10-02 8 215.81 EUR 25.0 0.0 EUR FALSE

Include a header row. Use dates such as 2020-10-01 (yyyy-mm-dd); yyyy/mm/dd, dd/mm/yyyy and dd.mm.yyyy are also supported. Use a dot for decimals, without thousands separators or currency symbols. For example, enter 2.54 under Fees Amount and CAD under Fees Currency.

To Cash is optional. In the example, buying 5 shares of AAPL deducts cash; selling 2.3 shares adds the proceeds to cash. The last purchase leaves cash unchanged. Stock Events exports include this column so you can import the file again.

Use TRUE, yes, y or 1 to include a trade in your cash balance, and FALSE, no, n or 0 to leave it out. Capitalization and surrounding spaces do not matter in these values or the To Cash header. If you leave the cell blank or omit the column, buys and sells do not change your cash balance. You can also name the column Deduct from Cash/Add to Cash.

If a cash value is not recognized, the whole import stops before changing any transactions, even if you selected the option to remove existing transactions. The error identifies the row, column and invalid value. Correct it and upload the file again. This column applies to the default format shown above.

Import stops when over your limit

Transactions over your current watchlist spots limit will not be imported. If you have more individual stocks in your import than you have watchlist spots available, we will import until the limit is reached. For unlimited spots, consider subscribing to Stock Events Pro.