Comma Separated Values (CSV) Import Format

This document outlines the fields expected by Portfolio mobile for CSV file import. This file format combines the import of several types of data in a single line therefore it’s essential that column names match up correctly with their associated data. Please review the column names for each data type below.

Portfolio mobile may alert you to errors as it encounters them during import. The app will report line numbers and details about the attempted record import to help you identify where the error occurred. Please note that every row in the CSV file must contain a cell for every column. In other words, if your file has columns to specify Ask and Bid price then at a minimum your CSV file should have a placeholder for that value (represented by a comma) even if you are specifying a record that does not have an ask or bid price such as a deposit to a cash account. In previous versions this was not a necessity but now it will cause importing to fail.

Several fields may be omitted for brevity. Where applicable, Portfolio mobile will substitute the word “Import”. For example, a CSV file that does not specify a column for portfolio name will import all equities into a portfolio called “Import.”

Importable Record Types

Each of the record types below correspond to the organization of data in Portfolio mobile. At the highest level, Portfolio mobile supports two importable record types: Broker Accounts and Watchlists. Broker Accounts may contain any number of Portfolio and Cash Accounts. Portfolios and Watchlists may contains any number of Equities (Stock, Bond, Mutual Fund, etc). Equities track Trades and Cash Accounts track Transactions. All of the aforementioned record types are importable in CSV format.

Because CSV is a flat representation format, Portfolio mobile uses names to create hierarchy amongst your data. For example, to ensure that equities are grouped together in a portfolio you need to ensure you have given every row related to that equity the same values for broker account and portfolio names.

For each of the following sections, a table will display the name of the field as it corresponds to its record type, the value that should be entered in the first row of the CSV file (the header row), and description of the field. Some fields recognize multiple header values. Alternative header values are shown in parentheses – pick one of the options, do not put the entire string with parentheses. For example, the equity symbol field can be specified as Symbol or Ticker. You want to put either the word “Symbol” or the the word “Ticker”, not both.

Broker Account Fields

Field CSV Header Description
Name Broker The name of the target broker account
Currency Broker Currency The currency of the target broker account

Portfolio Fields

Field CSV Header Description
Name Portfolio The name of the target portfolio
Currency Portfolio Currency The currency of the target portfolio

Equity Fields

The following are generic fields that can be applied to any equity type. Equity type-specific fields exist for bonds, options and mutual funds as outlined below.

Field CSV Header Description
Symbol Symbol (Ticker) The symbol of the import equity
Service Service The online service of the import equity. This service will be used to automatically set services for quotes, price history and RSS
Name Name The name of the import equity
Type Equity Type One of [ Stock, Bond, Option, Mutual Fund, Future, Commodity ]
Currency Currency The currency of the import equity

Bond Fields

Field CSV Header Description
Coupon Rate Coupon (Interest Rate) The coupon or interest rate for the import bond
Face Value Face The face value for the import bond
Maturity Date Maturity The maturity date for the import bond
Number of Payments Payments The number of payments per period for the import bond
Term Length Term The term length for the import bond – typically the number of years. The number of payments is per term.

Option Fields

Field CSV Header Description
Option Type Option Type The option type for the import option. Either Call or Put
Strike Price Strike The strike price for the import option
Option Expiration Date Expiration The expiration date for the import option

Equity Quote Fields

The following fields are used when importing quote data. These fields are optional.

Field CSV Header Description
Last Trade Date Last Date (Trade Date) The last trade date of the import equity quote
Last Trade Price Last (Last Price) The last trade price of the import equity
Change Change The change of the import equity
Change % Change % (Change Percent) The change % of the import equity
Open Price Open The open price of the import equity
Previous Close Price Close (Previous) The previous close price of the import equity
Intraday High High The intraday high price of the import equity
Intraday Low Low The intraday low price of the import equity
52 Week High High 52 The 52 week high price of the import equity
52 Week Low Low 52 The 52 week low price of the import equity

Trade Fields

Field CSV Header Description
Date Date The date of the trade
Type Type One of the trade types [Basis Adjustment, Buy, Buy to Close, Buy to Open, Corporate Action, Cover, Dividend, Exchange, Fee, Interest, Issued Option, Misc, Reinvest, Reverse Split, Sell, Sell to Close, Sell to Open, Short, Split, Tax, Transfer] *
Quantity Quantity The number of shares associated with the trade
Price Price The price of associated with the trade (eg. purchase price)
Fee Fee Fees associated with the activity
Commission Commission Any commission taken on the trade
Amount Amount The amount of the associated activity. The amount is used when importing non-trade transaction types for an equity (eg. Dividend, Corporate Action, Misc).
Comment Comment A comment to be stored with the trade for reference purposes
Split Ratio Numerator Split Numerator (Split Out) The numerator in the ratio of shares received for shares owned when splitting (eg. 3 in a 3-for–1 split).
Split Ratio Denominator Split Denominator (Split In) The denominator in the ratio of shares received for shares owned when splitting (eg. 1 in a 3-for–1 split).

* While all equity types may make use of the trade types listed above, some exist for specific equity types only. Bonds may make use of the additional ‘Retire’ trade type. Options may additionally use ‘Open’, ‘Exercise’, and ‘Write’ types.

Cash Account Fields

Field CSV Header Description
Name Cash The name of the target cash account
Currency Cash Currency The currency of the target cash account

Transaction Fields

Field CSV Header Description
Date Date The date of the transaction
Type Type One of the transaction types [Adjustment, Deposit, Dividend, Fee, Funds In, Funds Out, Interest, Misc, Tax, Transfer, Withdrawal]
Fee Fee Fees associated with the activity
Amount Amount The amount of the transaction
Comment Comment A comment to be stored with the trade for reference purposes

Watchlist Fields

Field CSV Header Description
Name Watchlist The name of the target watchlist