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

Auto-deleting Date columns in Excel



PureBytes Links

Trading Reference Links



-----Original Message-----
From: owner-metastock-digest@xxxxxxxxxxxxxxxxxx
[mailto:owner-metastock-digest@xxxxxxxxxxxxxxxxxx]
Sent: Monday, September 23, 2002 9:16 PM
To: metastock-digest@xxxxxxxxxxxxxxxxxx
Subject: metastock-digest V1 #1621



metastock-digest      Monday, September 23 2002      Volume 01 : Number 1621




----------------------------------------------------------------------

Date: Thu, 19 Sep 2002 17:04:24 -0700
From: "Bijan Khezri" <bij3peat@xxxxxxx>
Subject: Composite Index

Has anyone figured out what the so called "composite index" that Connie
Brown professes is all about?

------------------------------

Date: Thu, 19 Sep 2002 20:08:10 -0500
From: "Mikey" <mtg1021@xxxxxxxxxxxxx>
Subject: Re: Composite Index

lol never have but if ya ever do I sure would love a copy of it!!
- ----- Original Message -----
From: "Bijan Khezri" <bij3peat@xxxxxxx>
To: "Metastock" <metastock@xxxxxxxxxxxxx>
Sent: Thursday, September 19, 2002 7:04 PM
Subject: Composite Index


> Has anyone figured out what the so called "composite index" that Connie
> Brown professes is all about?
>
>

------------------------------

Date: Thu, 19 Sep 2002 22:13:05 -0500
From: "Lionel Issen" <lissen@xxxxxxxxxxxxxx>
Subject: RE: Composite Index

This is one of several easers that Connie Brown has in her book. Perhaps if
you took her expensive course you might learn how to construct it.

The name "composite index" either describes something about the function or
it is meant to mislead us.

Connie seems to like the RSI so maybe it is a composite of several different
length RSI functions.

Lionel



- -----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Mikey
Sent: Thursday, September 19, 2002 8:08 PM
To: metastock@xxxxxxxxxxxxx
Subject: Re: Composite Index


lol never have but if ya ever do I sure would love a copy of it!!
- ----- Original Message -----
From: "Bijan Khezri" <bij3peat@xxxxxxx>
To: "Metastock" <metastock@xxxxxxxxxxxxx>
Sent: Thursday, September 19, 2002 7:04 PM
Subject: Composite Index


> Has anyone figured out what the so called "composite index" that Connie
> Brown professes is all about?
>
>

------------------------------

Date: Thu, 19 Sep 2002 20:18:10 -0700
From: "Bijan Khezri" <bij3peat@xxxxxxx>
Subject: RE: Composite Index

I can't believe a person has the gull of writing a book where nearly
everything is compared using this "index", and a whole chapter is dedicated
to it, and then she has the guts to tell you to go to her website, where she
wants to charge $825 for the indicator.  Connie Brown, George Lane who wrote
the forward, and Irwin, the publisher should be ashamed for writing a huge
commercial.  Absolutely disgusting.  And there are organizations that even
push the book as required reading.  Shame.

The funny thing is that there is someone on the internet that claims to have
copied the "results" of the index, and he will sell you the formula for
about $200.


- -----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Mikey
Sent: Thursday, September 19, 2002 06:08 PM
To: metastock@xxxxxxxxxxxxx
Subject: Re: Composite Index


lol never have but if ya ever do I sure would love a copy of it!!
- ----- Original Message -----
From: "Bijan Khezri" <bij3peat@xxxxxxx>
To: "Metastock" <metastock@xxxxxxxxxxxxx>
Sent: Thursday, September 19, 2002 7:04 PM
Subject: Composite Index


> Has anyone figured out what the so called "composite index" that Connie
> Brown professes is all about?
>
>

------------------------------

Date: Fri, 20 Sep 2002 08:57:21 +0200
From: "Theo Lockefeer" <sky40912@xxxxxxxxx>
Subject: Metastock and Excel

This is a multi-part message in MIME format.

- ------=_NextPart_000_0022_01C26083.BADAD100
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hello friends,

of course it is possible to copy & past the O,H,L,C  to Excel
but how do i copy and paste "all the indicator data" in an Easy way
to Excel ?

Any help appriciated.

i hope everone is doing well in this market (my system performs
ok : up 6,62% in less then 4 days) there is only one flawn :
me :)

Good weekend,

Theo
=20




- ------=_NextPart_000_0022_01C26083.BADAD100
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4916.2300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Hello friends,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>of course it is possible to copy &amp; =
past the=20
O,H,L,C&nbsp; to Excel</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>but how do i copy and paste "all the =
indicator=20
data" in an Easy way</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>to Excel ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Any help appriciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>i hope everone is doing well in this =
market (my=20
system performs</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ok : up 6,62% in less then&nbsp;4 days) =
there is=20
only one flawn :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>me :)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Good weekend,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Theo</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

- ------=_NextPart_000_0022_01C26083.BADAD100--

------------------------------

Date: Fri, 20 Sep 2002 10:03:31 +0200
From: "staffan" <u46115068@xxxxxxxxx>
Subject: Re: Composite Index

What is commonly traded or available for free on the internet as Brown's
Composite Index is NOT her Composite Index.
The one for $200 might be the exception .....
To my understanding the proper Index is an indicator on another indicator -
like the StochRSI et al (UNnormalized, though).
Staffan

- ----- Original Message -----
From: "Lionel Issen" <lissen@xxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Friday, September 20, 2002 5:13 AM
Subject: RE: Composite Index


> This is one of several easers that Connie Brown has in her book. Perhaps
if
> you took her expensive course you might learn how to construct it.
>
> The name "composite index" either describes something about the function
or
> it is meant to mislead us.
>
> Connie seems to like the RSI so maybe it is a composite of several
different
> length RSI functions.
>
> Lionel
>
>
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Mikey
> Sent: Thursday, September 19, 2002 8:08 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Re: Composite Index
>
>
> lol never have but if ya ever do I sure would love a copy of it!!
> ----- Original Message -----
> From: "Bijan Khezri" <bij3peat@xxxxxxx>
> To: "Metastock" <metastock@xxxxxxxxxxxxx>
> Sent: Thursday, September 19, 2002 7:04 PM
> Subject: Composite Index
>
>
> > Has anyone figured out what the so called "composite index" that Connie
> > Brown professes is all about?
> >
> >
>


- ---
              Outgoing Mail is Certified Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.389 / Virus Database: 220 - Release Date: 2002-09-16
Here is a sub-routine in VBA that deletes the columns with a "Date" header.
Just paste it in the VBA workbook code and click RUN.
If you like you can create a macro that will call it from inside the Excel
workbook, so you will not
have to switch every time to VBA to run it.
It's also a good idea to use a macro utility to make copy-pasting multiple
indicators between MS and Excel
a single click's task.

Make sure that the first line "Option Compare Text" appears before any other
procedures.
This sub assumes that you use less than 100 columns and less than 10000
rows. If you are using more, then
change the numbers.

Cheers
Spyros


Option Compare Text
_______________________________

Sub DeleteDateColumns()

For x = 1 To 100
    If Cells(1, x) = "DATE" Then
        Range(Cells(1, x), Cells(10000, x)).Select
        Selection.Columns.Delete
        x = x - 1
    End If
Next

End Sub