How to Format Data for OHLC charts

with tags excel DokuWiki -

HOWTO: Format Data for OHLC charts

Format data in this manner:

Date Open High Low Close
1/1/12 4.72202 5.4999 4.615 5.26766
1/2/12 5.26766 5.47 4.8 5.21678