Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Non-Tech : Quote.com QCharts -- Ignore unavailable to you. Want to Upgrade?

To: Gibbons Burke who wrote (3982)	10/10/1999 11:54:00 PM
From: Ohshaw	Respond to of 17977

Here is a QLink question... I using VB to program some analysis, and the following line of code from my program actually loads certain cells with a Qlink formula: Worksheets("ts").Range("a1:d25").FormulaArray = "=QLink\|TS!'" + Symbol + ",25,DTCP'" The problem is, the subsequent lines of code that access the results of those formulas return errors because the qlink DDE takes some time to execute and update the cells. The question, how do I force a delay in my program, or force a DDE update, so the cells with the DDE links can be referenced to find real data rather than #NA values? I have tried ISERROR(cell(row,column)) to loop around in a delay, and I tried a Wait call, and I tried ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources but all with no luck. Any insight greatly appreciated. OhShaw

To: Gibbons Burke who wrote (3982)	10/10/1999 11:54:00 PM
From: Gary E	Read Replies (1) \| Respond to of 17977

Gibbons, I am not saying that you impose a delay, but a delay can be there because of the time requirements of the system itself, it might be only a second or two or 3 , and then when I hit that price it's allready a point higher..now if it was a bad tick,,,awe s*** I'm screwed again,,,only this time for even more. What I am saying is that sometimes I see a 1 min chart of ES9Z on QCharts stop or run behind the free site, this is not what we pay QCharts for. But we REALLY pay at the brokerage account. Hal