PureBytes Links
Trading Reference Links
|
Hi.
I was wondering if there was a way to access and manipulate (eg: getcount, getname, add, remove, gettickerlist etc) the AB watch lists via OLE and MS-Excel's VBA. The AB object model only references "watchlistbits" as a property of "stock" and a thread in this forum from Nov 2009 "seems" to indicate that this isn't possible? I suppose I can iterate through the entire list of symbols and check the watchlistbits for each watchlist membership, but I still wouldn't know the name of the watchlists or have a way of setting/deleting etc the watchlists.
Basically what I'm trying to do is to get all the watchlists as well as all the symbols in each watchlist easily in/out of Excel. This would really help in cleaning, organizing, backing up and creating watch lists "on the fly" as I have several lists of tickers created from various sources consolidated in an Excel spreadsheet.
I'm using AB 5.20pro and Excel 2003
Thanks.
------------------------------------
**** 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/
|