amisur
April 27, 2020, 4:04pm
#1
Dear Members,

I tried the below AFL based on the formula given by Mr.Modhelius in TradingView

Source Code;
res = ((baseSymbol/baseSymbol[lenght])/(comparativeSymbol/comparativeSymbol[lenght]) - 1)

Is it possible to add exploration column to find out if "res" is making higher highs or Lower Lows?

```
//Relative Strength
res = (Ref(C,1) / Ref(C,-55)) / (Ref(Foreign("Nifty 50","C"),1) / Ref(Foreign("Nifty 50","C"),-55)) -1 ;
Filter=1;
AddColumn (res,"RS-55",1.2);
```

Thank you

amisur:

`Ref(C,1)`

First you should realize that upper Ref() call looks into future!
Instead you should look back `Ref(C,-1)`

.

Secondly your `res`

equation has lots of over-complication.

It can be written like this

```
frg_price= Foreign("Nifty50","C");
res = Ref(C/frg_price,-1) * Ref(frg_price/C,-55) -1;
```

-> Division by multiplying a reciprocal

(BTW, are you sure your ticker is "Nifty 50"? Tickers don't have space).

As for higher highs / lower lows e.g. you may use HHV () and LLV () functions.

@amisur ,

What have you tried?

Go back to basics and learn how to find the Highest High value of something simple like the High value of the last few bars. That should lead you to what you need.

amisur
April 27, 2020, 4:39pm
#4
Thank you for correcting my mistake. I should look back Ref(c,-1)

"Nifty 50" is not ticker, Its the symbol for Index

nsm51
April 27, 2020, 5:03pm
#5
AB is smart
Conventionally, symbols don't have spaces but the Indices on NSE do have spaces and when such data is imported, it works out of the box.
Data vendors sometimes use the alternate name without spaces when streaming RTD.

Yes, IB symbols may have spaces too.

E.g. options

```
XXXX 200501C00155000-SMART-OPT
```

or future symbols.

Just not being a fan of spaces.