Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Wilder RSI 2-period Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
andrepare
Posted : Thursday, November 3, 2011 6:47:01 PM
Registered User
Joined: 12/26/2009
Posts: 50

How can I write a PCF for stocks with Wilder RSI 2-period above 90 for 2 consecutive days? Thx,

Bruce_L
Posted : Friday, November 4, 2011 8:55:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Please try the following:

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 > 90 AND 50 * (C1 - XAVGC3.2) / 2 / (.500030519440884 * (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) + .5 * (ABS(C14 - C15)))))))))))))))) + 50 > 90

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
patonet
Posted : Thursday, November 17, 2011 12:28:04 AM
Registered User
Joined: 12/12/2007
Posts: 10
I copy and paste this text on a Condition and appears an error message: "Formula Error". Maybe some parentheses missing?
Bruce_L
Posted : Thursday, November 17, 2011 7:59:52 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The formula as provided has absolutely no errors. Some thoughts would be that you did not copy and paste the exact formula or that you are not using US Regional settings in Windows. If you are not using US Regional settings, you would generally need to switch the commas and periods in the formula (or switch Windows to use US Regional settings).

If neither of these suggestions are the issue, please contact technical support.

All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival.

For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays, some Market Holidays or after 9PM ET on weekdays).

You can also contact us using Live Chat Support during business hours.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.