![]() ![]() Stock (or ticker) symbols often differ between applications. Map the symbols found in the import file to symbols known to StockMarketEye.Click on the “Next” button to move to the next step. 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. This data will be imported into a new or existing StockMarketEye portfolio that you select in Step #4. The file’s name should now be in the “CSV Investment Transactions File” field. Once you have found the file, select it and click OK. 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.Open StockMarketEye and use the menu: File -> Import Portfolio -> Import from CSV….Once you have created a CSV file containing your investment transactions, you can import it into StockMarketEye with the following steps. Importing a CSV Investment Transaction File If this field is empty, the import function will lookup the proper The full name of the company whose stock this transaction concerns. If this field is empty, the import function will Portfolio’s cash balance? Can be specified with ‘yes’ or ‘no’ (or Were the proceeds of this transaction added/deducted from the Will be determined by the import mechanism. Transactions and Portfolio are in the same currency, this column can Portfolio’s currency on the date of the transaction. The exchange rate between the currency of this transaction and the This column is optional and can be left blank. This column is for informational purposes and can be left blank.Īny comments you want to remember about this particular transaction, The number of shares affected by a distribution or SPLIT transaction. It is for informational purposes and can be left blank. This column is only used for distribution transactions such asĭIVIDEND, CAPGAIN, RETURN OF CAPITAL and their re-investmentĮquivalents. The amount of the distribution per share. For all other transactions, the amount is calculated from the This column is not used when the transaction type is SPLIT. RETURN OF CAPITAL, CAPGAIN, INTEREST IN, INTEREST OUT, OTHER IN, and A value in this column is mandatory for CASH IN, CASH OUT, DIVIDEND, The amount of the transaction, not including costs. If this column is empty, the costs for this transaction are set to 0. This column specifies any costs (fees or commissions) associated ![]() This column is not used when the transaction type is cash related orįor DIVIDEND, CAPGAIN, RETURN OF CAPITAL or SPLIT transactions. For SPLIT transactions, this column must contain the split ratio asĪ decimal number (i.e 2-for-1 split is 2.0). This column is not used when the transaction type is cash related orįor DIVIDEND, CAPGAIN or RETURN OF CAPITAL transactions. The number of shares associated with this transaction. If the transaction type is cash related, thisĬolumn can be empty or can contain the word “Cash”. Type is cash related (CASH IN, CASH OUT, INTEREST IN, INTEREST OUT, You must specify a symbol for every transaction unless the transaction The symbol connected with this 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. July 4, 2010) This column is mandatory and must always have a value specified. Available date formats are: MM/DD/YY or MM/DD/YYYY (ex. The following table describes the columns of the StockMarketEye CSV file format (old version) in greater detail. See the detail descriptions below for details. Values for the other columns are optionally required, depending on the type of transaction being recorded. Values are mandatory for the columns in bold. All columns must be present in the CSV file, for each line in the file.If the header line is included, the first cell must contain the word “date”. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |