Day Trading / Online Trading - Trade The Markets offers day trading tips, chat room, seminars, courses, video newsletters and day trading software.
Home | Download Library | Contact Us | Tell a Friend | Forum | Subscribe Now ! | Search | Member Login


 PRODUCTS
 Indicators
 Mentorships
 Trading Systems
 Webinars
 Live Seminars
 CDs and DVDs
 Trading Journal
 Day Trading Book
 SUBSCRIPTIONS
 Take a Tour
 Live Trading Room
 John's Newsletter
 Hubert's Newsletter
 Subscribe Now !
 RESOURCES
 Watch Live Trading
 Free Webinars
 Free Videos
 Tips and Articles
 FAQ
 MEMBER RESOURCES
 Member Webinars
 Download Library
 Blogs
 Discussion Forum
 Online Image Gallery
 ABOUT THIS SITE
 Reviews
 About us
 Contact Us
 Feedback
 Site Map
 Tell a Friend
 Terms of Use
 Text Size
 John Carter
 Hubert Senters


Previous Month October 2008 Next Month
S M T W T F S
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

Discussion Forum



 
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
   Excel pivot table



Digg This | Bookmark on del.icio.us | Submit to Reddit



·  Pivot Point Calculator
·  Pivot Chart
·  Learn Pivot Point Trading
·  What is Pivot Point?
·  How To Calculate Pivot Point?
·  Pivot Point Trading
·  Pivot Point Calculator for emini Futures



Free Online Trading
Video of the Day

[ view sample videos ]
Recent Day Trading Forum Posts
• IV Bands for 10/7/08
• Australia Trip
• Trading Computer Question
• London update
• GG = Good Grief!!!!
• Question for Carter
• IV Bands for 10/06/08
• Grains question
• JC- Trading questions
• Ergonomic computer desk chair
• Play money ;-)
• Quote of the Day
• JC - Dollar direction?
• Paint Bar in tradestation
• Market Profiles
Search Discussion

*Unique experiences and past performances do not guarantee future results! Please click here for full disclosure.

Here's what our online trading clients are saying ...

"Every penny I spent was worth the investment. Your group has given me the tools and knowledge needed to succeed."  

Randy S.
11/25/07
More customer reviews


"As I was listening to one of your videos, one of my 13 yr old twin girls walked by my desk. As she put the earbuds in from her mp3 she inquired in a teenager way, "You're listening to that annoying man again?" I replied, "Honey that man is the sound of money and paid for your mp3, so deal with it!" 

Bob W.
11/07/07
More customer reviews


Tonight's live trading video was right on the MONEY. Your information is really great and you make it look EASY. Thank so much for all your effort, knowledge, and generosity.

Bill C.
10/18/07
More customer reviews


Thank you for your videos- quality and content is excellent- you've recently raised your game by introducing the forex and currency futures. Superb. I've personally gained so much knowledge from the site which is beginning to reflect in an improving equity curve. Excellent work!

Daniel C.
9/28/07
More customer reviews


I can't tell you how much I've learned since becoming a TTM member. The nightly videos and live trading room have been excellent teaching tools for me as a beginner trader.

Todd K.
9/03/07
More customer reviews