Hi,
I need to create a graph with candlestick, I try using example but dont work.
For example I have the following data:
| Date | Invoice Number | Average Price |
|---|
| 14/01/2014 | 1 | 1.70 |
| 14/01/2014 | 2 | 1,55 |
| 28/01/2014 | 3 | 2.50 |
| 05/02/2014 | 4 | 2.25 |
| 18/02/2014 | 8 | 3.10 |
| 15/04/2015 | 20 | 2.85 |
| 18/04/2015 | 22 | 3.00 |
| 05/05/2015 | 32 | 2,78 |
| 07/05/2015 | 72 | 2,83 |
I need to have i the diagram one candle every MonthYear and the candle have:
- the higher candle's shadow limit is the higer Average Price of the MonthYear (for example jan 2014 = 2,50);
- the higher limit of the body of candle is the last Average Price, if the last Average Price is higher of the first Average Price of the
MonthYear, or the first Average Price, if if the last Average is lower of the first Average Price of the MonthYear;
- the lower limit of the body of candle is the first Average Price, if the first Average Price is lower of the last Average Price of the
MonthYear, or the last Average Price, if the first Average Price is higher of the last Average Price of the MonthYear;
- the lower candle's shadow limit is the lower Average Price of the MonthYear (for example jan 2014 = 1,55);
- the candle's color is green when if the last Average Price is higer of the First average price, red if the last average price is lower of the
first average price.
Pleaee anyone have any idea?
Thank you very much.
Best regards.
