|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "h3po" <h3pooo@xxx> 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 amibroker@xxxxxxxxxxxxxxx, "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.
> >
>
------------------------------------
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
amibroker-digest@xxxxxxxxxxxxxxx
amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|