search

Arghh / binance-trade-tracker

🖖 Track your daily and all time profits on binance locally
MIT License
18 stars 4 forks source link

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

Open algo-dude opened 3 years ago

algo-dude commented 3 years ago

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 commented 3 years ago

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.