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

Re: converting ascii file


  • To: <metastock@xxxxxxxxxxxxx>
  • Subject: Re: converting ascii file
  • From: "A.J. Maas" <anthmaas@xxxxxx>
  • Date: Wed, 14 Jul 1999 18:06:57 -0700
  • In-reply-to: <004601becd9f$0fa63ec0$5ecba2d0@xxxxxx>

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>
<DIV><FONT color=#800000 size=2><STRONG>First</STRONG></FONT></DIV>
<DIV><FONT size=2>The file is incomplete, eg the columns do not match up. 
</FONT><FONT size=2>In the file's contents:</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-the daily dates in the "date column" are plain missing</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-the "D" for Periodicity-column is entirely missing (and in the header as 
well)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Otherwise, the columns contents seem ok. Now by using the best 
proper header </FONT><FONT size=2>for an Asci file is your ticket 
out.</FONT></DIV>
<DIV><FONT size=2>Either have Convert to convert a MetaStock file </FONT><FONT 
size=2>to an ASCII for File Type(TXT)-file or (as I have made it a bit 
easier</FONT></DIV>
<DIV><FONT size=2>for you, eg and </FONT><FONT size=2>as&nbsp;this is also 
from&nbsp;earlier mails) this is what the proper (for use in Downloader) 
</FONT><FONT size=2>ASCII-file's header</FONT></DIV>
<DIV><FONT size=2>must&nbsp;look like:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT 
size=2>&lt;TICKER&gt;,&lt;PER&gt;,&lt;DTYYMMDD&gt;,&lt;OPEN&gt;,&lt;HIGH&gt;,&lt;LOW&gt;,&lt;CLOSE&gt;,&lt;VOL&gt;,&lt;OPENINT&gt;<BR></FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note1: 
without a separating comma at the line's end.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note2: 
to&nbsp;use CAPITOL letters only (this stems from the ol' 
DOS-days)<BR></FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note3: to 
always delete the last blank empty line(s) that are sometimes left behind in 
an&nbsp;</FONT><FONT size=2>ASCII text-file</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;(eg when Opening the ASCII-TXT-file using 
NotePad/WordPad/Word/Excel).</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note4: that 
the above header is totaly different from the &lt;not ever working&gt; example 
that is&nbsp;</FONT><FONT size=2>provided&nbsp;in</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
the DL-manual (p.70). (See also further below). Otherwise, most instructions on 
that page and&nbsp;</FONT><FONT size=2>the following</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;2x pages&nbsp;are most of the time correct.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#800000 size=2><STRONG>Example:</STRONG></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT 
size=2>&lt;TICKER&gt;,&lt;PER&gt;,&lt;DTYYMMDD&gt;,&lt;OPEN&gt;,&lt;HIGH&gt;,&lt;LOW&gt;,&lt;CLOSE&gt;,&lt;VOL&gt;,&lt;OPENINT&gt;<BR>MYTICKER,D,19990714,1500,2000,1400,1650,555656,0</FONT></DIV>
<DIV><FONT size=2>MYTICKER,D,990714,1500,2000,1400,1650,555656,0</FONT></DIV>
<DIV><FONT 
size=2>MYTICKER,D,1999/07/14,1500.00,2000.00,1400.00,1650.00,555656,0</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Use NotePad (minor) or Excel (large) or even Word 
(minor+large), to make&nbsp;the desired changes </FONT><FONT size=2>to a 
ASCII-TXT file.</FONT></DIV>
<DIV><FONT size=2>On Saving (Excel/Word) the file in one of these programs try 
to choose the </FONT><FONT size=2>"Text (TAB-delimited) (*.txt)"-</FONT><FONT 
size=2>option for File Type.</FONT></DIV>
<DIV><FONT size=2>Then, in Word(WordPad) Open the file to "Edit|Replace" the not 
visable TABs&nbsp;by blanks </FONT><FONT size=2>(eg leave the tiny window 
for</FONT></DIV>
<DIV><FONT size=2>the "replacement"&nbsp;plain empty).</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#800000 size=2><STRONG>Another example:</STRONG></FONT></DIV>
<DIV><FONT size=2>This ASCII-TXT&nbsp;file (eg its contents) can be directly 
Pasted into an already Open-ed&nbsp;Downloader's Datafile sheet</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>07/06/1999&nbsp;&nbsp;&nbsp; 35.50&nbsp;&nbsp;&nbsp; 
36.45&nbsp;&nbsp;&nbsp; 35.40&nbsp;&nbsp;&nbsp; 36.00&nbsp;&nbsp;&nbsp; 
8036736&nbsp;&nbsp;&nbsp; 1</FONT></DIV>
<DIV><FONT size=2>07/07/1999&nbsp;&nbsp;&nbsp; 36.65&nbsp;&nbsp;&nbsp; 
37.40&nbsp;&nbsp;&nbsp; 34.20&nbsp;&nbsp;&nbsp; 35.00&nbsp;&nbsp;&nbsp; 
6540326&nbsp;&nbsp;&nbsp; 1<BR>07/08/1999&nbsp;&nbsp;&nbsp; 
35.40&nbsp;&nbsp;&nbsp; 35.75&nbsp;&nbsp;&nbsp; 32.55&nbsp;&nbsp;&nbsp; 
33.10&nbsp;&nbsp;&nbsp; 5821690&nbsp;&nbsp;&nbsp; 
1<BR>07/09/1999&nbsp;&nbsp;&nbsp; 33.70&nbsp;&nbsp;&nbsp; 
34.40&nbsp;&nbsp;&nbsp; 33.20&nbsp;&nbsp;&nbsp; 33.55&nbsp;&nbsp;&nbsp; 
5271435&nbsp;&nbsp;&nbsp; 1<BR>07/12/1999&nbsp;&nbsp;&nbsp; 
33.80&nbsp;&nbsp;&nbsp; 33.85&nbsp;&nbsp;&nbsp; 32.95&nbsp;&nbsp;&nbsp; 
33.30&nbsp;&nbsp;&nbsp; 2921341&nbsp;&nbsp;&nbsp; 
1<BR>07/13/1999&nbsp;&nbsp;&nbsp; 33.20&nbsp;&nbsp;&nbsp; 
34.80&nbsp;&nbsp;&nbsp; 33.00&nbsp;&nbsp;&nbsp; 34.70&nbsp;&nbsp;&nbsp; 
4662857&nbsp;&nbsp;&nbsp; 1<BR>07/14/1999&nbsp;&nbsp;&nbsp; 
35.25&nbsp;&nbsp;&nbsp; 36.90&nbsp;&nbsp;&nbsp; 34.75&nbsp;&nbsp;&nbsp; 
36.25&nbsp;&nbsp;&nbsp; 5673425&nbsp;&nbsp;&nbsp;&nbsp;1</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note5: the 
columns here (have to be) are also TAB-delimited&nbsp;</FONT><FONT 
size=2>(eg&nbsp;for&nbsp;this, the&nbsp;"html mail"-editor does not 
seem&nbsp;</FONT><FONT size=2>to be</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><FONT 
size=2>able to pick&nbsp;up the TAB's, but they were there when I Pasted them in 
this mail).</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#800000 size=2><STRONG>Second</STRONG></FONT></DIV>
<DIV><FONT size=2>Read on up on the Convert-Tool and its sometimes parculiar 
Options,&nbsp;this as you will also have </FONT><FONT size=2>to get 
aquinted.</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Eg., with the 
program's handles for the:</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Convert 
dialog window (p.65-67)</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;-Options|Source TAB&nbsp;(p.67-68)</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Options|Destination 
TAB&nbsp;(p.68-69)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#800000 size=2><STRONG>Third</STRONG></FONT></DIV>
<DIV><FONT size=2>See the new DL page 70-72 &lt;now revisioned&nbsp; -but with 
the still incorrect ASCII headers- version&gt;&nbsp;below.&nbsp;</FONT></DIV>
<DIV><FONT size=2>This&nbsp;was taken from the build-in DL Help-file (DL6.52a) 
and note that the headers here given are for&nbsp;Excel-files only.</FONT></DIV>
<DIV><FONT size=2>The parts that are&nbsp;correct&nbsp;only, are the ASCII's  
"&lt;" and "&gt;"&nbsp; characters, eg the ones hugging the Excel headers.  
</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Also quickly noticed that there were a few new features 
added:</FONT></DIV>
<DIV><FONT size=2>- new </FONT><FONT size=2>- </FONT><FONT size=2>new is the 
&lt;name&gt; for the "name field"&nbsp;that </FONT><FONT size=2>was added for 
header's+column's option</FONT></DIV>
<DIV><FONT size=2>- new - if all the data in </FONT><FONT size=2>the ASCII 
</FONT><FONT size=2>file is for one security only, then only one column could be 
used (also in the&nbsp;header),</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;eg this 
is&nbsp;</FONT><FONT size=2>done so by omitting&nbsp;</FONT><FONT 
size=2>any&nbsp;of the </FONT><FONT size=2>other available columns 
(fields).</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Regards,<BR>Ton Maas<BR><A 
href="mailto:ms-irb@xxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxx</A><BR>Dismiss the 
".nospam" bit (including the dot) when replying.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>===========================================</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2><STRONG>ASCII Source File Layout</STRONG></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>In order for an ASCII source file to convert properly, the 
file must be arranged correctly.&nbsp; This section explains the proper 
alignment.<BR>The data in the ASCII file should be arranged as shown 
below.</FONT></DIV>
<DIV><FONT size=2><BR>&lt;ticker&gt;, &lt;per&gt;, &lt;date&gt;, &lt;time&gt;, 
&lt;open&gt;, &lt;high&gt;, &lt;low&gt;, &lt;close&gt;, &lt;vol&gt;, 
&lt;o/i&gt;</FONT></DIV>
<DIV><FONT size=2><BR>&lt;<STRONG>ticker</STRONG>&gt;&nbsp; The ticker symbol of 
the security.&nbsp; The ticker symbol is used to determine which MetaStock data 
file to post the data to.</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; The ticker symbol (if you choose to specify it in the ASCII file) must be 
included on every line of data.</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-If the ticker symbol in the ASCII file does not match a ticker symbol in the 
MetaStock data files, you will be asked</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;if you&nbsp;</FONT><FONT size=2>want to create a new MetaStock data 
file.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 -If the ticker symbol in the ASCII file includes a space, a comma-delimited 
header line must be created at the top</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;of the&nbsp;</FONT><FONT size=2>ASCII file (see <U><FONT 
color=#008000>ASCII Source File Layout </FONT></U>on how to create a header 
line).&nbsp; The header line allows the file to</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;be processed&nbsp;</FONT><FONT size=2>using only commas as delimiter 
characters.</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-The ticker field can be omitted, but only if the &lt;per&gt; field is also 
omitted.&nbsp; If the ticker symbol is omitted, you are</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
prompted to supply the ticker symbol (see <U><FONT color=#008000>Ticker Symbol 
Dialog</FONT></U>).</FONT><FONT 
size=2><BR>&lt;<STRONG>per</STRONG>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The 
periodicity of the data (e.g., Intraday, Daily, Weekly, Monthly, or 
Yearly).<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-If this field is omitted, the periodicity selected in the Conversion Options 
dialog is used (see</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;<U><FONT color=#008000>Conversion Options 
Dialog</FONT></U>).<BR>&lt;<STRONG>date</STRONG>&gt;&nbsp;&nbsp;&nbsp; The date 
of the data contained on the line of the ASCII file. Each line of the ASCII file 
must have a date.</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; The date can be in either the yymmdd or mm/dd/yy formats 
(e.g., 891222 or 12/22/89).</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; The dates must be in ascending order (i.e., most recent date 
is listed on the last line).</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-If the dates in the ASCII file precede the dates in the existing MetaStock file 
(i.e., the file you are appending to),</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;the data will be 
ignored.<BR>&lt;<STRONG>time</STRONG>&gt;&nbsp;&nbsp;&nbsp; The time of the data 
contained on the line of the ASCII file.</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This 
field should only be used if the ASCII file contains intraday</FONT><FONT 
size=2> price data (i.e., the periodicity is intraday).</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; The time should be entered using a 24 hour clock (e.g., 3:30 PM = 
15:30).<BR>&lt;<STRONG>open</STRONG>&gt;&nbsp;&nbsp; The opening price of the 
security.&nbsp; The open field can be omitted if the open interest (&lt;o/i&gt;) 
field is also omitted.</FONT></DIV>
<DIV><FONT size=2>&lt;<STRONG>high</STRONG>&gt;&nbsp;&nbsp;&nbsp; The high price 
for this date.<BR>&lt;<STRONG>low</STRONG>&gt;&nbsp;&nbsp;&nbsp;&nbsp; The low 
price for this date.<BR>&lt;<STRONG>close</STRONG>&gt;&nbsp;&nbsp; The closing 
(last) price for this 
date.<BR>&lt;<STRONG>vol</STRONG>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The 
volume for this 
date.<BR>&lt;<STRONG>o/i</STRONG>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The 
open interest for this date.&nbsp; The open interest field can be omitted if the 
open (&lt;open&gt;) field is also omitted.</FONT></DIV>
<DIV><FONT size=2><BR><STRONG></STRONG></FONT>&nbsp;</DIV>
<DIV><FONT size=2><STRONG>EXAMPLE INPUT:</STRONG></FONT><FONT 
size=2><STRONG><BR></STRONG>IBM,D,7/29/86,121,122.375,120.500,121.75,624589,0</FONT></DIV>
<DIV><FONT size=2>IBM,D,7/30/86,123.375,123.125,122.5,122.75,431234,0 
<BR>MOB,D,7/29/86,28.25,29.5,27.125,28,12627,0 
<BR>MOB,D,7/30/86,30,30.625,29.875,30.375,7588,0 </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Because the &lt;open&gt; and &lt;o/i&gt; fields are optional, 
this data also could be arranged as shown below.</FONT></DIV>
<DIV><FONT 
size=2><BR>IBM,D,7/29/86,122.375,120.500,121.75,624589<BR>IBM,D,7/30/86,123.125,122.5,122.75,431234 
<BR>MOB,D,7/29/86,29.5,27.125,28,12627<BR>MOB,D,7/30/86,30.625,29.875,30.375,7588</FONT></DIV>
<DIV><FONT size=2><BR>If all the data in the ASCII file is for one security 
only, then the &lt;ticker&gt; and &lt;per&gt; fields can be 
omitted.</FONT></DIV>
<DIV><FONT size=2>The data can be arranged as shown below.&nbsp; You will be 
prompted for the ticker symbol.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT 
size=2>7/27/96,41.375,40.5,40.75,524589&nbsp;<BR>7/38/96,42.5,40.5,41.75,345679<BR>7/29/96,42.375,41.125,41.75,678967<BR>7/30/96,43.625,42.500,43.125,564479</FONT></DIV>
<DIV><FONT size=2><BR>If all the data in the ASCII file is for one security 
only, then the &lt;ticker&gt; ,&lt;per&gt;,&lt;high&gt;,&lt;low&gt;, and 
&lt;vol&gt;&nbsp; fields</FONT></DIV>
<DIV><FONT size=2>can be omitted. The data can be arranged as shown below.&nbsp; 
You will be prompted for the ticker symbol.</FONT></DIV>
<DIV><FONT size=2>&nbsp; 
<BR>7/27/96,40.75&nbsp;<BR>7/38/96,41.75<BR>7/29/96,41.75<BR>7/30/96,43.125</FONT></DIV>
<DIV><FONT size=2><BR>In the resulting MetaStock files, the other price fields 
will be automatically filled with the close values.</FONT></DIV>
<DIV><FONT size=2>The volume fields will be filled with zeros.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>A header line can be placed at the top of the ASCII file to 
specify the arrangement of the data. </FONT><FONT size=2>This allows you 
to</FONT></DIV>
<DIV><FONT size=2>arrange the data in any order you wish.</FONT></DIV>
<DIV><FONT size=2>The line below shows volume appearing before the price 
fields.</FONT></DIV>
<DIV><FONT 
size=2><BR>&lt;date&gt;,&lt;vol&gt;,&lt;high&gt;,&lt;low&gt;,&lt;close&gt;<BR>7/29/86,624589,122.375,120.500,121.75&nbsp;<BR>7/30/86,431234,123.125,122.5,122.75 
<BR>7/29/86,12627,29.5,27.125,28<BR>7/30/86,7588,30.625,29.875,30.375</FONT></DIV>
<DIV><FONT size=2><BR>An ASCII source file can also contain a &lt;name&gt; 
field.&nbsp; This is helpful if your destination file is in the </FONT><FONT 
size=2>MetaStock format</FONT></DIV>
<DIV><FONT size=2>and you want the name of MetaStock file to be different than 
the ticker symbol.</FONT></DIV>
<DIV><FONT size=2>If you choose to include a &lt;name&gt; field in your ASCII 
file, you must define a header line, otherwise </FONT><FONT size=2>the 
conversion will fail.</FONT></DIV>
<DIV><FONT size=2>The following header line is an example.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>&lt;ticker&gt;, &lt;name&gt;, &lt;per&gt;, &lt;date&gt;, 
&lt;close&gt;, &lt;vol&gt;</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT 
size=2>========================================================</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT>
<DIV><FONT size=2>From: Raidak &lt;<A 
href="mailto:raidak@xxxxxxxxx";>raidak@xxxxxxxxx</A>&gt;</FONT></DIV>
<DIV><FONT size=2>To: Metastock List &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</FONT></DIV>
<DIV><FONT size=2>Sent: woensdag 14 juli 1999 4:15</FONT></DIV>
<DIV><FONT size=2>Subject: converting ascii file</FONT></DIV></DIV>
<DIV><BR></DIV><FONT size=2>&gt; i have an eod ASCII file which contains the 
following fields for 250 stocks:<BR>&gt; symbol, date, high, low close, 
vol.<BR>&gt; AA,00,00,00,00<BR>&gt; BB,00,00,00,00<BR>&gt; <BR>&gt; I have tried 
with the downloader but i couldn't get good results.<BR>&gt; <BR>&gt; 
Thanks<BR>&gt; <BR>&gt; raidak<BR>&gt; <BR>&gt; <BR>&gt; </FONT></BODY></HTML>
</x-html>From ???@??? Wed Jul 14 16:52:18 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 QAA07820
	for <neal@xxxxxxxxxxxxx>; Wed, 14 Jul 1999 16:51:53 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id GAA06366
	for metastock-outgoing; Thu, 15 Jul 1999 06:58:59 -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 GAA06363
	for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 15 Jul 1999 06:58:56 -0600
