![]() |
Download |
The Generic CSV script reads investment / brokerage CSV files. The script is capable of reading data from any brokerage as long as the said file contains (at a minimum) specific data columns required for an investment OFX transaction.
The script expects transaction lines to be delimited by comma with any fields containing commas qualified with double quotes. Currently, the file needs to be laid out in a particular order for only the minimum and extended layouts, and the next section expounds further on this.
The script will default to the flexible layout if all six required columns are present in the first line / header of the CSV file. The only difference between the minimum and extended layouts are the dates. For the extended layout, the CSV file contains both the Trade Date and the Settle Date. In the case of the minimum layout, the single date provided for each transaction will be applied to both the trade and settlement date variables in the resultant OFX /QIF file.
NOTE: The bold items are required in order to be able to support the full set of investment transactions, however, the Ticker, Units and Price fields are not required for cash investment transactions, which include interest, deposits and withdrawals.
The flexibility in the flexible layout lies in not expecting the columns to be ordered in any particular way (which the former 2 require).
The values for Units, Price, Fees, Total and Rate should be in the system number format to be correctly parsed by the script. In the save vein, the values for Date, Trade Date, Activity Date, Settle Date and Transaction Date MUST be in any system date format to be correctly parsed otherwise the entire transaction will not be parsed (in the case of the date strings).
The program supports all investment / brokerage transactions that are supported by the OFX specification. Investment transaction actions are preceded by the investment type, e.g for a stock buy the action is Stock - Buy and for a mutual fund buy Mutual Fund - Buy. QIF files do not have support for options transactions.
Generic |
Novia Financial |
Allan Gray |
BMO Investorline |
CIBC |
Charles Schwabb |
Crypto |
Custom1 |
Daily Access |
Dodge And Cox |
FI TEK |
Fidelity Investments |
Fidelity UK |
Fidelity US |
Foreign and Colonial |
Hargreaves And Lansdown |
PenSys |
Pension Plan Services |
QIF File |
Rabobank Direct |
Retirement Strategies |
Robinhood |
Scottrade |
Scottrade Advisors |
Stock Market Eye |
TD Ameritrade |
Transamerica |
U.S Bank |