Recently, a user requested the ability to import option transactions into StocksCafe. One of the main challenges of tracking options is the additional fields required compared to stock transactions, making the process more cumbersome and prone to errors.
At StocksCafe, we’re always striving to enhance your investment journey. Over the weekend, we dedicated time to building this feature. Since the user who made the request uses IBKR (Interactive Brokers), the format is currently tailored to IBKR’s data structure. However, we believe the implementation is generic enough to accommodate various formats.
If your preferred options brokerage uses a significantly different format, please share a sample export file with us. We’ll gladly explore the possibility of adding support for it.
Exporting from IBKR
1. Navigate to the Performance & Reports tab.
2. Select Statements.
3. Choose Activity as the statement type.
4. Select the desired time period.
5. Download the file in CSV format.
Preparing Your File for Import
After exporting your CSV file, use Microsoft Excel or Google Sheets to format it according to the requirements outlined on this page. Once formatted, save it as a Tab-Separated Values (TSV) file and import it into StocksCafe.
If you have any questions or feedback, feel free to reach out. We’re here to help!
Happy investing!
