Historical prices can be imported from QIF, QMTF or from CSV files. Current market prices can be imported from QFX and OFX files. Historical prices can also be downloaded or manually entered. Learn how to import historical prices from files below.
Import historical prices from files:
- Go to the Portfolio - Securities section.
- Select the security to import historical prices for if you are importing a CSV file.
- From the program's File menu, select "Import" → "Security Prices".
- Use the open file panel to select the QIF, QMTF, CSV, QFX or OFX file you'd like to import.
- Click "Import" to continue and then follow the info below for the specific type of file you are importing.
- Review the securities and prices found in the QIF file and do the following for each security:
- To import the prices for a security found in the QIF file into existing security, set the "Import Into Security" option to the appropriate existing security. There's no need to adjust the name, symbol, security type and currency of securities when importing them into existing securities.
- For securities you want to create, set the "Import Into Security" option to "Create New Security". Then edit their name, symbol, security type and currency.
- For securities that you don't want to assign to an existing security and that you don't want to create, uncheck the "Import" checkbox.
- Select the "Date Format" that most closely resembles the dates shown for prices in the file.
- Set the option to "Import and Merge With Existing" or "Import and Delete Existing" as desired.
- Then click "Import" to import the historical prices.
Note:
Be sure to select the proper date format matching the dates shown in the file.
Select the "MM-DD-YY" option for dates such as "1/31/18" and select the "MM-DD-YYYY" option for dates such as "1/31/2018".
The "-" in date format options can take the place of various kinds of separators including slashes and spaces.
Tip:
Use the space bar to toggle the "Import" checkbox for the selected security or for the selected historical price(s).
- Review the securities and prices found in the QIF file and do the following for each security:
- To import the prices for a security found in the QIF file into existing security, set the "Import Into Security" option to the appropriate existing security. There's no need to adjust the name, symbol, security type and currency of securities when importing them into existing securities.
- For securities you want to create, set the "Import Into Security" option to "Create New Security". Then edit their name, symbol, security type and currency.
- For securities that you don't want to assign to an existing security and that you don't want to create, uncheck the "Import" checkbox.
- Select the "Date Format" that most closely resembles the dates shown for prices in the file.
- Set the option to "Import and Merge With Existing" or "Import and Delete Existing" as desired.
- Then click "Import" to import the historical prices.
Note:
Be sure to select the proper date format matching the dates shown in the file.
Select the "MM-DD-YY" option for dates such as "1/31/18" and select the "MM-DD-YYYY" option for dates such as "1/31/2018".
The "-" in date format options can take the place of various kinds of separators including slashes and spaces.
Tip:
Use the space bar to toggle the "Import" checkbox for the selected security or for the selected historical price(s).
- Review the transactions found in the CSV file. Uncheck the "Import" checkbox for any individual price(s) you do not want to import.
- Set the "Start Row" to be the row of the first price you want to import.
- Set the "End Row" to be the row of the last price you want to import or just leave as a large number to import if the last row of the CSV file is the last price to import and there's not other information the bottom of the file.
- Make sure the "Decimal Separator" option is set correctly for the prices shown in the file (a period or a comma).
- Next, specify what value each column represents in the CSV file such as "Column 1" having the "Date" values and "Column 5" having the "Close" values. If a particular value is not listed in the CSV file, then set that value to "NA" (not available). It is required to at least set the columns for the "Date" and "Close" values.
- Select the "Date Format" that most closely resembles the dates shown for prices in the file.
- Then click "Import" to import the selected historical prices.
Note:
Be sure to select the proper date format matching the dates shown in the file.
Select the "MM-DD-YY" option for dates such as "1/31/18" and select the "MM-DD-YYYY" option for dates such as "1/31/2018".
The "-" in date format options can take the place of various kinds of separators including slashes and spaces.
Tip:
Use the space bar to toggle the "Import" checkbox for the selected historical price(s).
Note:
In order to import a CSV file of historical prices, you have to select the security that will receive the imported prices before it will be an option to select a CSV file for import.
Review the imported categories
Review the historical prices for a security by selecting the security in the Portfolio - Securities section and clicking on the "Historical Prices" text button underneath its name.
Tip:
When updating historical prices, if a historical price is added or updated with a date that is more recent than when the price was last set for the security then that historical price will become the security's new price.
Note:
The "Close" prices are used in reports and can be used in graphs.
The "Adjusted Close" prices are currently only used for graphs.
Tip:
Control-click on a graph of historical prices to be shown a menu with options for changing the date range of historical prices and the "Show Adjusted Close Prices" option that controls if adjusted close or close prices are displayed.