new to activeX : Basic Real Time quotes

[superpolo]

Hi I am new to activeX and this is probably a very simple question to all of you (i am still using DDEs but i've got to switch)

I downloaded the sample signalbook.xls and the help reference doc, but it still is not very clear.

I need to basically have a list of 50 stocks and quotes fields that update in real time on an excel spreadsheet.
i need last, bid, ask, change, high, low, close, open and volume.
with the GetBasicQuote, it seems i can only get bid, ask, last.

With DDEs i used to fill an array with formulas and print the array as a big block.
Is it possible to do something similar with activeX?

Does anyone have that sample code already available?

Thank you

[GenSpoo]

You are correct that GetBasicQuote doesn't provide all the info you are looking for. The work around would be to use RequestHistory to gather bars for those symbols and then get the info you need from the bars. Certainly not quite as simple as the DDE solution in this case. I'm not an Excel guy, so maybe someone else can work up a sample or share on if they have it.

Cheers... George