in reply to building a time series form dated flat files

What's more efficient depends partly on what you do with the data. Are you going back through every file over and over again for different stocks many times? That's the impression I got. If so, putting the info in a database of some sort up front and querying the database will be much more efficient. If, though, you are only interested in a few stocks and only hit those files for a particular date range a few times, you might not want to bother with changing anything.
  • Comment on Re: building a time series form dated flat files

Replies are listed 'Best First'.
Re^2: building a time series form dated flat files
by sean.snv (Initiate) on Oct 14, 2010 at 17:40 UTC
    Thanks for the response.

    That's what I wanted to know. If I was only hitting this once or twice, is there a better way to find the specific stock I want other than line by line until I get there? Otherwise, I will look to putting the data in a database if I need to access the data much more than that.

    Sean