Excel question

If you want to stay in Excel, you can also use the Microsoft ODBC text driver, which allows you to treat csv files like database tables and run SQL queries against them. You would also need to install the Excel ODBC add in for that. There are some bugs with the installation program for that, so you can just open the executable with winzip and grab the dll and xla from there. And remember google is your friend. I am guessing you don't know SQL either, but if you are serious about data miniing, you should learn it.
 
Thx everybody for your help and suggestions. i'll keep them in mind for future projects. for now, i was able to grind out a VBS script that does the following:

1. open and search a file (a CSV in this case)
2. consider only data from RTH Close to RTH Open
3. find the High and Low
4. create an XLS file
5. populate the file with the data

nothing too fancy but it works. i'm messing around with some bells and whistles, but nothing major. it's easy and functional, so i don't want to do anything to mess that up.

again, thx to all.
 
You must log in or register to reply here.
Back
Top