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.

es_weekly_range_plain

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

excel

excel2

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s