|
PureBytes Links
Trading Reference Links
|
For TS4 see Appendix B of the Server manual, pages235,6,7.
For BMI, DBC, S&P ComStock clients enter this in the Excel spreadsheet cell:
=OMEGA_SERVER|LIVEQUOTE!'SymbolName,FieldList'
| is the shift back slash symbol
In the symbolName part of the formula, enter the symbol exactly as it
appears in the Omega Server portfolio.
In the FieldList part of the formula, enter the types of price data, or
fields, that you want displayed in Excel. Enter the fields in the order you
want the information to appear in the spreadsheet. When entering the types
of data you want displayed, type the field names exactly as displayed in the
table. Do not include spaces or commas between fields when using the Omega
Server. You do not have to include a list of fields/ If no fields are
specified, the Last Price field is used by default. For example, if you
want to collect the Open, High, Low, Close and Last prices for the S&P 500
index, you would type the following formula:
=OMEGA_SERVER|LIVEQUOTE!'SPX,OHLCP'
List of fields for Live Quotes
P = last price
T = time
D= date
O = open
H = High
L = Low
C = previous close
A = ask
K = ask size
B = bid
J = Bid Size
V = Volume
I = Trade Volume
----- Original Message -----
From: Albert Saab <albert@xxxxxxxxxxxxxxxxxx>
To: <he96@xxxxxxxxxxxxxx>; <omega-list@xxxxxxxxxx>
Sent: Tuesday, August 03, 1999 12:14 PM
Subject: RE: Omega Server Quotes into Excel ???????
>
> There is no mention of DDE or Dynamic Data Exchange anywhere in the Help
> application nor anywhere on the Omega research "knowledge base". I guess
> the knowledge base is not that knowledgeable???
>
> Can you please give more information on how you accomplished this is TS4?
I
> will try to do the same in 2000i and see if that will work.
>
> Albert
>
>
> P.S. here is the response I got from Omega:
>
> -------------------------------------------
> For your purposes, You should read the material on the Data Access
Manager,
> which is the component that gets data from the Global Server. If you use
> Excel 97, you could probably add the type library to VBA and build a macro
> to produce the desired results. You could then apply the macro to a
> spreadsheet object embedded in the Omega Research Desktop. We personally
> hadn't considered that possibility, but someone briefly touched on that
> subject last week, and it does seem feasible to do. In the next week or
so,
> I hope to investigate this approach.
>
> FYI, the subject of a DDE link between an Excel spreadsheet and incoming
> quotes has been a hot topic among customers for a while now. Product
> Management recently informed us that this DDE link will be available in
the
> product, but at this time it's still too early to tell exactly when.
Product
> Management has assured us, however, that this feature WILL make it into
the
> product.
>
> --------------------------------------------
>
> -----Original Message-----
> From: hans esser [mailto:he96@xxxxxxxxxxxxxx]
> Sent: Tuesday, August 03, 1999 10:34 AM
> To: albert@xxxxxxxxxxxxxxxxxx; omega-list@xxxxxxxxxx
> Subject: RE: Omega Server Quotes into Excel ???????
>
>
> > > How do I pull the prices from the Globalserver into my excel
spreadsheet
> > > so that I can compute profit or loss without having to manually enter
> > > the current prices every time.
>
> good-old-TS 4.0 was able to do that with very simple DDE - sorry, cant
tell
> you for
> 00 00i
>
> maybe its the same......what does the manual tell about DDE ?
>
> rgds hans
>
>
|