[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Wheat


  • To: <metastock@xxxxxxxxxxxxx>
  • Subject: RE: Wheat
  • From: "Manuel Barquin" <ALEMANkkkkkkkkkkkkkkkkkkkkkkkk>
  • Date: Tue, 16 Nov 1999 09:50:15 -0800
  • In-reply-to: <000b01bf2cac$75d8c200$1831bccc@xxxxxxx>

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>&nbsp;</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.&nbsp; The CCT Bollinger Band Histogram 
reconfigures the classic bands.&nbsp; The new indicator constructs two<BR>(2) 
parallel lines instead of the erratic envelopes.&nbsp; These parallel lines 
represent a measurement of two (2) standard deviations from<BR>the mean and are 
assigned zero and 100 on the chart.&nbsp; The indicator represents the price as 
it travels above and below the mean<BR>(50%) and outside the two standard 
deviations (zero and 100).&nbsp; Penetration of the upper or lower band 
represents overbought and<BR>oversold conditions.&nbsp; When using the CCT 
Bollinger Band Histogram, &#8220;failure swings&#8221; and &#8220;divergences&#8221; can lead to 
significant<BR>reversals.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>&nbsp;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>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>My work has confirmed a buying opportunity in 
  wheat.&nbsp; I'm offsetting my short from 10/19 and going long on the 
  opening.</FONT></DIV>
  <DIV>&nbsp;</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>&lt;&lt;The CCT Bollinger Band Histogram 
reconfigures the classic bands.&nbsp; The new indicator constructs two (2) 
parallel lines instead of the erratic envelopes.&nbsp; These parallel lines 
represent a measurement of two (2) standard deviations from the mean and are 
assigned zero and 100 on the chart.&nbsp; The indicator represents the price as 
it travels above and below the mean (50%) and outside the two standard 
deviations (zero and 100).&nbsp; Penetration of the upper or lower band 
represents overbought and oversold conditions.&nbsp; When using the CCT 
Bollinger Band Histogram, &#8220;failure swings&#8221; and &#8220;divergences&#8221; can lead to 
significant reversals.&gt;&gt;</FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;</FONT></DIV>
<DIV><FONT face=Arial size=2>Steve,&nbsp;do you mind&nbsp;sharing&nbsp;&nbsp;a 
little bit more about your indicator. I&nbsp;am sorry but I cannot picture the 
indicator description&nbsp;"(2) standard deviations from the mean&nbsp;and are 
assigned zero and 100&nbsp;on the chart. The indicator represents the price as 
it&nbsp;travels above and below the mean...."&nbsp;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>I thank you for your help, </FONT></DIV>
<DIV><FONT face=Arial size=2>Manuel Barquin</FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>&nbsp; </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>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>My work has confirmed a buying opportunity in 
  wheat.&nbsp; I'm offsetting my short from 10/19 and going long on the 
  opening.</FONT></DIV>
  <DIV>&nbsp;</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
| |
|