|
PureBytes Links
Trading Reference Links
|
Tell Excel to write the columns out to a CSV file,
then tell Downloader to convert from an ASCII file.
CSV means "Comma Separated Values".
You want each line of data to look like this:
SFAM,d,05/02/97,27.2500,33.6250,27.2500,32.2500,6585,0
In the above example, SFAM is the stock symbol. The "d" means "daily"
periodicity, then comes Date, Open, High, Low, Close, Volume, and Open
Interest (used only for options).
On Fri, 2 May 1997 22:44:03 -0500 (CDT), you wrote:
>)
>Subject: ISO of utility to parse Excel 5 data into MetaStock format
>To: metastock-list@xxxxxxxxxxxxx
>I manually enter some non-public 401k fund daily quotes into an Excel
>5.0 spreadsheet (dates in rows, funds in columns). I am looking for a
>utility program to automate the parsing of this spreadsheet for the
>MetaStock 5.11 downloader.
>
>Do you know of any such program or how to write a batch file or other
>suitable program?
>
>Gary Capistrant
>
>
|