Price percent amount above the moving average

[Paul]

I need help with a script that would create a chart indicator showing the percent price (close) is above or below the moving average (e.g., 200 day simple moving average)

Thanks,

Paul

[Matthew]

Hi Paul,

The following script will display the value (in %) the close price of a chart is from a 200SMA:

//Set Variables V1 = MA(BARS=200) ; V2 = CLOSE(); //Formula for % from MA 100 * (V2-V1)/V1

1 2 3 4 5 6 7

//Set Variables V1 = MA(BARS=200) ; V2 = CLOSE(); //Formula for % from MA 100 * (V2-V1)/V1

This is how the script would look on a Show View (below the chart):

[Paul]

Thanks, Matthew – just what I needed.  Much appreciated – Paul

[Darren]

Sample workbook attached for US and ASX data. Remember you can save the Watchlist columns as a layout and apply them to any other watchlist.

[Lorenzo]

I used this template

can I know why the column % below 52 week high is partly in white and does not take the red and green formatting?

[Darren]

Hi Lorenzo,

The custom colour formatting in this example was set to green for within 5% of the 52 week high and red when more than 20% away, so those between 5% and 20% were not defined.

To modify, right-click on the column heading and change the conditional values under Custom Labels:

• This reply was modified 1 year ago by Darren.

1 user thanked author for this post.

Lorenzo IPPOLITI

[Author]

Posts