Indicator/Dashboard of Range%

Hi, presently I am manually inputting these data in Excel. I am wondering if the followings are possible to create?

1. A dashboard of these information in Chart
2. A dashboard in an Indicator Window.
3. A moving line in an Indicator window visibly like MACD, ATR, RSI, STOCH, etc.

Criteria of indicator settings may include:
1. An Indicator of the values with choice of selection to apply a specific TF visibly on another different TF.
2. MA average of last X candles with constant/fixed Y TF.
3. Etc....

Thanks in advance for any guidance.

Guidance...

Try the attached.

M.

Thanks futurespec, will give it a try.

Btw, you code yourself?

Yes I did the coding.
As always it is take it as it comes and if it helps then great, if not just bin it or if I have the time ask for a mod.

M.

Hi Futurespec, thanks for the quick coding of the 2 indicators, there are some doubts I had. I do not understand the values that are in the Data Windows, and what each colour average lines represent? Will it be hard for you to rename those variables which maybe I can have easier understanding.

Btw, can the ATR period be fixed at hourly candles but doesn't change values when choosing different TF charts?
Eg, I chose 24 ATR period, while I am at 15mins candles chart, it still reflect the MA of hourly of 24, instead of last 24 15M candles.

Not sure if you get what I am talking, sorry if none understand, but feel free to ask. Hopefully, my request doesn't bother you much. Really hope someone can afford his time to fine tune it.

** My purpose of using these data, is to determine the probability of different pips capture, which enable me to change my TP and SL, R/R according to given market conditions..

Eg with rough calculation based on the given data in my first post, for:
Open to High, taking profits at 5 pips stand at near 79% hit rate.
Open to Low, taking profits at 5 pips stand at near 83% hit rate.
Open to Close, taking profits at 5 pips stand at near 76% hit rate.
If the indicator is fine tune, I can visibly easier to decide my TP and SL for that market condition.

Eg with High Low range, during the given data for that period;
100% candles had a min range of 10 pips.
96% candles had a min range of 15 pips.
Blablablablabala.......
*the above data are base on H1 candles on limited period, it doesn't reflect 100% accuracy at any time.

Regarding your original statement "I am manually inputting these data in Excel", you could try playing around with the DDE and then write some simple VBA code to present the data in Excel as you wish - here's a thread on how to use DDE.

Thanks Tin, I actually read and try that previously, but as I am not good at coding, there is limitation as what I can achieve for my expectations. Every now and then, I extract brief data as attached. Btw the data I attached are not full.

Have named the lines on the Atr Indi for you.
No time to spend making it MTF, sorry.

The Range Pcnt indi does work on a fixed TF for any chart TF.
Set the var mTF to whatever TF you want (1440 = daily etc)
mBars is the number of bars you want to find the range for.

Headings should be self explanatory..
OH = Open High
OL = Open low
OC = Open close
HL = High low

Check the results against your XL .. hopefully they should match.

M.

As to the OP of the thread, I collect MANY stats like the ones you posted in your post.

I have tried DOZENS of various iterations, aggregations etc. over various segments of data, and timings within a day. I have done daily data, minute data, and tic data along with tic data and plotting various types of zz indicators to capture actual price movement.

The rub is that I do all of my programming in NT7 as it is what I've used for years, I also do most of my data exploration on Futures, particularly ES. But I have solid data for just about everything, including currencies as I have explored that before.

Here is a simple sheet created via exporting from my charting platform into tabular format, mostly daily, RTH ES data with some intraday particulars. Not that any of this is useful or important, but just something along a similar vein of the topic of the thread.

could please added more pairs to pcntchng indicator and make it just for daily time frame thanx alot