Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank you very much.
Sorry if the example was not perfect, I do this in a few minutes.
Now I have another problem, I dont have Average price so I can calculate this in the script but I have average price = 0 also...
Okay, now I fix this.
Thank you again!
Sorry but I'm here again.
I must to use the first value with FirstSortedValue(DISTINCT [Average Price], Date) but I need this is higher zero...
Please can you help me?
Thank you very much.
I have solved!
With a SET analysis!
min({<[Average Price]= {">0"}>}DISTINCT [Average Price])
Thank you!
Excellent. Congratulations!
-Rob
Thank you very much!
I attach your file file that I have change with color and fix the problem of Average Price = 0.
I dont know if I can change colours to Middle line and whiskers but this is good, I think!
Thank you again!
Hi,
thank you very much JoaquinLR but my problem was find the data (max, min, etc.).
Anyway I do this Yesterday.
Best regards.
Hi Giuseppe:
I wrote this message yestarday but it was under moderation !!!!
I'm glad you have solved it.
See you
Joaquín