|
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.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>CCT Bollinger Band Histogram:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Bollinger Bands were developed by John Bollinger
and are envelopes that are plotted at two (2) standard deviation levels above
and<BR>below a moving average. The CCT Bollinger Band Histogram
reconfigures the classic bands. The new indicator constructs two<BR>(2)
parallel lines instead of the erratic envelopes. These parallel lines
represent a measurement of two (2) standard deviations from<BR>the mean and are
assigned zero and 100 on the chart. The indicator represents the price as
it travels above and below the mean<BR>(50%) and outside the two standard
deviations (zero and 100). Penetration of the upper or lower band
represents overbought and<BR>oversold conditions. When using the CCT
Bollinger Band Histogram, “failure swings” and “divergences” can lead to
significant<BR>reversals.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> CCT Coppock Curve: </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></BODY></HTML>
</x-html>From ???@??? Tue Nov 16 09:59:09 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 KAA29860
for <neal@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 10:02:50 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id JAA31125
for metastock-outgoing; Tue, 16 Nov 1999 09:13:40 -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 JAA31118
for <metastock@xxxxxxxxxxxxxxxxxx>; Tue, 16 Nov 1999 09:13:37 -0700
Received: from perseus.santandersupernet.com (perseus.bancosantander.es [195.53.80.2])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id JAA16865
for <metastock@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 09:19:20 -0700 (MST)
Received: from ALEMANIA (cli81-84.santandersupernet.com [195.53.81.84])
by perseus.santandersupernet.com (8.8.8+Sun/8.8.8) with SMTP id RAA28471
for <metastock@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 17:04:11 +0100 (MET)
Message-ID: <005001bf304c$6e13c3a0$5916ebc3@xxxxxxxx>
From: "Manuel Barquin" <ALEMANIA@xxxxxxxxxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <000b01bf2cac$75d8c200$1831bccc@xxxxxxx>
Subject: RE: Wheat
Date: Tue, 16 Nov 1999 17:03:27 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0049_01BF3054.80104800"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
<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.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>
</x-html>From ???@??? Tue Nov 16 10:29:47 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 LAA32581
for <neal@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 11:32:50 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id KAA32254
for metastock-outgoing; Tue, 16 Nov 1999 10:35:29 -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 KAA32251
for <metastock@xxxxxxxxxxxxxxxxxx>; Tue, 16 Nov 1999 10:35:26 -0700
Received: from meg.pdq.net (pop.pdq.net [204.145.251.79])
by freeze.metastock.com (8.8.5/8.8.5) with SMTP id KAA16921
for <metastock@xxxxxxxxxxxxx>; Tue, 16 Nov 1999 10:41:11 -0700 (MST)
X-AirNote: 1
Received: from 56K-242.MaxTNT5.pdq.net [209.223.26.242-21] by meg.pdq.net ID 49_-1;
Tue, 16 Nov 1999 11:26:19 -0600
Message-ID: <001a01bf3057$a737c040$1464fea9@xxxxxx>
From: "Lionel Issen <lissen@xxxxxxxx>" <lissen@xxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <003601bf2ea2$5bd79d20$148a6395@xxxxxxx> <382FD85E.CD27186F@xxxxxxxxxxxxxxxxx> <001a01bf2f6d$5fc749a0$4d2367d1@xxxxxxx> <000001bf3048$60d65120$0d2467d1@xxxxxxx>
Subject: Re: formulas
Date: Tue, 16 Nov 1999 11:24:00 -0600
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.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
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:
2. ActiveCell.FormulaR1C1 = _
" =IF(RC[-1]>R[-5]C[-1],((R[-6]C[-1]-R[-7]C[-1]+1)*R[-6]C) ... etc.
3. using the "cells" property of worksheet (see the "." before "cells")
With Worksheets("Sheet1")
If (.Cells(10, 2).Value > .Cells(5, 2).Value) ... etc.
4. using the "range" property and names
If (Range("GrossPay").Value > Range("TaxBand3").Value) Then
Range("Tax") = (Range("TaxBand2") - Range("TaxBand1") + 1) ... etc.
5. using a simplified version of names
If GrossPay > TaxBand3 Then
Tax = (TaxBand2 - TaxBand1 +1) * TaxLevel1 ... etc.
==========
I prefer the "cells" method especially because the "in-cell" code often has
worksheet references associated with it, i.e.,
=IF(INDEX(DailyPrices,MATCH(WeeklyPrices!$A3,DailyPricesDate)+2,5)>INDEX(Da
i
lyPrices,MATCH(WeeklyPrices!$A3,DailyPricesDate)+1,6),"Up",IF(INDEX(DailyPr
i
ces,MATCH(WeeklyPrices!$A3,DailyPrice .... etc.
plus, it's also difficult to names 300 rows or 3,000 rows of "entry prices"
etc. <G>
Best Regards
Walter
----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Monday, November 15, 1999 8:28 AM
Subject: Re: formulas
| Hi Lars
|
| Will read the chapters again and then post the "cells" and "range"
methods
| for VBA coding of formulas, in addition to the "name" method.
|
| Best regards
|
| Walter
|
|
|
|
| ----- Original Message -----
| From: Lars Andersson <Lars.Andersson@xxxxxxxxxxxxxxxxx>
| To: <metastock@xxxxxxxxxxxxx>
| Sent: Monday, November 15, 1999 4:54 AM
| Subject: Re: formulas
|
|
| | Hi Walter.
| | I know what you mean. I have not learn this yet and I donīt think I
ever
| do that. The book you mention seems to be very good
| | so perhaps I buy it.
| | Thatīs not fun when you get 65 000 + rows filled just wonder how to do
| this.
| | Best regards.
| | Lars
| |
| | Walter Lake skrev:
| |
| | > Hi Lars
| | >
| | > Glad that you liked the coding.
| | >
| | > One of the problems I've been working with is learning different ways
to
| | > code Excel "in-cell" formulas into VBA code. For example one of Ton's
| | > Profit/Loss Index formulas:
| | >
| | > "... -Where the Formula for the "Units" (col I) cell on Row 3 is:
| | > =ABS(IF(A3>C3;((A3)/C3)+1;IF(A3<C3;((-C3)/A3)-1;0)))
..."
| | >
| | > Using the Macro Recorder and changing the ";" to "," you get this:
| | > ActiveCell.FormulaR1C1 =
| | >
|
"=ABS(IF(RC[-7]>RC[-5]((RC[-7])/RC[-5])+1,IF(RC[-7]<RC[-5]((-RC[-5])/RC[-7]
)
| | > -1,0)))"
| | >
| | > Not many of the reference books i.e., Walkenbach, WROX, Steve Roman,
21
| | > Days, etc. have much on writing formulas in VBA code. A new book
"Excel
| 2000
| | > Developer's Handbook" by Marion Cottingham at
| | >
| | > www.sybex.com
| | > http://www.sybex.com/cgi-bin/rd_bookpg.pl?2328back.html
| | >
| | > Has the following chapters which are quite complete:
| | >
| | > "Part II: Naming Formulas, Functions, and Constants
| | > Chapter 4: All About Formulas and Functions
| | > Chapter 5: But Names Will Never Hurt Me!
| | > Chapter 6: Using Constants
| | > etc ..."
| | >
| | > In Chapter 5, the author writes extensively about "naming" the
formula
| when
| | > you enter it into Excel and then using the name in your VBA code.
Lots
| of
| | > good ideas especially for Metastocker's who have indicator code etc.
to
| | > write into Excel. It also makes documenting much easier.
| | >
| | > Of course, it's the "filling down" part that always messes me up and
I
| end
| | > up with 65,000 + rows filled <G>.
| | >
| | > Best regards
| | >
| | > Walter
| |
|
|