SinceTrue(b, x) -> returns -1 if Boolean Formula was not true in period, or bars since it was true, 0 being the current bar, and period-1 the max it will return
For not true in period, I would like to replace -1 with max return value.
This is the best I can think of:
(SinceTrue(b,x) = -1) * (x-1)
-
(SinceTrue(b,x) > -1) * SinceTrue(b,x)
It seems kind of long. Is there a more efficient way to accomplish the same?
thank you
|
Hi Bruce:
Cancel that request. Figured it out.
STOC13.3 * (ABS(AVGC26 > AVGC65) + (AVGC26 < AVGC65))
It's not as useful for sorting a watchlist as I thought it would be. But, at least I learned something and didn't have to waste your time.
thank you
|
Hi,
Would like a PCF that displays:
1. the value of (STOC13.3) when XAVGC26 > XAVGC65, and
2. the value of (STOC13.3 * -1) when XAVGC26 < XAVGC65
thank you
|
Hi,
Can I get the PCF for the 5 period Trix?
Thank You
|
Hi Bruce,
I'd like to turn those three PCF's into an indicator. When I overlay the 3 PCF's, the dots are at different heights/values. Can you modify the formulas so that when overlayed, they produce a straight horizontal line of different colored dots?
thank you
|
The price is currently below the 13 period moving average.
I want to set an alert for when price moves above the 13 period moving average.
I click on the moving average listed above the price chart.
I see options in the expanded sublist: Moving Average 13 vs Price History.
Question: What is the difference between the options
1. Below Price History, and
2. Crossing Down Price History ?
Does one of the options wait for the bar to complete or close above the moving average?
thank you
|
What are the best features of V16?
Number 3 is probably ... Slide Show
Nnumber 2 would have to be ... Custom Sort
And The Number 1 spot is everyone's favorite ... BRUCE L
Have a great day!
|
Hi Bruce,
-- Request --
Can you help me set up a watchlist column to do the following:
Condition 1, STOC13.3 < 45 and XAVGC21 > XAVGC34 column displays -1 (or +1)
Condition 2, STOC13.3 > 65 and XAVGC21 < XAVGC34 column displays +1 (or -1)
When both Conditions are false, column displays 0.
It doesn't matter which condition is assigned the +1 (or -1) as they'll be color coded anyways.
------------------------------------
-- Question --
If above request were restated as follows,
Can a watchlist column be set up to display the value of (STOC13.3 * 2) - 100 when either condition is true
[(STOC13.3 * 2) - 100 < -30 and XAVGC21 > XAVGC34] or
[(STOC13.3 * 2) - 100 > 30 and XAVGC21 < XAVGC34]
and display 0 when both conditions are false.
I don't have a use for this, I'm just curious if it can be done.
thank you,
carlson
|
Hi Bruce,
Please cancel above request.
I just realized that I can take the formula you gave me earlier and just change the value of the moving averages.
Again, Thank you very much.
|