I think you will need at least Excel 2007 for this, I have Excel 2010
I am using Price Action Setups on NQ for day trading and this spreadsheet uses the Statistics from Sierra Chart Trade Statistics report and data that I collect after each trade.
I include a Notes.docx on how to start out and for ongoing.
My price action setups won't be the same as yours. The last sheet is called Data Validation and you would enter your Trading Strategies, Support Reasons, Error reasons etc. here to customize to your own Price Action strategies.
I don't do anything fancy in Excel. You can easily use the Excel help to learn the basics to make this work for you.
This could be converted to use NinjaTrader trade stats.
V1.0 - July 20, 2014
V1.1 - I discovered a hidden Row (#23) which does not get cleared when you 'clear contents'. This affects your Pivot Tables because you have data in row #23 you don't see in the Data Worksheet. I tried Unhiding the row in the Data worksheet using Home > Format > hide - unhide rows which didn't work for me. I needed to type A23 in the top left home cell of the Data Worksheet to highlight Row #23 then I was able to use Home > Format > Hide - Unhide and then clear contents of this row. Hope this helps
Category Sierra Chart
|
|
|