|
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.71.2016.0"' name=GENERATOR>
</HEAD>
<BODY bgColor=#d8d0c8>
<DIV><FONT color=#000000 size=2>Thanks, that's what I was looking for. I am now
experimenting to compose the whole macro.</FONT></DIV>
<DIV><FONT color=#000000 size=2><BR>Greetings from Jan
Diederik</FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Matt Tway <<A
href="mailto:mtway@xxxxxxxxxxx";>mtway@xxxxxxxxxxx</A>><BR><B>To: </B>Jan
Diederik <<A
href="mailto:jddehaas@xxxxxxx";>jddehaas@xxxxxxx</A>><BR><B>Cc: </B><A
href="mailto:metastock-list@xxxxxxxxxxxxx";>metastock-list@xxxxxxxxxxxxx</A>
<<A
href="mailto:metastock-list@xxxxxxxxxxxxx";>metastock-list@xxxxxxxxxxxxx</A>><BR><B>Date:
</B>zaterdag 6 december 1997 17:15<BR><B>Subject: </B>Re: Using Excel to
convert data<BR><BR></DIV></FONT>using the "ActiveWorkbook.Name"
Visual Basic function in Excel you can get your file name, you sould be able
to extract the date from the text.<BR><BR>At 10:33 PM 12/5/97 +0100, you
wrote: <BR>>>>><BR>
<BLOCKQUOTE>In order to use the data in MS I want to convert that data
through Excel (97) in the proper ASCII layout, so I can import it via
The Downloader. But for that I need to have the date included. The
filename of the TXT-files is xxxYMMDD.txt and I want to use that for
(automaticly) inserting in the Excel sheet. I can then save the sheet as
an ASCII file and convert it in The Downloader.<BR>Does anyone know how
to create a macro that that can do it for me (manually is waaayyyy to
much work). The data in the files are divided by semicolumns and have
the following format:<BR>Tickersymbol;Open;High;Low;Close;Volume.
<BR>Any help would be VERY appriciated. <BR><BR>Greetings from Jan
Diederik <BR><BR> </BLOCKQUOTE><<<<<BR><BR><BR><BR>*
Matthew P. Tway * mailto:mtway@xxxxxxxxxxx * <A
href="http://www.rscubed.com/~mtway";>http://www.rscubed.com/~mtway</A>
*<BR>* No unsolicited E-Mail * </BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Mon Dec 08 10:44:18 1997
Received: from smtp2.nwnexus.com (smtp2.nwnexus.com [198.137.231.18])
by mail1.halcyon.com (8.8.7/8.8.7) with ESMTP id KAA25383
for <neal@xxxxxxxxxxxxxxxx>; Mon, 8 Dec 1997 10:00:10 -0800 (PST)
Received: from mail.equis.com (equis.com [204.246.137.2])
by smtp2.nwnexus.com (8.8.7/8.8.7) with ESMTP id JAA07643
for <neal@xxxxxxxxxxx>; Mon, 8 Dec 1997 09:59:35 -0800
Received: (from list@xxxxxxxxx) by mail.equis.com (8.7.4/8.7.3) id MAA21270; Mon, 8 Dec 1997 12:03:44 -0700
Resent-Date: Mon, 8 Dec 1997 12:03:44 -0700
From: "Jan Diederik" <jddehaas@xxxxxxx>
To: "Metastock" <metastock-list@xxxxxxxxxxxxx>
Subject: Re: Using Excel to convert data
Date: Mon, 8 Dec 1997 14:37:58 +0100
Message-ID: <01bd03de$7eccdca0$0100007f@xxxxxxxx>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_006E_01BD03E6.E09144A0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Resent-Message-ID: <"dTJUi1.0.GC5.FI4Zq"@mail.equis.com>
Resent-From: metastock-list@xxxxxxxxxxxxx
X-Mailing-List: <metastock-list@xxxxxxxxxxxxx> archive/latest/5953
X-Loop: metastock-list@xxxxxxxxxxxxx
Precedence: list
Resent-Sender: metastock-list-request@xxxxxxxxxxxxx
Status: O
<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.71.2016.0"' name=GENERATOR>
</HEAD>
<BODY bgColor=#d8d0c8>
<DIV><FONT color=#000000 size=2>I took a look at it and it seems very powerful,
but really complicated!! I am going to experiment with it this week. What's the
price tag, because it is a 30 trial version?</FONT></DIV>
<DIV><FONT color=#000000 size=2><BR>Greetings from Jan
Diederik</FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Christian Kaiser <<A
href="mailto:chk@xxxxxxxxx";>chk@xxxxxxxxx</A>><BR><B>To: </B>'Jan
Diederik' <<A
href="mailto:jddehaas@xxxxxxx";>jddehaas@xxxxxxx</A>><BR><B>Date:
</B>zaterdag 6 december 1997 17:12<BR><B>Subject: </B>RE: Using Excel to
convert data<BR><BR></DIV></FONT>Jan,<BR><BR>our converter can do all of
your import. Check out <A
href="http://www.invest-tools.com";>www.invest-tools.com</A>.<BR><BR>Christian
Kaiser<BR>Kaiser Software Engineering<BR><BR></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Mon Dec 08 08:54:22 1997
Received: from smtp2.nwnexus.com (smtp2.nwnexus.com [198.137.231.18])
by mail1.halcyon.com (8.8.7/8.8.7) with ESMTP id HAA11637
for <neal@xxxxxxxxxxxxxxxx>; Mon, 8 Dec 1997 07:41:11 -0800 (PST)
Received: from mail.equis.com (equis.com [204.246.137.2])
by smtp2.nwnexus.com (8.8.7/8.8.7) with ESMTP id HAA27794
for <neal@xxxxxxxxxxx>; Mon, 8 Dec 1997 07:41:01 -0800
Received: (from list@xxxxxxxxx) by mail.equis.com (8.7.4/8.7.3) id JAA19616; Mon, 8 Dec 1997 09:59:33 -0700
Resent-Date: Mon, 8 Dec 1997 09:59:33 -0700
X-Sender: fbg@xxxxxxxxxxxxxxxxxxx
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0 Release Candidate 3
Date: Mon, 08 Dec 1997 09:38:44 -0500
To: metastock-list@xxxxxxxxxxxxx
From: "Frank B. Gaylord" <fbg@xxxxxxxxxxxxxx>
Subject: Upgrades/Downgrades / My Yahoo!
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Message-ID: <19971208153657671.AAA132@xxxxxxxxxx>
Resent-Message-ID: <"XvGeN.0.Qo4.qT2Zq"@mail.equis.com>
Resent-From: metastock-list@xxxxxxxxxxxxx
X-Mailing-List: <metastock-list@xxxxxxxxxxxxx> archive/latest/5949
X-Loop: metastock-list@xxxxxxxxxxxxx
Precedence: list
Resent-Sender: metastock-list-request@xxxxxxxxxxxxx
Status:
I use My Yahoo! as my Home Page. This morning when I logged on I found
that this site now offers a section devoted to analysts' Upgrades,
Downgrades and Coverage Initiated. for those who do not use My Yahoo!,
this is the personalized Yahoo! and is creatable from the "My Yahoo!" link
under the Search window at http://www.yahoo.com.
-- Frank :-)
High Return on Investment using Technical Analysis
http://www.usinternet.com/users/fbg/
Minnesota Long Distance Canoe Racing
http://www.usinternet.com/users/fbg/mnlong/
------------------------------------------------------------------------
|