I will look around as I seem to remember something on this posted here. Until then, you can always use Excel to shift the column of tickers to a row of tickers. Just hightlight the column, copy it, paste special using transpose and the column will end up as a row.
--- In [email protected], "h3po" <h3p...@...> wrote: > > Hi, thanks, but I'd rather not do it manually:) Say, I have about 200 tickers > that have passed the test in the filter, so it should cycle through the these > tickers automatically (like stated in the first post), creating 200 columns. > Is it possible? > > > --- In [email protected], "hjansenvanrensburg" <hjansenvanrensburg@> > wrote: > > > > > > Sorry, I missed the bit about the columns. Try this: > > > > t1 = Foreign("TICKERNAME1", "C"); > > AddColumn(t1, "TICKERNAME1 Close", 1.0); > > t2 = Foreign("TICKERNAME2", "C"); > > AddColumn(t2, "TICKERNAME2 Close", 1.0); > > etc. > > > > I hope that does the trick. > > >
