Sierra Chart - Excel Spreadsheet for tracking Price Action trades
futures io futures trading

Categories Help    

Sierra Chart
Sierra Chart Downloads / Sierra Chart Studies

Excel Spreadsheet for tracking Price Action trades
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 
Suggest other entries I might like
Details: Excel Spreadsheet for tracking Price Action trades
Category: Sierra Chart 

June 20th, 2014
Size: 287.50 KB
Downloaded: 193 times


Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432,
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.