Index and Match Duplicates

[matthewlouis]

I am using Index and Match with the variable being a percentage. However, I have duplicate percentages that have different matches (rows). So it is only returning the first row's information.

How do I get the Index and Match formula to recognize the different data on different rows given the duplicate percentages.

=IF(D26<>"",INDEX('INDEX Bullish RR'!$A$1:$DL$1,MATCH(D26,'INDEX Bullish RR'!$A$2:$DL$2,0)),"") where D26 = 6.35% and returns one row of data -- then the next row is . . .

=IF(D26<>"",INDEX('INDEX Bullish RR'!$A$1:$DL$1,MATCH(D27,'INDEX Bullish RR'!$A$2:$DL$2,0)),"") where D27 ALSO = 6.35% but it still returns the data from the row above it and ignores this row's data.

Thanks in advance for your imput and ideas

 

[Aladin Akyurek]

I think I fail to get thru.

Do not talk about the formula you already have.

Just say this is my input and post the input.

Then say this the output that I want from that input and post that output.

 

[matthewlouis]

No, it's probably me . . . I don't understand sometimes

OK, this is my input or what I am calling the source sheet.

<tbody>
[TD="class: xl119"]Time Frame, Swing Point, Wide Price (WP), High Volume (HV)[/TD]
[TD="class: xl116, width: 241"]Date[/TD]
[TD="class: xl116, width: 218"]Low[/TD]
[TD="class: xl116, width: 234"]High[/TD]
[TD="class: xl118, width: 245"]Current Price[/TD]
[TD="class: xl117, width: 1360"]Status[/TD]
[TD="class: xl116, width: 196"]Bars Taken for SP Test[/TD]
[TD="class: xl115, width: 288"]Tests -- Support and Resistance[/TD]

