|
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.2722.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>
<DIV><FONT size=2><STRONG>OLE between MSK+Excel (+v.v.)
- FAQ's </STRONG>{where ascii meets ole}</FONT></DIV>
<DIV><FONT
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><STRONG>Q8. </STRONG></FONT><FONT
color=#000000>Can I have daily data transfered into weekly, monthly,
quarterly (and so on) when data is </FONT></FONT><FONT size=2><FONT
color=#000000>being OLE</FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#000000> linked or
imported from an ASCII file? (</FONT></FONT></FONT><FONT size=2>I need the
general logic for determining </FONT><FONT size=2>the start of a new
time</FONT></DIV>
<DIV><FONT size=2> <FONT face=Arial size=2>period
such as a new week or new month from my imported data </FONT></FONT><FONT
size=2><FONT face=Arial size=2>that is in "DTYYYYMMDD"
form).</FONT></FONT></DIV>
<DIV><FONT size=2> </DIV></DIV></FONT>
<DIV><FONT size=2>1. Copied down below are two(2) Excel STATIC formula ways
to calculate weekly data from </FONT><FONT size=2>a file's</FONT></DIV>
<DIV><FONT size=2> daily data contents. </FONT><FONT
size=2>Note here that:</FONT></DIV>
<DIV><FONT size=2> a.-</FONT><FONT size=2>STATIC should
be read as: ROW 2 to ROW 6 is a week's 5 day row week.</FONT></DIV>
<DIV><FONT size=2> b.-DYNAMIC should be read as: you have
created (Cell) formula(s) or </FONT><FONT size=2>VBA code to test
for</FONT></DIV>
<DIV><FONT
size=2> and
overcome </FONT><FONT size=2>any in your data file </FONT><FONT
size=2>missing "days in a week" (eg the Exchange's holidays).</FONT></DIV>
<DIV><FONT size=2> c.-a TRUE week </FONT><FONT
size=2>should always be starting out:</FONT></DIV>
<DIV><FONT size=2> -for OPEN +
CLOSE:</FONT></DIV>
<DIV><FONT size=2>
-</FONT><FONT size=2>with
that </FONT><FONT size=2>week's first day's trading results and end with
that </FONT><FONT size=2>week's last </FONT><FONT size=2>day's trading
results</FONT></DIV>
<DIV><FONT size=2> -for
HIGH + LOW:</FONT></DIV>
<DIV><FONT size=2>
-with the (</FONT><FONT
size=2>inbetween) throughout the rest of that week
trading results</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>2. In the Downloader create a D(aily) dummy
security for your file's data contents, use Convert to (on a
</FONT><FONT size=2>daily</FONT></DIV>
<DIV><FONT size=2> base)</FONT> <FONT
size=2>update </FONT><FONT size=2>this dummy sec, then Open MSK +
Excel and:</FONT></DIV>
<DIV><FONT size=2> </FONT><FONT size=2>a.-In MSK Open
this dummy Security</FONT></DIV>
<DIV><FONT size=2> b.-change the Periodicity's Date
Compression to W {weekly}</FONT></DIV>
<DIV><FONT size=2> b1.-OLE
Link this dummy sec to Excel</FONT></DIV>
<DIV><FONT size=2>
or</FONT></DIV>
<DIV><FONT size=2>
b2.-Copy and Paste the Price (or custom created CLOSE ONLY)
indicator </FONT><FONT size=2>to an Excel sheet/workbook</FONT></DIV>
<DIV><FONT size=2> c.-</FONT><FONT size=2>Then at each
week's end in </FONT><FONT size=2>Excel :</FONT></DIV>
<DIV><FONT size=2> -Save
As your sheet to an ASCII file, preferably in the TAB delimited text(TXT)
format</FONT></DIV>
<DIV><FONT size=2> -Open
the just Saved As file to another sheet, either store in the same workbook or
move sheet</FONT></DIV>
<DIV><FONT size=2>
to another workbook(eg at the same time this sheet is Open, Open another
workbook, rightclick</FONT></DIV>
<DIV><FONT size=2>
this sheet's Tab {at the bottom} and click "Move or Copy sheet..." to
move and then select</FONT></DIV>
<DIV><FONT size=2>
the "another workbook".</FONT></DIV>
<DIV><FONT size=2> -Close
and Save all opened windows/files/books/sheets.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>3. For more in depth info, help and formulas and
codes:</FONT></DIV>
<DIV><FONT size=2> a. Search the web for XL related stuff (eg
use Alta Vista and search for the word XL)</FONT></DIV>
<DIV><FONT size=2> b. Subscribe to (one of) the Excel
newsgroups (esp. the Microsoft Excel newsgroups)</FONT></DIV>
<DIV><FONT size=2> c. Subscribe to the XL_Traders forum
{that's were the below printed formulas stem from} </FONT></DIV>
<DIV><FONT size=2> d. See XL Help</FONT></DIV>
<DIV><FONT size=2> e. See if you can obtain a
book on Excel formulas, methods and AddIns(use Alta Vista and search for
AddIn)</FONT></DIV>
<DIV><BR><FONT
size=2>==================================================</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>></FONT></DIV>
<DIV><FONT size=2>> Can't offer VBA solution, but here's a way using "Names"
and Excel's "Index" function <BR>> e.g. assuming you have 'hourly
data' in: A1:D500 [O,H,L,C headings in<BR>> A1:D1, prices in A2:D500] and
want to convert to "4-hour bars", you would:<BR>> <BR>> <BR>> define
your existing series' as named ranges; e.g.</FONT></DIV>
<DIV><FONT size=2>> "Open": A2:A500<BR>> "High": B2:B500,
etc.<BR>> <BR>> in your new sheet enter formulas in following
cells:<BR>> <BR>> A2: =Index(Open,(Row()-1)*4)<BR>> B2:
=Index(High,(Row()-1)*4)<BR>> C2: =Index(Low,(Row()-1)*4)<BR>> D2:
=Index(Close,(Row()-1)*4)<BR>> <BR>> then copy down to last row in each
column range . . . to convert Daily to<BR>> Weekly, change the "multiplier"
in the formulas from "4" to
"5"<BR>> <BR>------------------------------------------------<BR><BR>This
method just reports the values that occur at (Row()-1)*n bars. If n is 5, (and
you're trying to get</FONT></DIV>
<DIV><FONT size=2>daily data compressed into weekly), you will only get Friday's
numbers. This will not capture the</FONT></DIV>
<DIV><FONT size=2>true Highs and Lows for the week, just those on the last bar
of the week.<BR><BR>I think you could use the Offset() function to capture the
correct values, but the formulas will have</FONT></DIV>
<DIV><FONT size=2>to be different in each column. You simply want the first
value in each block for the Open, and</FONT></DIV>
<DIV><FONT size=2>the last for the Close. In the case of High and Low, you'll
want to apply the Max and Min functions</FONT></DIV>
<DIV><FONT size=2>to a range produced.<BR><BR>For example, the following
formulas will condense daily data to weekly, producing the desired</FONT></DIV>
<DIV><FONT size=2>results when placed in sheet 2 referring to data in sheet
1:<BR><BR>B2: =OFFSET(Sheet1!B2,(ROW()-2)*4,0)<BR>C2:
=MAX(OFFSET(Sheet1!C2,(ROW()-2)*4,0,5,1))<BR>D2:
=MIN(OFFSET(Sheet1!D2,(ROW()-2)*4,0,5,1))<BR>E2:
=OFFSET(Sheet1!E2,(ROW()-1)*4,0)<BR><BR>This assumes that sheet 1
contains:</FONT></DIV>
<DIV><FONT size=2>Open, High, Low, and Close data in columns B,C,D, and E
respectively, beginning in row 2.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT
size=2>====================================================================</FONT></DIV>
<DIV><FONT size=2>{end of FAQ8} </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>Now here you're asking content. I am sure that there are many
more ways to get you</FONT></DIV>
<DIV><FONT size=2>where you want, but......................lack of time prevails
in testing.</FONT></DIV>
<DIV> </DIV></DIV></FONT>
<DIV><FONT size=2>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss the
".nospam" bit (including the dot) when replying.<BR>Homepage <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A>
<DIV> </DIV></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>
Adam Hefner
</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> maandag 14 februari 2000 0:47</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Excel code question......</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Thanks to the good post from Ton, Walter
and many others, I have completed my first spread sheet</FONT></DIV>
<DIV><FONT face=Arial size=2>that calculates daily projected levels. My
next project will be to calculate these levels for multiple time</FONT></DIV>
<DIV><FONT face=Arial size=2>frames (weekly, Monthly, etc.) To do this I need
the general logic for determining the start of a new time</FONT></DIV>
<DIV><FONT face=Arial size=2>period such as a new week or new month from my
imported data that is in "DTYYYYMMDD" form.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Is this possible?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> If this is possible, then my next step will
be to determine the time periods high, low and close.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>If someone has the general logic for 1 or both of
these steps, I would appreciate the knowledge.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> Thank you,</FONT></DIV>
<DIV><FONT face=Arial
size=2> Adam
Hefner</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Mon Feb 14 18:45:54 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.9.3/8.9.3) with ESMTP id SAA10860
for <neal@xxxxxxxxxxxxx>; Mon, 14 Feb 2000 18:29:38 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id QAA27854
for metastock-outgoing; Mon, 14 Feb 2000 16:36:36 -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 QAA27846
for <metastock@xxxxxxxxxxxxxxxxxx>; Mon, 14 Feb 2000 16:36:32 -0700
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id QAA25015
for <metastock@xxxxxxxxxxxxx>; Mon, 14 Feb 2000 16:50:06 -0700 (MST)
Received: from escom ([195.121.219.94]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAB1B37
for <metastock@xxxxxxxxxxxxx>; Tue, 15 Feb 2000 00:34:05 +0100
Message-ID: <024901bf7744$69ceb860$5edb79c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <000401bf765a$84973720$71a294d1@xxxxxxx>
Subject: Re: A1Global
Date: Mon, 14 Feb 2000 23:40:45 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_01CE_01BF7744.EA1E50C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
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.2722.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2>Info (older mailings) below as requested......................
</FONT></DIV>
<DIV><BR><FONT size=2>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss the
".nospam" bit (including the dot) when replying.<BR>Homepage <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT>
<DIV><FONT size=2>From: Walter Lake <<A
href="mailto:wlake@xxxxxxxxx";>wlake@xxxxxxxxx</A>></FONT></DIV>
<DIV><FONT size=2>To: Metastock bulletin board > <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT size=2>Sent: zondag 13 februari 2000 20:41</FONT></DIV>
<DIV><FONT size=2>Subject: A1Global</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>-snip-<BR>> I don't know what the random walk formulas are
in Metastock, other posters<BR>> have described them as bad math. But I don't
know exactly what they meant by<BR>> that, wrong formulas or wrong variation
of the formulas?<BR>> <BR>> The RW high and RW low is probably the same as
the formula given on page 24<BR>> of the OT systems book. The equis site for
formulas has the Random Walk<BR>> Index etc. They only mention the Michael
Poulos article's in the Sept 92<BR>> issue of TASC but there is also the Jan
92 issue to look at also.<BR>> <BR>> Maybe Ton has some information in his
wonderful filing system.<BR>> <BR>> Best regards<BR>> <BR>>
Walter<BR></FONT></DIV>
<DIV><FONT size=2><FONT size=2>=+=+=+=/////////////=+=+=+=+=+=+=\\\\\<FONT
size=2> BREAK
/////=+=+=+=+=+=+=/////////////=+=+=+<BR></FONT></FONT></FONT><FONT
size=2>=+=+=+=/////////////=+=+=+=+=+=+=\\\\\<FONT size=2> BREAK
/////=+=+=+=+=+=+=/////////////=+=+=+<BR></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2>-----Original Message-----<BR>From: A.J.
Maas</FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2>Date: Saturday, October 03, 1998 7:57
AM<BR>Subject: Re: RWI - Random Walk Index system</FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT size=2>Lionel,</FONT></FONT><FONT size=2><FONT
size=2></DIV></FONT></FONT>
<DIV><FONT size=2>Here some "facts" on the RWI system and the original
Equis/Poulus RWI formula/MS help info.<BR><BR>-The Equis web-site formula
contains a few errors as in formulating and typing the formula.<BR>-As to futher
formulating, any "better-ing" solutions/suggestions are always
wellcomed.<BR>-The Maximum function Max(Data Array, Data Array) returns the
largest of two values(p.234).<BR> By using several other Max's within a
Max results in the Maximum comparisson by the<BR> program of, and as, to
wich value of each Max is the largest. In this:<BR>
Max(funct1,Max(funct2,Max(funct3,Max(funct4,0))))<BR> always
returns the highest value of one of the Max functions(terms) used for that
day(period)<BR> and wich Max, that is being returned, too, is
always greater then 0;<BR> otherwise the 0 used to differ to,
is being returned.<BR><BR>The seperate ranges(conditions with one or more
functions within a part of the total formula) you<BR>mention are multi-folded
on, and per, each line set out(The terms or conditions of a
function).<BR><BR>The LT 50 you refer to, was indeed not the LT with say 50 odd
Max's. That's what got stuck<BR>in my mind too last night, and as such, today
have send on the revised version of the original<BR>RWI-sytem mail. Delete the
old one, as there were more, minor errors fixed and other type
of<BR>addition(al)s made to it.<BR><BR>I have not read Mr. Poulos article, as I
do not have it, but sort of used all that is available to me.<BR>One of that was
ofcourse Equis original, others where either mailings, small articles,
explanations<BR>etc. Since I was writing this for my private use, got to stick
it down to using the Equis original and<BR>went on from there.<BR>In the
MS-build-in Help and MS manuals more references where to be found and also the
fact<BR>that I had used the v65 standard RWI- build-in -Indicator
before.<BR>Along with some of the other of the "Trend" indicating masters, like
MESA-Sine, fiddled around<BR>a bit to get to know more and see the
results.<BR>Since these were very promissing, went on to add the RWI Highs +
Lows v6.5 (p.242), the custom<BR>versions, and went on futher and futher
resulting in another set of custom indicators for the collection.<BR><BR>The
fact as to if the indicators are 100% TRUE Mr. Poulos indicators did not came
into it anymore,<BR>with all of the either adjustments made or the additionals I
added and writing a proper "manual" for<BR>them all. Besides that, my main aim
was to have good resulting giving indicators, and as<BR>such I succeeded very
well.<BR>Didn't bother much about writing the SystemTest/ExpertAdv for now, as
it, all in all, takes up to much<BR>of 'valuable' time to get there where I
wanted it to go to(eg forecast the markets Mode).<BR>But now there is a very
solid base to even futher develop it, maybe even into even more
better<BR>signaling indicators.<BR>All in all was quite pleased with results,
enough to pass it along to the List and our MS club.<BR><BR>If you or others
would like to add to this, by all means, do so. Help is always appreciated
and<BR>lets hope that from all of that has or is or is going to be written, was
and is for the better<BR>(for Listers too).<BR>Thanks also to the List, Equis/Ms
and several other sources and ofcourse our Dutch MS Users<BR>group, I have
gotten as far as I have now in doing all of this.<BR><BR>Best Regards,<BR>Ton
Maas.</FONT></DIV>
<DIV><FONT size=2><BR>=+=+=+=/////////////=+=+=+=+=+=+=\\\\\</FONT><FONT
size=2> BREAK
/////=+=+=+=+=+=+=/////////////=+=+=+<BR><BR>-----Oorspronkelijk
bericht-----<BR>Van: Lionel Issen</FONT></DIV>
<DIV><FONT size=2>Aan:</FONT><FONT size=2> A.J. Maas</FONT></DIV>
<DIV><FONT size=2>Onderwerp: Re: RWI - Random Walk Index
system<BR><BR>Maas:<BR>While my manual for V6.5 page 242 shows "random walk
index of highs" and<BR>"random walk index of lows" the only random walk index in
my indicator<BR>library is the one I downloaded from the Equis web site. The web
site<BR>version does not do justice to the random walk index at all.<BR><BR>I
thought that Poulos had separated the ranges of from 1 to 9 days
(short<BR>term), and from 10 to 60 days (long term).<BR><BR>There are several
formulations for the random walk index. Some time ago, I<BR>found several
on the internet formulated for Supercharts; including one from<BR>a consultant
who pointed out the errors in at least one other formulation of<BR>this
index.<BR><BR>There appears to be an error in your formulation. You
are misusing the<BR>"max" function. You can only have a max of 2 or more
values. Your set up<BR>shows a max of several individual functions.
You need a formulation<BR>something like<BR><BR>MAX ( funct1, funct2,
funct3, etc) instead of<BR>MAX(funct1),MAX(funct2),MAX(funct3)
etc<BR><BR>Your long term LT 50 day formulation is a repetition of the short
term ST 8<BR>day. For the long term formulation you need a MAX of 51 terms (10
to 60).<BR><BR>You have shown that using V6.5 it may be possible to formulate
the random<BR>walk index with this software. Some time ago Equis support
said that this<BR>could not be done, and that it was difficult to include it as
a built in
indicator.<BR><BR>Lionel<BR><BR>=+=+=+=/////////////=+=+=+=+=+=+=\\\\\<FONT
size=2> BREAK
/////=+=+=+=+=+=+=/////////////=+=+=+<BR><BR></FONT>-----Original
Message-----<BR>From: A.J. Maas</FONT></DIV>
<DIV><FONT size=2>Subject: RWI - Random Walk Index
system<BR><BR>================================================================<BR>RWI
- Random Walk Index system - E.M. Poulos - for Metastock
v6.x<BR>================================================================<BR>Re-written
by Ton Maas - 981001 - Ms-IRB@xxxxxx -
Amsterdam - The
Netherlands.<BR>---------------------------------------------------------------------------------<BR>The
original formula of the Random Walk Index, was created by Equis Intl.<BR>using
information from the article "Are There Persistent Cycles", by E.
Michael<BR>Poulos, in the September 1992 issue of
TASC.<BR>----------------------------------------------------------------------------------<BR>This
indicator is defined as the ratio of an acutal price move to the<BR>expected
random walk. If the move is greater than a random walk, and thus</FONT></DIV>
<DIV><FONT size=2>a trend is present, its index will be larger than "1.0"
.<BR><BR>Random Walk<BR>An economic theory that price movements in the commodity
futures markets and<BR>in the securities markets are completely random in
character (i.e., past prices are<BR>not a reliable indicator of future
prices).<BR><BR><STRONG>Random Walk Index<BR><BR></STRONG>Description<BR>In an
effort to find an indicator that overcomes the effects of a fixed
look-back<BR>period and the drawbacks of traditional smoothing methods, Michael
Poulos<BR>developed the Random Walk Index. The Random Walk Index is based on
the</FONT></DIV>
<DIV><FONT size=2>basic geometric concept that the shortest distance between two
points is</FONT></DIV>
<DIV><FONT size=2>a straight line. The further prices stray from a straight
line during a move between</FONT></DIV>
<DIV><FONT size=2>two points in time, the less efficient the
movement.<BR><BR>Interpretation<BR>Mr. Poulos found significant evidence during
his research that the "dividing<BR>line" between short- and long-term time
frames for most futures and stocks is<BR>right around eight to 10 days.
Therefore, he feels an effective trading system</FONT></DIV>
<DIV><FONT size=2>using the RWI can be devised using two different time
frames:<BR><BR>1.a short-term RWI (two to seven periods) for the market's
frantic, random side</FONT></DIV>
<DIV><FONT size=2> and<BR>2.a long-term RWI (eight to 64 periods) for
the market's steady, trending side.<BR><BR>-Peaks in the short-term RWI of highs
tend to coincide with price peaks.<BR>-Peaks in the short-term RWI of lows tend
to coincide with price troughs.<BR>-Readings of the long-term RWI of highs above
1.0 provides a good indication<BR> of a sustainable uptrend.<BR>-Readings
of the long-term RWI of lows below 1.0 provide a good indication<BR> of a
sustainable downtrend.<BR><BR>Indicators<BR>The Random Walk Index is standard
build-in in Metastock v6.5. See below for<BR>its Parameters. However custom
versions can be build by using the Indicator Builder.<BR><BR>In
<STRONG>Metastock v6.5</STRONG>:<BR>NAME
Random Walk Index [6.5] High<BR>SYNTAX rwih( PERIODS
)<BR>FUNCTION Calculates the predefined Random Walk Index of the highs
indicator.<BR>EXAMPLE rwih( 21 )<BR><BR>NAME
Random Walk Index [6.5] Low<BR>SYNTAX
rwil( PERIODS )<BR>FUNCTION Calculates the predefined Random Walk Index
of the lows indicator.<BR>EXAMPLE rwil( 21 )<BR><BR>Parameters
v6.5<BR>Standard Time Periods ST = 9<BR>Standard Time Periods LT =
70<BR>Standard Indicator Color = High: Red,Solid and Low: Red,Dotted<BR>Standard
Horizontal Line = 1.0, Black/Blue<BR><BR>Note that by DEFAULT the v6.5 build-in
is set to 9 for the periods used for<BR>both functions, and when 'dragged' from
the Indicator Builder to the chart, both<BR>will be promptly plotted as the 1
indicator in their inner window.<BR><BR>Custom indicator in <STRONG>Metastock
v6.x</STRONG>:</FONT></DIV>
<DIV><FONT size=2> </DIV></FONT>
<DIV><FONT size=2>NAME:<BR>"Random Walk Index [6.0] High"<BR></DIV></FONT>
<DIV><FONT size=2>Formula:<BR>{This is the ST 9-day version of the RWI. Color
High: Red,Solid<BR>and the Low: Red,Dotted. Horizontal line at
1.0(Black/Blue)}<BR>Standard Horizontal Line = 1.0, Black/Blue<BR>Max( (HIGH
-Ref(LOW,-1)) / ( (Ref(Sum(ATR(1),2),-1) / 2)*Sqrt(2) ),<BR>Max( (HIGH
-Ref(LOW,-2)) / ( (Ref(Sum(ATR(1),3),-1) / 3)*Sqrt(3) ),<BR>Max( (HIGH
-Ref(LOW,-3)) / ( (Ref(Sum(ATR(1),4),-1) / 4)*Sqrt(4) ),<BR>Max( (HIGH
-Ref(LOW,-4)) / ( (Ref(Sum(ATR(1),5),-1) / 5)*Sqrt(5) ),<BR>Max( (HIGH
-Ref(LOW,-5)) / ( (Ref(Sum(ATR(1),6),-1) / 6)*Sqrt(6) ),<BR>Max( (HIGH
-Ref(LOW,-6)) / ( (Ref(Sum(ATR(1),7),-1) / 7)*Sqrt(7) ),<BR>Max( (HIGH
-Ref(LOW,-7)) / ( (Ref(Sum(ATR(1),8),-1) / 8)*Sqrt(8) ),<BR>Max( (HIGH
-Ref(LOW,-8)) / ( (Ref(Sum(ATR(1),9),-1) /
9)*Sqrt(9)),0))))))))<BR><BR>NAME:<BR>"Random Walk Index [6.0] Low"</FONT></DIV>
<DIV><FONT size=2><BR>Formula:<BR>{This is the ST 9-day version of the RWI. For
High: Red,Solid<BR>and the Low: Red,Dotted. Horizontal line at
1.0(Black/Blue)}<BR>Max( (Ref(HIGH,-1) -LOW) / ( (Ref(Sum(ATR(1),2),-1) /
2)*Sqrt(2) ),<BR>Max( (Ref(HIGH,-2) -LOW) / ( (Ref(Sum(ATR(1),3),-1) /
3)*Sqrt(3) ),<BR>Max( (Ref(HIGH,-3) -LOW) / ( (Ref(Sum(ATR(1),4),-1) /
4)*Sqrt(4) ),<BR>Max( (Ref(HIGH,-4) -LOW) / ( (Ref(Sum(ATR(1),5),-1) /
5)*Sqrt(5) ),<BR>Max( (Ref(HIGH,-5) -LOW) / ( (Ref(Sum(ATR(1),6),-1) /
6)*Sqrt(6) ),<BR>Max( (Ref(HIGH,-6) -LOW) / ( (Ref(Sum(ATR(1),7),-1) /
7)*Sqrt(7) ),<BR>Max( (Ref(HIGH,-7) -LOW) / ( (Ref(Sum(ATR(1),8),-1) /
8)*Sqrt(8) ),<BR>Max( (Ref(HIGH,-8) -LOW) / ( (Ref(Sum(ATR(1),9),-1) /
9)*Sqrt(9)),0))))))))<BR><BR>Note that for both the High+Low as functions or as
indicators "friendly" error<BR>messages are returned regarding the division of
"0". This is very common in<BR>the program and in this they can be ignored.
These "friendlies" will not<BR>affect their functioning, values, output or
readings.<BR><BR>NAME:<BR>"Random Walk Index [6.0] LT High"</FONT></DIV>
<DIV><FONT size=2><BR>Formula:<BR>{This is the LT 50-day version of the RWI.
Color High: Red,Solid<BR>and the Low: Red,Dotted. Horizontal line at
1.0(Black/Blue)}<BR>SUM(<BR>Max( (HIGH -Ref(LOW,-1)) / ( (Ref(Sum(ATR(1),2),-1)
/ 2)*Sqrt(2) ),<BR>Max( (HIGH -Ref(LOW,-2)) / ( (Ref(Sum(ATR(1),3),-1) /
3)*Sqrt(3) ),<BR>Max( (HIGH -Ref(LOW,-3)) / ( (Ref(Sum(ATR(1),4),-1) /
4)*Sqrt(4) ),<BR>Max( (HIGH -Ref(LOW,-4)) / ( (Ref(Sum(ATR(1),5),-1) /
5)*Sqrt(5) ),<BR>Max( (HIGH -Ref(LOW,-5)) / ( (Ref(Sum(ATR(1),6),-1) /
6)*Sqrt(6) ),<BR>Max( (HIGH -Ref(LOW,-6)) / ( (Ref(Sum(ATR(1),7),-1) /
7)*Sqrt(7) ),<BR>Max( (HIGH -Ref(LOW,-7)) / ( (Ref(Sum(ATR(1),8),-1) /
8)*Sqrt(8) ),<BR>Max( (HIGH -Ref(LOW,-8)) / ( (Ref(Sum(ATR(1),9),-1) /
9)*Sqrt(9)),<BR>0)))))))),40)<BR><BR>NAME:<BR>"Random Walk Index [6.0] LT
Low"</FONT></DIV>
<DIV><FONT size=2><BR>Formula:<BR>{This is the LT 50-day version of the RWI. For
High: Red,Solid<BR>and the Low: Red,Dotted. Horizontal line at
1.0(Black/Blue)}<BR>SUM(<BR>Max( (Ref(HIGH,-1) -LOW) / ( (Ref(Sum(ATR(1),2),-1)
/ 2)*Sqrt(2) ),<BR>Max( (Ref(HIGH,-2) -LOW) / ( (Ref(Sum(ATR(1),3),-1) /
3)*Sqrt(3) ),<BR>Max( (Ref(HIGH,-3) -LOW) / ( (Ref(Sum(ATR(1),4),-1) /
4)*Sqrt(4) ),<BR>Max( (Ref(HIGH,-4) -LOW) / ( (Ref(Sum(ATR(1),5),-1) /
5)*Sqrt(5) ),<BR>Max( (Ref(HIGH,-5) -LOW) / ( (Ref(Sum(ATR(1),6),-1) /
6)*Sqrt(6) ),<BR>Max( (Ref(HIGH,-6) -LOW) / ( (Ref(Sum(ATR(1),7),-1) /
7)*Sqrt(7) ),<BR>Max( (Ref(HIGH,-7) -LOW) / ( (Ref(Sum(ATR(1),8),-1) /
8)*Sqrt(8) ),<BR>Max( (Ref(HIGH,-8) -LOW) / ( (Ref(Sum(ATR(1),9),-1) /
9)*Sqrt(9)),<BR>0)))))))),40)<BR><BR>System<BR>Mr. Poulus feels that an
effective trading system could be built that opens<BR>trades (after short-term
pull-backs against the direction of the long-term<BR>trend) using the following
guidelines:<BR><BR>·Enter long (or close short) when the long-term RWI of the
highs is greater<BR>than 1.0, and the short-term RWI of lows peaks above
1.0.<BR>·Enter short (or close long) when the long-term RWI of the lows is
greater<BR>than 1.0, and the short-term RWI of highs peaks above
1.0.</FONT></DIV>
<DIV><FONT
size=2>=======================================================</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Mon Feb 14 16:21:00 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.9.3/8.9.3) with ESMTP id RAA08831
for <neal@xxxxxxxxxxxxx>; Mon, 14 Feb 2000 17:29:38 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id PAA27760
for metastock-outgoing; Mon, 14 Feb 2000 15:43:32 -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 PAA27757
for <metastock@xxxxxxxxxxxxxxxxxx>; Mon, 14 Feb 2000 15:43:29 -0700
Received: from sm0101.promedia.net (root@xxxxxxxxxxxxxxxxxxx [208.131.40.4])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id PAA24976
for <metastock@xxxxxxxxxxxxx>; Mon, 14 Feb 2000 15:57:02 -0700 (MST)
Received: from TOMCAT (ppp-208-171-196-46.01.promedia.net [208.171.196.46])
by sm0101.promedia.net (8.9.3/8.9.3) with SMTP id HAA24951
for <metastock@xxxxxxxxxxxxx>; Thu, 1 Jan 1998 07:44:14 -0800
From: "Bob Jagow" <bjagow@xxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: RE: www.BigEasyInvestor.com
Date: Mon, 14 Feb 2000 14:41:09 -0800
Message-ID: <00e201bf773c$96d640b0$74c4abd0@xxxxxx>
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_NextPart_000_00E3_01BF76F9.88B300B0"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Importance: Normal
In-Reply-To: <38A8638C.6CC828DC@xxxxxxxxxxxxx>
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
QuotesPlus provides both for the 4 dows, e.g., the attached dji.gif
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Shawn Andrews
> Sent: Monday, February 14, 2000 12:20 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Re: www.BigEasyInvestor.com
>
>
> Joseph Ehardt wrote:
>
> > David,
> >
> > Even free quotes can be a mixed blessing and require one to do
> some homework. At least in the past, Yahoo! gave the theoretical
> highs and lows of the day for the DJIA, which is a ridiculous
> mistake. One should focus on print highs and lows because that is
> "physically" what the market did in actual trading during the
> course of the day. If one uses prices for predicting targets, use
> print highs and lows and not theoretical figures. Personally I
> have no "argument" against paying for the EOD quotes that I
> receive from Reuters/Equis, but I wish that competition would
> push the subscription prices even lower (consider what people
> used to pay for such information).
> >
> > Joe
> >
>
> I second you on that one. Expecially as a Chaologist one becomes
> well aware that predictions are very sensitive to the initial
> conditions ( In our case daily highs and lows of the Industrials
> ). Using unreliable data will cost you much more than what you
> think initially was a bargain.
>
> Esignal provides End of day data ( Tick Data daily ) for only
> $195 Dollars a year. I think
> that is a real bargain .
>
>
>
>
> --
> "It is not how right or how wrong you are that matters,
> But how much money you make when right and how much
> money you do not lose when wrong" ....
>
> Quaerendo Invenietis
>
>
>
Attachment Converted: "f:\eudora\attach\dji.gif"
|