[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


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/