16 Replies Latest reply: May 26, 2015 3:16 AM by Joaqu�n L�zaro RSS

    Question about candlestick.

    Giuseppe Gallina

      Hi,

       

      I need to create a graph with candlestick, I try using example but dont work.

       

      For example I have the following data:

       

      DateInvoice NumberAverage Price
      14/01/201411.70
      14/01/201421,55
      28/01/201432.50
      05/02/201442.25
      18/02/201483.10
      15/04/2015202.85
      18/04/2015223.00
      05/05/2015322,78
      07/05/2015722,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.