I want to screen the universe of stock price histories available from Yahoo for certain patterns.  That means iterating a screen over several thousand time series.  get.hist.quotes saves time series to CSV.  Putting everything into a database like MySQL seems to be a better idea than working with thousands of CSV files, especially when I might want to add new data points in the future.

I scoured the R and R packages manuals, the TOC of the Times Series Analysis Using R book, and googled r lists for information on get.hist.quotes and MySQL and came up only almost nothing on the practical use of MySQL.  (I did find a tantalizing pointer by Bollinger to a bunch of python, r and gnuplot packages for his own projects.  I think I might need to leverage python or perl to load up the database and then R packages manipulate the data.)

Any suggestions on where to learn more -- and find examples -- on using MySQL for ts and any comments on my type of project using R in general?

Thanks,
Ming


       
____________________________________________________________________________________

eChase.

	[[alternative HTML version deleted]]