Received: from dewey.mindlink.net (dewey.mindlink.net [204.174.16.4])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id QAA04052
	for <metastock@xxxxxxxxxxxxx>; Wed, 14 Jul 1999 16:45:30 -0600 (MDT)
Received: from cr247296-a.surrey1.bc.wave.home.com ([24.113.141.35] helo=CR247296-A)
	by dewey.mindlink.net with esmtp (Exim 2.11 #11)
	id 114XZx-0001QQ-00; Wed, 14 Jul 1999 15:32:41 -0700
Message-Id: <4.2.0.58.19990714152250.00a6dd50@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
X-Sender: ullrich_fischer@xxxxxxxxxxxxxxxx
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 
Date: Wed, 14 Jul 1999 15:32:01 -0700
To: metastock@xxxxxxxxxxxxx,
        "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
From: Ullrich Fischer <uf@xxxxxxxxxxxxxxxxxxx>
Subject: Re: intruders
In-Reply-To: <005b01becd5e$a66f8960$eda294d1@xxxxxx>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

63.68.55.25  is the ip address that comes up after a pretty standard 
tracert for www.bonzi.com.    The site doesn't look hacked.  I paid for and 
downloaded iasetupfull.exe from that site and have had a few emails from 
bonzi's tech support department.  So far, when I try to telnet into my PC 
from another PC on another ISP, I get an error message complaining that 
DNS.DCX hasn't been registered properly for every attempt to telnet in or 
scan the ports on my ip address using IPTOOLS.  The intruder alert logging 
isn't happening.   Bonzi tech support are working on my problem.  Has 
anyone else run into this?  Does anyone have any suspicion as to whether or 
not the above IP address belongs to the real bonzi?  -uf

At 02:36 PM 7/13/99 -0400, Walter Lake wrote:
>Hi Ken
>
>It sure makes me wonder ... I thought that hacking was only for the "big
>guys sites". I guess that the hackers need a computer that it on that they
>can use as a front or relay site. Who knows about all of this arcane
>business. It sounds like your .cz site was a relay or front? See the bogus
>sites (?) in the trace.
>
>My copy of Intruder Alert '99 was downloaded from the original Bonzi site
>several months prior to the site being hacked. My copy of the program checks
>out as clean for virus and trojans etc.
>
>If anyone doesn't trust the hacked site or can't get through to Bonzi (none
>of the addresses work for me) ... email me and I'll send you a copy of the
>original (2.11 MB) zipped program.
>
>I already sent a copy to Jose Pascual at <jpascual@xxxxxxxxxxx>. He may send
>a copy to you.
>
>If you want a copy please be prepared to forward your copy to others, 2.11
>MB ties up my line for a while.
>
>Best regards
>
>Walter
>
>================================
>
>10 144.232.5.162   157ms  138ms  150ms  TTL:  0  (icm-bb10-pen-0-0.icp.net
>ok)
>11 198.67.133.62   181ms  166ms  144ms  TTL:  0  (icm-bb4-pen-0-0-0.icp.net
>ok)
>12 192.157.69.75   249ms  158ms  155ms  TTL:  0  (Pennsauken1.NJ.US.EU.net
>probable bogus rDNS: host not found [non-authoritative])
>13 134.222.228.145 170ms  209ms  153ms  TTL:  0  (Nyk-nr01.NY.US.EU.net ok)
>14 134.222.228.42  180ms  155ms  150ms  TTL:  0  (Nyk-cr02.NY.US.EU.net
>probable bogus rDNS: host not found [non-authoritative])
>15 134.222.228.69  255ms  235ms  235ms  TTL:  0  (Asd-nr17.NL.EU.net ok)
>16 134.222.58.2    247ms  224ms  244ms  TTL:  0  (Asd-nr18.NL.EU.net ok)
>17 134.222.228.194 231ms  258ms  239ms  TTL:  0  (Ledn-cr01.NL.EU.net ok)
>18 134.222.228.198 263ms  254ms  248ms  TTL:  0  (Ffm-nr03.eunet.com ok)
>19 134.222.22.6    257ms  257ms  258ms  TTL:  0  (Prague1.CZ.EU.net ok)
>20 134.222.22.18   271ms  267ms  256ms  TTL:  0  (Czechia.CZ.EU.net ok)
>21 193.86.72.6     282ms  285ms  268ms  TTL:  0  (ci1a-mo.eunet.cz ok)
>22 193.86.81.137   263ms  272ms  334ms  TTL:  0  (No rDNS)
>23 193.86.81.133   283ms  275ms  279ms  TTL:104  (krakonos.chemopetrol.cz
>ok)
>
>=================================
>
>person:      Petr Polak
>address:     Chemopetrol
>address:     Computer Centre
>address:     Litvinov
>address:     436 70
>address:     The Czech Republic
>phone:       +420 35 6162023
>fax-no:      +420 35 6164784
>e-mail:      polak@xxxxxxxxxxxxxx
>nic-hdl:     PP15-RIPE
>changed:     ors@xxxxxxxxxxxxxx 19970224
>source:      RIPE
>
>person:      Pavel Kunc
>address:     Chemopetrol
>address:     Computer Centre
>address:     Litvinov
>address:     436 70
>address:     The Czech Republic
>phone:       +420 35 6162287
>fax-no:      +420 35 6164784
>e-mail:      kunc@xxxxxxxxxxxxxx
>nic-hdl:     PK36-RIPE
>
>
>----- Original Message -----
>From: <wander@xxxxxxxx>
>To: Walter Lake <wlake@xxxxxxxxx>
>Sent: Tuesday, July 13, 1999 12:09 PM
>Subject: Re: track down intruders
>
>
> > Walter,
> >
> > FWIW,
> > Yesterday I decided to install Intruder Alert after reading your post.
>This
> > morning I had an "attack".  Win98's built in Tracert traced the intruders
>IP
> > address to krakonos.chemopetrol.cz [193.86.81.133].  The only web site I
>could
> > figure out is http://www.chemopetrol.cz/en_index.htm    At the moment,
>that's as
> > far as I've taken it.  I didn't have Samspade installed because frankly I
>didn't
> > think I had a problem.  Interesting.  I wonder if other MS list
>subscribers are
> > being checked out, or if this is just a coincidence.
> >
> > Krakonos - a legendary lord and guardian of
> >      Krkonose.
> >
> > I attached part of the trace.  I guess I'm glad you posted to the list.<g>
> >
> > Regards,
> > Ken
> >
> > Walter Lake wrote:
> >
> > > Hi Guy, Chip and all the others who helped
> > >
> > > My copy of Intruder Alert 99 is already installed and running, thanks to
>a
> > > nice person who sent me a copy.
> > >
> > > 20 to 30 minutes after installation the firewall shut the door on
>somebody.
> > > So who knows how many times I've been "examined".
> > >
> >
>