|
PureBytes Links
Trading Reference Links
|
I use an Excel97 macro to create a new *.csv containing the stocks I want in
the order I want.
It uses match() function to copy codes from an MS exploration of my
database. This speeds up converting considerably as the codes are in the
exact same order in the database and the new *.csv (eliminating swapping
backwards and forwards between directories).
On the Australian market (<3000 codes in original .csv) I update 1900 daily,
macro forms new .csv in about 45 seconds, converts into MS 4 minutes +.
(200Pentium).
Unfortunately the macro is included in a 1meg file, inappropriate for
posting. If you use Excel and are interested I could extract the pertinent
section.
-----Original Message-----
From: Marco Guglielmo <mgugliel@xxxxxxxxxxxxxxxx>
To: metastock-list@xxxxxxxxxxxxx <metastock-list@xxxxxxxxxxxxx>
Date: Sunday, 21 September 1997 5:29
Subject: US stock data file conversion
>Hi to the list,
>
>I am triyng to build up an historical data base of the most important US
>stocks.
>I am using the daily file quotations downloaded free from the
>www.gofutures.com site.
>Considering that the ASCI file has more than 16,000 strings of data,
>does anybody advise me how to extract in a quick way only some hundreds
>stock quotations?
>Does anybody has already withstanded this problem?
>Any help would be greatly appreciated
>
>Best Regards
>
>Marco Guglielmo
>(Turin,Italy)
>
>
|