You could choose the foreign data by examining the market a stock belongs to. In this case, you do not need the IIF function, a simple IF statement will work, since the market does not change on different bars.
marketName = MarketID(1); if (marketName == "Nasdaq") indexTicker = "!NDX"; // adjust for your database else indexTicker = "!SPX"; // adjust for your database index = Foreign(indexTicker, "C"); Hope that helps, Steve --- In [email protected], "Robert" <[EMAIL PROTECTED]> wrote: > > Here is a question I would like to querry the group with: > > Is there a way using and IIF statement that would allow for the > choosing of the proper foreign data for the stock in question? > > an example > > BEAS is a Nasdaq component stock but during the exploration if the > foreign data is not known, Dow Nas or Amex can a statement be written > that would allow for the proper selection of the foreign data > component automatically when looking to compare the stock against? > > Disq >
