Importing Investment Data from an OFX/QFX File
You can transfer your investment data into StockMarketEye via Open Financial eXchange (OFX) files. OFX files contain information about your current holdings as well as historical transactions that have occurred in your account. Many brokerages and other financial institutions allow you to download your data in the OFX format, often referring to it as a data format for Intuit’s Quicken or for Microsoft Money.
StockMarketEye can also load QFX (Quicken Financial eXchange) formatted files. QFX files are similar to OFX files in that they contain current holdings information and historical transaction data. Some brokerages and financial institutions will allow you to download your data in the QFX format, rather than the OFX format.
In addition to brokerages and other financial institutions, OFX files may be obtained from some financial software packages. If you are currently using another financial software, but would like to transfer your investment data to StockMarketEye, you may be able to have your financial software create an OFX file with that data. If your financial software does not create OFX files, it may be able to create QIF files instead, which can then be imported into StockMarketEye.
HowTo Import OFX/QFX Files
- Open StockMarketEye and use the menu: File -> Import Portfolio -> Import from OFX/QFX…
- Select the OFX/QFX file that you downloaded from your brokerage or exported from another financial software. Click “Next” to start processing the file.
- When StockMarketEye has processed the file, you’ll have the opportunity to preview the data.
To complete the import, you must first select a portfolio into which the data will be imported. Select one of the listed portfolios or create a new portfolio by clicking on the “New Portfolio” button.
What data is imported into the selected portfolio is controlled by the “Import Mode” section. The following import modes are available:
- New portfolio with holdings, cash and transactions (standard) – all data from the OFX/QFX file will be added to the selected portfolio. This option is typically used if you are importing into a new portfolio.
- New portfolio with holdings, cash and transactions (alternative) – all data from the OFX/QFX file will be added to the selected portfolio. This option is typically used if you are importing into a new portfolio. Use this option if the first option (standard) made changes to your Prices view vs what you expected from your brokerage. The first method with try to match current holdings to downloaded transactions, but in some cases may result in differences in the number of shares held. Use this second (alternative) method if this happens and is not what you want.
- Apply only new transactions – the transactions from the OFX/QFX file, which are not currently in the selected portfolio, will be applied to (i.e. executed in) that portfolio. StockMarketEye determines if a transaction already exist in the portfolio by comparing a unique identifier that is specified for each transaction in the OFX/QFX file. If this unique identifier is not already present in this portfolio, the transaction will be applied to the portfolio.
- Apply all transactions – all of the transactions from the OFX/QFX file will be applied to (i.e. executed in) the selected portfolio.
- Import all transactions without applying them – All of the transactions from the OFX/QFX file will be added to the Transaction report of the selected portfolio, but will not be applied to (i.e. executed in) that portfolio.
To finish the import, click on the “Finish” button.
You can modify all of the data after the import has been completed.