|
PureBytes Links
Trading Reference Links
|
You must also save as an Excel 4.0 worksheet and the downloader reads it
perfectly. I have had no errors in the 30 industrials I have downloaded.
The basic process summarized:
a. download the data into excel
b. sort the data ascending
c. reformat the date column into downloader format
d. save as excel 4.0 worksheet -- for those using excel 97
d. utilize the convert the command in downloader to convert
Tom
-----Original Message-----
From: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
To: Tuva1 <Tuva1>
Date: Monday, November 02, 1998 12:42 AM
Subject: Re: Fw: QuoteMonster [Was:Re: Yahoo data]
>Daniel Martinez wrote:
>>
>> MetaStock Users:
>> I just downloaded the DOW (^DJI) from 1928 to the present. I rarely use
the
>> Downloader. Because the dates are in descending order, I don't know how
to
>> incorporate the data into MetaStock. Can anyone tell me how this is
done?
>>
>> This is a sample of the data:
>> Date,Open,High,Low,Close,Volume
>> 30-Oct-1998,8591.58,8718.25,8481.39,8592.1001,7850000
>> 29-Oct-1998,8371.22,8539.83,8305.5401,8495.03,6994000
>> 28-Oct-1998,8372.7401,8504.04,8271.5501,8371.9701,6775000
>> 27-Oct-1998,8503.7901,8586.69,8309.92,8366.04,7645000
>> 26-Oct-1998,8483.96,8564.03,8349.57,8432.21,6099100
>> 23-Oct-1998,8531.34,8589.01,8366.04,8452.29,6376400
>> 22-Oct-1998,8519.03,8629.17,8334.12,8533.14,7549000
>> 21-Oct-1998,8504.6701,8641.02,8380.7201,8519.23,7451000
>> 20-Oct-1998,8540.0901,8713.62,8419.08,8505.85,9582000
>>
>
>Daniel,
>You can read the data into EXCEL, as CSV text.
>- Change the date format.
>- Sort by date (ascending order)
>- Insert columns for the symbol, period, and open interest
>- Set the symbol to DJI, period to D, and open interest to 0
>- Save the file in CSV text format
>
>Now you can import into the DownLoader
>
>Regards,
>Tim
>
|