I seem to recall that changing the Name property of the ActiveDocument property
of the Application object will load the symbol. Haven't tried it recently
though, so I can't swear to it ;)
e.g. from JScript
ab = new ActiveXObject("Broker.Application");
ab.ActiveDocument.Name = "ORCL";
http://www.amibroker.com/guide/objects.html#Application
Mike
--- In [email protected], "kurasake" <kuras...@...> wrote:
>
> Hi.
>
> I'm trying to find some code in MS-Excel VBA that would allow me to select a
> cell in Excel containing a stock ticker, pass that stock ticker to AB and
> have AB select that symbol and change the graph/chart.
>
> I see plenty of examples that show how to export/import stock data but I
> don't seem to see any code or objects, methods. properties in the AB Object
> Model that would change the chart.
>
> The closest I've found is if I add a new ticker/symbol using the
> Stocks.Add(<stockname>) method then it will add the symbol to AB, switch to
> it and have the chart created on the fly (I'm using a live data feed). But,
> if the ticker already exists in AB then it does nothing.
>
> I'm using AB 5.2 Pro and Excel 2003
>
> Any help would be appreciated.
>
> Thank you.
>
