|
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.) - FAQ's</STRONG></FONT></DIV>
<DIV><FONT face=Arial color=#000000
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV><FONT face=Arial color=#000000></FONT> </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 to each line</FONT>.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>> In DL EOD this works:<BR>> <BR>> Add a Price
(Open,High,Low,Close) to the next blank row, than<BR>> the Downloader will
automatically fill the correct next Day's date.<BR>> <BR>> Now for RT
replace Day with Time..........<BR></FONT></DIV>
<DIV> </DIV>
<DIV>And in Excel this works:</DIV>
<DIV> </DIV>
<DIV>-see part 1 -sheet 1</DIV>
<DIV>-see part 2 -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 <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>PART 2 - sheet2</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </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> </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" <</FONT><A
href="mailto:metastock@xxxxxxxxxxxxx";><FONT
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>></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>> In DL EOD this
works:<BR>> <BR>> Add a Price (Open,High,Low,Close) to the next blank row,
than<BR>> the Downloader will automatically fill the correct next Day's
date.<BR>> <BR>> Now for RT replace Day with Time..........<BR>>
<BR>> Regards,<BR>> Ton Maas<BR>> </FONT><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT
size=2>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=2>> Dismiss the
".nospam" bit (including the dot) when replying.<BR>> Homepage
</FONT><A href="http://home.planet.nl/~anthmaas";><FONT
size=2>http://home.planet.nl/~anthmaas</FONT></A><BR><FONT size=2>> <BR>>
<BR>> <BR>> <BR>> ----- Original Message ----- <BR>> From: "iamken"
<</FONT><A href="mailto:iamken@xxxxxxxxxxxxxxx";><FONT
size=2>iamken@xxxxxxxxxxxxxxx</FONT></A><FONT size=2>><BR>> To:
<</FONT><A href="mailto:metastock@xxxxxxxxxxxxx";><FONT
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>><BR>> Sent:
woensdag 12 april 2000 16:36<BR>> Subject: add 3 hours to each Downloader
line?<BR>> <BR>> <BR>> > <BR>> > I have a intraday security in
the Downloader and I want to add 3 hours<BR>> > to each line. For
instance a line currently reads 06:31:00 and the next<BR>> > line is
06:32:00. I want it to read 09:31:00 and the next line to read<BR>>
> 09:32:00. There are thousands of lines. I can't find a way to
do this<BR>> > in either the Downloader or Excel. Any help is
appreciated. If there<BR>> > were a trade on each one minute
interval (there isn't), I could copy the<BR>> > times from another file
that has the 09:31:00 times and paste them in in<BR>> > place of the
06:31:00 times. Any ideas?<BR>> > <BR>> > Regards,<BR>>
> Ken</FONT> </BODY></HTML>
</x-html>
Attachment Converted: "f:\eudora\attach\sheet2.gif"
|