Right now, the only way to import security prices is via CSV-type file from the File menu in a particularly awkward format (exactly one tuple of symbol, price, and date per line). I think several things could be improved from this:
- Instead of being forced to import this data via the File menu, a button in the Security Detail View also seems a very logical place to put this functionality.
- If importing from a CSV-type file, support for more flexible layouts should be offered. For example, in many systems one can import a CSV-type file in which the first line defines column headings and the subsequent lines are values with the column. One could use this format to have a Date column and multiple security columns to import multiple security prices in a single file.
- Direct support for spreadsheet files (e.g. .xls, .xlsx, etc.). These formats have been around for very long times.
- Full support for the values in the Price History window. The current Price History window has possible values for Price (which isn't well-defined), High, Low, and Volume. It seems that the import should at least support these fields, though ideally the "Price" column should be split into "Open" and "Close" columns, since those are the standards.
