Editing & Importing Investment Historical Quotes
Editing & importing investment historical quotes is easy. For securities not available to download historical investment quotes you can manually enter and edit or import their historical quotes from CSV and QIF files.
Editing & Importing Investment Historical Quotes
Editing Investment Historical Quotes:
- Select the "Portfolio" listing from the main Account List.
- Select "Analysis" from the top bar of buttons.
- Then select "Security List" or "Watch List" from the "Portfolio Analysis" bar of buttons under the top bar.
- Select the desired security you wish to manually edit or view its historical quotes.
- Then click the "Quotes Table" button underneath the table of securities to pull down the historical quotes table for the selected security.
- Use the "+" button to add a new historical quote (it automatically will enter the next day from the last quote in table for the date and its close for its value.
- Use the "-" button to delete currently selected historical quote(s).
- To edit a historical quote double click its value and enter the new one.
Notes:
- If the security is listed on Yahoo! Finance and investment quotes are updated the manually entered historical quotes will be replaced. If you wish to manually update all information for a security that is listed on Yahoo! Finance then you can set it's Yahoo! Finance ticker symbol to "NA". Adding "-CQO" or "-HQO" to a security's Yahoo! Symbol will have it download current quotes only or historical quotes only respectively. Refer to Setting an Investment Security's Yahoo! Finance Symbol for more details.
- Bond prices are expected to be percentage of par values.
- CDs cannot have historical quotes entered or imported as CDs are expected to be entered using $1 for the unit price and face value as the number of units.
- Entering date values can be done using the Keyboard Shortcuts.
- Entering close values can also be done using the pop-up calculator. Information on using the pop-up calculator can be found in the Keyboard Shortcuts Help Page.
- The last available quote from the historical quotes table will be used for current market price if it is more recent.
Importing Investment Historical Quotes From CSV Files:
- Select the "Portfolio" listing from the main Account List.
- Select "Analysis" from the top bar of buttons.
- Then select "Security List" or "Watch List" from the "Portfolio Analysis" bar of buttons under the top bar.
- Select the desired security you wish to import historical quotes for.
- Then click the "Import Quotes" button underneath the table of securities.
- Now find the CSV file you would like to import in the "Open" file browser and select "Open".
- Wait for a moment while SEE Finance gathers the information from the selected file.
- Next the CSV import window will come down and show the historical quotes imported from the file. Check to verify whether or not you want to import these historical quotes. You can check individual historical quotes to be imported or not using the "Import" column in the table of historical quotes.
- Select the appropriate values for "Start Row" and "End Row" in case the file has header information in the first row(s) and/or summary information in the last row(s).
- Select the date format that specifically matches the historical quotes found in the file (see note below).
- Check and set the decimal separator used for numbers found in the file. If the numbers are using periods for decimal separators select "Period" (like "50.00"), if the numbers are using commas for decimal separators select "Comma" (like "50,00").
- Match the date, close and adjusted close columns to the information they represent using the pop up buttons for Date, Close, and Adjusted Close (adjusted close is optional).
- Select whether you wish to import these historical quotes and replace any existing quotes for the selected security or whether you wish to import these historical quotes and just add to them to the existing historical quotes for this security.
- Select the "Import" button and you're done!
Notes:
- Make sure you have chosen the proper date format from the date format pop up button when importing the QIF file. If you don't the quotes will not have the proper dates and may be given a strange date or might not be imported at all. Note that formats showing "-" for separators are for all similar formats using any kind of separator. For example, the date format "MM-DD-YY" would be appropriate for dates such as: "12/31/10", "12 31 10", "12-31-10", "12.31.10", "12/31'10", etc. However, using the "MM-DD-YY" date format for an investment quote with a date such as "12/31/2010" would result with the investment quote having the year of 2020 (use the "MM-DD-YYYY" date format instead).
- Make sure you have selected the proper decimal separator for numbers (period or comma). If you choose comma and the numbers in the file actually use the period a number like "500.00" will be set to "50000".
- If the security is listed on Yahoo! Finance and investment quotes are updated the imported historical quotes will be replaced. If you wish to manually update all information for a security that is listed on Yahoo! Finance then you can set it's Yahoo! Finance ticker symbol to "NA". Adding "-CQO" or "-HQO" to a security's Yahoo! Symbol will have it download current quotes only or historical quotes only respectively. Refer to Setting an Investment Security's Yahoo! Finance Symbol for more details.
- Bond prices are expected to be percentage of par values.
- CDs cannot have historical quotes entered or imported as CDs are expected to be entered using $1 for the unit price and face value as the number of units.
- The last available quote from the historical quotes table will be used for current market price if it is more recent.
Importing Investment Historical Quotes From QIF Files:
- Select the "Portfolio" listing from the main Account List.
- Select "Analysis" from the top bar of buttons.
- Then select "Security List" or "Watch List" from the "Portfolio Analysis" bar of buttons under the top bar.
- Then click the "Import Quotes" button underneath the table of securities.
- Now find the QIF file you would like to import in the "Open" file browser and select "Open".
- Wait for a moment while SEE Finance gathers the information from the selected file.
- Next the QIF import window will come down and show the securities found in the QIF file that has historical quote available for import. Check to verify whether or not you want to import any of these security's historical quotes. In the top table check the "Import" check box of the securities you wish to import. You can also check individual historical quotes to be imported or not using the "Import" column in the "Investment Quotes for Selected Security:" table.
- Select the date format that specifically matches the historical quotes found in the file (see note below).
- Select whether you wish to import these historical quotes and replace any existing quotes for the selected security or whether you wish to import these historical quotes and just add to them to the existing historical quotes for this security.
- Select the "Import" button and you're done!
Notes:
- The QIF file containing the historical quote information to import needs both the list of securities and the prices list in order to import the quotes.
- Make sure you have chosen the proper date format from the date format pop up button when importing the QIF file. If you don't the quotes will not have the proper dates and may be given a strange date or might not be imported at all. Note that formats showing "-" for separators are for all similar formats using any kind of separator. For example, the date format "MM-DD-YY" would be appropriate for dates such as: "12/31/10", "12 31 10", "12-31-10", "12.31.10", "12/31'10", etc. However, using the "MM-DD-YY" date format for an investment quote with a date such as "12/31/2010" would result with the investment quote having the year of 2020 (use the "MM-DD-YYYY" date format instead).
- If the security is listed on Yahoo! Finance and investment quotes are updated the imported historical quotes will be replaced. If you wish to manually update all information for a security that is listed on Yahoo! Finance then you can set it's Yahoo! Finance ticker symbol to "NA". Refer to Setting an Investment Security's Yahoo! Finance Symbol for more details.
- Bond prices are expected to be percentage of par values.
- CDs cannot have historical quotes entered or imported as CDs are expected to be entered using $1 for the unit price and face value as the number of units.
- The securities selected to have their historical quotes imported will have those quotes added to any existing Stock, Mutual Fund, ETF, Bond or Other security that matches up with the security found in the QIF file based on security symbol.
- The last available quote from the historical quotes table will be used for current market price if it is more recent.
See also
Investments
Updating Investment Quotes
Investment Tips & Tricks
Investment Preferences
List of Investment Topics