Addins for Excel - Historical Data

[jdowd]

Is anyone aware of any activeX add-ins that have been developed to pull historical market data (closing prices, volumes, etc.) into Excel? I looked for any code examples in the shared files area, other than the brief examples in the user manual, and there does not appear to be anything there...

[gordonrose]

I'm sure you're well aware, but just in case, you can of course automate Excel as easily as you can automate the ActiveX control and generate any set of worksheets you would want.

Regards,

Gordon

[macavity_katt]

Excel Add-In

I have a 500 symbol limit.
Is there a way that I can pull in prices into Excel from a VBA request.
I do not need real-time prices, but I need to pull in (closing) prices of various options, and there are more than 500 symbols across all the expiries, stocks, etc..

-macavity