[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: How to auto-import symbol list in worksheet of Excel into AB?



PureBytes Links

Trading Reference Links


How can i do it if i want the list to be imported with industry id i 
mean under sectors/industry i have the list in excel with symbols & 
industry id.
 sanjayt





--- In amibroker@xxxxxxxxxxxxxxx, "hairy_mug" <WSCHWARZ@xxxx> wrote:
> 
> in excel, erase all the columns except for the symbol.
> 
> save this one column sheet into a "csv" file.
> 
> in AB goto menu
>  symbol >
>      watchlist >
>             import
> 
> enter the file name and the symbols are now in AB
> 
> To automate the process, build an Excel macro and use 
> the AB OLE object detailed in the help file.
> 
> Walt
>  
> --- In amibroker@xxxxxxxxxxxxxxx, "masspectrometry" 
<yangwangyw@xxxx> 
> wrote:
> > 
> > 
> > anyone know how to auto-import symbol list in worksheet of Excel 
> into 
> > AB?





------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> 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/