Charles Schwab Import Instructions:
There are two different methods of importing transaction history from Schwab into TradeLog (for instructions select a method below):
-
BrokerConnect is the reccomended method of importing
-
The csv file is limited to 1500 records. Unfortunately, there is no way to know ahead of time if the date range you have requested will exceed this limit. If the limit is exceeded, the file will contain no records and you will have to shorten the date range and try again.
NOTE: Problems with Schwab Reports
Occasionally, Schwab presents their trade history data out of order for a specific date. This usually occurs when one has challenged a fill or has had an other manual edit from customer service. Since Schwab does not report time of day for their trades, there is no automated way for any software program to determine the proper order of trades. And since TradeLog matches trades in a first-in first-out methodology as required by the IRS, it is inevitable that trades will be mismatched when this happens. This is especially noted for very active intra day traders.
We have tried almost every conceivable method for automatically re-ordering the trades, but it seems that Schwab is not in any way consistent when this happens. Add to this the fact that Schwab does NOT report when a buy is a "buy to cover" a short sale, and you can see that it becomes impossible to automate this.