Tweet
hello,
I have an Excel application (written in VBA) that tracks a large number of securities using DDE. Once the market opens, if I find that a a particular stock does not satisfy some criteria, I would like to set the corresponding DDE links to 0 (null ???) in an attempt to lower the load on the system. As you can emagine, the load on the system is very high, especially in the first minutes after market opens.
I have a few questions. To get DDE data for a symbol in row "i" I would use something like
.cells(i,j).value="=WINROS|......"
This works fine. Is it better to use the above expression or to
use the .formula property of the cell, namely (this works too)
.cells(i,j).formula="=WINROS|......."
Now, my main question. If I set the values for such cells (containing DDE links) to 0 (.cells(i,j).value=0) does this automatically inform DDE server not to get further updates?
What do I need to do to let the esignal DDE know that I am no longer interested in particular links? Should I move these cells to a differenet worksheet and erase the correspnding rows? Are there Microsoft utilities to detect and erase these dead links.
Does eSignal offer RTD to get real-time quotes?
Thank you very much
Eugene Pinsky
e-mail: [email protected]
I have an Excel application (written in VBA) that tracks a large number of securities using DDE. Once the market opens, if I find that a a particular stock does not satisfy some criteria, I would like to set the corresponding DDE links to 0 (null ???) in an attempt to lower the load on the system. As you can emagine, the load on the system is very high, especially in the first minutes after market opens.
I have a few questions. To get DDE data for a symbol in row "i" I would use something like
.cells(i,j).value="=WINROS|......"
This works fine. Is it better to use the above expression or to
use the .formula property of the cell, namely (this works too)
.cells(i,j).formula="=WINROS|......."
Now, my main question. If I set the values for such cells (containing DDE links) to 0 (.cells(i,j).value=0) does this automatically inform DDE server not to get further updates?
What do I need to do to let the esignal DDE know that I am no longer interested in particular links? Should I move these cells to a differenet worksheet and erase the correspnding rows? Are there Microsoft utilities to detect and erase these dead links.
Does eSignal offer RTD to get real-time quotes?
Thank you very much
Eugene Pinsky
e-mail: [email protected]