|
PureBytes Links
Trading Reference Links
|
> Albert,
>
> I noticed that I can create an Excel query only when I start Excel (I'm
not
> allowed to create one in an Excel sheet located in a TSY2K workspace).
> Any way, once your query is created, you will be able to use it in an
Excel
> sheet located in a TSY2K workspace.
>
>
> In Excel go to Data\External Data\ Create a query
> In the dialog box :
> select DataBASE
>
> Select OmegaResearch Alerts DataSource
> Click on Ok
>
> Then you will get a query assistant.
> On the left side choose (you can click onto the + sign, to see which
fields
> you can get)
> For example Open Position
> Clik on > to add fields you wanna have in Your excel sheet
> For example :
> Symbol
> Description
> Entry Price
> Last
> Profit
> Entry Time
> Signal
>
> Click on Next
> Create a filter if you want, otherwise click on next
> Sort them if you want, otherwise click on next
>
> check Send the data to Excel
>
> Name and Save the query
>
> click on Finish
>
> Then a dialog box pops up and asks you to choose the upper left cell of
the
> table you will create in excel
> Click on Ok
>
> And now, you should see your Open Positions in the excel sheet.
>
> Now that the query has been created you can go into an excel sheet in
TSY2K
> and call this query.
>
>
>
> (sorry, my Excel 2000 version is in French, then I try to guess what words
> you should see in your US version)
>
> I do not own RadarStation, then I cannot be of any help with It, Sorry.
>
> Greetings from Paris,
> Philippe
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> philippe_lhermie@xxxxxxxxxxx
>
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> ----- Original Message -----
> From: Albert Saab <albert@xxxxxxxxxxxxxxxxxx>
> To: Philippe Lhermie <philippe_lhermie@xxxxxxxxxxx>
> Sent: Wednesday, August 04, 1999 11:36 PM
> Subject: RE: Omega Server Quotes into Excel ??---> Using Excel Queries
>
>
> >
> > When you go to create an Excel Query, HOW did you select a tracking
center
> > as the data source? Can you do the same with a RadarStation window?
>
>
>
> Thanks again for your help.
> >
> > Thanks
> > Albert
> >
> >
> > -----Original Message-----
> > From: Philippe Lhermie [mailto:philippe_lhermie@xxxxxxxxxxx]
> > Sent: Wednesday, August 04, 1999 1:55 PM
> > To: code-list@xxxx Brown; albert@xxxxxxxxxxxxxxxxxx;
> > omega-list@xxxxxxxxxx
> > Subject: Re: Omega Server Quotes into Excel ??---> Using Excel Queries
> >
> >
> > Hi Albert,
> >
> > I've just created a query between the Omega Tracking center and Excel.
> > A web query has got an IQY file extension and a Microsoft Query a DQY
> > extension
> > Attached is a query of the open positions generated by any system you
> want
> > and the TSY2K workspace (look into "Essai DBC" sheet).
> > First add a system to any chart you want in one of your workspaces.
> > Make sure you've got a long entry by looking at your tracking center
> >
> >
> > You can have an excel sheet updated at least every minute or on demand,
> and
> > you can include :
> > Active Orders
> > Alerts
> > Canceled Orders
> > Filled Orders
> > MessageLog
> > Open Positions
> > Table Info
> >
> > And some others possibilities that I don't understand for the time
being.
> >
> > In each of theses sections, you can add columns in Excel
> > For example, with Open Postions :
> > ID
> > Entry Price
> > EntryBaseCode
> > LastLong
> > LastBaseCode
> > ProfitLong
> > ProfitBaseCode
> > Entry Time
> > System
> > Signal
> > Workspace
> > Interval
> > Position Number
> > Order Number
> > Alert String
> > hWindow
> > Alert Type
> >
> > You can also add filters into each of these columns and sort them
> >
> > Greetings from Paris,
> > Philippe
> > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> >
> > philippe_lhermie@xxxxxxxxxxx
> >
> > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > ----- Original Message -----
> > From: Albert Saab <albert@xxxxxxxxxxxxxxxxxx>
> > To: Philippe Lhermie <philippe_lhermie@xxxxxxxxxxx>
> > Sent: Wednesday, August 04, 1999 7:10 AM
> > Subject: RE: Omega Server Quotes into Excel ??????? ---> Using Excel
> Queries
> >
> >
> > >
> > >
>
>
|