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

Formula for Unfilled Gaps?



PureBytes Links

Trading Reference Links

<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.72.3612.1706"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000>Has anyone come across formula code which could be used 
to flag unfilled Gaps in a displayed chart? The MetaStock language has the 
&quot;Gap Down&quot; and &quot;Gap Up&quot; built-in formulas which could be 
used to identify all gaps, but I would like to look back in time from the right 
edge of the chart and flag only the <FONT 
color=#0000ff><STRONG>unfilled</STRONG></FONT> gaps. I could visualize adding 
the code to any custom Expert Advisor to display a symbol only for the unfilled 
gaps for however many records are loaded in the chart.</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>Thinking a bit further, I could see such a formula 
being used with the &quot;Gap Down&quot; and &quot;Gap Up&quot; built-in 
formulas to calculate the percentage of gaps which end up getting filled for a 
particular security. Of course, at least several years of data should be used in 
generating the latter statistic.</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>Charles</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Mon Jan 17 09:34:32 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 UAA08926
	for <neal@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 20:27:50 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id SAA03462
	for metastock-outgoing; Sat, 15 Jan 2000 18:43:24 -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 SAA03459
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 15 Jan 2000 18:43:20 -0700
Received: from smtp.email.msn.com (cpimssmtpu10.smtp.email.msn.com [207.46.181.60])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id SAA02538
	for <metastock@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 18:54:12 -0700 (MST)
Received: from my-computer - 63.21.20.245 by email.msn.com with Microsoft SMTPSVC;
	 Sat, 15 Jan 2000 17:38:32 -0800
