| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 6/13/2005
Posts: 5
|
Hi, I need to find stocks with are up vs 12/31/2016. And i'll run this scan daily so I can't say look back X days since every day X will increase by 1.
erik
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Personal Criteria Formula.
C > C'12/30/2016'
If you want to actually calculate the percent change since this the last trading day of 2016, then you could use the following.
100 * (C / C'12/30/2016' - 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/30/2017
Posts: 1,227
|
Cool. I'd forgotten you can hard code dates in PCFs. Always learn (or re-learn) something cruising these forums!
|
|
Gold Customer
Joined: 6/13/2005
Posts: 5
|
Great. Thank you for your reply. It would be great if I actually got an email alert once you replied to my post or anyone else commented on the thread.
|
|
Registered User
Joined: 9/17/2010
Posts: 484
|
Try Watch This Topic Button above
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Unfortunately watching topics and forums no longer sends notifications and I don't know when or if it will be fixed (it broke when the forums got moved to a different server).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/30/2017
Posts: 1,227
|
Yeah, been there and done that. The watch-this-topic feature is broken.
dowmaster, the good news is that Bruce is very prompt and you can almost always expect a same day response ... except on those days when he's vacationing on his yacht in the Hamptons.
|
|
|
Guest-1 |