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

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


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

PureBytes Links

Trading Reference Links

That'll simplify things a million fold!  Thanks!

--- In amibroker@xxxxxxxxxxxxxxx, "ta" <tagroups@xxx> wrote:
>
> 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/

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/