Sorry for the delay in posting the file. But anyway here it is. As mentioned previously it is a revision / expansion of the Total Trader file. It will only work in excel as the macros use visual basic. As it uses macros the file needs to be saved as a macro enabled excel file .xlsm
You can download the file from Google Drive using the link below. Any questions / corrections / suggestion message me.
https://drive.google.com/file/d/1G5fKj600EDBfM--QNMzQxxOmEkDCJUDF/view?usp=sharing
FILE USAGE INSTRUCTIONS (also included on the "INSTRUCTIONS" sheet):
The default in the file is an account size / starting balance of $25,000 and risk of $50 per trade. These can be adjusted as required on the "INSTRUCTIONS" sheet.
The file calculates commissions for either CMEG, IB (tiered) or excluding commissions. If you select to include commissions (using the "ON"/"OFF" switch) the file will estimate fees as well. The fees are an estimate only and I tend to overwrite them when the actual data is available from the broker to ensure the account balance is 100% correct.
First step is to enter the Date for the trades on the "INSTRUCTIONS" sheet. European format DD-MM-YYYY.
The file is based on loading the "Trades" report from DAS. The columns in the report should be structured as below.
You then copy the data in the Trades report and paste (past values) into the "DAS_DATA" sheet in the file. I then tend to sort the data. Select the data from cell A2 to the end of the data (A2:H6 shown below), select Sort and Sort by SYMB then by TIME.
Then run the "Analyse DAS Data" macro using the button on the "INSTRUCTIONS" sheet.
It converts the data shown above to identify the trade direction, duration, total profit, commissions and Fees, gives an ID number, win/loss etc.
Add some additional data on the first row of each trade ONLY (the rows with a Trade ID):
Add in the STOP price when you entered the trade (used for calculating the overall reward to risk), the Strategy you were following, then (based on the strategy indicators you have defined for the strategy) you enter a 1 if the indicator was present at the point of entry or 0 if it was not present. This gives a way to track which indicators are key or for example the success rate of a setup if more than 50% of the indicators are present at the point of entry versus the success rate if 100% of the indicators are present.
Enter the timeframe of the chart you were using for the setup. If the setup was on the 5 minute chart but you used the 1 minute to get a better entry, you should enter "5".
Enter a wellbeing score from 1 to 10 (10 being best).
If you want to track some comments you can also enter a tag line and a key takeaway.
Example when populated
Then run the "Transfer Data to Journal" macro using the button on the "INSTRUCTIONS" sheet
When finished you will see this message (click OK):
Data is transferred from the "DAS_DATA" sheet to the "JOURNAL" sheet. "JOURNAL" sheet feeds the "CALCULATIONS" sheet and the blue sheets "WEEKLY_CARD", "SCORECARD", "DASHBOARD", "STRATEGY_STATS".
Clear the data from the "DAS_DATA" sheet with the macro "Remove DAS Data" button on the "INSTRUCTIONS" sheet.
I set the excel calculation options to "Manual" when using the file to speed the macros up. Then each sheet should be refreshed after the DAS data to Journal sheet successfully completed. There are buttons on the Blue sheets to calculate the sheet and charts.
What can you get out of the file? Examples below are using the single trade AMD example from above. Obviously the more trades loaded, the more informative the analysis, but this gives a small flavour...
A moving weekly scorecard that can be refreshed using the drop down list selecting the week end date:
A total Scorecard tracking the account from inception to current date:
A Dashboard with detailed stats across a range of elements that can be viewed on a total basis on average basis:
A Strategy Stats sheet with in-depth tracking of the Strategies you have defined