Ratio of indicators instead of stock prices

[vgt2101]

I would like to plot the ratio of the results of an indicator between two different stocks/ticker symbols. Meaning the ratio of SPY's RSI (21) / MSFT's RSI (21) as an example. In this example, SPY and MSFT are stocks/ticker symbols, RSI is an indicator, and (21) is the amount of days for the indicator.

 

[Joshua]

declare lower;
def MSFT = RSI(21,price = close("MSFT"));
def SPY = RSI(21,price = close("SPY"));
plot Ratio = SPY / MSFT;

 

[majidg]

declare lower;
def MSFT = RSI(21,price = close("MSFT"));
def SPY = RSI(21,price = close("SPY"));
plot Ratio = SPY / MSFT;

it always shows same rsi for MSFT and SPY or any other symbol?
the label for SPY and MSFT or any other symbol compare to SPY always show the same number, Can you please help to fix this to show actual RSI value for both?

 

[halcyonguy]

it always shows same rsi for MSFT and SPY or any other symbol?
the label for SPY and MSFT or any other symbol compare to SPY always show the same number, Can you please help to fix this to show actual RSI value for both?

he created a study to do exactly what you asked for.
if you want something different, ask a different question.
what do you want to see?

 

[majidg]

he created a study to do exactly what you asked for.
if you want something different, ask a different question.
what do you want to see?

Thanks, I see that now

 

[vgt2101]

he created a study to do exactly what you asked for.
if you want something different, ask a different question.
what do you want to see?

Can the same code be created for the money flow index? So I'd like to see the plot of SPY's Money Flow Index period 21 : MSFT's Money Flow Index period 21.

 

[vgt2101]

So I'd like to see the plot of SPY's Money Flow Index period 21 : MSFT's Money Flow Index period 21. I would like to plot the ratio of the results of an indicator between two different stocks/ticker symbols.

 

[netarchitech]

Upon further review, it would appear that my previous reply did not properly address @vgt2101's request...Further testing has yielded the following script that I believe does find the correct ratio:

declare lower;

script mfi {
    input length = 21;
    input movingAvgLength = 1;
    input symbol  = "SPY";

    plot MoneyFlowIndex = Average(moneyflow(high(symbol), close(symbol), low(symbol), volume(symbol), length), movingAvgLength);
}

input symbol1 = "SPY";
input symbol2 = "MSFT";

def s1  = mfi(symbol = symbol1);
def s2  = mfi(symbol = symbol2);

def sym1 = if IsNaN(s1) then s1[1] else s1;
def sym2 = if IsNaN(s2) then s2[1] else s2;

plot Ratio = sym1 / sym2;

Hope this helps...

Good Luck and Good Trading

 

[majidg]

Upon further review, it would appear that my previous reply did not properly address @vgt2101's request...Further testing has yielded the following script that I believe does find the correct ratio:

declare lower;

script mfi {
    input length = 21;
    input movingAvgLength = 1;
    input symbol  = "SPY";

    plot MoneyFlowIndex = Average(moneyflow(high(symbol), close(symbol), low(symbol), volume(symbol), length), movingAvgLength);
}

input symbol1 = "SPY";
input symbol2 = "MSFT";

def s1  = mfi(symbol = symbol1);
def s2  = mfi(symbol = symbol2);

def sym1 = if IsNaN(s1) then s1[1] else s1;
def sym2 = if IsNaN(s2) then s2[1] else s2;

plot Ratio = sym1 / sym2;

Hope this helps...

Good Luck and Good Trading

what can be done to make symbol2 to be any symbol? when I put getsymbol() for "MSFT" I am not able to add label, or label will disappear.