|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Manuel,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>The majority of my work has focused on
momentum oscillators. Please understand: I struggled with graduate
statistics and actually feel that passing college calculus (in my late "40's")
was one of the "miracles of life". The CCT Bollinger Band Histogram
has received a lot of attention lately. In fact, starting
on Thursday, at the TAG seminar in Las Vegas, Prophet Finance will
be "introducing" this indicator to the "world". Soon, the public will
be able to access this indicator at a java charting site (it's the indicator
that pops up when you plug in a symbol at my site ... try W9912 as the
symbol for December Wheat). I'm also writing a MetaStock
softwareadd-on that will include the Histogram as part of package of ten
indicators and it will be discussed in a book that should follow in the second
quarter of 2000 (focusing on momentum oscillators).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I've always liked John Bollinger's bands, but the
squiggly lines have always confused me. I reconstructed the exact formula
(well, not exactly, I've made a few secret changes) into something that makes
more sense to me. John's "bands" create an envelope that brackets the
market. This envelope is two standard deviations from the average (mean)
price. The average is typically a simple moving average of the last twenty
days. In John's formulas, the bands expand and contract based on
volatility.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>In my reconstruction, I decided to straighten the
lines out and peg the upper band to always represent 100 and the lower band to
represent zero. If today's close was identical to the 20 day simple moving
average, the closing price would be resting exactly equal distance between
John's bands and on my histogram: the indicator would be pegged to 50
(halfway between the two lines). If the price starts to appreciate and the
20 period moving average starts to increase in value: John's bands would
curve up to represent the adjusted higher average price. In my histogram,
the 100 and zero never stray from their values. Instead, the indicator
becomes the "closing price as a percentage of the range of the of the two
bands". If the price closes at a value that exceeds the upper bands two
standard deviation value, ... then that will be represented on the histogram by
the indicator exceeding the 100 level.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Maybe, Don, or Adam, or Walter (the real
programming wizards) can shed more light on the theory or construction of
Bollinger's work. I'm just a guy "hacking" away at things that work for me
(momentum oscillators). I don't usually concern myself with the theory,
I'm more interested in focusing on how it works instead of why it works.
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Hope this helps,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Steve Karnish<BR>Cedar Creek Trading<BR><A
href="http://www.abbracadabra.com/cybercast/";>http://www.abbracadabra.com/cybercast/</A></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> </FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:ALEMANIA@xxxxxxxxxxxxxxxxxxxxx";
title=ALEMANIA@xxxxxxxxxxxxxxxxxxxxx>Manuel Barquin</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, November 16, 1999 8:03
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Wheat</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Dear Steve: Re your message on wheat I went to
your web page (valuable information), and I read the CCT Bollinger Band
Histogram indicator description:</FONT></DIV>
<DIV><FONT face=Arial size=2><<The CCT Bollinger Band Histogram
reconfigures the classic bands. The new indicator constructs two (2)
parallel lines instead of the erratic envelopes. These parallel lines
represent a measurement of two (2) standard deviations from the mean and are
assigned zero and 100 on the chart. The indicator represents the price
as it travels above and below the mean (50%) and outside the two standard
deviations (zero and 100). Penetration of the upper or lower band
represents overbought and oversold conditions. When using the CCT
Bollinger Band Histogram, “failure swings” and “divergences” can lead to
significant reversals.>></FONT></DIV>
<DIV><FONT face=Arial size=2> </FONT></DIV>
<DIV><FONT face=Arial size=2>Steve, do you mind sharing a
little bit more about your indicator. I am sorry but I cannot picture the
indicator description "(2) standard deviations from the mean and are
assigned zero and 100 on the chart. The indicator represents the price as
it travels above and below the mean...." </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I thank you for your help, </FONT></DIV>
<DIV><FONT face=Arial size=2>Manuel Barquin</FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> </FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:kernish@xxxxxxxxxxxx"; title=kernish@xxxxxxxxxxxx>Steve
Karnish</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> ; <A
href="mailto:realtraders@xxxxxxxxxxxx";
title=realtraders@xxxxxxxxxxxx>List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, November 12, 1999 2:22
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Wheat</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>List,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>My work has confirmed a buying opportunity in
wheat. I'm offsetting my short from 10/19 and going long on the
opening.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Steve Karnish<BR>Cedar Creek Trading<BR><A
href="http://www.abbracadabra.com/cybercast/";>http://www.abbracadabra.com/cybercast/</A></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Tue Nov 16 12:49:46 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id NAA04459
for <neal@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 13:51:16 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id MAA00357
for metastock-outgoing; Tue, 16 Nov 1999 12:54:52 -0700
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id MAA00354
for <metastock@xxxxxxxxxxxxxxxxxx>; Tue, 16 Nov 1999 12:54:49 -0700
Received: from hme0.mailrouter02.sprint.ca (hme0.mailrouter02.sprint.ca [207.107.250.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id NAA16988
for <metastock@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 13:00:34 -0700 (MST)
Received: from default (spc-isp-ott-uas-18-33.sprint.ca [209.103.36.134])
by hme0.mailrouter02.sprint.ca (8.8.8/8.8.8) with SMTP id OAA10411
for <metastock@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 14:46:01 -0500 (EST)
Message-ID: <000b01bf306b$1cf95740$862467d1@xxxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <003601bf2ea2$5bd79d20$148a6395@xxxxxxx> <382FD85E.CD27186F@xxxxxxxxxxxxxxxxx> <001a01bf2f6d$5fc749a0$4d2367d1@xxxxxxx> <000001bf3048$60d65120$0d2467d1@xxxxxxx> <001a01bf3057$a737c040$1464fea9@xxxxxx>
Subject: Re: formulas
Date: Tue, 16 Nov 1999 14:45:17 -0500
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Hi Lionel
I don't think that she did an Excel 97 book.
Here's Dr. Cottingham's listings from Sybex:
Excel 2000 Developer's Handbook
By Marion Cottingham
ISBN: 0782123287
Microsoft Office 2000 Developer's Set
By Susann Novalis, Guy Hart-Davis, and Marion Cottingham
ISBN: 0782125794
The Excel "in-cell" code and VBA code is the same as 97.
I use Excel 97 and 2000 VBA reference books interchangeably. Luckily, I
found a book store that sells them by the pound <G>
Best regards
Walter
PS: The Excel 97 Developer's Handbook version that I have is not being shown
as a separate volumn but only as a set of 4 books:
Microsoft® Office 97, Developer Edition, Resource Library
by Microsoft Corporation
Pages 1888
Disk 1 CD
Level Int/Adv
Release 6/11/97
Price 99.99 US
ISBN# 1-57231-606-3
The MICROSOFT EXCEL 97 DEVELOPER'S HANDBOOK contains more than 650 pages and
13 chapters in four sections:
Introduction to Microsoft Excel objects and Microsoft Visual Basic for
Applications
Developing information systems and designing custom interfaces
Database access, messaging, and built-in features of Microsoft Excel
Integrating with other applications, the Web, and other topics
----- Original Message -----
From: Lionel Issen <lissen@xxxxxxxx> <lissen@xxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, November 16, 1999 12:24 PM
Subject: Re: formulas
| Does anyone have a copy of Conningham's book for Excel 97?
| I am using Office 97, because of the basic changes in Office 2000
requiring
| much larger files, I intend to stay put for a while.
|
| Lionel
| ----- Original Message -----
| From: Walter Lake <wlake@xxxxxxxxx>
| To: <metastock@xxxxxxxxxxxxx>
| Sent: Tuesday, November 16, 1999 9:34 AM
| Subject: Re: formulas
|
|
| Hi Lars, Angel and others who have written
|
| Here's Marion Cottinham's variations for writing "in-cell" formulas in
VBA:
|
| 1. Original worksheet code:
|
| =IF(B10>B5,((B4-B3+1)*C4) .... etc.
|
| macro recording:
|
|