I want to create an OHLC chart with selected times and no gaps between entries. The grid below won't chart this way as it adds times with no data. I only want to show the data on spreadsheet.
Time Open high Low Close
3/16/10 12:00 AM $15.45 $18.07 $15.45 $18.07
5/6/10 12:00 AM $18.07 $19.50 $17.31 $17.31
5/20/10 12:00 AM $17.31 $18.44 $16.26 $16.26
6/29/10 12:00 AM $16.26 $16.66 $14.48 $14.48
7/26/10 12:00 AM $14.48 $16.14 $13.88 $16.14
8/26/10 12:00 AM $16.14 $16.52 $14.50 $14.50
9/20/10 12:00 AM $14.50 $16.55 $14.48 $16.55
12/16/10 12:00 AM $16.55 $17.77 $15.76 $17.77
1/21/11 12:00 AM $17.77 $19.74 $17.70 $19.74
2/18/11 12:00 AM $19.74 $21.52 $19.92 $19.94
Bookmarks