|
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.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000080 face="Franklin Gothic Book">I've just started
downloading daily data from a new supplier (see sample below).</FONT></DIV>
<DIV><FONT color=#000080 face="Franklin Gothic Book">The data is fine except
that when a security has not traded on the day and there is zero volume the
supplier still provides the O/H/L/C which I assume are the most recent
prices the security traded at. In the sample below, the security AAA hasn't
traded since January this year. So having a data point on my chart when the
stock has not traded to me is useless.</FONT></DIV>
<DIV><FONT color=#000080 face="Franklin Gothic Book"> My previous data
supplier only ever supplied data which <STRONG>ACTUALLY </STRONG>traded on each
day. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000080 face="Franklin Gothic Book"><U>My question
is:</U></FONT></DIV>
<DIV><FONT color=#000080 face="Franklin Gothic Book">Is there an easy way to
"clean" this data and eliminate those securities from the file which have zero
volume before I convert the file in the Downloader? I had a try in Excel without
success and I thought maybe someone on the list might have a
solution.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000080
face="Franklin Gothic Book">regards........Ian</FONT></DIV>
<DIV><FONT color=#000080 face="Franklin Gothic Book"> </FONT></DIV>
<DIV><FONT face=Arial><FONT
size=2>AAA,20000911,2.5,2.5,2.5,2.5,0<BR>AAAWMB,20000911,0.001,0.001,0.001,0.001,0<BR>AAAWXA,20000911,0.15,0.15,0.15,0.15,0<BR>AAI,20000911,59,59,59,59,0<BR>AAP,20000911,7.14,7.15,7.12,7.12,67120<BR>AAPWMA,20000911,1.02,1.02,1.02,1.02,0<BR>AAR,20000911,0.028,0.028,0.027,0.027,38704<BR>AAT,20000911,0.465,0.48,0.46,0.47,159920<BR>AATDA,20000911,1,1,1,1,0<BR>AATDB,20000911,0.5,0.5,0.5,0.5,0<BR>AATNA,20000911,1.95,1.95,1.95,1.95,0<BR>AATR,20000911,0.52,0.52,0.52,0.52,0<BR>AAU,20000911,1.7,1.7,1.7,1.7,18000<BR>AAV,20000911,0.11,0.11,0.11,0.11,0<BR>ABC,20000911,0.47,0.47,0.45,0.47,510843<BR>ABCG,20000911,2.07,2.07,2.07,2.07,29500<BR>ABCN,20000911,0.92,0.92,0.92,0.92,0<BR>ABCR,20000911,0.21,0.21,0.21,0.21,0<BR>ABD,20000911,0.28,0.28,0.28,0.28,0<BR>ABDDA,20000911,0.165,0.165,0.165,0.165,0<BR>ABDO,20000911,0.09,0.09,0.09,0.09,0<BR>ABF,20000911,2.85,2.85,2.85,2.85,0<BR>ABG,20000911,2.01,2.01,2.01,2.01,2000<BR>ABK,20000911,0.4,0.4,0.4,0.4,29450<BR>ABKO,20000911,0.13,0.13,0.13,0.13,0<BR>ABN,20000911,0.85,0.85,0.85,0.85,0<BR></FONT></DIV></FONT></BODY></HTML>
</x-html>
|