Format of the Transactions CSV File

When importing transactions from a CSV file, StockMarketEye expects the transactions to be in a specific format. This format is described below.

When exporting from the Transactions report using the option, "Export columns necessary for re-import into StockMarketEye", the format of the generated CSV file will be the same as the format described below. You may wish to first export transactions from a different portfolio, then use the exported CSV file as an example when creating your own new file.

CSV Import Format

StockMarketEye reads your investment data from the CSV file, one transaction per line. The data contained in each line of the CSV file must meet the specifications described in the sections below.

All columns must be present in each line of the CSV file.
Column values are required for "Date" and "Type" fields.
Column values for the other columns are optionally required, depending on the type of transaction being recorded. See the “Descriptions” below for details.
The order of the columns in the CSV file must be the same as that specified below. See the example file if you are unsure.
You may include a “header” line in the CSV file, but it is not required. If the header line is included, the first cell must contain the word “date”.

You can generate an example CSV file by exporting transactions from the Transactions report. When doing this, be sure to use the option, "Export columns necessary for re-import into StockMarketEye" is checked.

Column Descriptions

Column	Description
Date	The date of the transaction. This column is mandatory and must always contain a valid date. StockMarketEye will try to automatically detect the date format. However, the import screen also has a "Date Format" dropdown that you can use to select the specific date format used in your file. If the date format used in your CSV file is not listed in the "Date Format" dropdown, StockMarketEye will be able to automatically detect and properly parse the date. Some of the automatically detected date formats are: MM/DD/YY or MM/DD/YYYY (ex. 07/4/2010 for July 4th, 2010) MMM D, YYYY (ex. July 4, 2010) YYYY-MM-DD (ex. 2010-07-04) YYYY-MM-DD'T'HH:mm:ss.SSSZZ (ex. 2019-01-02T22:19:00.000-06:00)
Type	The type of the transaction. This column is mandatory and must always contain a valid transaction type. The following transaction types are available. BUY SELL SELL LOT (Note: transaction types with "LOT" at the end relate to a specific lot of the current holding. The "Linked UUID" field of the "LOT" transaction must match the "UUID" field of the corresponding purchase transaction for the lot being removed.) SELL SHORT COVER SHORT COVER SHORT LOT SHARES IN SHARES OUT SHARES OUT LOT DIVIDEND DIVIDEND REINVEST CAPGAIN CAPGAIN REINVEST RETURN OF CAPITAL SPLIT CORPORATE ACTION CASH IN CASH OUT INTEREST IN (Note: can relate to either a specific holding [such as interest paid by a specific fund] or to the portfolio in general [such as interest paid by the Cash balance].) INTEREST IN REINVEST (Note: relates to a specific holding that pays interest.) INTEREST OUT (Note: can relate to either a specific holding [such as interest paid by a specific fund] or to the portfolio in general [such as interest paid by the Cash balance].) OTHER IN OTHER OUT FEES (Note: this transaction type refers to management fees for the portfolio as a whole.)
Symbol	The ticker symbol connected with this transaction. You must specify a value for this column (i.e. a ticker symbol) for every transaction unless the transaction type is cash related (CASH IN, CASH OUT, INTEREST IN, INTEREST OUT, OTHER IN, OTHER OUT, FEES). If the transaction type is cash related, this column can be empty or can contain the word “Cash”.
Shares	The number of shares associated with this transaction. Whole and decimal numbers are accepted. This column is not used when the transaction type is cash related or for DIVIDEND, CAPGAIN or RETURN OF CAPITAL transactions. For SPLIT transactions, this column must contain the split ratio as a decimal number (i.e 2-for-1 split is 2.0). For CORPORATE ACTION transactions, this column must contain the share ratio as a decimal number.
SharePrice	The price per share of this transaction. This column is not used when the transaction type is cash related or for DIVIDEND, CAPGAIN, RETURN OF CAPITAL or SPLIT transactions. If this column is empty, StockMarketEye will lookup the price of the stock on the transaction date and use the closing price from that date as the price/share. For CORPORATE ACTION transactions, this column must contain the basis percentage as a decimal number. If this security trades in British Pence, the value in this column should be the price in Pence (i.e. 237 Pence, not 2.37 Pounds) and the Currency column should be GBX. In this case, all other columns, with the exception of DivAmount, are specified in Pounds (GBP).
Costs	This column specifies any costs or commissions associated with the transaction. If this column is empty, the costs for this transaction are set to 0.
Fees	This column specifies any fees associated with the transaction. If this column is empty, the fees for this transaction are set to 0. Note that fees associated with the portfolio (such as management fees/charges), should be specified with a FEES transaction.
Total Amount	The total amount of the transaction, including costs and fees. This is the Net Total amount of the transaction. A value in this column is mandatory for CASH IN, CASH OUT, DIVIDEND, RETURN OF CAPITAL, CAPGAIN, INTEREST IN, INTEREST OUT, OTHER IN, OTHER OUT, and FEES transactions. This column is not used when the transaction type is SPLIT. For all other transactions, if no value is specified, the value will be computed from the price/share, shares, costs and fees columns.
DivAmount	The amount of the distribution per share. This column is only used for distribution transactions such as DIVIDEND, CAPGAIN, RETURN OF CAPITAL and their re-investment equivalents. It is for informational purposes and can be left blank.
ShareAffected	The number of shares affected by a distribution (DIVIDEND, CAPGAIN, RETURN OF CAPITAL and their re-investment equivalents) or SPLIT transaction. This column is for informational purposes and can be left blank.
Currency	The currency of the transaction. If this field is left blank, the import will determine the currency based on the symbol (if this is a symbol specific transaction) or take the currency of the portfolio (if this is a cash transaction). If the security trades in British Pence, use GBX as the currency in this field and enter the SharePrice in Pence. The RateCurrency field would still be GBP (Pounds) if your portfolio's currency is Pounds.
Rate	The exchange rate between the currency of this transaction and the Portfolio’s currency on the date of the transaction. If your transactions and Portfolio are in the same currency, this column can be left blank. Defaults to 1 if left blank.
Cash Affected	Were the proceeds of this transaction added/deducted from the Portfolio’s cash balance? Can be specified with ‘yes’ or ‘no’ (or ‘true’ / ‘false’). If this field is empty, the import function will determine the proper value.
Name	The full name of the security specified in the "Symbol" field. If this field is empty, the import function will search for a name.
Comment	Any comments you want to remember about this particular transaction, up-to a limit of 10240 characters. This column is optional and can be left blank.
Brokerage Id	The ID of this transaction at the brokerage. This field will be filled in by StockMarketEye when exporting transactions that have been imported from a brokerage. This column is optional and can be left blank.
Taxes	The taxes associated with this transaction. This field is only used for distribution transactions (DIVIDEND, CAPGAIN, RETURN OF CAPITAL and their re-investment equivalents). This column is optional and can be left blank.
Credits	The credits/franking associated with this transaction. This field is only used for distribution transactions (DIVIDEND, CAPGAIN, RETURN OF CAPITAL and their re-investment equivalents). It is for informational purposes only and is not used in any performance calculation. This column is optional and can be left blank.
RateCurrency	The currency to which the exchange "Rate" value converts. Typically this is the currency of the portfolio. This column is optional and can be left blank.
ACB per share	The Average Cost Basis value per share of this transaction. This field is only used in sell transactions (SELL, SELL LOT, SHARES OUT, SHARES OUT LOT, COVER SHORT, COVER SHORT LOT). This column is optional and can be left blank.
UUID	The unique identifier for this transaction. You can use sequential numbers or generate a universally unique identifier. This column is optional and can be left blank. If left blank, StockMarketEye will generate the identifiers for you.
Linked UUID	The unique identifier of any linked transaction. This field is used for "LOT" type transactions (SELL LOT, COVER SHORT LOT, SHARES OUT LOT). The identifier in this field must match the "UUID" field of the corresponding purchase transaction for the lot being removed. This column is optional and can be left blank.
Use Rate Ccy	This field determines if the Total, Costs, Fees, Taxes, and Credits values are specified in the "Rate Currency". Can be specified with ‘yes’ or ‘no’ (or ‘true’ / ‘false’). Typically the values in these fields are in the same currency as the currency of the transaction ("Currency" field), which is either the currency of the security or the currency of the portfolio, depending on the transaction type. This is the case for mono-currency portfolios (i.e. where all holdings and the currency of the portfolio are the same). In these standard situations, the value of the "Use Rate Ccy" field should be "false". However, this field can be used to denote that the currency for these fields is determined by the "RateCurrency" column. This can be useful for portfolios with holdings in multiple currencies where the brokerage calculates these values in your account's currency. Defaults to 'false' (i.e. the values in these fields are in the currency specified in the "Currency" field).
Provider	The data provider for the ticker Symbol field. Values can be NONE, YAHOO or MSN. This column is optional and can be left blank (recommended).