In our previous post, we shared that StocksCafe now supports IBKR imports. However, many users encountered the “Expects 84 columns but got 85” error due to a difference in the exported file format.
We’ve now improved the feature so it works with both the 84-column and 85-column exports.
To be honest, we’re still not sure what caused the change, as we don’t have our own IBKR account and rely on users sending us their exports for review.
Please revisit the previous post and give it another try.
💡 Tip: Create a brand new portfolio when testing, to avoid issues with existing data.
Please continue to let us know if you have other issues. Thanks!
Hey Evan,
Getting an error:
[Error] Line 11 – Expected integer for TradeID (), TransactionType (FracShare)
Seems like the script can’t handle fractional share transactions.
Hi, can you email support@stocks.cafe for me to take a look at it? Give me the file that you tried to upload.
It is not the problem with fractional shares transactions, it is the fact that trade ID is missing and I am using it as primary key to prevent double loading transactions if users upload the same file multiple times. So, I wonder why trade ID is missing in your case.
Hi Evan,
It seems the ibkr upload is calculating negative commission from the export file
Hi there, can you reach out via the forum? Thanks.