Importing Investment Data from a CSV File (Old Format)
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.
|Transaction Date||Transaction Type||Symbol||Shares||Price/Share||Costs||Amount||Distribution Amount||Shares Affected||Comment||Exchange Rate||Currency||Cash Affected||Name|
The following table describes the columns of the StockMarketEye CSV file format (old version) in greater detail.
|Transaction Date||Value is|
|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|
|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.|
|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”.
|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).
|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.
|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.
|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|
|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|
|The number of shares affected by a distribution or SPLIT transaction. This column is for informational purposes and can be left blank.|
|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|
|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.
|The currency of the transaction. This field can be left blank and|
will be determined by the import mechanism.
|Cash Affected||Value is|
|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.
|The full name of the company whose stock this transaction concerns.|
If this field is empty, the import function will lookup the proper
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.
- Open StockMarketEye and use the menu: File -> Import Portfolio -> Import from CSV…
- 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.
- 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.
- 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.
- The investment data has now been imported into the selected portfolio.