|
PureBytes Links
Trading Reference Links
|
> I would like to import the opening price for $INDU (DOW) into an Excel
> spreadsheet.
Why???
That sounds like a flippant answer but I'm actually quite serious. It
may take 5 or more minutes for all the dow stocks to start trading.
Until they all open, the index is calculated using yesterday's close for
those stocks. So the question is WHICH open....
Yesterday's close???
First tick (when maybe only 1 of the 30 stocks has traded)???
Theoretical open (using the first tick of each stock even though they
occurred at different times)???
Price once all the stocks have opened (even though that may be several
minutes after the first stock opens)???
Bottom line, I don't see any value for realtime trading in the "open" of
the indices. But, if you really need that first tick in realtime, you
could plot a 1-tick chart and trigger the export with
if d > d[1] then begin
You can't use daily data in realtime because the export won't trigger
until the bar closesunless you set it to update every tick. And if you
do that, it will export every time a new tick comes in.
--
Dennis
|