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.
Choose options for creating the new investments.
Choose whether to import all positions into a new sub-portfolio:
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:
"0": do not use; "1": use (Default)
"0": use when not the same as AVAILCASH (Default); "1" always use; "2": never use; "3" always use but multiply by -1 first
"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.
Importing Open Financial Exchange Transactions
Preview Importing Positions Dialog