NexusFi: Find Your Edge

Home Menu


Categories Help    

The Elite Circle
File sharing for Elite Members only, includes any and all platforms and file types

Futures True Range Report
This is an excel file (excel 365) that includes an analysis of the most traded futures markets. The goal was to analyze and compare the different futures contracts based on volume, dollar, tick and point movement at different timeframes.

An indicator JFTrueRange calculated the true range for each bar and generated a report that was then copied into excel. It average the true range for all bars on a given day of the week and time of day. i.e. for 15 minute bars, it average all the bars at 6:00 for monday, at 6:15 for monday, etc for all times and days of week. For daily bars, it averaged 1000 days. For minute bars, it averaged 400 days. The report includes statistics an each futures contract for daily, 240, 60, 15 & 5 minute bars. For each bar it used the TickSize & PointValue to determine the price range, tick range & point range per bar. Daily bars ended at different times. So that is an interesting artifact you will see in the data.

In the summary report volume is higher in the high timeframe reports (daily, 240 min) than in the lower timeframe reports (15min & 5min). This is because I totaled the volume at each timeframe and this included the odd times that bars were reported. The higher daily volume at 15:00 is approximately the same as the lower timeframe bar totals.

Finally, the true range reported in points, ticks and dollars is higher at low timeframes as expected. This is because it takes into account all the smaller price fluctuations. Some of these fluctuations are inside the higher timeframe bars and are thus washed out.

Note: The timeframe used in the reports was Mountain Time (MT). Sorry, that is my timezone. So do the mental adjustment or modify the times to meet your needs.

I hope you find this report interesting and useful.

Category The Elite Circle 
Suggest other entries I might like
Details: Futures True Range Report
Category: The Elite Circle 

January 9th, 2024
Size: 3.47 MB
Downloaded: 212 times


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top