In TC can we paint the price based on condition like SF? 

Nope, not exactly.

But Bruce has some alternative solutions, which are almost as good, which he'll be glad to describe in a few minutes. He can explain it much better than I.

I actually just asked the same question a few minutes ago, because I haven't done it in a while and need a refresher.

The technique is pretty much designed to work with Custom PCF Indicators and the Dots or Histogram Plot Style.

There are basically two formats. The first format should work in both v12 and v17.

(value you want plotted) / ABS(condition for when you want value plotted)

The way this works is that you are dividing by 1 when the condition is true and dividing by 0 when the condition is false. So the value is plotted when true and the division by zero error when false means nothing gets plotted.

The second format only works in v17.

IIF(condition for when you want value plotted, value you want plotted, 1 / 0)

The way this works is that the value you want plotted gets plotted when the condition is true and 1 / 0 (which generates a division by zero error) means nothing is plotted when false.

You generally need to plot a different Custom PCF Indicator for each color you want to plot. You can get two colors out of each Custom PCF Indicator when using the Histogram Plot Style as long as the colors are different when above or below zero.

Ok I will look at this tom

Also can TC plot indicators off of an excel like SF?

No, TC2000 does not have a way to import data and plot it on the chart.

Bruce I like to do a simple test to get a hang of this

IIF(condition for when you want value plotted, value you want plotted, 1 / 0)

I like to paint the price bar green when its > the 50 day average and red when < it 

How do I do this 

You can't point the price bar. You can plot a colored dot or histogram bar when something is true.

So you would need to plot two different Custom PCF Indicators with the Plot Style set to Dots in the same pane and scale as price. The first would be green.

IIF(C > AVGC50, C, 1 / 0)

The second would be red.

IIF(C < AVGC50, C, 1 / 0)

The dots would plot at the closing price, but you could change this by changing the lone C in the middle of each formula to a different value instead.

Can I make the size of the dots bigger

No, there is not a way to change the size of the dots in TC2000 v12/v17.

Other ideas thnkbigr,  put dots on moving averages.

Change dot to histogram and plot from low of bar to bottom of chart.

(this works best with spike type PCFs like moving average crosses)

Thanks