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.
