You'll need to show you'e tried something if you are hoping for anything
remotely useful as a reply.

Preprocessing with text tools will make life easier (think cat, awk, etc) -
4 million rows is pretty trivial for tools in R - xts is designed to eat
this for lunch ;-)

Your question really needs to be more specific if you want specific help
though, and I'd suspect you haven't done too much to read up on the list or
elsewhere of potential solutions (since you included Word as an option...)

So advice as of now - read through the archives of this list, read the
zoo/xts documentation, read about R, look at quantstrat and post some small
example of your best efforts with R (as this is the R list)

Best,
Jeff


On Mon, Jul 11, 2011 at 10:08 AM, Michael Gates <mgates@wdemail.com> wrote:

> I want to back test a huge amount of stock data with one run.  I have not
> yet read the data into R.  It is comprised of 1000 symbols for the past 20
> years.  OHLCV are columns.  Dates are rows.  The number of rows exceeds 4
> million so I can't prepare it as a single .txt doc in either Excel or Word.
>
>
>
> My hardware is:  1 TB HD,  8 GB DDR2 Ram and an Intel  Core2 Quad
> processor.
>
>
>
> Any suggestions on best approach would be appreciated.
>
>
>
> Thanks in advance,
>
>
>
> Mike
>
>
>
>
>        [[alternative HTML version deleted]]
>
> _______________________________________________
> R-SIG-Finance@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions
> should go.
>



-- 
Jeffrey Ryan
jeffrey.ryan@lemnica.com

www.lemnica.com
www.esotericR.com

	[[alternative HTML version deleted]]

