|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY bgColor=#d8d0c8>
<DIV><FONT size=2>One very good reason for using the LOAD XXXX RECORDS option is
if your want your study confined to only those records of a particular period.
For example, I find that there are about 253 trading days in a calendar year. In
certain kinds of explorations I will load 254 records (the previous 253 days
plus the current day) to do certain kinds of analysis. I do this because I found
that the HHV function (e.g., REF(HHV(HIGH,253),-1) would reject any equity (or
whatever is being studied) if there were not the requisite number of bars and I
did not want any rejections if an equity did not have at least 254 price bars.
For one, some mergers can foil such explorations. Recent IPOs also will be
eliminated, which I did not want. Given 254 days, instead I ask for
REF(HIGHEST(HIGH),-1), which is yesterday's highest high since the first date
loaded.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Overall I think it pays to think about the time span that is
being loaded for a given exploration. Excessive loading only slows the
exploration, but one must be sure that one loads enough to satisfy your wishes.
My 400 MHz Pentium II scans the entire S&P 500 in 25 seconds for a yearly
analysis.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Joe</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Nicholas Kormanik <<A
href="mailto:nkormanik@xxxxxxxxxx";>nkormanik@xxxxxxxxxx</A>><BR><B>To:
</B>metastock@xxxxxxxxxxxxx
<<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR><B>Date:
</B>Sunday, January 09, 2000 10:23 AM<BR><B>Subject: </B>Faster
Explorations....<BR><BR></DIV></FONT>I discovered why my explorations were
taking so long. In the Explorer<BR>Options, the 'Load Minimum Records'
option was **not** checked. Instead I<BR>had the 'Load [5000] Records'
option checked.<BR><BR>Do any of you, for some good reason, advocate using the
'Load [XXXX]<BR>Records' option?<BR><BR>Incidentally, I sent in a check for
the program earlier mentioned here,<BR>vRamDir, and got it from the author a
few days ago. After experimenting,<BR>I'm left with the impression that
vRamDir probably is **not** a panacea for<BR>faster explorations --- each file
of stock price data still must be<BR>individually read, and is not
subsequently re-read, thus bringing it into<BR>cache in real time serves no
purpose. One would have to copy all data files<BR>to RAM **before hand**
in order for the cache to make a difference.<BR><BR>One additional note:
reading over the benefits of Windows 2000, it seems<BR>that it will make quite
a difference to our explorations speed, from several<BR>different
enhancements. Have any of you folks thought about this?<BR><BR>Thanks
for your advice.<BR><BR>Nicholas<BR><BR></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sun Jan 09 22:42:35 2000
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 SAA20214
for <neal@xxxxxxxxxxxxx>; Sun, 9 Jan 2000 18:35:01 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA25538
for metastock-outgoing; Sun, 9 Jan 2000 17:57:48 -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 RAA25535
for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 9 Jan 2000 17:57:45 -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 SAA27975
for <metastock@xxxxxxxxxxxxx>; Sun, 9 Jan 2000 18:08:05 -0700 (MST)
Received: from escom ([195.121.217.229]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAA601B
for <metastock@xxxxxxxxxxxxx>; Mon, 10 Jan 2000 01:52:28 +0100
Message-ID: <003901bf5b05$61214e40$e5d979c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: "Metastock-List" <metastock@xxxxxxxxxxxxx>
References: <001501bf5ac1$62d0c3e0$cbda79c3@xxxxx>
Subject: Re: how to improve generalization in system optimization
Date: Mon, 10 Jan 2000 01:54:45 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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:
A correction here.
----------------------------------------------------------------
For example, the following code displays tomorrow's date:
MsgBox "Tomorrow is " & DateValue(Now + 1)
Similarly, the following code sets the system clock back one hour:
Time = Timevalue(Now - 1/24)
-----------------------------------------------------------------
This should now read as:
For example, the following code displays tomorrow's date:
MsgBox "Tomorrow is " & Date + 1
The following code sets the system clock back one hour:
Time = Time - 1 / 24
-----------------------------------------------------------------
Like the first
Time =
"insruction", eg thus not the second
Time
"function", the
DateValue()
"function" and the
TimeValue()
"function" are not to be used (anymore) in or within other "fuctions", eg
like in the MsgBox "function".
The (first,wrong) book example given, must have worked at that time
the book was published and is based on an older version of VB(4.0).
Since I have (silly) also bought that book version, I will have to transform
some more of the code to 6.0.
A bummer (and not, since this can also be VB-educative), but at least the
code seams to have shrunk with newer versions.
Besides the fact that it is a cute book (eg it reads easy), it gets one quickly
aquinted with the many features of Excel, and VB and VBA, eg and at least
this version is Office9x compatible.
It is also a fat rich book(860+ p.), fully explaining the basics of VB, the
basics of VBA and the basics of the Excel program. From all three also
the advanced features
Also detailed are the basics of 'VB' and 'VBA' working with Windows and
its API environment features (OLE etc.).
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying and
note the new address change. Also for my Homepage
http://home.planet.nl/~anthmaas
"Excel documentation often refers to procedures as macros. The two terms
mean the same thing: procedures (sub .......... end sub), though macro often
also refers to Excel 4.0 macros."
==================================================
----- Original Message -----
From: A.J. Maas <anthmaas@xxxxxxxxx>
To: Metastock-List <metastock@xxxxxxxxxxxxx>
Sent: zondag 9 januari 2000 17:48
Subject: Fw: how to improve generalization in system optimization
> Next up I am asuming your "system test" to be a VBA macro
> or at least includes a macro for use in Excel. From the below
> description of VB's DATE data type youcan see what and what
> actions you can perform and what for consequences/impact
=======snip=============
|