Stock & Option Trade Data in Comma Delimited Format
If your broker is not listed in the Broker dropdown box and you have a Comma Delimited Format (CSV) file,
you can use this utility to process your trade data quickly.
This utility supports the following two types of trade data:
- Transactions (e.g., history of trade records)
You need to specify proper column indexes for
Trade Date, Action, Symbol, Description, Quantity, Price, Commission, Fees and Net Amount.
- Realized Gain/Loss (e.g., proceeds and cost basis, profit and loss)
You need to specify proper column indexes for
Symbol, Quantity, Date Acquired, Cost Basis, Date Sold, Proceeds and Gain/Loss.
If you have an Excel file ending with .xls, you will need to open it in Excel and then save it as Comma Delimited (*.csv).
After converting .xls to .csv, you can choose the .csv file in the above file selection box.