software to plot Bar/Candlestick chart from CSV

ss4

Newbie
Messages
5
Likes
0
Hi

I need to create a OHLC(Candlestick/Bar) chart out of historical data that I have in a CSV file format. Any ideas on software that can be used to do this? Please help.

My data is like this:
Time,Open,High,Low,Close
07.11.2011 20:00:00.000,5544.3,5544.3,5540.3,5540.3
07.11.2011 20:05:00.000,5540.3,5541.5,5539.8,5540.3
07.11.2011 20:10:00.000,5545.3,5549.8,5545.3,5548.3
07.11.2011 20:15:00.000,5547.5,5548.8,5546.5,5546.5
07.11.2011 20:20:00.000,5542.0,5542.5,5541.8,5542.3
07.11.2011 20:25:00.000,5545.5,5546.0,5544.8,5544.8
07.11.2011 20:30:00.000,5536.5,5542.0,5536.3,5542.0

I am looking for a software that will take the CSV file as an input. It should use the Time as X-axis and Close as Y axis. The content displayed should be bar/candlestick, representing all the 4 columns.

I already have a full fledged trading software that I can use for charting and execution. But, it is not capable of plotting charts from historical data.

Regards
ss4
 
xls has it.. But, it holds fine as long as we have just a few bars. If i am looking at a 2 min bar chart for a day in xls, it is not very nice..
1 more thing i find lacking there is that when i hover on a bar, no information is provided by xls regarding the OHLC prices.. (it is capable of displaying only 1 of the data series when we click on a point)
 
Top