Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Transaction/Position Retrieve

Fund Manager can retrieve transactions and positions directly from a wide variety of brokers and mutual fund companies.  (Read this if you don't see your broker or mutual fund company listed.)  The following are supported:

  • A.G. Edwards
  • Accutrade
  • Advantage Capital
  • American Century Brokerage
  • American Century Investments
  • American Express Brokerage
  • American Funds (read tips)
  • Ameriprise Financial Services
  • Ameritrade (legacy)
  • AmeriVest
  • AmSouth Investment Services
  • Ariel Investments
  • Banc of America Investment Services (read tips)
  • Bernstein Global Wealth Management
  • BrownCo
  • Cambridge Investment Research
  • Charles Schwab (read tips)
  • Compass Brokerage
  • Credit Suisse Securities USA
  • CRI Securities
  • D. A. Davidson & Co.
  • Deutsche Bank Securities
  • Dodge and Cox Funds
  • Dreyfus
  • E*TRADE
  • Edward Jones
  • FBRDirect
  • Fidelity Investments
  • Fidelity NetBenefits
  • First Clearing
  • First Command Select Investor Program
  • First Southwest Company
  • Franklin Templeton
  • FSC Securities
  • GunnAllen Financial
  • Harris Investor Services
  • Harrisdirect
  • Hewitt Associates
  • Hewitt Financial Services
  • ING Institutional Plan Services
  • International Assets Advisory
  • Invesco AIM
  • Janus Funds
  • JPMorgan Funds
  • JPMorgan Retirement Plan Services
  • KMS Financial Services
  • Mercantile Brokerage Services
  • Merrill Lynch & Co.
  • MetLife Securities
  • Morgan Keegan
  • Morgan Stanley ClientServ Investments (read tips)
  • Morgan Stanley Smith Barney
  • myStreetscape
  • National Planning Corporation
  • NetExchange Client
  • New England Securities
  • NMIS
  • Northern Trust - Investments
  • Oppenheimer
  • OptionsXpress
  • Penson Financial Services
  • Peremel & Company
  • Pershing Advisor Solutions
  • PNC Investments, LLC
  • Principal Financial Group
  • Principal Funds
  • Prudential Retirement
  • RBC Wealth Management
  • Royal Alliance
  • Royce & Associates
  • Ryan Beck & Co
  • Scottrade
  • Securian Financial Services
  • Securities America
  • Sentinel Securities
  • ShareBuilder
  • Smith Barney - Investments
  • Stanford Group Company
  • State Trust
  • Sterne Agee
  • Strong
  • T. Rowe Price
  • T. Rowe Price - Brokerage
  • T. Rowe Price Retirement Plans
  • TD Ameritrade (read tips)
  • TD Waterhouse (legacy)
  • The Investment Center
  • TIAA-CREF Brokerage Services
  • Tower Square Securities
  • UBS Financial Services
  • USAA Investment Management
  • VALIC
  • Vanguard Group
  • Wachovia Securities
  • Wall Street Access
  • Walnut Street Securities
  • Weitz Funds
  • Wells Fargo Advantage Funds
  • Wells Fargo Advisor
  • Wells Fargo Investments
  • Wells Fargo Trust - Investment Mgt
  • Winslow, Evans & Crocker
  • WaMu Investments

For sub-portfolios enabled for online access, you can perform any of these actions:

  1. Retrieve transactions directly from your broker or mutual fund company using the Edit / Internet Retrieve / Transactions... menu command.  You can also press the button on the toolbar.
  2. Retrieve positions for reconciling your account by using the Edit / Reconcile... menu command and choosing the option to retrieve the statement from your broker/fund company.
  3. Retrieve transactions and positions for setting up new accounts by using the New Portfolio Setup Wizard (File / New Portfolio Wizard...).

Setup Instructions:
You will need to have an online account set up with your broker/fund company.  Some broker/fund companies actually have a separate account for this service.  It may be called Direct Download or Web Connect.  It is the same feature used by Quicken and Microsoft Money to download transactions.  Once you get signed up with your broker/fund company you should receive a User ID/password.  Use the Portfolio Editor to set up a sub-portfolio for this broker/fund company.  Assign this User ID/password in the sub-portfolio's properties.  On the Portfolio Properties Dialog there will be a "Transaction Retrieve Settings..." button where you assign your broker, User ID, password, and account number for this sub-portfolio.  Then, just do an internet retrieve of your transactions using the Edit / Internet Retrieve / Transactions... menu command, or by pressing the button on the toolbar.

The "Retrieve Transactions" dialog allows you to choose which sub-portfolio to retrieve.  You can also select the "Also Retrieve All Sub-Portfolios" to retrieve all sub-portfolios below the selected sub-portfolio.  You can control the date range of transactions to retrieve.  Fund Manager remembers the date of your last retrieve for each sub-portfolio, and sets this as the default starting date.  Once you press the "Next" button, Fund Manager will retrieve your transactions and you will be taken to the Preview Importing Transactions page to see what transactions will be updated.

When Fund Manager retrieves transactions from your broker or mutual fund company, a CUSIP is provided with each downloaded transaction.  When Fund Manager matches up retrieved transactions with your existing investments, it first looks for investments with a matching CUSIP.  If a matching investment could not be found based on CUSIP, it next looks for a match based on the recorded symbol.  Using the CUSIP to match your transactions up with your investments will be more reliable than using the symbol, as some broker and mutual fund companies do not always provide the symbol, although they do always provide a CUSIP.  Using the CUSIP for transaction retrieves also allows you to record an independent symbol for price retrieval, in case the quote server you're using uses a different symbol.

Comments:  This feature retrieves your transactions over the internet using the "Open Financial Exchange" protocol, which is an encrypted, secure protocol (HTTPS).

Technical DetailsAfter a transaction retrieve there will be 3 log files: "ofxretr.txt", "xmldump.txt" and "ofxmemtrandump.txt".  The first is the raw data received from the OFX server.  The second is a more human readable format of the first log file.  The third is a list of transactions Fund Manager parsed from this response.  Some of the displayed fields in this third log file will have either a "(1)" or a "(0)" after them, indicating whether or not they were read in from the received data (1), or are at their default value (0).  The log files will be located here:

Windows XP and earlier:

C:\Documents and Settings\<username>\Application Data\Fund Manager

Windows Vista and 7:

C:\Users\<username>\AppData\Roaming\Fund Manager

FundManagerSoftware.com | Contact Us | Site Map | About Us | Privacy Policy