

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. I tried Unhiding the row in the Data worksheet using Home > Format > hide - unhide rows which didn't work for me. This affects your Pivot Tables because you have data in row #23 you don't see in the Data Worksheet. V1.1 - I discovered a hidden Row (#23) which does not get cleared when you 'clear contents'. This could be converted to use NinjaTrader trade stats. You can easily use the Excel help to learn the basics to make this work for you. here to customize to your own Price Action strategies. The last sheet is called Data Validation and you would enter your Trading Strategies, Support Reasons, Error reasons etc. My price action setups won't be the same as yours.
#SIERRA CHARTS WAVEBOX HOW TO#
I include a Notes.docx on how to start out and for ongoing. 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 think you will need at least Excel 2007 for this, I have Excel 2010 ĮCIVwap tools are shipped under GPL and also available in the SierraChart contributed studies.
#SIERRA CHARTS WAVEBOX INSTALL#
To install : download and unzip the archive. The ECIVwapBracket uses Vwap computation algorithm, and draws a vwap until price breaks out of bottom/top levels 4 (excess levels). The ECIVwapChannel uses Vwap computation algorithm, but draws a vwap channel of a user based period number of bars. The ECIVwapAnchor uses Vwap computation algorithm, but the start and end dates are can be set in different ways (manually, automatically, at major reversal points, etc.). This is also true for the standard deviation calculation.

Vwap computation tries to be as accurate as possible since using volume at all prices in each bar, and is compatible with Sierra Vwap when using "Base on Underlying Data" option. The ECIVwap computes Volume Weighted Average Price for Daily/Weekly/Monthly/Quarterly/Yearly periods, and draws extensions of previous periods. This tool includes few VWAP based indicators :
