Perspective

In this section you will learn how to use Equity Market Data Perspective to find specific Symbols. The Equity Market Data Perspective contains two search type: Basic Search and Advanced Search. After searching out the symbols you want, you could copy them into a new watch list.

• Basic Search

  1. Open the menu Window > Open Perspective > Equity Market Data to open the Equity Market Data perspective.

     

     

  2. In the Basic Search like the picture above, you can type any search conditions in these forms, such as Date, Close, Change etc...
  3. The default value is Any in all these forms.
  4. After filling the conditions, click the button Find Symbols to search.
  5. The Corresponding symbols will be listed in the table Symbols Search Results.

  

• Advanced Search

  1. Click the button Advanced Search to open the advanced search query form.

     

  2. The query form can only supports standard SQL right now, and you can only select the column symbol and name from the table endofdayequities or bihourly. For instance, you can type select distinct symbol,name from endofdayequities where currentPrice>=101 and currentPrice<=320 ORDER BY symbol ASC.
  3. After inputing the query, click the button Find Symbols to search.
  4. The Corresponding symbols will be listed in the table Symbols Search Results.




• Save as a watch list

  1. After searching out the results through the function Basic Search or Advanced Search, click the button Copy to Watch List, in the opened dialog, type the watch list name.

     

  2. The new watch list will be created.
     Open the menu Window > Open Watchlist > the watch list name to open the watch list that you just created.