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

V.13:07 (286): SIDEBAR: Filtering in Excel by Scott Barrie
Item# \V13\C07\SIDEFIL.PDF
Availability: In Stock

Product Description

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.

*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. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.

Take Control of Your Trading.
Professional Traders' Starter Kit
All these items shown below only $299.99!
  • 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.)
  • 5 year access to S&C Archive
  • 5 year access to S&C Digital Edition
  • 5-year subscription to Traders.com Advantage.
  • 5-year subscription to Working Money.
  • Free book selection.
  • Click Here to Order