How to convert tick data into Candlestick chart

**cherrychan** · 02-20-2013, 07:11 PM

Dear all expert

i have huge tick data and want to create Candlestick chart

but the problem is the format

my data format is
Date Time Price
HSI 20120103 9:15:00 18879 1 20
HSI 20120103 9:15:00 18847 4 20
HSI 20120103 9:15:00 18833 2 1
HSI 20120103 9:15:00 18800 1 1

The candlestick chart require format is:
Date Time Open High Low Close
HSI 20120103 9:15:00 18879 18847 18833 18800
HSI 20120103 9:15:01 .....................
HSI 20120103 9:15:02 .....................

Open means the first price of 9:15:00
Close means the last price of 9:15:00
High means the highest price of 9:15:00
Low menas the lowest price of 9:15:00

any expert can help to create a macro for processing the conversion.

Thank you very much

**cherrychan** · 02-21-2013, 11:10 AM

Please help!!

**cherrychan** · 02-22-2013, 07:18 PM

please helpppp

**xlbiznes** · 02-23-2013, 05:06 AM

Hi,

Attached is your solution.

Hope this helps.

Happy Investing & Computing.

**outlook888** · 01-05-2018, 10:34 PM

I am looking for a similar solution but I want 5 minute candlestick from my tick data. The attach file is for every 4 data points.

Can someone help by editing the marco. Thank you.

**FDibbins** · 01-06-2018, 04:02 AM

outlook welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.