In my trading software I generate a file like the following:
10:00:00.0000001 1.25333
...........................
...........................
14:58:48.5024961 1.23456
14:58:48.5024987 1.23455
14:58:48.5025003 1.23460
14:58:48.5025108 1.23458
...........................
...........................
17:59:59.9997788 1.21111
I have millions of items in total. I want to see graphic, especially "extremums" (time is "X" and value is "Y"). I need ability to "zoom" to interesting parts of the graphic etc.
Probably I can do that in Excel or I should better use some specific software. What can you recommend?
As I generate the file myself, I can change format as needed (use ";" as a delimeter, change time format etc.)
Update: How do I run octave in Windows?
Oleg@OlegPC ~
$ octave
GNU Octave, version 3.6.1
Copyright (C) 2012 John W. Eaton and others.
This is free software; see the source code for copying conditions.
There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. For details, type `warranty'.
Octave was configured for "i686-pc-cygwin".
Additional information about Octave is available at http://www.octave.org.
Please contribute if you find this software useful.
For more information, visit http://www.octave.org/help-wanted.html
Read http://www.octave.org/bugs.html to learn how to submit bug reports.
For information about changes from previous versions, type `news'.
warning: unable to open X11 DISPLAY
octave:1>