|
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.2721.2900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 face=Arial size=2>
<P>> Were you able run any tests with Control Panel's Regional Settings set
to<BR>> dd/mm/yy ?</P>
<P>Yes. Results were here the same text-date divergence as it happened
in your transfer.<BR>This disappeared when I used a single
'space' (eg hit the keyboard's spacebar)<BR>in place of any of the seperators:
the " / " (forward slash) or the " - " (dash) in the Regional
Settings.</P>
<P>However, this is not the problem. The problem is that (quoting the
Microsoft Windows Handbook):</P>
<P>"All configurations in the properties tabsheets for the Regional Settings are
standard configurations.<BR>This meaning that although Windows will pass on your
choices to the other applications, these<BR>applications are not restricted
to their use. Certain applications will ignore the configurations<BR>and
will keep their own appearance configurations. If you set certain
appearance-formats in the<BR>Control Panel, and an application uses a different
style, consult the manuals or Help-systems<BR>of that application."</P>
<P>Excel's Help+manuals explain that cells can hold both text and values. Values
are figures while<BR>figures in cells can be the cells values as well as
plain text. Since your data, when copied from the<BR>Downloader, is in the
standard Equis notation, eg mm/dd/yyyy, and than when this data is
added<BR>to a cell in Excel, it is also interpreted as date value(s) and
accordingly 'read' by the program in<BR>your Regional Settings configuration for
dates, eg the dd/mm/yyyy and as such Excel will paste<BR>accordingly.<BR>For
starters this is naturaly the wrong format/arrangement but also any
applications (in Windows)<BR>right to use for default. For
Excel, interpreting the copied data in the way that it had to
be added<BR>to the cells, will than also automatically check to see if the
contents are values or text.<BR>Since Excel works, by default, with its Serial
systematics system for date values AND works with<BR>your configurations set in
the Regional Settings' configurations, the FIRST figure in this to be
pasted<BR>value's date-sequence is also a date, eg in your RS configuration
this is a "day".<BR>Since zero dates ("0") do not excist in the Gregorian
calander, than Excel will not read the cell as<BR>a date-value but will, by
default, interpret and paste this to the cell as plain text.</P>
<DIV><FONT size=2>Solution/workaround:</FONT></DIV>
<DIV><FONT size=2>In your Regional Settings do not apply these seperators
(" - " or " / " or ..........).</FONT></DIV>
<DIV> </DIV>
<DIV>So, if you realy would like to omit this to happen, than set your
RS-configurations according to the top<BR>of this mail, eg use a blanc space for
separator (which by the way, by default, will not be included in the
text).<BR>In Excel cells you will then not have "true" dates, but no hic ups
either.</DIV>
<P>Below have printed some info on the value's Serial systematics used by Excel
(else see program Help+manuals<BR>or the Excel's Support + Site, and can
also be found in the Microsoft Support's Knowledge Base-articles).</P>
<P>===============================================</P>
<P>10&#0;01&#0;1999</P>
<P>This here above is an Excel cell's contents that was pasted from the
Downloader (mm/dd/yyyy), and now<BR>below also expressed in your Regional
Settings' date configuration. The equivelant for this
in Excel's Serial<BR>systematic sytem is 36170 which in
the date value represents the 10th of Jan 1999
(dd/mm/yyyy).</P></FONT></DIV>
<DIV><FONT size=2>The 1st of Oct 1999 is 36434 in the (Excel's) Serial format,
</FONT><FONT size=2>eg 264 days later (36170+264). The Serial counting<BR>starts
with 1 for this Centuries' 1st day, eg </FONT><FONT size=2>the 1st of Jan 1900
and the Excel's "computerised way" for<BR>representing the calander dates would
then be 10 for the </FONT><FONT size=2>10th of Jan 1900 </FONT><FONT
size=2>and 275 for the 1st of Oct 1900 etc.).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Excel recoqnises automatically if any data added to a cell is
a value (serial data) or text (plain).</FONT></DIV>
<DIV><FONT size=2>===============================================</FONT></DIV>
<DIV> </DIV>
<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 and<BR>note the new address
change. Also for my Homepage<BR><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: Glen Wallace <<A
href="mailto:gcwallace@xxxxxxxx";>gcwallace@xxxxxxxx</A>></FONT></DIV>
<DIV><FONT size=2>To: MetaStock listserver <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT size=2>Sent: dinsdag 12 oktober 1999 0:57</FONT></DIV>
<DIV><FONT size=2>Subject: Re: Strange bug?</FONT></DIV></DIV>
<DIV><BR></DIV><FONT size=2>> Ton:<BR>> <BR>> So there seems to be no
problem when Excel expresses the DownLoader dates in<BR>> text format --
which yyyymmdd (your testing) and m/dd/yy (my testing)<BR>> seems to
consistently return. For me, the problem appeared when DownLoader<BR>>
handed the dates to Excel as dd/mm/yy, in which case Excel tried to
express<BR>> the post-September dates in date format (rather than text) and
incorrectly.<BR>> <BR>> Were you able run any tests with Control Panel's
Regional Settings set to<BR>> dd/mm/yy ?<BR>> <BR>> Regards.<BR>>
<BR>> </FONT></BODY></HTML>
</x-html>From ???@??? Wed Oct 13 20:01:40 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 SAA28397
for <neal@xxxxxxxxxxxxx>; Wed, 13 Oct 1999 18:02:00 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id IAA15355
for metastock-outgoing; Thu, 14 Oct 1999 08:31:54 -0600
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 IAA15352
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 14 Oct 1999 08:31:50 -0600
Received: from hme0.mailrouter02.sprint.ca (hme0.mailrouter02.sprint.ca [207.107.250.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id SAA22258
for <metastock@xxxxxxxxxxxxx>; Wed, 13 Oct 1999 18:17:16 -0600 (MDT)
Received: from wlake (spc-isp-ott-uas-21-8.sprint.ca [209.103.37.9])
by hme0.mailrouter02.sprint.ca (8.8.8/8.8.8) with SMTP id UAA01934
for <metastock@xxxxxxxxxxxxx>; Wed, 13 Oct 1999 20:03:05 -0400 (EDT)
Message-ID: <000701bf15d7$a657ff40$092567d1@xxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
Subject: clear data but leave formulas intact
Date: Wed, 13 Oct 1999 20:04:12 -0400
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.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Here's a sub that is an alternative to using templates in Excel from:
http://www.j-walk.com/ss/excel/eee/eee005.txt
Put this on a button or toolbar,
import your tradable from Metastock,
do your analysis stuff using your own formulas,
then press the button to clear the worksheet of data and leave the formulas
intact.
Sub ResetModel()
Range("A1").SpecialCells(xlCellTypeConstants, _
xlNumbers).ClearContents
End Sub
It will save you a lot of "starting from scratch" or templating.
Best regards
Walter
|