Vanguard Import of downloaded CSV file.
Note: Vanguard limits trade history downloads to past 18 months.
Go to the Vanguard web site and log in to your account.
Click on My Accounts & Transaction History.
- Click on Download.
- Under Step 1, choose A spreadsheet-compatible CSV file.
- Select a date range for your report such as 1 month or 1 year.
Select the account you wish to download from (DO NOT select more than one account) and click the Download button.
Save the CSV file to your "documents\tradelog\import" directory.
Please do NOT open the csv file with Excel. Opening the csv file and then saving it will change the original formatting and render in unreadable by our TradeLog Vanguard import filter.
- Run TradeLog
Click on the Vanguard Imp speed button.
If there are no trades in your TradeLog data file an "IMPORTING RECORDS FOR THE FIRST TIME" dialog box will pop up - click YES. An Import from Vanguard *.csv file dialog box will appear - click on the YES button.
Select the appropriate CSV file and click on the Open button.
Your trades will be imported and automatically matched.