Mike, I tried it and it worked great. The only change I had to make was to create each pair twice with the symbols reversed i.e.
case "SNDK": data2 = "QCOM"; break; case "QCOM": data2 = "SNDK"; break; case "ORCL": data2 = "IBM"; break; case "IBM": data2 = "ORCL"; break; This showed me both sides of the trade for each pair. Thanks again for your elegant solution. --- In [email protected], "chapman49682" <chapman49...@...> wrote: > > Excellent! Thank you Mike; I'll give it a try. > > --- In [email protected], "Mike" <sfclimbers@> wrote: > > > > > > The following can be used for both scenarios (i.e. don't need Optimize > > statement). Just run on the complete watchlist. First symbol of each > > pair will cause data2 to be set and logic executed. When processing > > second symbol of each pair, data2 will be set to empty string and logic > > will not be executed. > > > > data1 = Name(); > > > > switch (data1) { > > case "SNDK": data2 = "QCOM"; break; > > case "ORCL": data2 = "IBM"; break; > > case "MSFT": data2 = "AAPL"; break; > > default: data2 = ""; break; > > } > > > > Filter = StrLen(data2); > > > > AddColumn(Close, "Price"); > > > > Mike > > > >
