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

RE: [amibroker] Watch List via OLE/VBA?


  • Date: Thu, 21 Jan 2010 12:07:47 -0800
  • From: "ta" <tagroups@xxxxxxxxxxxxx>
  • Subject: RE: [amibroker] Watch List via OLE/VBA?

PureBytes Links

Trading Reference Links



The watchlists are simple text files (with tls extension) that could easily be imported into excel.

 

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of kurasake
Sent: Thursday, January 21, 2010 11:59 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Watch List via OLE/VBA?

 

 

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/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___