Ive searched our forum and thought we might have a tool to accomplish this , to no avail . If anyone has some guidance Id appreciate it , maybe some sort of template to follow ( for the computer illiterate to build a spreadsheet maybe ) or links for details .
aHelp = "TRO2010_DW_COUNT_UI" ;
aHelp = "Displays frequency distribution of" ;
aHelp = "high minus open when daily open is" ;
aHelp = "greater than or equal weekly open" ;
aHelp = "or open minus low when daily open is" ;
aHelp = "less than or equal weekly open" ;
aHelp = " " ;
aHelp = "User can enter the ranges via inputs" ;
aHelp = " " ;
aHelp = " " ;
aHelp = "column 1 is number of occurrences" ;
aHelp = "column 2 is % of total" ;
aHelp = " " ;
aHelp = "DWLong = TRUE: count daily (High - Open)" ;
This post has been selected as an answer to the original posters question
You can analyze your data in Excel and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak. This data analysis add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) is available when you install Microsoft Office Excel 2007, but it might not be loaded automatically.
Important If you don't see the Data Analysis button in the Analysis group on the Data tab, you must load the Analysis ToolPak add-in.
(a) Find the daily/weekly/monthly low, high, mean, mode etc.
-> Have a look at low, high, midline and volume weighted average price of prior month and current month, prior week, and curent week, prior day and today, all displayed via SessionPivots indicator (download section)
(b) net change (high - open)
-> you would want to code an indicator that loads the values for high-open and open-low for the last 14 days (or whatever you think appropriate), and then calculate a mean and a standard deviation
-> you would need to calculate an ATR(14) from daily bars and add that to the current low or substract it from the current hig
These indicators are not difficult to implement. It is very similar to the original idea behind floor pivots: You need a reference (typical price = high + low + close) and a measure for volatility, such as the range specified under (b) or (c).
If you look at floor pivots there is
- a reference -> the main pivot
- a first support level S1 -> pp + (pp-current high), which adds volatility to the reference in a way RO suggests under (b)
- a second support level S2 -> pp -range, adding volatility as suggested by RO under (c)
So this guy just stole the idea of pivots, replaced the main pivot with the open and then the range with a range distribution over x days. The pivot indicator just takes into account yesterday's range, while RO wants the average range of x days.
But we can do better than that:
Take a better reference, which would be VWAP of yesterday and than add Avg(prior dayVWAP - currentLow) and subtract Avg(currentHigh - prior day VWAP), where the averages are calculated over x days. Note that we add downward volatility and substract upward volatility here.
This is a modernized floor pivot indicator in a way RO proposes.
You can also build a confidence interval for the average true range and replace support and resistance level with support and resistance zones.
An example how to trade these reaction or breakout points is The Reaction Trend System, published by Welles Wilder in 1978 (!) in his book "New Concepts in Technical Trading Systems", see Section VII.
Last edited by Fat Tails; June 19th, 2010 at 04:39 AM.
Reason: text corrected
The following user says Thank You to Fat Tails for this post:
Very enlightening , thanks for all the suggestions from everyone . What I aim to pin down is the most efficient bias' and targets within certain price " zones " that produce edges for forex , particularly for intraday . What TRO offers here is a tool to divine this info unfortunately its a metatrader EA . One thought is to just donate and use the TRO EA on a free demo I have access to and another is to build my own in ninja but Id need to find historical data . Id prefer to build my own so as to have full understanding and control . Again , thanks for the help .