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

Re: Weeding Out Non Trading Equities



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>1. </FONT><FONT size=2>Use the Downloader to delete 
securities. </FONT><FONT size=2>See the DL man/p.78 "Delete Securities" 
section.</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; (The Tools - Menu options are mentioned on 
p.56 and displayed on p.5)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>-click Tools</FONT></DIV>
<DIV><FONT size=2>-click Delete|Securities</FONT></DIV>
<DIV><FONT size=2>-select the securities to delete in the "Delete Securities" 
dialog window</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; For multi selecting:</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-per security:</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-hold down the CTRL-key and click the security(ies)</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-per bunch:</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;</FONT><FONT size=2>-click the first security</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-hold down the SHIFT-key and click the last security</FONT></DIV>
<DIV><FONT size=2>-click Delete when finished selecting&nbsp;</FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>2. Use the calander's&nbsp;Functions in a&nbsp;Scan to detect 
the&nbsp;</FONT><FONT size=2>securities that haven't traded for a 
while.</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>In the Explorer Editor add the following exploration 
scan:</FONT></DIV>
<DIV><FONT size=2>&nbsp;</FONT></DIV>
<DIV><FONT size=2>&nbsp;Exploration Name:</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;Non-Trading Stock</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>&nbsp;Exploration Notes:</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; Click on a single security and hit the CTRL 
+ C keys to have the non-traders copied</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; to Clipboard. Run&nbsp;Excel (it will 
automaticaly have Cell A1 selected) and hit CTRL + V keys</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;</FONT><FONT 
size=2>to&nbsp;</FONT><FONT size=2>have the Clipboard contents 
Pasted&nbsp;</FONT><FONT size=2>into the New sheet. Click and 
Drag&nbsp;mousepointer over</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; all of the Column's headers (of columns 
that contain data), this will have these columns Selected(=black).</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; On the WorkMenu&nbsp;choose 
Data|Sort&nbsp;and hit&nbsp;the A-Z (arrow down) "Sort"-button. In the "Sort" 
dialog window</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; select the appropiate options 
for:</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;Sort:&nbsp;Trading&nbsp; 
and click the Radio-button for Ascending sorting</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (eg the ColB 
column in Explorer)</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;Next: 
Folder</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (eg the 
Folder column in Explorer)</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - Next: 
Name&nbsp;&nbsp;&nbsp;and click the Radio-button for List contains 
FieldName-row</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><FONT 
size=2>(eg the Name column in Explorer)</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;Click OK to have the sheet sorted on 
the (last available trading) dates.</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;Delete the rows containing the most 
recent Date, eg Select (by clicking and dragging over the square 
numberical</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;buttons on the left) all rows that 
contain&nbsp;that Date, float the mousepointer over the selected field of cells, 
then</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp; &nbsp;right-click&nbsp;for the Context Menu and 
click Remove to delete selected rows.</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp; &nbsp;Print out the sheet and run&nbsp;the 
Downloader. (as explained in step #1)</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; &nbsp; </FONT></DIV>
<DIV><FONT size=2>Columns and Filter :</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ColA - Name: Last </FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; Month()</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ColB - Name: Trading</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; Day of Month()</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ColC - Name: Date</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; Year()</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Click OK.</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Back in The Explorer"&nbsp;dialog Window (and with the empty 
MetaStock Startup Window visable in the background)</FONT></DIV>
<DIV><FONT size=2>the Non-Trading Stock scan will be selected(=blue), if not 
select it&nbsp;and h</FONT><FONT size=2>it the Explore-button (at the 
bottom-left).</FONT></DIV>
<DIV><FONT size=2>Select and Add the Folders, containing the securities to be 
scanned, to the window on the right</FONT></DIV>
<DIV><FONT size=2>(in the Select Securities-</FONT><FONT size=2>dialog window) 
and hit OK.</FONT></DIV>
<DIV><FONT size=2>Than wait for the scan to finish and click Report to view the 
results. See the above Exploration Notes to continue</FONT></DIV>
<DIV><FONT size=2>from this point onwards.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Note:</FONT></DIV>
<DIV><FONT size=2>Do note that some "Non Trading Securities" might 
have&nbsp;ONLY had their Name changed due to mergers/takeovers</FONT></DIV>
<DIV><FONT size=2>(and for other&nbsp; -who knows what- reasons) </FONT><FONT 
size=2>or plainly had&nbsp;just their Ticker Symbol Code or their&nbsp;Exchange 
listed Name</FONT></DIV>
<DIV><FONT size=2>been&nbsp;changed, and as such do not trade anymore, 
eg&nbsp;not under this "alias" anymore but did </FONT><FONT size=2>proceed under 
another</FONT></DIV>
<DIV><FONT size=2>"alias", eg now in their new Name/Ticker,&nbsp;and</FONT><FONT 
size=2> therefore creating a backup first (to an ASCII-txt file)&nbsp;and also 
doing so</FONT></DIV>
<DIV><FONT size=2>before </FONT><FONT size=2>deleting the original,&nbsp;is very 
much advisable.</FONT></DIV>
<DIV><FONT size=2>The loss of&nbsp;any &lt;still usable&gt; historical data can 
this way than&nbsp;be&nbsp;omitted.</FONT></DIV>
<DIV><BR>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.</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>From one of the Equis' faq's:</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Q. Securities are showing up on my Exploration Results and 
they don't have data for the<BR>&nbsp;&nbsp;&nbsp;&nbsp; required current date. 
Why?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2><BR>A. The Explorer tests the last day of data that is 
specified. If the day specified is not<BR>&nbsp;&nbsp;&nbsp;&nbsp; there then it 
goes to the next day available.<BR>&nbsp;&nbsp;&nbsp;&nbsp; For example if you 
tell the Explorer to test on 08/16/96 and there is only 
data<BR>&nbsp;&nbsp;&nbsp;&nbsp; to 08/08/96 for one security the explorer will 
check the 8th for your criteria.<BR>&nbsp;&nbsp;&nbsp;&nbsp; If the data on the 
8th passes your criteria it will show up on&nbsp;the explorer results on 
08/16/96 and later. </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</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"><STRONG>From: 
  </STRONG>George Ashton</DIV>
  <DIV style="FONT: 10pt arial"><STRONG>To:</STRONG> <A 
  href="mailto:metastock@xxxxxxxxxxxxx"; 
  title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> vrijdag 11 juni 1999 2:44</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Weeding Out Non Trading 
  Equities</DIV>
  <DIV><BR></DIV>Is it possible to do the deletions in explorer, or do the 
  deletions have to be done through MS 
