Registered User Joined: 10/25/2008 Posts: 218
|
Hi Bruce,
I know the pcf for the 2 period wilder's rsi which is below. Is there a way to add to the pcf a specfic datwe? For example, I want to scan a watchlist for the 2 period rsi value on 10/15/14.
Thank you
50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you want to use dates for the calculations, you would need to substitute dates for all of the bars ago parameters.
50 * (C'10/15/2014' - XAVGC3.'10/14/2014') / 2 / (.50003052 * (ABS(C'10/15/2014' - C'10/14/2014') + .5 * (ABS(C'10/14/2014' - C'10/13/2014') + .5 * (ABS(C'10/13/2014' - C'10/10/2014') + .5 * (ABS(C'10/10/2014' - C'10/9/2014') + .5 * (ABS(C'10/9/2014' - C'10/8/2014') + .5 * (ABS(C'10/8/2014' - C'10/7/2014') + .5 * (ABS(C'10/7/2014' - C'10/6/2014') + .5 * (ABS(C'10/6/2014' - C'10/3/2014') + .5 * (ABS(C'10/3/2014' - C'10/2/2014') + .5 * (ABS(C'10/2/2014' - C'10/1/2014') + .5 * (ABS(C'10/1/2014' - C'9/30/2014') + .5 * (ABS(C'9/30/2014' - C'9/29/2014') + .5 * (ABS(C'9/29/2014' - C'9/26/2014') + .5 * (ABS(C'9/26/2014' - C'9/25/2014')))))))))))))))) + 50
-Bruce Personal Criteria Formulas TC2000 Support Articles
|