[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: QuoteMonster and Yahoo Indexes



PureBytes Links

Trading Reference Links

Daniel.
What is the webadress where I can find these historical quotes for the
index you mention.
Lars 

At 01:39 04-11-1998 -0800, you wrote:
>Jim,
>I finally downloaded and installed the Perl Standard Distribution file and
your
>QuoteMonster Historical download file.  I was able to download Yahoo's Dow
Jones
>Industrial Average data dating back to Oct 1, 1928.  This is most excellent,
>especially so since I was hoping for data going back only 20 years.  The
file has
>18,647 records(!) and the date field was parsed correctly.  I converted
the file
>using the Downloader and used the Downloader to sort the file.  Because
Quattro
>Pro's line limit is 8,192 lines, I used the Downloader instead.  I don't
know what
>Excel's limit is.  It is easier to use the Downloader for sorting anyway.
>
>I believe subsequent downloads can be simultaneously converted and merged
into
>existing MetaStock data using the Downloader.  Sorting must be done after
each
>merge.
>
>To anyone who's interested in Yahoo data.  The following Indexes are
available and
>I am sure there are many others which I have not investigated yet (SOX, XAU):
>Ticker      Description                  Start_Date
>^SPX        S&P500                       Jan/3/1950
>^DJI        DOW JONES INDUSTRIALS        OCT/1/1928
>^DJU        DOW JONES UTILITIES          JAN/2/1929
>^DJT        DOW JONES TRANSPORTS         OCT/1/1928
>^RUT        RUSSELL 2000                 SEP/10/1987
>
>For those of you who are newbies at using computers, it is necessary to
change one
>line in the QMH file in the QuoteMonster Historical ZIP file.  You must
change the
>"my $header" line so that it looks like this:
># If your data file must contain a header, enter it here. An example of an
>optional
># Metastock header is on the next line following the #:
>
>#<ticker>,<date>,<open>,<high>,<low>,<close>,<vol>
>
>my $header = '<ticker>,<date>,<open>,<high>,<low>,<close>,<vol>';
>
>Perhaps the QMH file can be edited, Jim?  The QMH Readme.now file mentions
a "LWP
>module".  This module appears to included in the Perl Standard
Distribution (PSD)
>file.  I deleted the extra copies of files created during the UNZIP
process but
>tranferred the "distfiles" folder to the x:\Perl folder.  Because I know
so much
>about computers and installations, I was able download, install PSD, and
convert
>to MS format.  I don't know if newbies can climb the learning curve as well.
>
>Good job Jim and thank you for creating your web page and QMH file.
>
>Daniel.
>
>
>
>Jim Michael wrote:
>
>> On Sun, 1 Nov 1998, 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
>>
>> If you use QuoteMonster dates are converted to a format usable by
>> MetaStock (yymmdd). Also, the order of dates doesn't seem to matter with
>> the Downloader, although a script will be up shortly to reverse the date
>> order of quotes.
>
>
>
>