??<BR><BR>George.<BR></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sat Jun 12 22:13:41 1999
Received: from listserv.equis.com (204.246.137.2)
	by mail07.rapidsite.net (RS ver 1.0.4) with SMTP id 06982702;
	Sat, 12 Jun 1999 22:01:10 -0400 (EDT)
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id TAA09624
	for metastock-outgoing; Sat, 12 Jun 1999 19:42:25 -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 TAA09621
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 12 Jun 1999 19:42:22 -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 TAA01166
	for <metastock@xxxxxxxxxxxxx>; Sat, 12 Jun 1999 19:55:35 -0600 (MDT)
Received: from walter ([209.103.33.194])
	by hme0.mailrouter02.sprint.ca (8.8.8/8.8.8) with SMTP id VAA08497
	for <metastock@xxxxxxxxxxxxx>; Sat, 12 Jun 1999 21:43:17 -0400 (EDT)
Message-ID: <000e01beb53e$5fcca700$c22167d1@xxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
Subject: Manual removal of worm
Date: Sat, 12 Jun 1999 21:45:09 -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.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-Loop-Detect: 1
X-UIDL: a8f38cfa4cc0688b7ac8844e463190e8.08

Hi Ton

For your files

Best regards

Walter

===============================

http://www.avertlabs.com/public/datafiles/valerts/vinfo/va10185.asp

Manual Removal of this worm

Win9x-

Run the System Configuration Editor -
Select the Start menu from your desktop and Run SYSEDIT.EXE

2. Select the C:\WINDOWS\WIN.INI window.

3. In the line run =, remove the listing run=C:\WINDOWS\SYSTEM\EXPLORE.EXE

Select File > Save, then Exit.

4. Select the Start menu and Shutdown -

Choose Restart the computer in MS-DOS mode;

Click Yes. (This action purges EXPLORE.EXE from system memory.)

5. Once your PC is in DOS, type EXIT to return to Windows. (This action
reloads Windows without EXPLORE.EXE in memory.)

6. In Windows, remove the file, EXPLORE.EXE, from your system -

Click Start > Find > Files or Folders;

In the Find: All Files dialog box, type EXPLORE.EXE in the (Named) field;

Click Find Now;

Delete EXPLORE.EXE

WinNT-

In Windows NT, this worm runs as an "explore" process in WinNT Task Manager.
You may experience high CPU utilization prior to ending this process.

1. Run the WinNT Registry Editor -

Click Start > Run > Open REGEDIT (not REGEDT32).

2. Locate the hive
[HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\Windows].

3. Highlight the following key "run=C:\\WINNT\\System32\\Explore.exe" and
remove by pressing the Delete button.

4. Restart Windows NT -

Click Start > Shutdown.

Select Restart and click OK. (Your system will now reboot.)

5. Remove the file, EXPLORE.EXE, from your system -

Click Start > Find > Files or Folders;

In the Find: All Files dialog box, type EXPLORE.EXE in the (Named) field;

Click Find Now;

Delete EXPLORE.EXE