Limiting the Graph to a Relevant Period of Time

Synopsis

Objectives

  1. Limiting the attributes using the WHEN date condition.

  2. Using Multiple SHOW attributes.

  3. Using compound attributes.

  4. Introduction to the arithmetic operator.

Market Brief

Investors examine price history for some significant period of time, such as a 52-week chart or a 6-month chart. Price history is commonly viewed in bar charts, although many chart traders may prefer to use only closing prices for their price graphs. A graph that uses a daily bar represents the opening price with a left horizontal mark, the close by a right horizontal mark and the two daily extremes of the high and low and as the top and bottom of a vertical line. The difference between the extreme points on the bar is the daily price range for the security. Some investors prefer to view the range as a value separate from the bar chart. Certain traders maintain that when a security trades within a tight range for a period of time (where the daily range is much smaller than usual for some period of time), a price breakout to the up or downside is expected.

To confine the period of time that the attribute will be shown, it is necessary to construct a WHEN condition. The WHEN condition provides the ability to confine the results of the query or “question about the markets” to specific dates and times of interest. Earlier it was mentioned that XMIM’s language structure for the SHOW/WHEN query, is SHOW my security WHEN certain conditions are met. What would you like to see WHEN those conditions are met? Show both a bar chart (the open, close, high and low prices for our security) and the daily range for your security.