How to build a intraday candlestick?

Hi I have data like this and I want to put it in a chart type called candle stick.
Usualy candlestick are for daily use, but also can be unse intraday.
So to create a candlestick you need the data fo $
- At the bigenning of the minute
- At the top of the minute
- Bottom of the minute
- Close of the minute
Time Volume $
14:22:45 750 1.22 +
14:22:36 500 1.20 +
14:22:30 1000 1.19 +
14:22:27 559 1.20 +
14:22:24 500 1.20 +
14:22:03 1000 1.20 +

Volume is the quantity of shares in the transaction.
You can find the candlestick graphic in excel into Stock market type of graphic.

- What I need I thing it is a macro or a formulat that will extract the 4 data mentionned above.

So here the data will be the price

- At the bigenning of the minute 1.20$
- At the top of the minute 1.22$
- Bottom of the minute 1.19$
- Close of the minute 1.22$

Originally Posted by oldchippy

Does this link help?

http://peltiertech.com/Excel/Charts/stock.html

Thanks helpfull for daily candlestick, but I am looking for intraday candlestick.

As an aside, you might wonder what an intraday candlestick is?

Well, I am no day trading expert nor a technical analyst of stock markets, but statistically speaking, there can be high, low, open and close values for any given interval. Although, on a busy day, you might find that close of a 10 minute interval is equal to open of the next 10 minute interval. But, these days, the stock markets are seldom busy (unless you are busy selling ). Again, I digress. So going back to the intraday candlestick charts,
trading tips
nifty tips
MCX tips