|
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.3401" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>12a. Merge</FONT></DIV>
<DIV><FONT size=2> After going through Step
11, use the Downloader's Merge-Tool to have any current
names/tickers</FONT></DIV>
<DIV><FONT size=2> also get new
security names, </FONT><FONT size=2>eg Merge the old files with the new
(from the .Sym file) created</FONT></DIV>
<DIV><FONT size=2> securities(see
DL-Help|Index|Merge).</FONT></DIV>
<DIV><FONT size=2>or</FONT></DIV>
<DIV><FONT size=2>12b. Convert</FONT></DIV>
<DIV><FONT size=2> Export, (eg
Convert to ASCII or Excel) your historical data to separate files
(txt,csv,xls,asc), eg</FONT></DIV>
<DIV><FONT
size=2> files </FONT><FONT
size=2>that can than (or later) </FONT><FONT size=2>always be
Converted back into your new (Downloader Data Files)
security-files.</FONT></DIV>
<DIV><FONT size=2> Multi-select the ASCII
files and click Convert. </FONT> </DIV>
<DIV><FONT size=2>or</FONT></DIV>
<DIV><FONT size=2>12c. ASCII</FONT></DIV>
<DIV><FONT size=2> In ASCII files, you
are allowed to have a Name column, eg use the correct ASCII Millenium proof
header</FONT></DIV>
<DIV><FONT size=2> in a file, before using
the DL's Convert-tool. </FONT><FONT size=2><FONT size=2>The proper header
is: (eg convert a standard MetaStock</FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2>
security-file to Ascii for the proper example</FONT><FONT
size=2>).</FONT></DIV>
<DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT
size=2><TICKER>,<NAME>,<PER>,<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT><BR></FONT></FONT><FONT
size=2>or</FONT></DIV></DIV>
<DIV><FONT size=2>12d. Use Excel's Copy & Paste functions</FONT></DIV>
<DIV><FONT size=2> a. from Downloader,
either back and forth to an opened Spreadsheet or</FONT></DIV>
<DIV><FONT size=2> b. from Downloader,
to an opened Spreadsheet and click Save As (Excel 4.0 sheet), and use
the</FONT></DIV>
<DIV><FONT
size=2> DL's
Convert-tool </FONT><FONT size=2>to "import" the data back into the new
(Downloader Date Files) securities</FONT></DIV>
<DIV><FONT size=2> </FONT></DIV>
<DIV><FONT size=2>13. Automate previous steps by using programs like
ScriptIt or AutoIt, eg especialy for multiple</FONT></DIV>
<DIV><FONT size=2>
tickers/names/securities.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT
size=2>-------------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>The above is a follow up on previous mail.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>See my homepage(below) for info+examples on the programs+their
script/language.</FONT></DIV>
<DIV><FONT size=2>If you can (easy) relate to the Metastock-formula language,
than it is a piece of cake to</FONT></DIV>
<DIV><FONT size=2>automate anything else (thus also anything in Windows'
OS).</FONT></DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>Use these programs too for automating any other (Windows or
Windows-program's) tasks.</FONT> </FONT></DIV></DIV>
<DIV><FONT size=2>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>You'll be truly amazed to find out how "comfortable" this
all is & can be, when working on</FONT></DIV>
<DIV><FONT size=2>repeat-a-tive tasks, eg </FONT><FONT size=2>by just using
ScripIt or AutoIt.</FONT></DIV></FONT><BR>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></DIV>
<DIV> </DIV>
<DIV> </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:Richard_Harms@xxxxxxxxxxx";
title=Richard_Harms@xxxxxxxxxxx>Richard Harms</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>Metastock</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> woensdag 29 september 1999
3:13</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Company Names &
Symbols</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Thanks AJ. That worked fine for creating
new charts. What I'm wondering though, Is there a way that you know of
to add the company names to charts that I've already created or do I have to
go through and recreate all the charts from scratch if I want them to have the
company name attached as well. Thanks</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Richard H</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Too many times we confuse motion with
progress. Cyclops</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Tue Oct 05 17:44:13 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 RAA12091
for <neal@xxxxxxxxxxxxx>; Tue, 5 Oct 1999 17:38:03 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id IAA23716
for metastock-outgoing; Wed, 6 Oct 1999 08:04:56 -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 IAA23713
for <metastock@xxxxxxxxxxxxxxxxxx>; Wed, 6 Oct 1999 08:04:53 -0600
Received: from mailhost1.attcanada.net (mailhost1.attcanada.net [206.191.82.42])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA16183
for <metastock@xxxxxxxxxxxxx>; Tue, 5 Oct 1999 17:49:35 -0600 (MDT)
Received: from marbil ([142.194.243.91]) by mailhost1.attcanada.net
(InterMail v03.02.07.03 118-128) with SMTP
id <19991005233340.NSV6718@xxxxxx> for <metastock@xxxxxxxxxxxxx>;
Tue, 5 Oct 1999 23:33:40 +0000
From: "MB" <marekbilinski@xxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: Copying layouts
Date: Tue, 5 Oct 1999 19:35:41 -0400
Message-ID: <LOBBJOAEKKBAOJDCIBOMMEIBCAAA.marekbilinski@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0004_01BF0F68.CEDC4220"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Importance: Normal
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.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999>List:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=968322523-05101999>I had to re-install
everything on my hard drive recently. What I want to know (if this ever happens
again) is, Is it necessary to re-create all my layouts in order for me to have
access to them or is there a way to use those that I had backed
up?</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=968322523-05101999>I am asking this
because after I re-installed all my software, I copied my data onto my drive
(using the same folder and partition names I used before) and when I tried
opening my Metastock layouts, it gave a me a "can't find file" message(or
something like that). I received that message for every layout I tried opening,
so I gave up and created all new ones.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=968322523-05101999>Is there a
way?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999>Marek</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=968322523-05101999></SPAN></FONT> </DIV></BODY></HTML>
</x-html>From ???@??? Wed Oct 06 18:26: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 QAA01233
for <neal@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 16:56:07 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id HAA25610
for metastock-outgoing; Thu, 7 Oct 1999 07:17: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 HAA25607
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 7 Oct 1999 07:17:51 -0600
Received: from ultra1.pitnet.net (ultra1.pitnet.net [156.46.121.80])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA16831
for <metastock@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 17:02:36 -0600 (MDT)
Received: from frt1000.pitnet.net (live180.pitnet.net [156.46.116.180])
by ultra1.pitnet.net (8.8.8/8.8.8) with SMTP id RAA05843
for <metastock@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 17:48:26 -0500 (CDT)
From: "Bill N." <frt1000@xxxxxxxxxx>
To: "Metastock List" <metastock@xxxxxxxxxxxxx>
Subject: Excel question. Help for the simple minded.
Date: Wed, 6 Oct 1999 17:47:38 -0500
Message-ID: <01bf104c$caa78b80$b4742e9c@xxxxxxxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0043_01BF1022.E1D18380"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.71.1712.3
X-Mimeole: Produced By Microsoft MimeOLE V4.71.1712.3
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.71.1712.3"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>List,</DIV>
<DIV> </DIV>
<DIV>Could anyone with expertise in Excel give me advice?</DIV>
<DIV> </DIV>
<DIV>What formula would I use in the case below? What I want the cells in
Col B below to do is to take the value of Col A. and Copy it to B only if it is
a positive number. Just as in the example. In col A. row 1 the value
is "2". Col. B would show "2". But in row 2 col
A the value is a negative number "-1.3". So I would want row 2
Col B to remain blank.</DIV>
<DIV> </DIV>
<DIV>Also is there any formula that in the end would count the number of entries
in Col B? I'm not sure right now if I'm going to need to know this but it
might be helpful. Some of these columns are going to be close to 2000 rows
long. (Other than sorting the speadsheet by col B and counting it
myself) </DIV>
<DIV> </DIV>
<DIV>Since I'm at this I might as well go for broke. If the above is
possible, would there then be a way to tally column B by number? An
example would be: there are [x] number of rows greater than2 but less than 3,
and [y] number of rows greater than 3 but less than 4 etc. I don't really
expect the values to be more than 10.</DIV>
<DIV> </DIV>
<DIV>Thanks for any help. I'm hoping this project might earn me a buck or
two in the markets when I get it done. What I'm doing is importing
continuous data from MetaStock into Excel for this.</DIV>
<DIV> </DIV>
<DIV>Bill N.</DIV>
<DIV>Milwaukee, WI USA</DIV>
<DIV> </DIV>
<DIV><FONT color=#000000>THE EXAMPLE:</FONT></DIV>
<DIV><FONT color=#000000></FONT> </DIV>
<DIV><FONT
color=#000000>
Col A Col B</FONT></DIV>
<DIV>1
2
2</DIV>
<DIV>2
-1.3</DIV>
<DIV>3
0.4
0.4
</DIV>
<DIV>4
5.2
5.2</DIV>
<DIV>5
-6.1</DIV>
<DIV>6
2
2</DIV>
<DIV>7
-1.6</DIV>
<DIV>8
5
5</DIV>
<DIV>9
3
3</DIV></BODY></HTML>
</x-html>From ???@??? Wed Oct 06 18:26:52 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 RAA01679
for <neal@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 17:25:22 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id HAA25688
for metastock-outgoing; Thu, 7 Oct 1999 07:59:26 -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 HAA25685
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 7 Oct 1999 07:59:23 -0600
Received: from secure.smtp.email.msn.com (cpimssmtpu07.email.msn.com [207.46.181.28])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA16853
for <metastock@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 17:44:10 -0600 (MDT)
Received: from Eagle - 63.23.147.14 by email.msn.com with Microsoft SMTPSVC;
Wed, 6 Oct 1999 16:29:37 -0700
Message-ID: <000f01bf1053$9ec36a00$0e93173f@xxxxxxxxx>
From: "Gitanshu Buch" <OnWingsOfEagles@xxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <01bf104c$caa78b80$b4742e9c@xxxxxxxxxxxxxxxxxx>
Subject: Re: Excel question. Help for the simple minded.
Date: Wed, 6 Oct 1999 19:36:28 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_000A_01BF1032.15571120"
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:
<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.3401" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>=if(A2>0,a2," ") for the copy of col a with positive value
and space blank if 0 or negative value.</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>Also is there any formula that in the end would count the number of
entries in Col B? </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=2>=count(b2:b200) should be placed in the cell where you want
the result.</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Wed Oct 06 18:27:01 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 SAA02304
for <neal@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 18:03:48 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id IAA25903
for metastock-outgoing; Thu, 7 Oct 1999 08:27:55 -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 IAA25900
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 7 Oct 1999 08:27:53 -0600
Received: from smtp.email.msn.com (cpimssmtpu08.email.msn.com [207.46.181.30])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id SAA16876
for <metastock@xxxxxxxxxxxxx>; Wed, 6 Oct 1999 18:12:39 -0600 (MDT)
Received: from pavilion - 63.23.103.175 by email.msn.com with Microsoft SMTPSVC;
Wed, 6 Oct 1999 16:58:06 -0700
Message-ID: <000701bf1070$8cd1bb40$af67173f@xxxxxxxx>
From: "Jim Greening" <JimGinVA@xxxxxxxxxxxxx>
To: "Metastock" <metastock@xxxxxxxxxxxxx>
Subject: Mid Week Pick
Date: Wed, 6 Oct 1999 20:03:32 -0700
Organization: Microsoft Corporation
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:
All,
This is the kind of market I've been waiting for! It's hard to
complain when all your stocks are rising <G>. Actually, looking at my
indicators, today's action didn't really change anything, but the NASD and
NDX are close to all time highs and the DJI is right at the top of its Short
Term Down Trend Channel (STDTC). If we can get some follow through we will
get all kinds of new bullish signals.
AOL has made a good move and is nearing the resistance area of the top
of the Intermediate Term Down Trend Channel (ITDTC). I think it has built
up enough steam to blow right on through, but the next few days will tell
for sure.
The Internet Group has shown excellent strength the last few days and I
think it will continue. One I've been watching for a good entry point is
CMGI Inc (CMGI). It may not be a household name, but CMGI is one of the
chief architects of the Internet. What began as a direct marketing firm has
become a prolific investor in the future of the Internet. It's venture
capital arm, @Ventures, is a savvy trend-spotter boasting a portfolio with
stakes in more than 40 Internet companies (Lycos, Raging Bull). It also
owns 83% of search engine AltaVista, which it plans to grow into its
centerpiece Web property. CMGI's Internet Group includes a string of
majority-owned companies (Engage Technologies, Planet Direct) offering
services such as Web hosting. About 80% of CMGI's revenue comes from
fulfillment and mailing list services.
CMGI at 105 3/4 broke out of its ITDTC today. It hit an all time high
of 165 on 4/13/99 then fell to a low of 66 ¼ on 8/5/99. Since then it has
formed a Short Term Up Trend Channel (STUTC) and is now at the top of that
channel. The Tema binary is positive and rising. The Tema Qstick is still
negative but rising fast. That usually means we are close to a good entry
point. The conservative approach would be to wait until CMGI falls back
towards the bottom of the STUTC before entering, but that risks not catching
it if it takes off. Since I believe it may well take off, I'm going to
enter here. I'll open a position tomorrow with a target at the all time
high of 165 and a stop just under the STUTC at 85 ¾.
See chart at http://www.geocities.com/jimginva/
JimG
|