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

RE: QuoteMonster and Yahoo Indexes



PureBytes Links

Trading Reference Links

Daniel,

	Thanx for posting the tickers for the indexes.  I was unaware they had 
this!  If you learn of more, would you be kind enough to post those as 
well?  Thankx again...

----------
From: 	Daniel Martinez[SMTP:DanM@xxxxxxxx]
Reply To: 	metastock@xxxxxxxxxxxxx
Sent: 	Wednesday, November 04, 1998 4:39 AM
To: 	metastock@xxxxxxxxxxxxx; Jim Michael
Cc: 	Tom; AlanGLutz@xxxxxxx; UG
Subject: 	Re: QuoteMonster and Yahoo Indexes

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.