Importing Positions

 

Importing positions refers to the process of importing share balances from a file into Fund Manager sub-portfolios/investments.  Importing positions can be useful when first setting up your Fund Manager data files, or for reconciliation purposes:

Setting Up New Fund Manager Data:

When establishing new Fund Manager data files, you can import your positions as of a certain date, and then import or retrieve transactions going forward.  If you have all of your historical transaction data, it is not necessary to import positions, instead import your transactions.  Importing the complete transaction history has the advantage of providing accurate historical returns and cost basis.  There is no cost basis data available when importing positions, therefore all positions will be created with a cost basis of zero.  To adjust the cost basis, use the Data Register and edit the initial purchase price and value.

 

Reconciliation:

When importing positions for reconciliation purposes, import positions into a new sub-portfolio.  You can then compare the share balances in this imported position sub-portfolio against the share balances in your actual sub-portfolios.  After reconciliation, you can delete the imported position sub-portfolio (see the Portfolio Editor).

Video Tutorial:  See the Tutorial on Importing Institutional Position/Transaction Files (Advisor Version).

 

There are many sources of files that Fund Manager can import from, and they are listed below.

 

Source

Format

Comments

Open Financial Exchange

*.OFX or *.QFX

 

BrokersXpress

*.POS

Advisor Version

DAZL

*.TXT

Advisor Version

DST FAN Mail

*.TXT

Advisor Version

Fidelity

*.POS

Advisor Version

FOLIOfn

*.POS

Advisor Version

Interactive Brokers (Generic)

*Position*.csv

Advisor Version

Interactive Brokers (PC)

*.POS

Advisor Version

Pershing

*.GCUS or *.FUND

Advisor Version

Rydex

*.POS

Advisor Version

Schwab

*.RPS

Advisor Version

Scottrade

*SC.SE1

Advisor Version

Southwest Securities

BPS_POS_xx_mmyy.rpt

Advisor Version

TD Ameritrade

*.POS

Advisor Version

TIAA-CREF

*.POS

Advisor Version

See Also

Importing Transactions

Retrieving Transactions

Importing Prices

Tutorial on Importing Position/Transaction Files (Advisor Version)

 


Fund Manager Home