Tweet
Dde
Anyone know how to DDE data such as "stochastics" or "moving averages" into Excel? I already know how to get last price data and such, but for some reason can't find a way to get this other info?
-
-
geronimo1
See this article in the EFS KnowledgeBase. Also if you run a Search for DDE in this Bulletin Board you should find several threads (with examples) on the topic
Alex -
DDE for indices
Hi,
Does anyone know how to get the name and 52-week high/low in excel under DDE for an index? I have no problem to get them for a stock (such as SPY), but not for an index (such as $SPX). I have no idea why it is like that.
Chuan
Please see below:
SYMBOL Name Date Prev Open High Low Last Change 52WHigh 52WLow 52HDate 52LDate
DIA DIAMONDS TR 04/18/05 100.70 100.62 101.01 100.11 100.55 -0.15 109.83 97.27 03/07/05 10/25/04
$INDU #No Data., 04/18/05 10087.51 10088.54 10105.39 10020.93 10071.25 -16.26 #No Data., #No Data., #No Data., #No Data.,
$OEX #No Data., 04/18/05 547.25 547.24 550.07 546.21 548.15 0.90 #No Data., #No Data., #No Data., #No Data.,
SPY SPDR TR 04/18/05 114.15 114.12 114.96 113.96 114.50 0.35 123.25 106.59 03/07/05 08/13/04
$SPX #No Data., 04/18/05 1142.62 1142.40 1148.92 1139.80 1145.98 3.36 #No Data., #No Data., #No Data., #No Data.,Comment
Comment