Lower of formula - Trading Software

Lower of formula

JC
2018-11-17 13:47:33

Is there a formula such as the "lower of" two values?
for example I'd like to plot the lower of two indicators when using an exit. such as the lower of an SMA and the SAR for example

using pseudo code
close<"lowerof" sma(10), sar(o.2,0.2);

I'm sure it could be written as an IF statement. but it would be so much easier if there was

QuantShare
2018-11-19 04:09:09

Best Answer

Hi,

You can type something like:
a = min(sma(10), sar(0.2, 0.2));

For the IF Statement, you can type:
a = iff(condition, series1, series2);

Christian
2018-11-19 07:42:59

I have a similar problem, but with different series data.
With that formula I tried to get the lowest value from that three series, but the MIN function is not accepting that code:

v1 = GetSeries('C_1', close);
v2 = GetSeries('C_2', close);
v3 = GetSeries('C_3', close);
vMin = min(v1, v2, v3);

JC
2018-11-19 15:53:43

certainly works for my predicament, thanks for responding so quickly absolutely amazing

QuantShare
2018-11-20 04:06:46

Use this:
vMin = min(v1, min(v2, v3));

Christian
2018-11-21 06:08:36

Okay, thank you.

Get more messages

No more messages

Back


Trading Items Black-Scholes Option Pricing Model formula Trading based on Boillinger Lower Band position on defined Market PREV - Previous value of the same formula PIPS conversion formula in Forex trading Sharpe Ratio Ranking System to Lower Trading Strategies Volatilit...	How-to Lessons How to create a formula How to speed up watchlist and screener plug-ins when working with... How to change volume bar colors when the price closes down How to create a moving average of an indicator How to add a trading indicator to a chart
Related Forum Threads bollinger band & rsi formula formula use all over Formula Creatin Error in formula Guru, formula for line cross	Blog Posts Working with the formula editor Charting, Backtesting and Trading using Fundamental Data Different Types of Trading Indicators: Trend, Momentum, Volatilit... Forecast volatility using trading rules and neural networks 3 ways to rank stocks in a trading system - Simulator and Potfoli...