|
PureBytes Links
Trading Reference Links
|
Hi.. How do I actually get the zipped file.. I went to the site but didn't
see where to zip it...thanks
At 06:25 AM 11/2/98 -0500, you wrote:
>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
>>
>
>
>
>
|