|
PureBytes Links
Trading Reference Links
|
<x-html><html><head></head><BODY bgcolor="#FFFFFF"><p><font size=3 color="#000080" face="Book Antiqua"><i>Hello everyone,<br>Since I don't have Metastock RT, I've been creating 2-min and 5-min<br>charts in Excel 7 with tick data from CME. <br>Does anybody know how to copy / convert this type of data ( HTML )<br>into Excel 7?. What I've been doing is copy the data from CME to<br>my h. drive as .HTML file and type the data into Excel. This is very <br>tiresome and time consuming ( hundreds of rows per file ! ).<br>If I try to copy or convert this data into a spreadsheet, I get ALL the <br>data in a single column and moving cells to rearrange the data is as <br>inefficient as typing the whole thing.<br>Any help will be appreciated.<br>Have a nice weekend.<br><br>Efrain R Portales<br><font color="#0000FF"><u>efrain12@xxxxxxxxxxxx</u><font color="#000080"></p>
</font></font></font></body></html></x-html>From ???@??? Sat Aug 02 09:22:11 1997
Received: from smtp1.nwnexus.com (smtp1.nwnexus.com [198.137.231.16])
by mail1.halcyon.com (8.8.5/8.8.5) with ESMTP id CAA02468
for <neal@xxxxxxxxxxxxxxxx>; Sat, 2 Aug 1997 02:23:51 -0700 (PDT)
Received: from mail.equis.com (equis.com [204.246.137.2])
by smtp1.nwnexus.com (8.8.5/8.8.5) with ESMTP id CAA21047
for <neal@xxxxxxxxxxx>; Sat, 2 Aug 1997 02:22:17 -0700
Received: (from list@xxxxxxxxx) by mail.equis.com (8.7.4/8.7.3) id DAA15335; Sat, 2 Aug 1997 03:17:42 -0600
Resent-Date: Sat, 2 Aug 1997 03:17:42 -0600
Date: Sat, 2 Aug 1997 21:08:12 +1200 (NZST)
Message-Id: <199708020908.VAA17173@xxxxxxxxxxxxxxxxxxxxxxxx>
X-Sender: slatta@xxxxxxxxxxxxx
X-Mailer: Windows Eudora Pro Version 2.1.2
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
To: "Efrain R Portales" <efrain12@xxxxxxxxxxxx>,
"Metastock List" <metastock-list@xxxxxxxxxxxxx>
From: Steve Latta <slatta@xxxxxxxxxxxxx>
Subject: Re: Tick Data in Excel
Resent-Message-ID: <"lBXST2.0.Yl3.rilup"@mail.equis.com>
Resent-From: metastock-list@xxxxxxxxxxxxx
X-Mailing-List: <metastock-list@xxxxxxxxxxxxx> archive/latest/3586
X-Loop: metastock-list@xxxxxxxxxxxxx
Precedence: list
Resent-Sender: metastock-list-request@xxxxxxxxxxxxx
X-UIDL: e7e59d526686ca063975ff27d6efe0d7
Try "Text to Columns" under the Data menu
>At 02:13 2/08/97 -0500, Efrain R Portales wrote:
>Hello everyone,
>Since I don't have Metastock RT, I've been creating 2-min and 5-min
>charts in Excel 7 with tick data from CME.
>Does anybody know how to copy / convert this type of data ( HTML )
>into Excel 7?. What I've been doing is copy the data from CME to
>my h. drive as .HTML file and type the data into Excel. This is very
>tiresome and time consuming ( hundreds of rows per file ! ).
>If I try to copy or convert this data into a spreadsheet, I get ALL the
>data in a single column and moving cells to rearrange the data is as
>inefficient as typing the whole thing.
>Any help will be appreciated.
>Have a nice weekend.
>
|