Hi Guys,

I have a formula which makes use of the ValueWhen() function to start a series of values when a condition is met.

Is there a way of ending the series when another condition is met?

For example I have a trailing stop which follows under rising prices, and as soon as it is greater than a bar/candle Low I would like the series to end, as I will have exited the trade.

Currently the plotted line of the series continues all the way across the chart ad infinitum. But I would like it to stop dead when it hits a bar/candle. Otherwise if I enter a trade on the same stock a number of times, I keep getting old remnant dead series plotting across the chart messing it up.

I have been able to send the series to value zero (0) so it at least plots the rest of the series along the bottom of the chart, but its still messy, and means my chart's vertical axis has to range from 0 to the current trading price, which can make my bars/candles unusably stunted.

Ideally I would love a ValueUntil() function which would work in an equivalent but opposite way to ValueWhen(), to turn off the series of values once a condition is met.

I don't think I can use Ref() as I don't want to turn it off for the last x periods, I want it turned off permanently from a certain point onwards forever.

Any other ways I can turn off a series of values?

Thanks for any help you can offer.

Regards

Drew

Hi Roy,

Thanks so much for quick and detailed reply. It will take me a few days to process that and try a few things. But I will get back to you once I have tested your theory, and a couple of others I have had in the past 24hrs. I was thinking that if I could multiply the "post-stop" series values (ie the values of the series that I don't want plotted) by an "undefined" value, that maybe the post-stop series values would become undefined themselves, and hence not be plotted. Just a theory - I have no idea whether it even makes sense (except to me).

Thanks again for the great lead - looks hopeful - I appreciate it

Kind Regards

Drew

Hi Roy,

Well thanks to your help I've been able to achieve my initial goal (and a little extra). The following code plots an EMA90 whenever its less then an EMA30. It successfully turns the plot on and off again (which is more than what I was originally after).

ema30 := Mov(C, 30, E);
ema90 := Mov(C, 90, E);
undefined := ValueWhen(1, 0, 0);
plottedEma90 := ema90 * if(ema90 < ema30, 1, undefined);
plottedEma90;

However its not perfect - I am still experiencing the issue where if I zoom into an area of the chart where the EMA90 has been switched off, the scale will range from the highest High of the visible bars down to zero (0) - I'm guessing because the plottedEma90 becomes N/A, and that is probably defaulted to 0 by the chart rendering rules.

When I scroll into the middle of a long uptrend and I have plenty of visible EMA90 on either side of the visible bars, then the display behaves itself and the vertical (price) scale will range from the highest High to the lowest Low of the visible bars.

Roy, you seemed to think you could disassociate the plot from the vertical scale. I don't what you mean by "This is done by adding an N/A result as a second output to the primary result that you want." How do you add a value as a second output to the primary?

Do you still think that's possible even when the plot values are undefined?

Anyway - getting closer - unfortunately it won't be much use if I can't get the vertical scales working correctly.

Have a play and see what you think - many thanks again Roy

Kind Regards

Drew