Announcement

Collapse
No announcement yet.

Excel DDE link

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel DDE link

    Hey all,

    I'm trying to set up a DDE link through Excel. Our company uses a program called ProphetX to view nymex quotes in real time. We'd like to have an Excel sheet everyone can use to view the quotes in real time. ProphetX is running on one of our workstations.

    This is the formula I have so far, for one of the cells...

    =\\compname\PROPHETX|QUOTE!'[email protected][DTN:NYMEX]?Previous Price'

    compname being the name of the computer running ProphetX. This gives me cells with #REF! in them. I'm not sure whats wrong with the formula. Any ideas?
Working...
X