I have csv data some of which is trade data and some of which is not. It is too large for excel to graph every point without crashing. Any recommendations? I'd prefer software with a gui and inexpensive.
Too many datapoints for Excel would also mean too many points to distinguish individual observations, no? In any case, there's R and other opensource tools, or look at http://www.synergy.com/
yes, this is true. I think I will time average and then take one out of every x points to graph. It's just my algorithms work on all of the data, and it'd be nice to look and "see" if there were aberration in the data or the analysis. I know eventually I will want to learn R/ matlab so maybe that time is now. It couldn't hurt.
Try using StockChartx from modulusfe. I use it with Matlab and other data I keep databased. http://www.modulusfe.com/stockchartx/ StockChartX includes over 35 example projects that demonstrate how to perform real-time charting (free Real-Time Data Feed API trial included), how to read data from Microsoft Access Databases, CSV files, MetaStock data files, and other sources, display charts within Microsoft Excel, create custom charts within VB.NET, C#, VB6, VC++, Delphi, and Borland C++, how to create charts using a free scripting language (included) plus much more! Free email support, live chat, and telephone technical support is included.