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 plot a stock using different periods in the same chart How to create a screen How to create histogram charts
Related Forum Threads bollinger band & rsi formula formula use all over guru ,Help in formula Formula builder exit rule formula on high	Blog Posts Working with the formula editor Charting, Backtesting and Trading using Fundamental Data Backtesting a Strategy Based on Bond and Stock Index ETFs Fundamental Stock Analysis: Rank stocks based on a valuation rati... Different Types of Trading Indicators: Trend, Momentum, Volatilit...