David, exporting data is really quite easy. Virtually all the data and charting programs have an "export" capability (application) that you can select. With the two or three I have seen, when you activate "export," the program gives you a choice of output formats, virtually always one of which is ASCII. It also asks you where you want to put the export data, path\filename, etc., and what kind of delilmiters you want. Some also allow you to select the specific data you want to export, high, low, close, etc. Then you simply "load," not "input," the data into EXCEL. EXCEL will put the data on a new page (sheet). You can rearrange, copy, paste, etcl, all you want. With TC2000 and WOW, its quite simple, and doesn't take much time. I don't know about the other data providers, but TC2000 allows you to export multi files for any number of stocks, one file for each stock.
I have written programs to get data directly from TC2000 database, it's not too difficult, but you need a downloadable *.DLL from Microsoft to decode the ancient format Worden uses in their database. I only got the data in this way when I was toying around with building an automated Visual Basic file handler (I didn't have WOW at that time) to provide a base for a homebuilt charting program. But, as you might expect, building a suitable database and all the specialized data manipulation and correcting applications got to be much more of a task than I wanted to undertake. Also, I had bought WOW by then! But, for the things I do that WOW won't do, I still export from TC2000 and use EXCEL.
In short, I export ASCII and load ASCII files into EXCEL.
Bill |
