|
PureBytes Links
Trading Reference Links
|
Gerald:
I can't answer your question but a friend a I spent a lot of time on
discovering exactly how the opening is calculated each day. I
forget all the details but it is only after some time has passesd that
the official number is available. It is physically impossible, I believe
to get it as it is happening. The problem surrounds the idea that
the individual stocks open at different times after the bell. So, the
official number that appears in the WSJ is 'theoritical'-I believe-
insofaras not one trade took place at the 'open' but several and
they were at different times.
Chas
Chas
-----Original Message-----
From: Gerald Marisch <gm@xxxxxxxxxxxxx>
To: Omega list <omega-list@xxxxxxxxxx>
Date: Tuesday, April 13, 1999 9:55 AM
Subject: DDELink
>I'm using an Excel spreadsheet linked to the Omega Server.
>
>I would like the opening price for the DOW (Signal symbol "$INDU") to
appear
>in one of the cells. The formula I'm using for this is:
>"=OMEGA_SERVER|LIVEQUOTE!'$INDU,O'"
>without the beginning and ending double quotation marks.
>
>I used the same formula for the opening price for "SP M9", the only
>difference
>being the space between SP and M9. This formula works. The $INDU formula
>does not generate the opening price for the DOW.
>
>Thanks in advance to anyone who can help with any suggestions on how the
>opening price for the $INDU can
>automatically be entered into the cell. Manually entering it every day
does
>not seem to be the was to go!
>
>Gerald Marisch
>Block 43368
>
>
|