Thinkorswim Importing Error

[JohnRobson]

Hi, thank you for this great project. I'm trying to use it with Thinkorswim (from Charles Schwab), I follow all steps from https://tradenote.co/brokers.html#td-ameritrade-thinkorswim

But it gives an error:

ERROR IN UPLOAD FILE
No matching execution in Account Trade History for execution in Cash Balance on 5/23/25 10:30:06. Please correct your file manually and upload it again.

I don't understand the error because all trades Match the execution Buy and Sell or Sell and Buy.

What can be? Thank you.

[gitricko]

I get this alot too... check out this readme.https://github.com/Eleven-Trading/TradeNote/tree/main/brokers#td-ameritrade-thinkorswim

In some cases you may see the following message on import

ERROR IN UPLOAD FILE No matching execution in Account Trade History for execution in Cash Balance on xx/xx/xx xx:xx:xx. Please correct your file manually and upload it again.

The way the import code works is that it looks for matching executions in two tables : Account Trade History and Cash Balance. The code matches these executions by date and time. However, there is a bug in TD where certain matching executions have one or two seconds time difference. You need to look for those time differences and change them manually.

[7aklhz]

This is the answer @JohnRobson

Thanks @gitricko