TRUEINROW(C > AVGC50,100)

The result is the number of bars that the close has been above the 50 bar average.  If C is less than AVGC50 on the latest bar it will return 0.

No, use (C'12/30/16' - C'12/31/15') / C'12/31/15' * 100

I looked at your profile and the only two condition columns I saw were Stoc 12,3 Daily Xup 80 and Stoc 12,3 Daily xDn 20.  You created those from the chart so they are set to update in real time. If you edit he column and change the refresh rate to anything other than Real Time, then you will see the Refresh option on the right click menu.

Bruce can answer when he gets back but I think the formulas are going to be lengthy.

You can get a pretty close approximation using the following:

(AVGC13 * AVGV13)/AVGV13

(AVGC26 * AVGV26)/AVGV26

(AVGC52 * AVGV52)/AVGV52

(AVGC78 * AVGV78)/AVGV78

Yes, we own the freestockcharts.com website.  Our privacy policy can be found here: http://www.worden.com/Products/PrivacyPolicy

There's a link to it at the bottom of this page as well.

Set the Force Index to 1 and the exp moving average of the force index to 13.

"a 13-Period Force Index is a 13-period EMA of the 1-period Force Index values for the last 13 periods"