V.13:07 (286): SIDEBAR: Filtering in Excel by Scott Barrie

V.13:07 (286): SIDEBAR: Filtering in Excel by Scott Barrie

Here are the Excel 4.0 formulas to perform individual market filters. For our example, we'll use the December 1994 Treasury bond futures market (sidebar Figures 1 and 2) with a 1% filter. The spreadsheet will use the following formulas in their respective cell locations: column A: contract symbol; column B: date (be sure to use trading days only); column C: opening price; column D: intraday high; column E: intraday low; column F: close or settlement.

In column headings, I have used the_ to represent spaces between words so my macros can identify the heading. For example, I use "end_date" for "end date." Copy down all formulas that are entered into row 3. The formulas follow the colon after the cell designation.

FOR THOSE ORDERING ARTICLES SEPARATELY:
*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail.

Take Control of Your Trading.

Professional Traders' Starter Kit

All these items shown below only $495!

5-year subscription to Technical Analysis of STOCKS & COMMODITIES, The Traders' magazine. (Shipping outside the US is extra. Washington state addresses require sales tax based on your locale.)
S&C on DVD 10.25 plus next year's upgrade FREE!
5-year subscription to Traders.com Advantage.
5-year subscription to Working Money.
Free book selection.

Save up to 54% by purchasing today. Limited time offer. By purchasing today you also receive your choice of one volume from the Professional Traders' Series (Volumes 1-17 or Charting The Stock Market) for FREE!
NOTE: Use the "comment" field during checkout to tell us which book you would like to receive.

Click Here to Order

You save $502.31 plus the value of the book you choose over the regular price of these items. Offer ends soon.