[TD="class: xl110, width: 809"][/TD]
[TD="class: xl111, width: 241"][/TD]
[TD="class: xl112, width: 218"][/TD]
[TD="class: xl113, width: 234"][/TD]
[TD="class: xl113, width: 245"][/TD]
[TD="class: xl109, width: 1360"][/TD]
[TD="class: xl103, width: 196"][/TD]
[TD="class: xl108, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"]Daily SP High[/TD]
[TD="class: xl105, width: 241"]3/21/2018[/TD]
[TD="class: xl101, width: 218"]2,709.79[/TD]
[TD="class: xl101, width: 234"]2,739.14[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Over SPH[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]2.55%[/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"]Daily SP High[/TD]
[TD="class: xl105, width: 241"]3/13/2018[/TD]
[TD="class: xl101, width: 218"]2,758.68[/TD]
[TD="class: xl101, width: 234"]2,801.90[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Over SPH[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]4.90%[/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"]Daily SP High[/TD]
[TD="class: xl105, width: 241"]2/27/2018[/TD]
[TD="class: xl101, width: 218"]2,744.22[/TD]
[TD="class: xl101, width: 234"]2,789.15[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Over SPH[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]4.43%[/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl100"][/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"]Daily SP Low[/TD]
[TD="class: xl105, width: 241"]3/2/2018[/TD]
[TD="class: xl101, width: 218"]2,647.32[/TD]
[TD="class: xl101, width: 234"]2,696.25[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Failed[/TD]
[TD="class: xl106, width: 196"]1[/TD]
[TD="class: xl99, width: 288"]Failed[/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"]Daily SP Low[/TD]
[TD="class: xl105, width: 241"]4/10/2018[/TD]
[TD="class: xl101, width: 218"]2,635.78[/TD]
[TD="class: xl101, width: 234"]2,665.45[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Failed[/TD]
[TD="class: xl106, width: 196"]1[/TD]
[TD="class: xl99, width: 288"]Failed[/TD]

[TD="class: xl107, width: 809"]Daily SP Low[/TD]
[TD="class: xl105, width: 241"]4/2/2018[/TD]
[TD="class: xl101, width: 218"]2,553.80[/TD]
[TD="class: xl101, width: 234"]2,638.30[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-4.39%[/TD]

[TD="class: xl107, width: 809"][/TD]
[TD="class: xl105, width: 241"][/TD]
[TD="class: xl101, width: 218"][/TD]
[TD="class: xl101, width: 234"][/TD]
[TD="class: xl101, width: 245"][/TD]
[TD="class: xl104, width: 1360"][/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"][/TD]

[TD="class: xl107, width: 809"]Daily SP Low[/TD]
[TD="class: xl105, width: 241"]2/9/2018[/TD]
[TD="class: xl101, width: 218"]2,532.69[/TD]
[TD="class: xl101, width: 234"]2,638.67[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-5.18%[/TD]

[TD="class: xl107, width: 809"]Daily SP High[/TD]
[TD="class: xl105, width: 241"]4/18/2018[/TD]
[TD="class: xl101, width: 218"]2,703.63[/TD]
[TD="class: xl101, width: 234"]2,717.49[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Over SPH[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]1.74%[/TD]

[TD="class: xl107, width: 809"]Daily Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]2/9/2018[/TD]
[TD="class: xl101, width: 218"]2,532.69[/TD]
[TD="class: xl101, width: 234"]2,638.67[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Daily Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-1.21%[/TD]

[TD="class: xl107, width: 809"]Daily Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]2/6/2018[/TD]
[TD="class: xl101, width: 218"]2,593.07[/TD]
[TD="class: xl101, width: 234"]2,701.04[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Daily Wide Price and High Volume[/TD]
[TD="class: xl102"][/TD]
[TD="class: xl99, width: 288"]-3.00%[/TD]

[TD="class: xl107, width: 809"]Daily Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]2/8/2018[/TD]
[TD="class: xl101, width: 218"]2,580.56[/TD]
[TD="class: xl101, width: 234"]2,685.27[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Daily Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-3.50%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP High[/TD]
[TD="class: xl105, width: 241"]1/22/2018[/TD]
[TD="class: xl101, width: 218"]2,808.12[/TD]
[TD="class: xl101, width: 234"]2,872.87[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Over SPH[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]7.56%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP High[/TD]
[TD="class: xl105, width: 241"]3/12/2018[/TD]
[TD="class: xl101, width: 218"]2,741.47[/TD]
[TD="class: xl101, width: 234"]2,801.90[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Over SPH[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]4.90%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]11/13/2017[/TD]
[TD="class: xl101, width: 218"]2,557.45[/TD]
[TD="class: xl101, width: 234"]2,590.09[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-4.25%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]2/5/2018[/TD]
[TD="class: xl101, width: 218"]2,532.69[/TD]
[TD="class: xl101, width: 234"]2,763.39[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-5.18%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]10/2/2017[/TD]
[TD="class: xl101, width: 218"]2,520.40[/TD]
[TD="class: xl101, width: 234"]2,552.51[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-5.64%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]8/21/2017[/TD]
[TD="class: xl101, width: 218"]2,417.35[/TD]
[TD="class: xl101, width: 234"]2,454.77[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-9.49%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]6/26/2017[/TD]
[TD="class: xl101, width: 218"]2,405.70[/TD]
[TD="class: xl101, width: 234"]2,450.42[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-9.93%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]5/15/2017[/TD]
[TD="class: xl101, width: 218"]2,352.72[/TD]
[TD="class: xl101, width: 234"]2,405.77[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-11.91%[/TD]

[TD="class: xl107, width: 809"]Intermediate SP Low[/TD]
[TD="class: xl105, width: 241"]3/27/2017[/TD]
[TD="class: xl101, width: 218"]2,322.25[/TD]
[TD="class: xl101, width: 234"]2,370.42[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl120, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-13.05%[/TD]

[TD="class: xl107, width: 809"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]1/29/2018[/TD]
[TD="class: xl101, width: 218"]2,759.97[/TD]
[TD="class: xl101, width: 234"]2,870.62[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]3.23%[/TD]

[TD="class: xl107, width: 809"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]2/26/2018[/TD]
[TD="class: xl101, width: 218"]2,647.32[/TD]
[TD="class: xl101, width: 234"]2,789.15[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-0.89%[/TD]

[TD="class: xl107, width: 809"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]11/27/2017[/TD]
[TD="class: xl101, width: 218"]2,598.87[/TD]
[TD="class: xl101, width: 234"]2,657.74[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-0.49%[/TD]

[TD="class: xl107, width: 809"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]2/5/2018[/TD]
[TD="class: xl101, width: 218"]2,532.69[/TD]
[TD="class: xl101, width: 234"]2,763.39[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-5.46%[/TD]

[TD="class: xl107, width: 809"]Monthly SP High[/TD]
[TD="class: xl105, width: 241"]5/1/2015[/TD]
[TD="class: xl101, width: 218"]2,067.93[/TD]
[TD="class: xl101, width: 234"]2,134.72[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Closed Over SPH ** Tested SPH High on HIGHER Volume ** Hasn't Failed[/TD]
[TD="class: xl106, width: 196"]2[/TD]
[TD="class: xl99, width: 288"]-20.08%[/TD]

[TD="class: xl107, width: 809"]Monthly SP High[/TD]
[TD="class: xl105, width: 241"]11/1/2015[/TD]
[TD="class: xl101, width: 218"]2,019.39[/TD]
[TD="class: xl101, width: 234"]2,116.48[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Closed Over SPH ** Tested SPH High on LESS Volume ** Hasn't Failed[/TD]
[TD="class: xl106, width: 196"]3[/TD]
[TD="class: xl99, width: 288"]-24.39%[/TD]

[TD="class: xl107, width: 809"]Monthly SP Low[/TD]
[TD="class: xl105, width: 241"]5/1/2017[/TD]
[TD="class: xl101, width: 218"]2,352.72[/TD]
[TD="class: xl101, width: 234"]2,418.71[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-11.91%[/TD]

[TD="class: xl107, width: 809"]Monthly SP Low[/TD]
[TD="class: xl105, width: 241"]11/1/2016[/TD]
[TD="class: xl101, width: 218"]2,083.79[/TD]
[TD="class: xl101, width: 234"]2,214.10[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-21.98%[/TD]

[TD="class: xl107, width: 809"]Monthly SP Low[/TD]
[TD="class: xl105, width: 241"]10/1/2014[/TD]
[TD="class: xl101, width: 218"]1,820.66[/TD]
[TD="class: xl101, width: 234"]2,018.19[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-31.83%[/TD]

[TD="class: xl107, width: 809"]Monthly SP Low[/TD]
[TD="class: xl105, width: 241"]2/1/2016[/TD]
[TD="class: xl101, width: 218"]1,810.10[/TD]
[TD="class: xl101, width: 234"]1,962.96[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-32.23%[/TD]

[TD="class: xl107, width: 809"]Monthly SP Low[/TD]
[TD="class: xl105, width: 241"]2/1/2014[/TD]
[TD="class: xl101, width: 218"]1,737.92[/TD]
[TD="class: xl101, width: 234"]1,867.92[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-34.93%[/TD]

[TD="class: xl107, width: 809"]Monthly SP Low[/TD]
[TD="class: xl105, width: 241"]8/1/2013[/TD]
[TD="class: xl101, width: 218"]1,627.47[/TD]
[TD="class: xl101, width: 234"]1,709.67[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl104, width: 1360"]Hasn't Closed Under SPL[/TD]
[TD="class: xl106, width: 196"][/TD]
[TD="class: xl99, width: 288"]-39.07%[/TD]

[TD="class: xl107, width: 809"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]3/1/2016[/TD]
[TD="class: xl101, width: 218"]1,937.09[/TD]
[TD="class: xl101, width: 234"]2,072.21[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-22.42%[/TD]

[TD="class: xl107, width: 809"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]1/1/2016[/TD]
[TD="class: xl101, width: 218"]1,812.29[/TD]
[TD="class: xl101, width: 234"]2,038.20[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-23.69%[/TD]

[TD="class: xl107, width: 809"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]10/1/2014[/TD]
[TD="class: xl101, width: 218"]1,820.66[/TD]
[TD="class: xl101, width: 234"]2,018.19[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-24.44%[/TD]

[TD="class: xl107, width: 809"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl105, width: 241"]2/1/2016[/TD]
[TD="class: xl101, width: 218"]1,810.10[/TD]
[TD="class: xl101, width: 234"]1,962.96[/TD]
[TD="class: xl101, width: 245"]2,670.93[/TD]
[TD="class: xl100"]Monthly Wide Price and High Volume[/TD]
[TD="class: xl114"][/TD]
[TD="class: xl99, width: 288"]-26.51%[/TD]

</tbody>

 

[matthewlouis]

This is my output

<colgroup><col style="mso-width-source:userset;mso-width-alt:2592;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:13344;width:313pt" width="417"> <col style="mso-width-source:userset;mso-width-alt:7520;width:176pt" width="235"> <col style="mso-width-source:userset;mso-width-alt:4352;width:102pt" width="136"> <col style="mso-width-source:userset;mso-width-alt:4320;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:5952;width:140pt" width="186"> <col style="mso-width-source:userset;mso-width-alt:3008;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:6528;width:153pt" width="204"> <col style="mso-width-source:userset;mso-width-alt:22752;width:533pt" width="711"> </colgroup><tbody>
[TD="class: xl111, width: 81"] [/TD]
[TD="class: xl103, width: 417"]Intermediate SP High[/TD]
[TD="class: xl101, width: 235"]1/22/2018[/TD]
[TD="class: xl98, width: 136, align: right"]2,808.12[/TD]
[TD="class: xl98, width: 135, align: right"]2,872.87[/TD]
[TD="class: xl102, width: 186, align: right"]7.55%[/TD]
[TD="class: xl110, width: 94"]1[/TD]
[TD="class: xl99, width: 204"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Over SPH[/TD]

[TD="class: xl111"]17[/TD]
[TD="class: xl105"]Daily SP High[/TD]
[TD="class: xl108, align: right"]3/13/2018[/TD]
[TD="class: xl109, align: right"]2,758.68[/TD]
[TD="class: xl109, align: right"]2,801.90[/TD]
[TD="class: xl102, align: right"]4.89%[/TD]
[TD="class: xl110"]2[/TD]
[TD="class: xl99"] [/TD]
[TD="class: xl106"]Hasn't Closed Over SPH[/TD]

[TD="class: xl111"]34[/TD]
[TD="class: xl105"]Intermediate SP High[/TD]
[TD="class: xl108, align: right"]3/12/2018[/TD]
[TD="class: xl109, align: right"]2,741.47[/TD]
[TD="class: xl109, align: right"]2,801.90[/TD]
[TD="class: xl102, align: right"]4.89%[/TD]
[TD="class: xl110"]2[/TD]
[TD="class: xl99"] [/TD]
[TD="class: xl106"]Hasn't Closed Over SPH[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily SP High[/TD]
[TD="class: xl101"]2/27/2018[/TD]
[TD="class: xl98, align: right"]2,744.22[/TD]
[TD="class: xl98, align: right"]2,789.15[/TD]
[TD="class: xl102, align: right"]4.41%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl99"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Over SPH[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl101"]1/29/2018[/TD]
[TD="class: xl98, align: right"]2,759.97[/TD]
[TD="class: xl98, align: right"]2,870.62[/TD]
[TD="class: xl102, align: right"]3.21%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl99"]0[/TD]
[TD="class: xl104, width: 711"]Intermediate Wide Price and High Volume[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily SP High[/TD]
[TD="class: xl101"]3/21/2018[/TD]
[TD="class: xl98, align: right"]2,709.79[/TD]
[TD="class: xl98, align: right"]2,739.14[/TD]
[TD="class: xl102, align: right"]2.54%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl99"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Over SPH[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily SP High[/TD]
[TD="class: xl101"]4/18/2018[/TD]
[TD="class: xl98, align: right"]2,703.63[/TD]
[TD="class: xl98, align: right"]2,717.49[/TD]
[TD="class: xl102, align: right"]1.73%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl99"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Over SPH[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl101"]11/27/2017[/TD]
[TD="class: xl98, align: right"]2,598.87[/TD]
[TD="class: xl98, align: right"]2,657.74[/TD]
[TD="class: xl102, align: right"]-0.51%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl99"]0[/TD]
[TD="class: xl104, width: 711"]Intermediate Wide Price and High Volume[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Intermediate Wide Price and High Volume[/TD]
[TD="class: xl101"]2/26/2018[/TD]
[TD="class: xl98, align: right"]2,647.32[/TD]
[TD="class: xl98, align: right"]2,789.15[/TD]
[TD="class: xl102, align: right"]-0.90%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl100"]0[/TD]
[TD="class: xl104, width: 711"]Intermediate Wide Price and High Volume[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily Wide Price and High Volume[/TD]
[TD="class: xl101"]2/9/2018[/TD]
[TD="class: xl98, align: right"]2,532.69[/TD]
[TD="class: xl98, align: right"]2,638.67[/TD]
[TD="class: xl102, align: right"]-1.22%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl100"]0[/TD]
[TD="class: xl104, width: 711"]Daily Wide Price and High Volume[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily Wide Price and High Volume[/TD]
[TD="class: xl101"]2/6/2018[/TD]
[TD="class: xl98, align: right"]2,593.07[/TD]
[TD="class: xl98, align: right"]2,701.04[/TD]
[TD="class: xl102, align: right"]-3.02%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl100"]0[/TD]
[TD="class: xl104, width: 711"]Daily Wide Price and High Volume[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily Wide Price and High Volume[/TD]
[TD="class: xl101"]2/8/2018[/TD]
[TD="class: xl98, align: right"]2,580.56[/TD]
[TD="class: xl98, align: right"]2,685.27[/TD]
[TD="class: xl102, align: right"]-3.51%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl100"]0[/TD]
[TD="class: xl104, width: 711"]Daily Wide Price and High Volume[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Intermediate SP Low[/TD]
[TD="class: xl101"]11/13/2017[/TD]
[TD="class: xl98, align: right"]2,557.45[/TD]
[TD="class: xl98, align: right"]2,590.09[/TD]
[TD="class: xl102, align: right"]-4.26%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl100"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Under SPL[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily SP Low[/TD]
[TD="class: xl101"]4/2/2018[/TD]
[TD="class: xl98, align: right"]2,553.80[/TD]
[TD="class: xl98, align: right"]2,638.30[/TD]
[TD="class: xl102, align: right"]-4.40%[/TD]
[TD="class: xl110"]1[/TD]
[TD="class: xl100"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Under SPL[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl103, width: 417"]Daily SP Low[/TD]
[TD="class: xl101"]2/9/2018[/TD]
[TD="class: xl98, align: right"]2,532.69[/TD]
[TD="class: xl98, align: right"]2,638.67[/TD]
[TD="class: xl102, align: right"]-5.19%[/TD]
[TD="class: xl110"]2[/TD]
[TD="class: xl100"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Under SPL[/TD]

[TD="class: xl111"] [/TD]
[TD="class: xl107, width: 417"]Daily SP Low[/TD]
[TD="class: xl101"]2/9/2018[/TD]
[TD="class: xl98, align: right"]2,532.69[/TD]
[TD="class: xl98, align: right"]2,638.67[/TD]
[TD="class: xl102, align: right"]-5.19%[/TD]
[TD="class: xl110"]2[/TD]
[TD="class: xl100"] [/TD]
[TD="class: xl104, width: 711"]Hasn't Closed Under SPL[/TD]

</tbody>

 

[Aladin Akyurek]

Thanks. What is the rule by which we get the output?

 

[matthewlouis]

It's how far (as a precentage) that the current price is from the low or the high DEPENDING on what the last column says . . . example: if the last column says, "Hasn't Closed Over SP High" then it's the percentage the current price (found in the input table) is away from the High. Or, if it says "Hasn't Closed Under SP Low" the percentage is how far the current price is away from the low.

 

[Aladin Akyurek]

"What is the rule by which we get the output?"

This means: What are we testing? Are we testing the Status column or are we testing the Tests -- Support and Resistance column?

 

[matthewlouis]

We are testing the current price against Support and Resistance columns -- these are the prices of significance, and these Support and Resistance prices are defined as to what they are in Column B and the date they occurred in Column C. The status column is the result that measures where the test is.

In the massive table with all the empty rows I posted, do you see 2,760 all the way down -- that is current price and that is what we're testing against Support and Resistance -- the lows and highs in that HUGE table with all the blank rows. This is where the percentage comes in -- how far away is the current price test from Support and Resistance?

Is the current price above the prices of significance's high? Or, is the current price below the price of significance's low?

Thanks for your patience -- I hope this is more precise in what you are asking, the way you asked it certainly helps.

 

[matthewlouis]

Hi Aladin, did you see my last post? Does that answer your question better? What do you think?

 

[matthewlouis]

Aladin?

 

[Aladin Akyurek]

Hi Aladin, did you see my last post? Does that answer your question better? What do you think?

1. Create a scaled-down sample (input) which does not contain irrelevant details (columns).
2. Create the output that must be obtained from the input.
3. State clearly what part of the output is computed (must be computed) and how.