Help‎ > ‎mStocks Help‎ > ‎

Importing Transactions

posted Nov 22, 2015, 1:17 PM by Admin Manager   [ updated Dec 6, 2015, 9:03 AM ]
Importing allow you to load transactions into mStocks+ from your brokerage account or other data sources. The instructions below are important to make sure that the import file you use meets the format that mStocks+ needs to correctly interpret the data. 

- - - - - - - - 

Import File 

The file that you use for importing into mStocks+ needs to be in a comma separated value (CSV) format. This file can be created in Microsoft Excel or Apple Numbers. The columns in this file should contain, at a minimum, the import fields specified below. If there happens to be extra data (columns), this is ok. When you perform the import you can tell mStocks+ which fields should be used and the others will be ignored. The import file can also have a header row that specifies the data column names. The header row can be marked to be ignored when the import if performed. 

Import Fields  

Only the following import fields will be loaded into mStocks and they MUST have corresponding columns in the CVS import file.
  • SYMBOL 
  • TRANSACTIONTYPE 
  • DATE 
  • SHARES 
  • PRICE 
  • AMOUNT
  • FEES
  • EXCHANGERATE
  • NOTES
It is important to note that before you run an import, you should make sure that you have added the symbols being importing into your symbols list. You will get an error message if a symbol in the import file is not found in your symbols list. This rest of the symbols will be loaded, but those not found will be skipped.

Transaction Types

For some transactions types, import fields can be zero or blank. The TRANSACTIONTYPE must one of the following values. Other values will be ignored and the record will not be imported.
  • DEPOSIT - cash deposits 
  • WITHDRAW - cash withdrawals 
  • BUY - stock purchases 
  • SELL - stock sales (assumed to be FIFO) 
  • SPLIT - stock splits 
  • REINVESTMENT - reinvested dividends 
  • DIVIDEND - cash dividends 
  • INTEREST - interest payments 
  • EXPENSE - transaction costs or other expenses 
For each transaction type that you import, you need to make sure that the certain fields have values in the import record. These requirements are as follows. Note that fields not listed for transactions will be ignored. Note that the other fields also need to be there, but they are ignored.

DEPOSIT
  • SYMBOL - IGNORED
  • TRANSACTIONTYPE - Must be "DEPOSIT"
  • DATE - date of deposit
  • SHARES - IGNORED 
  • PRICE - IGNORED 
  • AMOUNT - amount of deposit 
  • FEES - IGNORED
  • EXCHANGERATE - IGNORED
  • NOTES - notes for the transaction
WITHDRAW
  • SYMBOL - IGNORED
  • TRANSACTIONTYPE - Must be "WITHDRAWL"
  • DATE - date of withdrawl
  • SHARES - IGNORED 
  • PRICE - IGNORED 
  • AMOUNT - amount of withdrawal 
  • FEES - IGNORED
  • EXCHANGERATE - IGNORED
  • NOTES - notes for the transaction
BUY
  • SYMBOL - symbol that was purchased 
  • TRANSACTIONTYPE - Must be "BUY"
  • DATE - date of stock purchase 
  • SHARES - number of shares purchased 
  • PRICE - acquisition price 
  • AMOUNT - IGNORED
  • FEES - transaction fees
  • EXCHANGERATE - Exchange Rate (can be zero)** 
  • NOTES - notes for the transaction
SELL
  • SYMBOL - symbol that was sold 
  • TRANSACTIONTYPE - Must be "SELL"
  • DATE - date of stock sale 
  • SHARES - number of shares sold 
  • PRICE - sale price
  • AMOUNT - IGNORED
  • FEES - transaction fees
  • EXCHANGERATE - Exchange Rate (can be zero)** 
  • NOTES - notes for the transaction
  •         (note - all sales transactions are imported as FIFO) 
SPLIT
  • SYMBOL - symbol that was spit 
  • TRANSACTIONTYPE - Must be "SPLIT"
  • DATE - date of stock split 
  • SHARES - split ratio 1 
  • PRICE - split ratio 2 
  • AMOUNT - IGNORED
  • FEES - IGNORED
  • EXCHANGERATE - IGNORED
  • NOTES - notes for the transaction
  •      (e.g. Split 1 for 7 would be shares = 1 and price = 7) 
REINVESTMENT
  • SYMBOL - symbol that was reinvested 
  • TRANSACTIONTYPE - Must be "REINVESTMENT"
  • DATE - date of reinvestment 
  • SHARES - number of shares reinvested 
  • PRICE - acquisition price 
  • AMOUNT - IGNORED
  • FEES - transaction fees
  • EXCHANGERATE - Exchange Rate (can be zero)** 
  • NOTES - notes for the transaction
DIVIDEND
  • SYMBOL - symbol that received the dividend  (can be blank)
  • TRANSACTIONTYPE - Must be "DIVIDEND"
  • DATE - date of dividend 
  • SHARES - IGNORED
  • PRICE - IGNORED
  • AMOUNT - cash amount received 
  • FEES - IGNORED
  • EXCHANGERATE - IGNORED
  • NOTES - notes for the transaction
INTEREST
  • SYMBOL - symbol that received the interest  (can be blank)
  • TRANSACTIONTYPE - Must be "INTEREST"
  • DATE - date of interest 
  • SHARES - IGNORED
  • PRICE - IGNORED
  • AMOUNT - cash amount received 
  • FEES - IGNORED
  • EXCHANGERATE - IGNORED
  • NOTES - notes for the transaction
EXPENSE
  • SYMBOL - symbol that received the expense (can be blank)
  • TRANSACTIONTYPE - Must be "EXPENSE"
  • DATE - date of expense 
  • SHARES - IGNORED
  • PRICE - IGNORED
  • AMOUNT - cash amount paid 
  • FEES - IGNORED
  • EXCHANGERATE - IGNORED
  • NOTES - notes for the transaction
** Note that the exchange rate will be looked up based on current currency rates for the symbol being imported if you don't specify a value in the import file.  We allow for importing of exchange rates as these rates vary over time. The rate should be the exchange rate at the time you purchased the shares.  Note, you don't need to worry about exchange rates if you are purchasing stocks in the same currency as that specified in the Base Currency field in the preferences.

- - - - -

For examples purposes, your import file would should something like the following:

,DEPOSIT,1/1/2015,0,0,50000,0,0,notes
AAPL,BUY,1/15/2015,100,72.50,0,9.99,0,notes
AAPL,EXPENSE,1/15/2015,0,0,9.99,0,0,notes
MSFT,BUY,1/15/2015,500,39.00,0,9.99,0,notes
MSFT,EXPENSE,1/15/2015,0,0,9.99,0,0,notes
AAPL,DIVIDEND,6/1/2015,0,0,350.00,0,0,notes
MSFT,REINVESTMENT,6/1/2015,12,45.00,0,0,0,notes

There is a sample download file on our website...

ċ
Transactions.csv
(0k)
Admin Manager,
Dec 6, 2015, 8:59 AM
Comments