← Support
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:

  • Basis Adjustment
  • Buy – Buy to open long position
  • Buy to Close – Buy to cover short position
  • Buy to Open – Buy to open long position
  • Cover – Buy to close short position
  • Dividend
  • Exchange
  • Fees
  • Interest
  • Misc
  • Reinvest – Reinvest dividend in new shares
  • Reverse Split
  • Short – Sell to open short position
  • Sell – Sell to close long position
  • Sell to Close – Sell to close long position
  • Sell to Open – Sell to open short position
  • Split
  • Tax
  • Transfer

Portfolio mobile understands the following transaction types for options:

  • Buy to Close – Buy to cover short position
  • Buy to Open – Buy to open long position
  • Exercise – Exercise open option contracts (price is zero for out of money)
  • Issued Option – Record options for shares you’ve received (usually from employer)
  • Sell to Close – Sell to close long position
  • Sell to Open – Sell to open short position
  • Write – Write option contracts

Portfolio mobile understands the following transaction types for bonds:

  • Buy
  • Retire
  • Sell

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:

  • Adjustment
  • Deposit
  • Fee
  • Funds In
  • Funds Out
  • Interest
  • Misc
  • Tax
  • Withdrawal

 

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.

 

Stock Attributes

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:

  • Option – 1 / yes / true
  • Option Type – CALL / PUT
  • Option Expiration
  • Option Strike

Bond instruments can be imported using the following fields:

  • Bond – 1 / yes / true
  • Bond Face Value
  • Bond Coupon Rate
  • Bond Maturity Date
  • Bond Periods
  • Bond Terms
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).

Foreign Trading

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.

Column List

Attribute Alternatives Description
Portfolio Portfolio / Watchlist Name of portfolio or watchlist that instrument (stock) or transaction belongs to
Watchlist Is Watchlist True / False (1 / 0) flag indicating if row represents a watchlist container or portfolio
Currency Portfolio Currency Currency of portfolio
Account Cash Account Name of cash account that transaction belongs to
Ticker Symbol or Instrument or Instrument Symbol or Instrument Ticker Ticker symbol for represented instrument (stock)
Instrument Currency Stock Currency Trading currency of instrument (stock)
Service Online service used to track this instrument (stock) – defaults to Yahoo
Name Instrument name Name of instrument (stock) represented in row
Date Date of transaction / trade
Type Transaction Type or Action Accepted transaction type in lists above
Price Price of trade or amount of cash transaction
Amount Amount of cash transaction
Quantity Volume Number of shares represented in trade
Fee Fees or commission for transaction
Exchange Rate Ex Rate or Exrate Exchange rate from instrument (stock) trading currency to portfolio currency at date of transaction
Reinvest Reinvested True / false (1 / 0) flag indicating if dividend transaction is accompanied by a Buy trade to fulfill reinvestment action
Shares Number of shares acted on
Split In Denominator in ratio of shares for split action
Split Out Numerator in ratio of shares for split action
Ex Div ExDiv or ExDivDate or Ex Dividend or Ex Dividend Date Ex-dividend date for dividend transaction
Option True / False (1 / 0) flag indicating that instrument is an option
Strike Option Strike Strike price for option represented in row
Option Type Type of option (Call / Put)
Expiration Option Expiration Expiration date for option represented in row
Bond Is Bond True / False (1 / 0) flag indicating that instrument is a bond
Maturity Date Bond Maturity Date Maturity date for bond represented in row
Face Value Bond Face or Bond Face Value Face value for bond represented in row
Coupon Coupon Rate or Bond Coupon Rate or Bond Rate or Bond Coupon Coupon rate for bond represented in row
Bond Periods Periods Number of periods of bond payments
Bond Terms Payment Terms or Terms Term (typically in years) for bond represented in row
Last Last Trade or Close Last trading price for instrument

Example

Spreadsheet
Portfolio Currency Account Symbol Name Date Type Quantity Price Fee Exchange Rate Service Stock Currency Sector Industry
My Portfolio USD Cash 1/1/08 10:00AM deposit 10000.00
My Portfolio USD AAPL Apple Computer 1/2/08 10:00AM buy 100 194.83 9.99 1.0 Yahoo USD Technology Personal Computers
My Portfolio USD AAPL Apple Computer 2/7/08 11:02AM buy 100 121.04 9.99 1.0 Yahoo USD Technology Personal Computers
My Portfolio USD AAPL Apple Computer 5/15/08 2:34PM buy 100 188.52 9.99 1.0 Yahoo USD Technology Personal Computers
My Portfolio USD AAPL Apple Computer 8/13/08 12:12PM sell 300 179.12 9.99 1.0 Yahoo USD Technology Personal Computers
My Portfolio USD USB US Bank 2/22/08 3:45PM buy 100 32.76 9.99 1.0 Yahoo USD Financial Regional – Midwest Banks
My Portfolio USD USB US Bank 10/3/08 1:01PM dividend 10.42 1.0 Yahoo USD Financial Regional – Midwest Banks
My Foreign Portfolio EUR HLG.DE Highlight 1/3/08 3:45PM buy 100 4.42 9.99 0.74 Yahoo EUR Services Entertainment – Diversified
My Foreign Portfolio EUR HLG.DE Highlight 6/1/08 4:00PM sell 50 5.63 9.99 0.75 Yahoo EUR Services Entertainment – Diversified
CSV
Portfolio,Currency,Account,Symbol,Name,Date,Type,Quantity,Price,Fee,Exchange Rate,Service,Stock Currency,Sector,Industry
My Portfolio,USD,Cash,,,1/1/08 10:00AM,deposit,,10000.00,,,,,
My Portfolio,USD,,AAPL,Apple Computer,1/2/08 10:00AM,buy,100,194.83,9.99,1.0,Yahoo,USD,Technology,Personal Computers
My Portfolio,USD,,AAPL,Apple Computer,2/7/08 11:02AM,buy,100,121.04,9.99,1.0,Yahoo,USD,Technology,Personal Computers
My Portfolio,USD,,AAPL,Apple Computer,5/15/08 2:43PM,buy,100,188.52,9.99,1.0,Yahoo,USD,Technology,Personal Computers
My Portfolio,USD,,AAPL,Apple Computer,8/13/08 12:12PM,sell,300,179.12,9.99,1.0,Yahoo,USD,Technology,Personal Computers
My Portfolio,USD,,USB,US Bank,2/22/08 3:45PM,buy,100,32.76,9.99,1.0,Yahoo,USD,Financial,Regional – Midwest Banks
My Portfolio,USD,,USB,US Bank,10/3/08 1:01PM,dividend,,10.42,,1.0,Yahoo,USD,Financial,Regional – Midwest Banks
My Foreign Portfolio,EUR,,HLG.DE,Highlight,1/3/08 3:45PM,buy,100,4.42,9.99,0.74,Yahoo,EUR,Services,Entertainment – Diversified
My Foreign Portfolio,EUR,,HLG.DE,Highlight,6/1/08 4:00PM,sell,50,5.63,9.99,0.75,Yahoo,EUR,Services,Entertainment – Diversified

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.

 Latest Blog Items