Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Moving average Offset plot with negative value, histogram doable? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
IsItPossible
Posted : Monday, April 30, 2018 7:22:08 PM
Registered User
Joined: 7/7/2008
Posts: 115

Scenario:

1. Plot a 10 day moving average: AvgC10

2. Offset by -5: Can be achieved on the chart easily

3. As we are using negative offset, current bar or 5 recent bars will not show #2 above

4. Need to plot as histogram or bar chart: Mean of bar + L - #2 value which makes the plot considering #2 as zero line

(H-L)/2 + L - #2 value at that bar (dont care about recent 5 bars)

 

Can this be achieved in any form?

 

any help is much apppreciated.

Bruce_L
Posted : Tuesday, May 1, 2018 10:06:11 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The formula for the most recent value of what you want would be the following which could be plotted as a Custom PCF Indicator.

(H5 + L5) / 2 - AVGC10

You can then add a 1-period simple moving average with an offset of -5 and the Plot Style set to Histogram to the Custom PCF Indicator to plot it where you want it on the chart. Set the opacity of the original Custom PCF Indicator all the way to the left if you don't want it to plot as well.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
IsItPossible
Posted : Sunday, May 6, 2018 1:19:21 PM
Registered User
Joined: 7/7/2008
Posts: 115

Thanks :-)

Bruce_L
Posted : Monday, May 7, 2018 8:59:47 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.