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

Re: add 3 hours to each Downloader line?



PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Times New Roman" size=2><FONT color=#0000ff>
<DIV><FONT face=Arial color=#000000 size=2><STRONG>OLE between MSK+Excel 
(+v.v.)&nbsp; -&nbsp;&nbsp;FAQ's</STRONG></FONT></DIV>
<DIV><FONT face=Arial color=#000000 
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV><FONT face=Arial color=#000000></FONT>&nbsp;</DIV></FONT></FONT></DIV>
<DIV><FONT face="Times New Roman" size=2><FONT face=Arial><STRONG><FONT 
color=#0000ff>Q13</FONT></STRONG>. I have an intraday security in the Downloader 
and I want to add 3 hours&nbsp;to each line</FONT>.</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>&gt; In DL EOD this works:<BR>&gt; <BR>&gt; Add a Price 
(Open,High,Low,Close) to the next blank row, than<BR>&gt; the Downloader will 
automatically fill the correct next Day's date.<BR>&gt; <BR>&gt; Now for RT 
replace Day with Time..........<BR></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>And in Excel this works:</DIV>
<DIV>&nbsp;</DIV>
<DIV>-see part 1 -sheet 1</DIV>
<DIV>-see part 2&nbsp;-sheet 2</DIV>
<DIV><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.<BR>Homepage&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>PART 2 - sheet2</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2><IMG alt="" hspace=0 
src="cid:009401bfa98f$1bf016c0$LocalHost@xxxxx"; align=baseline 
border=0></FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT>
<DIV><FONT size=2>From: "A.J. Maas"</FONT></DIV>
<DIV><FONT size=2>To: "Metastock-List" &lt;</FONT><A 
href="mailto:metastock@xxxxxxxxxxxxx";><FONT 
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>&gt;</FONT></DIV>
<DIV><FONT size=2>Sent: donderdag 13 april 2000 3:24</FONT></DIV>
<DIV><FONT size=2>Subject: Re: add 3 hours to each Downloader 
line?</FONT></DIV></DIV>
<DIV><FONT size=2><BR></FONT></DIV><FONT size=2>&gt; In DL EOD this 
works:<BR>&gt; <BR>&gt; Add a Price (Open,High,Low,Close) to the next blank row, 
than<BR>&gt; the Downloader will automatically fill the correct next Day's 
date.<BR>&gt; <BR>&gt; Now for RT replace Day with Time..........<BR>&gt; 
&nbsp;<BR>&gt; Regards,<BR>&gt; Ton Maas<BR>&gt; </FONT><A 
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT 
size=2>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=2>&gt; Dismiss the 
".nospam" bit (including the dot) when replying.<BR>&gt; Homepage&nbsp; 
</FONT><A href="http://home.planet.nl/~anthmaas";><FONT 
size=2>http://home.planet.nl/~anthmaas</FONT></A><BR><FONT size=2>&gt; <BR>&gt; 
<BR>&gt; <BR>&gt; <BR>&gt; ----- Original Message ----- <BR>&gt; From: "iamken" 
&lt;</FONT><A href="mailto:iamken@xxxxxxxxxxxxxxx";><FONT 
size=2>iamken@xxxxxxxxxxxxxxx</FONT></A><FONT size=2>&gt;<BR>&gt; To: 
&lt;</FONT><A href="mailto:metastock@xxxxxxxxxxxxx";><FONT 
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>&gt;<BR>&gt; Sent: 
woensdag 12 april 2000 16:36<BR>&gt; Subject: add 3 hours to each Downloader 
line?<BR>&gt; <BR>&gt; <BR>&gt; &gt; <BR>&gt; &gt; I have a intraday security in 
the Downloader and I want to add 3 hours<BR>&gt; &gt; to each line.&nbsp; For 
instance a line currently reads 06:31:00 and the next<BR>&gt; &gt; line is 
06:32:00.&nbsp; I want it to read 09:31:00 and the next line to read<BR>&gt; 
&gt; 09:32:00.&nbsp; There are thousands of lines.&nbsp; I can't find a way to 
do this<BR>&gt; &gt; in either the Downloader or Excel.&nbsp; Any help is 
appreciated.&nbsp; If there<BR>&gt; &gt; were a trade on each one minute 
interval (there isn't), I could copy the<BR>&gt; &gt; times from another file 
that has the 09:31:00 times and paste them in in<BR>&gt; &gt; place of the 
06:31:00 times.&nbsp; Any ideas?<BR>&gt; &gt; <BR>&gt; &gt; Regards,<BR>&gt; 
&gt; Ken</FONT> </BODY></HTML>
</x-html>
Attachment Converted: "f:\eudora\attach\sheet2.gif"