|
-
Jun 15th, 2008, 01:54 PM
#1
Thread Starter
New Member
[2008] CSV file into Dataset...
...Or at least I think thats what I want to do. I'm new to VB, and haven't done much programming in general.
I'm trying to read a CSV file of stock market data like below:
Date,Open,High,Low,Close,Volume
6/6/2008,26.50,27.08,26.03,26.44,37746600
6/5/2008,26.46,26.64,25.97,26.36,30152200
6/4/2008,26.25,27.05,26.16,26.85,29973600
6/3/2008,26.36,26.60,25.78,26.15,25586000
6/2/2008,26.80,26.81,26.03,26.40,26366800
5/30/2008,27.07,27.10,26.63,26.76,17754100
5/29/2008,27.34,27.36,27.00,27.07,17905300
I want to be able to store this data somehow so that I can then scan through it for patterns. I also want to be able to scan through dozens of files (for different stocks) and look for similar patterns. So it seems like I would want to put the data from each stock into datasets, and then I can scan through it from there.
But as I said, I'm new, and I'm not really sure this is even the best way to go about this. Simpler is better. But then I also want to expand this later, and be able to search through thousands of files repeatedly for different patterns, so will this method be fast enough to do that in a reasonable amount of time? I tried searching for tutorials and such, but they mostly seem to deal with transferring data from an SQL database or something. Right now I'm using another program to download the CSV files, though I suppose I'll eventually write the program to download the information and run the scans by itself.
I think that's about it. Thanks so much for any help you can provide.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|