binance-trade-tracker icon indicating copy to clipboard operation
binance-trade-tracker copied to clipboard

On import error: Too many cells in [datetime and ticker info] this row

Open algo-dude opened this issue 3 years ago • 1 comments

image

Everything seems to run smoothly with starting the db and the jar, but none of the trades import. Would you like a copy of my .xlsx?

algo-dude avatar Jun 10 '21 11:06 algo-dude

Looks like if you don't generate a custom report and just use their standard date range, that it will export with rows "fee coin" and "quote asset". To avoid this you can do a custom report generation (5 per month), and it will save as a zip and extract to a csv instead. I can save this as an .xlsx file, and then the error becomes:

The Excel sheet you have entered is not correct. Can't convert Date(UTC) to any value. [Date(UTC), Pair, Side, Price, Quantity, Amount, Fee, Realized Profit]

If it matters, all of my trades are futures.

algo-dude avatar Jun 10 '21 13:06 algo-dude