Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 1/23/2014 Posts: 10
|
Does Tracking % (trk%) reflect stock splits? It seems like it does not.
Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
No, it does not take into account splits.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/23/2014 Posts: 10
|
Then is there any way I can find performance of an equity from a certain date?
Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Custom Date Sort should take into account splits.
Basics of Custom Date Sort (5:32)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/23/2014 Posts: 10
|
Custom Date sort is static. It is not exactly what I want. I want something like P&L% for a watch list column, something that reflects price change dynamically.
Is it possible to access trk% and stock split information in PCF?
Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
No, it is not possible to reference any of tracking values or split information in a Personal Criteria Formula.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/23/2014 Posts: 10
|
Just out of curiosity, if trk% doesn't reflect splits, what is this for?
How can I use trk%?
Thank you.
|
|
Registered User Joined: 4/8/2008 Posts: 37
|
H'12/19/17' have this to tell me what was yesterday's high, and I have this to tell me how much the stock is up from yesterday's high (C-H'12/18/17')
Now I want to know how do i write a formula to know the percentage gain or loss from today's price and the high of 12/19
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
100 * (C / H'12/19/2017' - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 4/8/2008 Posts: 37
|
thanks it worked
|
|
Registered User Joined: 4/8/2008 Posts: 37
|
100 * (C / H'12/19/2017' - 1) CAN we add make the value to show with negative or positive sign and the percentage change sign?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It should show a negative sign, but there is no way to add the positive sign or the % symbol.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |