I don't want to throw stones at the other guys, but since you started this... [Paraphrased]

:smt043

Good morning Miss M!!!!!

Hey, how do you use the Dynamic Data Exchange (DDE) to automatically update data in Excel? I don't think I've read that yet... can you give me a cell formula example?

---

Traders' Consortium

I am transparent aren't I??? Patrick says that all the time..

:) Here is a little doc wih more info on DDE!... I would love to say I wrote it but it was KevinC... :wink: Damn it... I wish I was a better liar.. then I would take credit... :D

---

"It takes no more time to see the good side of life than it takes to see the bad."
Jimmy Buffett

I am transparent aren't I?

Hey, who said that?? :P Wow! Thanks for the quickest response time ever. Equis support is the best! :D I'm going to include this in the Tips File too, but it will be a day or so before I can do that. I want to check it out thoroughly first.

---

Traders' Consortium

hmm... it is described in a brief one paragraph entry on p.25 of the Quick Reference Guide. Wonder how I ever missed it?! ](*,)

---

Traders' Consortium

:smt023 g - how could you ever be expected to know it all by now??? You are lightyears ahead of me already! :) M

---

"It takes no more time to see the good side of life than it takes to see the bad."
Jimmy Buffett

Here is an example Excel Worksheet using the DDE setup to collect real time data. Very simple. I was able to retrieve basic data on 100 symbols in about a second or two. :D

note: QC must be running in the backgroud for the worksheet to update.

---

Traders' Consortium

Hi can you send me the file?

How do I install the Add-in for DDE to Excel?

 

Thanks

Marilyn:

Here is a little doc wih more info on DDE!

where is it?

StorkBite:

Here is an example Excel Worksheet using the DDE setup to collect real time data. .

I must be getting blind. Where is the excel sheet?