Portfolio mobile is a product of Bare Reef. Visit our website to check out the other great apps we offer.
Please direct bug reports, feature requests and other questions and comments to
© Bare Reef LLC 2013
Import / Export
Import / Export
The Portfolio mobile web portal found at www.portfoliomobile.com/portal-login supports file import in CSV, OFX, QFX and QIF formats. To import a file in one of these formats, login using your online credentials and click the Import toolbar item. Select the target file and import mode, and click the Import button. The import mode controls how the existing position data is treated during import. Options exist for various types of replacement and update.
The import process will attempt to identify recent prices in your import files and update corresponding quotes in your data. Additional fields for CSV import are described below. OFX and QFX files may contain the last price for current positions. Inclusion of this data is dependent on the broker and is not guaranteed. Brokers do not provide change, open, close, volume or a corresponding date for the price data. During import quotes are matched by ticker symbol and assigned today’s date.
Comma-Separated Values (CSV)
Portfolio mobile expects transactions in comma-separated values (CSV) format with fields specifying stock ticker symbol (empty for manual equities), the name of the stock, the name of the enclosing portfolio and transaction attributes. Transactions are defined by the fields date, type (or action), price, quantity, fee and exchange rate.
Column headers must match the acceptable types listed above – see below for an example.
Use of spreadsheet applications such as Microsoft Excel and Apple Numbers can ease the complexity of creating valid CSV files.
Portfolio mobile understands the following transaction types for stocks:
Portfolio mobile understands the following transaction types for options:
Portfolio mobile understands the following transaction types for bonds:
To record a cash account transaction omit values for the ticker field, and provide the portfolio and account names accordingly. Portfolio mobile understands the following cash transaction types:
Cash Account Attributes
Portfolio mobile supports adding multiple cash accounts to a portfolio. By including the optional ‘Account’ you can name these accounts and define which account cash transactions are added to.
Portfolio mobile accepts several stock-specific attributes including symbol, name, service, market, currency, favorite, sector and industry. These columns should be identified appropiately by the labels: Symbol, Name, Service, Market, Stock Currency, Sector and Industry, respectively.
Service should be one of: Bloomberg, Borse, Euronext, Google, Morningstar, MSN, Reuters or Yahoo. Euronext stocks should additionally define one of the reference markets supported by Euronext (AMS, BRU, GBR, LIS, LON, PAR, USA) in the market field. For non-US stocks served by Yahoo, you may need to specify a specific Yahoo server (eg. Yahoo – United Kingdom).
Stock currency should be entered as the 3 letter abbreviation for the currency (eg. USD for US Dollar).
Additional fields exist to support bond and option instruments. Option instruments can be imported using the following fields:
Bond instruments can be imported using the following fields:
Date and Value Formats
Portfolio mobile expects all numeric values to use ‘.’ (dot) decimal point notation. Dates can be formatted in any known format that includes month, day, year, hour and second. If using the mm/dd/yyyy format you should always put month first (ie. do not use the dd/mm/yyyy format). Time is necessary to disambiguate transaction ordering (ie. sell after buy).
All numeric values should be positive with the exception of the price value for Misc transactions and the quantity value for Transfer transactions (for instance the price value for a Fees transaction should be positive not negative).
If you are trading instruments in a different currency than your portfolio you should specify an appropriate value for the exchange rate field. This is used to convert from the stock trading currency to your portfolio currency.
Purchase (and sale) prices are always defined in the stock trading currency.
Fees are always defined in your portfolio currency.
Example: Joe lives in the US but trades several German stocks in Euro. His portfolio is based in US Dollars. To record a buy transaction he would specify the exchange rate to be around 1.4, the purchase price of €14.50 in Euro and a fee of $9.00 in US Dollars.
Stock Quote Attributes
The following quote-related fields may be added to CSV import files: Date, Last, Change, Percent, Open, Close, and Volume. The Date field is shared amongst transactions and quote data. If you plan to mix price and trade importing, and your quote data is more recent than the last trade date, include quote data in a final row after the stock’s transactions to ensure that the correct date is assigned. In import files containing multiple quote records for the same ticker symbol, the last record in the file will be used.
It is usually a good idea to wrap each field value in quotes to prevent commas in from indicating the end of a field prematurely. Most spreadsheet applications will do this for you automatically.