Sorry Mike, did see your Transpose reply or I would not have provided same.
Here is an afl to place each Stock Name in row from any watchlist. Is this
what hjansenvanrensburg is looking for?
// Start
WatchListNo = Param("WatchListNo", 0, 0, 63, 1);
list = CategoryGetSymbols( categoryWatchlist, WatchListNo );
//Filter = 1;
Filter = Status("lastbarinrange");
SetOption("NoDefaultColumns", True);
for( i = 0; ( symbol = StrExtract( list, i ) ) != ""; i++ )
{
AddTextColumn(symbol, "Symbol");
}
// End
This places the (stock) Symbol header in row 1 and the actual Stock Symbol in
row 2. I do not know how to eleminate row1 and just have symbols in row 1 with
nothing else. I guess I could do by opening file and writing just what I need.
--- In [email protected], "Mike" <sfclimb...@...> wrote:
>
> If you want to spare yourself the programming, just do the normal Exploration
> with AddColumn, giving one row per symbol. Then when opening the .csv file in
> excel; copy the data and right click to where you want to past it - using
> Paste Special. From the Paste Special dialog just select the "Transpose"
> option.
>
> Mike
>
> --- In [email protected], "h3po" <h3pooo@> wrote:
> >
> > Hi, thanks.
> >
> > Yes, I have tried that, but all tickers are then written to only one column
> > containing the tickerdata successively, so it is difficult to separate them
> > when opening the .csv file in other programs. I need each ticker to have
> > their own column..
> >
> >
> >
> > --- In [email protected], "hjansenvanrensburg"
> > <hjansenvanrensburg@> wrote:
> > >
> > >
> > > You don't have to use a loop. Just by adding
> > >
> > > AddColumn(C, "Close", 1.0);
> > >
> > > to your formula, you will be able to use
> > >
> > > Analysis, Automatic Analysis, Explore
> > >
> > > to get a list of ticker name, dates and closing prices. You can then save
> > > the results as a CSV file (File button).
> > >
> > > To select all the tickers that you are interested in, create a watch list
> > > and then use "use filter" and the Define button (also on the Automatic
> > > Analysis dialog) to only export those tickers that are on the watch list.
> > > You can also specify the date range that you are interested in, or export
> > > all the available bars.
> > >
> >
>
