Re: Omega Server Quotes into Excel ??---> Using Excel Queries

["Philippe Lhermie" <philippe_lhermie@xxxxxxxxxxx>]

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
>
>
> >
> >