Candlestick bar colors

Optuma General Discussion
1

Hi, I have been trying to create a custom candlestick color chart. Please see attached chart. The top chart is what I want to end up with but the 1 show bar numbered bars should be in black. I have attempted to do this in the second chart with the pink bars but when I select my green and red bars in custom colour scripts in the second chart the green candlesticks are overriding some of the pink candlesticks - which they should not.

Can someone please let me know what I’m doing wrong.

Thanks,

Karen

OptumeSent-01.04.2020.owb (40.1 KB)

2

Hi Karen,

It appears that the conditions are not mutually exclusive, ie a candle can have more than one custom colour, so the order of the scripts will determine which colour is selected.

If you change the order of the scripts (click and drag the 3 horizontal lines up or down) are the correct colours used? Note they will be black if none of the conditions are true.

Capture

3

Thanks.