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

Re: Using Excel to convert data



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>Here it comes ;-)</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT><FONT size=2>BTW what is 
Concat?</FONT></DIV>
<DIV><FONT color=#000000 size=2><BR>Greetings from Jan 
Diederik</FONT>&nbsp;</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>Bill Ford &lt;<A 
    href="mailto:whford@xxxxxxxxxxxx";>whford@xxxxxxxxxxxx</A>&gt;<BR><B>To: 
    </B>Jan Diederik &lt;<A 
    href="mailto:jddehaas@xxxxxxx";>jddehaas@xxxxxxx</A>&gt;<BR><B>Date: 
    </B>zaterdag 6 december 1997 14:26<BR><B>Subject: </B>Re: Using Excel to 
    convert data<BR><BR></DIV></FONT>Jan Diederik wrote:<BR>&gt; In order to use 
    the data in MS I want to convert that data through<BR>&gt; Excel (97) in the 
    proper ASCII layout, so I can import it via The<BR>&gt; Downloader. But for 
    that I need to have the date included. The<BR>&gt; filename of the TXT-files 
    is xxxYMMDD.txt and I want to use that for<BR>&gt; (automaticly) inserting 
    in the Excel sheet. I can then save the sheet<BR>&gt; as an ASCII file and 
    convert it in The Downloader.<BR>&gt; Does anyone know how to create a macro 
    that that can do it for me<BR>&gt; (manually is waaayyyy to much work). The 
    data in the files are divided<BR>&gt; by semicolumns and have the following 
    format:<BR>&gt; Tickersymbol;Open;High;Low;Close;Volume.<BR>&gt; Any help 
    would be VERY appriciated.<BR>&gt; <BR>&gt; Greetings from Jan 
    Diederik<BR>Hi Jan<BR>If you email me a sample of your data files that need 
    to be converted I<BR>will take a look at it. A simple Concat should do 
    it.<BR><BR>Bill Ford<BR></BLOCKQUOTE></BODY></HTML>
</x-html>
Attachment Converted: "c:\eudora\attach\Ndx71205.txt"