ES – plotting monthly range distribution with excel

Todays volume was very low which has been happening at interim tops the last few months. Fundamentals continue to disappoint but the price keeps rising. I dont know if it is possible to have a buying climax in the ES but Friday came close (it was also options expiry – people will soon forget it was stops being blown up during “expiration auction” that got us past 2100).

Current swing is 135 pts and I was wondering how this looks vs other monthly ranges.


There is a very useful Data Analysis add-in for excel which allows you to build histograms to quickly visualise this:



Data is based on months built from ES weekly chart for 1997-present on Market Delta.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s