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

[amibroker] Watch List via OLE/VBA?


  • Date: Thu, 21 Jan 2010 19:59:09 -0000
  • From: "kurasake" <kurasake@xxxxxxxxx>
  • Subject: [amibroker] Watch List via OLE/VBA?

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/