Importing Open Financial Exchange Positions

This dialog is available from the File / Import / Positions / Open Financial Exchange... menu command.

Position data can be imported from Open Financial Exchange formatted *.ofx or *.qfx files:

OFX File to Import

Select which *.OFX or .QFX file to import.

Accounts to Import

Choose whether to import all accounts in the selected file, or only a particular account. Use the "Scan OFX" button to fill in the list of available accounts in the importing file.

Import Options

Choose options for creating the new investments.

Choose whether to import all positions into a new sub-portfolio:

When this option is on, type the name of the new sub-portfolio where all the positions will be placed. No existing sub-portfolios will be modified in this case. When importing positions for reconciliation purposes, you should import into a new sub-portfolio.
When this option is off, Fund Manager will look through your existing sub-portfolios to try and find a match based on account number. If no matching account number is found, the new sub-portfolio will be created at the top level of the portfolio hierarchy. If a matching sub-portfolio is found, the positions will be updated in there. When the sub-portfolio is already existing, Fund Manager will look for matching investments in that sub-portfolio based on CUSIP first, and then on symbol. If an existing investment match could not be found, a new investment will be created.

Press the "Next" button after filling in all of the above fields. The importing file will be read in, and you will be taken to the Preview Importing Positions page to see what transactions will be imported.

Important Note on Cost Basis:

When importing positions there is no cost basis data available. 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.

Advanced Note on Handling Cash:

This section is advanced, and you can most likely ignore it, and just use the default settings in Fund Manager.

The generator of an OFX file (usually your broker) can specify an available cash balance (AVAILCASH), a margin balance (MARGINBALANCE) and a short balance (SHORTBALANCE). The default behavior of Fund Manager for determining your cash balance is to use AVAILCASH only, unless different values are present for both AVAILCASH and MARGINBALANCE. When these 2 have different values, they are summed to obtain your cash balance. The SHORTBALANCE figure is not used by default. This default behavior works for the majority of OFX files. You may however adjust how Fund Manager determines your cash balance by writing options to the registry. Registry options can be set on a per-broker basis, so you can have different options for each broker. There are 3 options available for each broker, one to control whether or not to use AVAILCASH, one to control whether or not to use MARGINBALANCE, and one to control whether or not to use SHORTBALANCE. Each of these options is written to the following registry location:

HKEY_CURRENT_USER\Software\Beiley Software\Fund Manager\CurrentVersion\OFXRET

The 3 options are controlled with string values named "<BROKERID>_UseAC" (for AVAILCASH), "<BROKERID>_UseMB" (for MARGINBALANCE), and "<BROKERID>_UseSB" (for SHORTBALANCE). The acceptable values and their meaning are shown for each of these values:

<BROKERID>_UseAC: (AVAILCASH)

"0": do not use; "1": use (Default)

<BROKERID>_UseMB: (MARGINBALANCE)
"0": use when not the same as AVAILCASH (Default); "1" always use; "2": never use; "3" always use but multiply by -1 first

<BROKERID>_UseSB: (SHORTBALANCE)
"0": use when not the same as AVAILCASH; "1" always use; "2": never use (Default); "3" always use but multiply by -1 first

The <BROKERID> should be replaced with the value for BROKERID from your OFX file. You will see this field near the top of your OFX file, which you can view in any text editor, such as Notepad.

See Also