Introduction to The Explorer
In our opinion The Explorer is the most powerful tool within MetaStock. The reason being, it allows us toÂ perform in-depth explorations, scanning thousands of securities, to identify those securities that exhibit predefinedÂ criteria. This could involve anything from finding securities that have hit their 6 month high to those whoseÂ stochastic oscillator has moved above the 20 line, or both. Itâ€™s completely up to you.
More than that, TheÂ Explorer then becomes a multi-purpose analysis tool. That is, we can use it to search, sort, and rank the informationÂ gathered. Â In the past, to achieve all this would be almost impossible, but now once we learn how, MetaStockÂ can change the way we identify trading opportunities.
All we need to do is merely identify what criteria we wish to search for, and choose a listÂ of securities that we wish to filter through. Once complete, a report showing the results of the exploration, will beÂ displayed. This dialog allows us to sort and rank these opportunities.
Creating a New Exploration
The best way to learn all that weâ€™ve mentioned is by way of example; therefore weâ€™ll now create an explorationÂ describing the steps and menus along the way. To begin, open a new explorer from the Power Console. Â This opens â€˜The Explorerâ€™ dialog,Â shown below:
Right mouse click on the top entry with the word ‘ Explorations’, to click on ‘New Exploration’. Â If you right mouse click on any existing Explorations, you will see the following options:
- Edit: Displays the â€˜Exploration Editorâ€™ dialog of the selected exploration. This is used to alter anÂ existing exploration.
- Report: Displays the reports for the selected exploration. Note: this button canâ€™t be activated unless there isÂ an â€˜<R>â€™ next to the selected exploration. The â€˜<R>â€™ signifies that a report is available from the mostÂ recent exploration.
- Copy: Makes a copy of the selected exploration.
- Delete: Deletes the selected exploration.
- Print: Prints the selected explorations, their names and/or formulas.
- Organizer: Displays the â€˜Formula Organizer Wizardâ€™.
To create a new exploration click on the â€˜Newâ€™ button, and this will open the â€˜Exploration Editorâ€™ dialog, shownÂ below:
First we must enter a name for our exploration. Â Let’s name our exploration â€œMy First MetaStock Explorerâ€. Â Also contained in this dialog is the â€˜notesâ€™ text box, which is optional and is used to write any descriptiveÂ notes. Below this there are 12 Column Tabs (A-L) and the Filter Tab.
The Column Tabs are used to display specific values relating to the corresponding security. This will then beÂ displayed on the reports page once the exploration is complete. For example, columns can display anything fromÂ the closing price of a security to the value of its RSI(14) from 3 days ago. The real benefit in using these columnsÂ is that they allow for securities in the report to be ranked within a column. That is to say, once we have scannedÂ the market, we can then select a column and rank the filtered securities by that column.
The Filter Tab is the principal part of our explorer. Â This is where we stipulate the criteria that the security mustÂ meet to be listed in the results report.
Columns and Filter
Before we enter any information into the columns or the filter, we must realise that they perform separate and distinct functions. The columns display specific information regarding the securities, while the filter contains the criteria that a security must pass to make it to the reports page (this removes the unwanted securities).
When entering the coding into the columns we should ask ourselves â€œwhat security specific information do we wish to know?â€ Â In our example, we may wish to know yesterdayâ€™s and todayâ€™s prices as well as the average turnover for the last 5 periods.
To code the closing price within â€˜Column Aâ€™ type â€˜câ€™ into the text box. Â To the left of this there is another text box titled, â€˜Col. Nameâ€™. Â Type â€˜closeâ€™ into this box. Â (Note: Anything can be entered when naming a column as long as it is 8 characters or less).
Next, click on the â€˜Column Bâ€™ tab and name the column â€˜Prev Câ€™. Â Then code in yesterdayâ€™s closing price as follows: Ref(C,-1)
To identify the average turnover we could simply enter this formula within â€˜Column Câ€™: Mov(C,5,S)*Mov(V,5,S)
Its interpretation is such that the average price multiplied by the average volume over the last 5 periods. Â This could be named â€˜Avg T/Oâ€™.
If you have any other criteria that youâ€™d wish to rank the securities by, once they have passed through the filter, enter them into columns â€˜Dâ€™ and â€˜Eâ€™ and so forth. Â Usually, we rank securities in a similar manner, thus the column layout we just entered can be used in any explorer. Accordingly, all you have to do is change the filter section.
The final tab is the Filter Tab. This is where we specify the exact criteria a security must exhibit for it to appear in the report.
Within this tab, itâ€™s important to note that in addition to the formula language we can also reference any of the other columns. For example, assume we wanted to have the amount of dollars traded to be above a certain value. Since we have already coded the average turnover into â€˜Column Câ€™, we can simply reference this, rather than retyping it. The code would be as follows:
This stipulates that whatever value is returned in â€˜Column Câ€™, must be greater than 100,000. The result of using â€˜ColC > 100000â€™ would be the same as writing â€˜Mov(C,5,S)*Mov(V,5,S) > 100000â€™.
As you can see this saves time and makes code easier to read if the information within the columns was quite complex. Â The correct syntax for referencing a column is simply â€˜Colâ€™ and then the correct column alpha value i.e. A or B or Câ€¦ or F. Just remember though, this function can only be used within the Filter Tab.
For the purpose of this example, we will keep the filter simple. Â Click on the filter tab and type in:
C>0.2 and ColC > 100000 and C>Mov(C,20,S)
This formula looks for the closing price to be above 20 cents, the average turnover to be more than $100,000 and the closing price is above the 20 period simple moving average.
Weâ€™re now ready to begin the exploration, so click â€˜OKâ€™ to return to the Exploration dialog. Â After you have selected the securities to explore in the window below, click â€˜Start Explorationâ€™.
Click â€˜OKâ€™ once again, and this gets the exploration underway. The â€˜Exploration Statusâ€™ window opens, giving us information about its progress.
This dialog lets us know whatâ€™s going on by providing some self-explanatory statistics. Â This disappears after a few minutes (depending on the speed of your computer) and the â€˜Exploration Completedâ€™ dialog opens. Â From this dialog, we can click â€˜Reportsâ€™ to gain access to our results.
You will see a window resembling the one below:
Within this dialog there are three tabs to choose from:
- The â€˜Resultsâ€™ tab lists the securities that have been identified as fulfilling our requirements (i.e. meeting the criteria specified within the filter).
- The â€˜Rejectsâ€™ tab lists those securities that didnâ€™t meet the criteria. Additionally, it tells the reason for the rejection.
- The â€˜Explorationâ€™ tab details the exploration; this includes column formulas, the filter rules and the periodicity.
Usually the latter two tabs are not reviewed at all. Â As a reminder, theÂ real benefit in using the columns is that they allow for securities in the report to be ranked based on the data displayed in a column. Â In the Reports screen above, you can click on any column header to re-arrange the instruments listed. Â Click on it again to reverse that order.
The other options within this dialog are as follows:
- Inspect: Displays the historical values calculated for each column of the exploration.
- Open Chart: Displays the selected chart(s).
- Sort: Allows us to arrange securities within their column, in ascending or descending order. The simple way to do this, rather than clicking the sort button, is to simply click on the title of each column. For example, by clicking on â€˜closeâ€™ (i.e. Column A) the results are sorted from lowest to highest. Click once more and theyâ€™re sorted from highest to lowest.
- Print: Prints out the report.
- Save list: Save the results; in this way we can then scan those securities with another explorer.
To find the securities which met our filter criteria, we look in the â€˜Resultsâ€™ tab. To review these charts simply highlight them (holding the shift key and/or ctrl key to multiple select) and click â€˜Open Chartâ€™. Click â€˜Closeâ€™, and â€˜The Explorerâ€™ dialog appears. Click â€˜Closeâ€™ once more and now itâ€™s time to view the charts, deciding which securities are the best trading candidates.