Excel Pivot Table

Excel Pivot Table Set Up

Once you have the pivot calculator set up, you can set the formulas up in an excel pivot table template, I can quickly obtain all of the key levels for the YM, ES, NQ and ER. I did that, and all I did today is just enter in the high, low and close in my excel pivot table. Once this is done, the excel pivot table fills in the rest of the numbers for me automatically. It takes me just a few minutes to look up, and then plug in the high, low, close into this an excel pivot table. I then instantly have my levels for the next trading day. Of course, I only have to update the Weekly Pivots once a week, and the Monthly Pivots once a month. The an excel pivot table for this chart we are working on looks like this:

Excel Pivot Table Example

Excel pivot table