|
PureBytes Links
Trading Reference Links
|
You click on "download spreadsheet format" on the bottom of the page. My
computer automatically opens Excel. If you don't have Excel, I'm not sure
what prompt you will get.
-----Original Message-----
From: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
To: Tuva1 <Tuva1>
Date: Monday, November 02, 1998 8:42 AM
Subject: Re: Fw: QuoteMonster [Was:Re: Yahoo data]
>
>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
>>>
>>
>>
>>
>>
>
>
|