Importing Investment Data from a CSV File (Old Format)

Warning

This section pertains to the CSV data format from StockMarketEye v2. The latest version of StockMarketEye no longer produces this format. StockMarketEye can still import files that are in this format, however, but if you are creating new files, you are encouraged to use the newest CSV format.

CSV Import Format Notes

  • StockMarketEye reads your investment data from the CSV file, one transaction per line.
  • The order of the columns in the CSV file must be the same as that specified in the table below. See the example file if you are unsure.
  • You may include a “header” line, but it is not required. If the header line is included, the first cell must contain the word “date”.
  • All columns must be present in the CSV file, for each line in the file. Values are mandatory for the columns in bold. Values for the other columns are optionally required, depending on the type of transaction being recorded. See the detail descriptions below for details.

Column Order

Transaction Date Transaction Type Symbol Shares Price/Share Costs Amount Distribution Amount Shares Affected Comment Exchange Rate Currency Cash Affected Name

Column Descriptions

The following table describes the columns of the StockMarketEye CSV file format (old version) in greater detail.

Column Usage Description
Transaction Date Value is mandatory

The date of the transaction.

Available date formats are:

  • MM/DD/YY or MM/DD/YYYY (ex. 07/4/2010 for July 4th, 2010)
  • YYYY-MM-DD (ex. 2010-07-04)
  • MMM D, YYYY (ex. July 4, 2010)

This column is mandatory and must always have a value specified.

Transaction Type Value is mandatory

The type of the transaction.

Available transaction types are:

  • BUY
  • SELL
  • SELL SHORT
  • COVER SHORT
  • CASH IN
  • CASH OUT
  • DIVIDEND
  • DIVIDEND REINVEST
  • INTEREST IN
  • INTEREST OUT
  • SHARES IN
  • SHARES OUT
  • SPLIT
  • CAPGAIN
  • CAPGAIN REINVEST
  • RETURN OF CAPITAL
  • OTHER IN
  • OTHER OUT

This column is mandatory and must always have a value specified.

Symbol Value is mandatory

The symbol connected with this transaction.

You must specify a symbol for every transaction unless the transaction type is cash related (CASH IN, CASH OUT, INTEREST IN, INTEREST OUT, OTHER IN, OTHER OUT). If the transaction type is cash related, this column can be empty or can contain the word “Cash”.

Shares Value is optional

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).

Price/Share Value is optional

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.

Costs Value is optional

This column specifies any costs (fees or commissions) associated with the transaction.

If this column is empty, the costs for this transaction are set to 0.

Amount Value is mandatory for cash transactions.

The amount of the transaction, not including costs.

A value in this column is mandatory for CASH IN, CASH OUT, DIVIDEND, RETURN OF CAPITAL, CAPGAIN, INTEREST IN, INTEREST OUT, OTHER IN, and OTHER OUT transactions.

This column is not used when the transaction type is SPLIT.

For all other transactions, the amount is calculated from the price/share and shares columns.

Distribution Amount Value is optional

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.

Shares Affected Value is optional

The number of shares affected by a distribution or SPLIT transaction.

This column is for informational purposes and can be left blank.

Comment Value is optional

Any comments you want to remember about this particular transaction, up-to a limit of 2048 characters.

This column is optional and can be left blank.

Exchange Rate Value is optional 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.
Currency Value is optional The currency of the transaction. This field can be left blank and will be determined by the import mechanism.
Cash Affected Value is optional 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 Value is optional The full name of the company whose stock this transaction concerns. If this field is empty, the import function will lookup the proper name.

Importing a CSV Investment Transaction File

Once you have created a CSV file containing your investment transactions, you can import it into StockMarketEye with the following steps.

  1. Open StockMarketEye and use the menu: File -> Import Portfolio -> Import from CSV...

    Open the portfolio CSV import wizard
  2. In the “Import CSV Investment Transactions” window, click on the “Browse” button to help select the CSV file containing the investment data that you want to import. Once you have found the file, select it and click OK. The file’s name should now be in the “CSV Investment Transactions File” field.

    This data will be imported into a new or existing StockMarketEye portfolio that you select in Step #4.

    Once you have entered an existing CSV (old V2 format) investment data file, be sure to select the “StockMarketEye old (v2) format” so that StockMarketEye can properly read your transactions. Click on the “Next” button to move to the next step.

    Select the CSV file to import into StockMarketEye
  1. Map the symbols found in the import file to symbols known to StockMarketEye.

    Stock (or ticker) symbols often differ between applications. In this step you can convert the stock symbols that were found in the import file into symbols known to StockMarketEye.

    Before moving to the next step, you must accept each symbol mapping by checking its “Accepted” box.

    If the box is initially checked, it has been mapped automatically by StockMarketEye.

    If the box is initially unchecked, there was no direct match to a StockMarketEye symbol.

    You can modify the mapped, StockMarketEye symbol by clicking on the “Modify” button. This will open the Symbol Search window where you can search for the correct symbol. Clicking “Ok” in the Symbol Search search window will use the selected “Search Result” as the mapped, StockMarketEye symbol. If you click “Ok”, but have not selected one of the “Search Results”, the search query itself will be used as the mapped, StockMarketEye symbol. This allows you to enter and use unrecognized ticker symbols.

    Note that you don’t need to have a valid ticker symbol for each entry, but you do need to accept all of the mappings before continuing. Unrecognized symbols (ex. obsolete or non-existent ticker symbols) are OK to include in the mapping and are often useful for including items in your portfolio which do not have a ticker symbol (ex. bonds, preferred stock, etc). Note, however, that StockMarketEye will not be able to get historical or current quotes for these symbols which can affect performance calculations and the Portfolio’s historical value chart.

    You can reset the mapped, StockMarketEye symbol to its original, unmapped symbol using the “Reset” button. This will uncheck the symbol’s “Accepted” button and reset the StockMarketEye symbol to the symbol from import.

    When all of the symbols have been mapped and accepted, click on the “Next” button to move to the final step.

    Map the import symbols to corresponding StockMarketEye symbols
  2. Finish the import of the investment data by selecting a portfolio into which the data will be added. You can either select an existing portfolio, or create a new one.

    Click on the “Finish” button to complete the import.

    Confirm and finish the import.
  3. The investment data has now been imported into the selected portfolio.

    After the portfolio CSV import.

Try it for Free!

Try our software, free, for 30-days. No credit-card or email required.
Just download, install and run.

Get StockMarketEye Try it for free!
Available for:  Investment Management Software for Windows 8 / 7 / Vista / XP      Investment Management Software for Mac OS X      Investment Management Software for Linux      Investment Management Software for iOS Investment Management Software for Android