Serving the Quantitative Finance Community

Search found 5 matches

by IQuant1
March 19th, 2012, 9:15 pm
Forum: Programming and Software Forum
Topic: Calling non-registered COM .dll's from Excel VBA
Replies: 10
Views: 147656

Calling non-registered COM .dll's from Excel VBA

http://thecommon.net/3.htmlLook at directcom for regfree loading.Overall this is a fantastic free as beer toolset.
by IQuant1
March 1st, 2012, 4:39 pm
Forum: Programming and Software Forum
Topic: Best way to have real time data in Excel
Replies: 14
Views: 57001

Best way to have real time data in Excel

<t>Above is a 7 minute sample comparing DDE to RTD for capturing and processing market data.For our particular case we:Receive Market DataCalculate ArbsPublish DataArchive to DB.The data range is a 2500 x 20 cells, both DDE and RTD processes are taking control of Excel calculations. (Breaks Copy-N-p...
by IQuant1
March 1st, 2012, 11:34 am
Forum: Programming and Software Forum
Topic: Best way to have real time data in Excel
Replies: 14
Views: 57001

Best way to have real time data in Excel

No we have not, If this is an area of particular interest to you send me a PM.
by IQuant1
February 28th, 2012, 8:14 am
Forum: Programming and Software Forum
Topic: Best way to have real time data in Excel
Replies: 14
Views: 57001

Best way to have real time data in Excel

Low latency was the wrong phrase but in the context of this thread relates to pushing data in and out of Excel comparing DDE versus RTD.
by IQuant1
February 26th, 2012, 8:53 pm
Forum: Programming and Software Forum
Topic: Best way to have real time data in Excel
Replies: 14
Views: 57001

Best way to have real time data in Excel

<t>After extensive testing of low latency feed handling we can vouch a properly designed excel using DDE can outperform RTD/COM significantly.In our specific case we are able to process 140 symbols via DDE, calculate 2200 synthetic Arbs and write the results off to SQL db using excel at a precision ...