Symbol Sector Comparison to Current Chart

[stockmonkey]

Hi Everyone!

I have a small watchlist consisting about 20 symbols. I'm looking for a way to have a study that will add the underlying sector ETF as a comparison to the currently selected ticker. For example:

My watchlist:

ACGLN	ARCH CAPITAL GROUP DEP SHS REP 1/1000TH PFD *CLBL	Financials
ABR	ARBOR REALTY TRUST INC COM USD0.01	Financials
ABCM	ABCAM PLC ADR SPONSORED	Health Care
AAT	AMERICAN ASSETS TRUST INC COM USD0.01	Real Estate
AB	ALLIANCEBERNSTEIN HOLDING LP SBI	Financials
ABNB	AIRBNB INC COM CL A	Consumer Discretionary
ACA	ARCOSA INC COM	Industrials
AAPL	APPLE INC COM	Information Technology

When I have Apple as my current chart is there a way that the study can check the listed symbols from the above list (already coded as a part of this study) and find the corresponding sector of the current chart symbol (Information Technology for the Apple example) and add the corresponding ETF from the below listed as a comparison overlaying chart:

Cyclicals = "XLY";
Technology = "XLK";
Industrials = "XLI";
Materials = "XLB";
Energy = "XLE";
Staples = "XLP";
HealthCare = "XLV";
Utilities = "XLU";
Financials = "XLF";

Hope I was clear in my expression and thanks so much for any help in advance.

 

[JamesB]

Stockmonkey, could you please share what information that you are looking for from the secondary symbol. For example, do you want to be able to see what the MACD of XLK is doing while you are on a chart of AAPL? Thus, is there a particular indicator that you want to be able to see of a secondary symbol, or are you looking for something else?

 

[halcyonguy]

Hi Everyone!

I have a small watchlist consisting about 20 symbols. I'm looking for a way to have a study that will add the underlying sector ETF as a comparison to the currently selected ticker. For example:

My watchlist:

ACGLN	ARCH CAPITAL GROUP DEP SHS REP 1/1000TH PFD *CLBL	Financials
ABR	ARBOR REALTY TRUST INC COM USD0.01	Financials
ABCM	ABCAM PLC ADR SPONSORED	Health Care
AAT	AMERICAN ASSETS TRUST INC COM USD0.01	Real Estate
AB	ALLIANCEBERNSTEIN HOLDING LP SBI	Financials
ABNB	AIRBNB INC COM CL A	Consumer Discretionary
ACA	ARCOSA INC COM	Industrials
AAPL	APPLE INC COM	Information Technology

When I have Apple as my current chart is there a way that the study can check the listed symbols from the above list (already coded as a part of this study) and find the corresponding sector of the current chart symbol (Information Technology for the Apple example) and add the corresponding ETF from the below listed as a comparison overlaying chart:

Cyclicals = "XLY";
Technology = "XLK";
Industrials = "XLI";
Materials = "XLB";
Energy = "XLE";
Staples = "XLP";
HealthCare = "XLV";
Utilities = "XLU";
Financials = "XLF";

Hope I was clear in my expression and thanks so much for any help in advance.

this should work , to get you started

def na = double.nan;
def z;
if GetSymbol() == "AAPL" then {
z= close("XLK")

# copy these 2 lines and replace symbols as needed
} else if GetSymbol() == "ACA" then {
z= close("XLI")

} else {
z = 0;
};

plot z2 = if z>0 then z else na;

 

[stockmonkey]

Stockmonkey, could you please share what information that you are looking for from the secondary symbol. For example, do you want to be able to see what the MACD of XLK is doing while you are on a chart of AAPL? Thus, is there a particular indicator that you want to be able to see of a secondary symbol, or are you looking for something else?

Hi JamesB!
Thanks for the reply. I’m looking for what XLK is doing while I am on a chart of AAPL. XLK As an overlay (or compare with study) on the AAPL chart. Similar to that when I am on another symbol like ABCM which is a healthcare sector I’m looking for XLV as the overlay(comparison study) on the ABCM chart. I hope I was able to explain better this time.

 

[JamesB]

Hi JamesB!
Thanks for the reply. I’m looking for what XLK is doing while I am on a chart of AAPL. XLK As an overlay (or compare with study) on the AAPL chart. Similar to that when I am on another symbol like ABCM which is a healthcare sector I’m looking for XLV as the overlay(comparison study) on the ABCM chart. I hope I was able to explain better this time.

#This will chart a symbol in the subgraph if that is what you are after.

# thanks to @mashume for the method
declare lower;
input symbol = "XLK";

def nan = double.nan;
def o = open(symbol = symbol);
def c = close(symbol = symbol);
def h = high(symbol = symbol);
def l = low(symbol = symbol);

AddChart(high = if c > o then h else nan,
low = if c > o then l else nan,
close = if c > o then c else nan,
open = if c > o then o else nan,
ChartType.CANDLE, Color.GREEN);
AddChart(high = if c < o then h else nan,
low = if c < o then l else nan,
open = if c < o then o else nan,
close = if c < o then c else nan,
ChartType.CANDLE, Color.RED);
AddChart(high = if c == o then h else nan,
low = if c == o then l else nan,
open = if c == o then o else nan,
close = if c == o then c else nan,
ChartType.CANDLE, Color.GRAY);