Importing from a CSV File - Charles Schwab

  • Updated
Follow
General Procedure:
 
  1.  Log on to your Charles Schwab trading account web site and click on the Accounts tab and then Transaction History.
    Schwab 1.png

    If you have more than one account, select the account you wish to download from the drop down.
     
    Schwab 3.png
     
  2.  By default, the filter should be set to All Transactions. You can confirm this by clicking on Filter by Transaction Types, make sure Select All has been checked, then click Apply.
     
    Note: This is necessary so you can get all option expirations, exercises, and assignments.
    Schwab 4.png

    Schwab 3.png
     
  3.  Select the date range from the drop down box: You can select Custom and fill in the From/To date fields, then click Search.
     
    Schwab 5.png
     
  4.  TIP: For best results, click on the Date column header to sort the date in ASCENDING order (oldest date first), as this will help import trades in correct order.
     
    Schwab 6.png
     
  5.  Click the Export button in the top right corner, then select CSV as the export type, and press Export again to begin the csv file download. (Note that Schwab limits the download to 10,000 records. If you have more than 10,000 records, you will need to download smaller time periods.)
     
    Schwab 7.pngSchwab 8.png
     
  6.  Click the OK button on the popup Export Transactions Data dialog box.

    drex_schwab-csv_custom_6.png

    Click the Save button on the popup File Download dialog box.

    Note: If the csv file opens in your web browser, or opens in Microsoft Excel, rather than receiving a prompt to download and save, then there is likely a problem with your Windows file associations for csv files. For instructions on how to fix this click here
    If prompted: Save the file to the documents/tradelog/import folder.
     
  7.  Click the Save button to save the file to this location on your hard drive.
     
    Note, some web browsers will not prompt for a location to save the file, instead they will automatically save the file in a downloads folder. You will need to move the file to the location specified above.
     
  8.  Run TradeLog
     
  9. Go to the Account tab at the top and click the from File button.
     
  10.  Select the file you just saved from Charles Schwab and click the Open button.
     
  11.  Your trades will be automatically imported and matched.
     
  12.  Repeat steps 3-11 as needed until all of your data is imported up to date.
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request
Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.

Promoted articles