I start at the second line and add the initial deposit to the current line.
So I'm going to create a new column to keep a running total of the account balance. In this example, the last column contains the initial deposit, as well as the profit/loss from each trade. Then select Tab and Comma and click on the Finish button.Įxcel will ask you where you want to import the data. Start at row 1 to keep the header row.Ĭlick on the Next button to go to the next step.
Select Delimited as the original data type.For this example, I'll use the settings for importing a Forex Tester file. The settings you choose in the wizard will depend on the format of your file. Then find your file and click the Import button at the bottom.įrom there, you'll enter the import wizard. Once you have your file saved, then in Excel, go to: I exported my trade history file from Forex Tester as a CSV file. You can learn more about Forex Tester here. I'll be using an export from Forex Tester to analyze my backtesting results. Just be sure that they are in CSV or another text file that your spreadsheet program can import. You can use the formula above in spreadsheet programs like:įirst, you'll need to have a set of trades to analyze. A list of trades with a running account balance or profit/loss per trade.SEE ALSO: Learn the RSI Divergence trading strategy that works