|
PureBytes Links
Trading Reference Links
|
At 10:43 08/12/00 -0800, kimberly@xxxxxxxxxx wrote:
>Is it the retrieval of the data from within cells which is
>inefficient(processing)? Execution engine?
Passing data into worksheets and reading it from there is relatively
slow. Processing it in VB or VBA (as arrays) or through worksheet formulae
is fine. I'm doing it.
>How about using a SQL interface to read in the data?
That still doesn't take care of live updates, and DDE is too slow. (SQL
Server is nice for a history database, though.) A couple of companies
offer software development kits that allow you to use COM to connect to
their feed. Have a look at http://developer.futuresource.com for a
start. Not cheap, but it's a good product.
Regards,
Stefan Schulz
Suaviter Limited
prog1@xxxxxxxxxxxxxx
|