Hello All.
I have a formula that displays a dual coloured Moving Average (If it's displayed as large dots)


What I would like to be able to do is incorporate a"% shift" function to this also,, so I can shift the MA by say 1.5%
(Actually if this is possible,, I would then plot this again, so as to create a banding around the price bars,).

Not sure how to do it.
I did look here;
http://trader.online.pl/MSZ/e-w-Moving_Average_Shifted_Bands.html
& found a formula with a %shift function,,,but I just wasn't able to do it. :-(

Hope somebody can help me with this please, I think it would be quite useful,, a MA band that changes colour also.

Many thanks for all your time
The Ghost

Hi jjstein,, many many thanks for your swift reply,, actually it's not quite what I'm looking for. :-(
Let me try and explain a bit more as I don't think I was too clear before.

1st,, a mistake by me in my original formula (Copy & paste went hey-wire I think,, it's when you copy text out of Metastock into texpad it seems to slightly go wrong ) :-)
Original code for #2 Colour MA is as follows;

***ACTUALLY,,It's done it again,, copying into Firefox,, Meant to be If(A,,THEN THE GREATER THAN SYMBOL on line 2,, & line 3 If(A LESS THAN SYMBOL,,,NOT>,,,&Lt,, Not sure how tyo get over this,, tried editing a few times,, couldn't change it)*** Sorry
2nd,, "A picture paints a 1000 words!",, I'll insert a picture to try and illustrate 1st jjstein.


Hopefully you can see what I'm really trying to achieve jjstein. My original formula lets me create a MA that can be dual coloured. What I would really like to do is be able to plot 2 MA's on the same chart,, say two 5 period MA's that are dual coloured. By using the vertical shift formula,, I can create a banding around the price (IE say 1.5 as a setting for vertical shift).

The formula that you wrote is 50-70% there,, but not in a way that the MA's can be dual coloured.
Maybe my above formula needs to be written to incorporate the vertical shift as well (Which I don't know how do do, hence this post :-),, then I just plot this twice on the chart.
Or, might be better/ easier to create 2 MA's dual coloured with vertical shift all within 1 formula?

I hope this kind explains it a bit better jjstein.

Again,, many many thanks for your help.
Much appreciated.

Many thanks
TheGhost

I'm still here! :-)
Many thanks again for your reply jjstein,,
Sorry,, but again,, maybe I've confused the issue more with the images! :-(
Here is what I have; (Another image which I hope doesn't confuse things).

If possible,, all I'm looking to do is add a vertical shift function to this formula in the image above. Then,, I can set this shift to say +2.
THEN,, I add the formula again to the same price chart,, but with a shift of -2,, hence creating banding around the price that is dual coloured. :-)

Possible jjstein?
I just can't get it.
I hope this makes sense this time jjstein.
Many thanks again for trying though.
It's a tough 1 !! ;-)

Best regards jjstein
TheGhost :-)
PS,, as a noye,, The MA would be a lot smaller,, IE 5 or 8 period,, not 21 :-),, just thought I'd mention it.

Yes! That's more like it jjstein! :-)
As it happens I've just received a formula that does a similar job,, but,, well is different.
(I haven't wrote it, (Not clever enough! ) :-)
The code is as follows;


Any thoughts on this code jjstein?
Many thanks for trying again,,,I must look at the 2 together now,, see how they line up.
many thanks again jjstein.
Kind regards
TheGhost

Hi Johnathan

And I thought I could stay below the radar. I didn't want to draw attention but you got me anyway. I guess my style is as good as (or as bad as) a signature.

The purpose of ValueWhen(1,0,A), for example, is to create an N/A result as the final output of the indicator. This has the effect of allowing properly functioning indicator plots to move beyond the borders of the chart window while remaining scaled to the price plot. Dotted lines are used for a multi-coloured plot because dotted lines leave no trace as they move between one bar and the next. Dashed and solid lines, on the other hand, do leave a trace, and this is particularly unwanted when switching from value to zero or vice versa.

Roy

Hi Johnathan

There's no reason why ValueWhen(1,0,0) can't be used, and it was in the formula that I sent to TG. Any expression that generates an N/A output across all bars would be fine. I like ValueWhen() because of it's known ability to generate an N/A until the "Expression" parameter is TRUE. The "Data Array" parameter is irrelevant for this situation since it will never display anyway.

I'm not sure that I get your meaning about "most indicators" so I may be about to try and answer the wrong question(s). I've noticed that indicators generating a valid result as the last (or only) output tend to fill a window's vertical space except for top and bottom bands of around 10%. The one notable exception is an unscaled flat-line indicator that shares the window with a non-flat-line indicator.

Once an indicator has a scale applied to it will plot within the 80% vertical range that I just mentioned. In the "flat-line off the bottom of the chart" scenario, that indicator can be located, marked and scaled by drawing the cursor slowly through the bottom of the window (thicker flat lines will be visible but lines with the default thin setting will not be).

What having an N/A result as the last output appears to do is remove the restriction that normally forces a valid plot to stay within the 80% range of a window's upper and lower extremes (ignoring the unscaled flat line which is able to sit at the extreme lower edge of the window). The price chart and other "normal" indicators will continue to display within the 10%-90% vertical range of a window while an "N/A modified" indicator apparently ignores the 10% and 90% limits that apply to normal indicators. Why? I have no idea. In the case of a dual-color moving average, it should be scaled to the same scale as the price bars. That prevents the required dotted lines from reaching for the stars (plotting somewhere above the upper limit of the window).

So the short answer to your second question is that we don't know why an N/A result has the effect it does, but we do know what that effect is. It's presence allows the visible output(s) of an indicator to "float" out of view (above or below) the normal vertical extremities of an inner window.

Roy

Hi Johnathan

I'd guess that almost any "Nth" and "Condition" parameter function would substitute for ValueWhen(). The only requirement is that the "Condition" parameter never comes TRUE. If it does come TRUE the indicator will bring the unwanted portion of the plot back into the viewable area and distort the price plot that it's scaled to. I imagine that almost any code that generates an N/A result in an exploration might might be a candidate for the same result when used in an indicator. I'm sure you're aware that ValueWhen() and similar functions should never be used in a "Minimum Periods" exploration because of this tendency to generate an N/A result if the Condition parameter remains FALSE.

To be honest I've never used (or even noticed as far as I can remember) the "overlay" option. My way of making sure that the "N/A" indicator is scaled to what I want is to disable that output {with braces} and then set a normal output to the appropriate scale. Typically this has been "left" in my default template since the days of MS version 6.5. With that done the N/A element can be made active again.

Roy