Thank you again for your help on this project!!
Attached is the spreadsheet for a daily analysis. I finished creating the tabs and set up a "Table of Contents" tab as the first tab which will have hyperlinks to each tab on the spreadsheet. I finished hyperlinking January through April. Do you mind finishing the other 8 months? I also have all 9 of the Combined Trade Lists you had worked on previously on this spreadsheet with hyperlinks already set up to those tabs on the Table of Contents page. I started to fill in January 1 but realized there were no trades for the last 11 years on January 1 (I expect the same for 12/25 as well). So the example of how I'd like each tab (not including the Combined Trade List Tabs) can be found on January 2.
Looking at January 2, you will notice I have the side by side comparisons of the strategies not using news report exits at the top. Just below that, you will see a side by side comparison of the strategy results including news report exits. The next section I can finalized once you have finished this project. This area is a side by side comparison of all 9 strategy results. Lastly, I have the trades listed out for Entry Date January 2 and organized by strategy. This information comes from the Combined Trade Lists at the end of this spreadsheet which is also your previous work. Using the information in this area, I filled in the "Gross _____ (name of the strategy)" as well as the number of trades taken that day multiplied by 2 since there is an entry trade and an exit trade. The formulas to the right automatically figure out the"Slippage" and the "Net ____ (strategy name)". I'll use the "Net" to finalize the data between the "Results" and "Trade List" sections.
If you have any questions, please let me know. Also, once you complete the project, should you feel $85 is an inaccurate figure, please let me know!
I appreciate all your assistance in this project!!! Thank you for your willingness to work with me again!
I'll send the file in a separate email. The upload button here is non-responsive.