Message-ID: <00d901bf5fc2$65bf6740$f514153f@xxxxxxxxxxx>
From: "Charles Kalb" <chaskalb@xxxxxxxxxxxxx>
To: "MetaStock List" <metastock@xxxxxxxxxxxxx>
Subject: Reuters DataLink and Symbol Changes
Date: Sat, 15 Jan 2000 19:38:24 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00D6_01BF5F90.1698B860"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
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.72.3612.1706"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=3>
<DIV><FONT color=#000000><FONT size=3>I'm hoping that someone has some direct 
experience with this service specifically for classes of securities that might 
go through a sequence of symbol changes, e.g.&nbsp; from the original symbol to 
a new symbol, then eventually back to that same original symbol. This is not as 
far-fetched as it initially sounds. One example <FONT color=#000000>is when the 
SEC appends a &quot;D&quot; for 30 days after a stock split for Bulletin Board 
stocks.</FONT></FONT></FONT></DIV>
<DIV><FONT color=#000000><FONT size=3></FONT></FONT><FONT 
size=3></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000><STRONG>BACKGROUND:&nbsp; </STRONG></FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>I have a question on how The DownLoader (I am using 
v6.52) works with Reuters DataLink when securities have a symbol change. I will 
pose a hypothetical Over-The-Counter Bulletin Board (OTC BB) stock with symbol 
&quot;ABCD&quot; but the question applies to other classes of securities as 
well. </FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>The SEC is currently going through a process of 
requiring OTC BB companies to file financial information. During one stage of 
that process if the filed forms are not completely acceptable to the SEC an 
&quot;E&quot; is appended to the company's stock symbol and the company has a 
certain period of time to supply amended information. If the SEC approves the 
amended filings the &quot;E&quot; is removed and the company then is considered 
a &quot;reporting&quot; company. Companies that do not pass this process or 
which do not file any information are delisted to the Pink Sheets.</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>A user determines that a symbol has changed by 
inspecting the Reuters DataLink Collection Report/Additional Information/Details 
to list the Security Report.&nbsp; DataLink does not automatically change the 
symbols, so the user must change them manually in order to continue getting data 
for that security. The problem with the OTC BB stocks is that, if one is 
attempting to follow a large number of them, too much time is required to 
manually keep adding and deleting E's. In the following hypothetical example it 
is assumed that the user <FONT color=#0000ff><STRONG>DOES NOT MAKE 
</STRONG></FONT>the manually required symbol changes to his data 
files.</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>Hypothetical Example:</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT 
color=#000000><STRONG>DATE</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<STRONG>STOCK SYMBOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATALINK 
RESULT</STRONG></FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>Prior<BR>to 
11/01/99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
ABCD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
DataLink recognizes ABCD and supplies EOD 
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
data for it</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>11/01/99 
through&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
ABCD<FONT 
color=#ff0000><STRONG>E</STRONG></FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
DataLink gives error message that ABCD has 
<BR>11/28/99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
changed to ABCDE and no data are 
downloaded&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000>11/29/99 
and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
ABCD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
???????????<FONT color=#ff0000><STRONG>What Happens 
Here</STRONG></FONT>?????????????<BR>subsequent days</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV><FONT color=#000000><STRONG>QUESTION:&nbsp; </STRONG>If I do not make the 
manual changes to symbols of my OTC BB data files but continue to attempt to 
collect daily EOD data for <STRONG>all</STRONG> the stocks in my OTC BB 
directory/folder (some with E's, most without), will DataLink 
<STRONG>eventually</STRONG> fill in all the missing data for the periods where 
stocks had the &quot;E&quot; appended, once the &quot;E&quot; is dropped?&nbsp; 
</FONT></DIV>
<DIV><FONT color=#000000></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#000000>Charles Kalb<BR><A 
href="mailto:chaskalb@xxxxxxx";>chaskalb@xxxxxxx</A></FONT></DIV></FONT></DIV></BODY></HTML>
</x-html>From ???@??? Mon Jan 17 09:33:48 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 TAA06426
	for <neal@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 19:23:40 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id SAA03539
	for metastock-outgoing; Sat, 15 Jan 2000 18:46:13 -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 SAA03530
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 15 Jan 2000 18:46:10 -0700
From: lissen@xxxxxxx
Received: from pocahontas.pdq.net (mail.pdq.net [204.145.251.78])
	by freeze.metastock.com (8.8.5/8.8.5) with SMTP id SAA02543
	for <metastock@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 18:57:02 -0700 (MST)
X-AirNote: 1
Received: from 56K-288.MaxTNT2.pdq.net [209.144.230.34-2] by pocahontas.pdq.net ID 46_-1;
	Sat, 15 Jan 2000 19:41:31 -0600
Message-ID: <002c01bf5fc2$b911aa20$1464fea9@xxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <00b601bf5f9a$11b2dc40$38e8adce@xxxxxxx>
Subject: Re: S&P lists
Date: Sat, 15 Jan 2000 19:38:33 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0025_01BF5F90.1B820B60"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
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.2919.6307" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#d8d0c8>
<DIV><FONT size=2>Joe:</FONT></DIV>
<DIV><FONT size=2>Thanks much.&nbsp;&nbsp;I had reached this site, but it wasn't 
obvious how to get past the S&amp;P 500 page.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Lionel</FONT></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:jehardt@xxxxxxxxxxxxxx"; title=jehardt@xxxxxxxxxxxxxx>Joseph 
  Ehardt</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A 
  href="mailto:metastock@xxxxxxxxxxxxx"; 
  title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, January 15, 2000 2:49 
  PM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: S&amp;P lists</DIV>
  <DIV><BR></DIV>
  <DIV><FONT size=2>Lionel,</FONT></DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT size=2>S&amp;P 500 is at <A 
  href="http://www.spglobal.com/ssindexmain500text.html";>http://www.spglobal.com/ssindexmain500text.html</A></FONT></DIV>
  <DIV><FONT size=2>S&amp;P 400 is at <A 
  href="http://www.spglobal.com/ssindexmain400text.html";>http://www.spglobal.com/ssindexmain400text.html</A></FONT></DIV>
  <DIV><FONT size=2>S&amp;P 600 is at <A 
  href="http://www.spglobal.com/ssindexmain600text.html";>http://www.spglobal.com/ssindexmain600text.html</A></FONT></DIV>
  <DIV>&nbsp;</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>lissen@xxxxxxx &lt;<A 
    href="mailto:lissen@xxxxxxx";>lissen@xxxxxxx</A>&gt;<BR><B>To: </B><A 
    href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> &lt;<A 
    href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;<BR><B>Date: 
    </B>Saturday, January 15, 2000 12:30 PM<BR><B>Subject: </B>S&amp;P 
    lists<BR><BR></DIV></FONT>I was able to download the S&amp;P 500 list at the 
    S&amp;P web site.&nbsp; I was not<BR>able to access the list for the S&amp;P 
    mid cap and small cap stocks.<BR><BR>Where can I access these 
    lists?<BR><BR><BR>Lionel Issen<BR><A 
    href="mailto:lissen@xxxxxxxxx";>lissen@xxxxxxxxx</A><BR><BR><BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Mon Jan 17 09:33:44 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 TAA06317
	for <neal@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 19:20:15 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id SAA03825
	for metastock-outgoing; Sat, 15 Jan 2000 18:55:00 -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 SAA03822
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 15 Jan 2000 18:54:57 -0700
Received: from mail.rdc2.occa.home.com (imail@xxxxxxxxxxxxxxxxxxxxxx [24.2.8.66])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id TAA02564
	for <metastock@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 19:05:49 -0700 (MST)
Received: from home.com ([24.15.117.246]) by mail.rdc2.occa.home.com
          (InterMail v4.01.01.00 201-229-111) with ESMTP
          id <20000116015040.GAWR8398.mail.rdc2.occa.home.com@xxxxxxxx>
          for <metastock@xxxxxxxxxxxxx>; Sat, 15 Jan 2000 17:50:40 -0800
Message-ID: <3881240E.8FBFD98C@xxxxxxxx>
Date: Sat, 15 Jan 2000 17:51:11 -0800
From: Larry <lpetersen1@xxxxxxxx>
Organization: @homenetwork
X-Mailer: Mozilla 4.7 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Metastock Group <metastock@xxxxxxxxxxxxx>
Subject: Bill Gates Speaks....
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

http://www.ocregister.com/liberty/animation/microsoft_anim.shtml