joepistell 37 posts msg #157441 - Ignore joepistell |
8/26/2021 6:16:59 PM
I am looking at the column 'Perf(%)' 100 trading days back. I'd like to know what 'Perf(%)' was happening in between. HELP. Is there a SF formula that can show me an additional column of the 'Perf(%)' say... 50 trading days back?
Example I fetch stocks, go 100 trading days back (April 6,2021 to today), I lets say I get one stock.
I see the Default: 'Perf(%)' = 22.5%
I'd like to see the Perf(%) 50 days back (April 6th to June 16)
DId I explain this right? Looking for SF code to display performance within the lookback period.
|
Cheese 1,374 posts msg #157442 - Ignore Cheese |
8/26/2021 9:05:10 PM
joe,
maybe something like this, using your day counts.
good luck
|
wantonellis 161 posts msg #157450 - Ignore wantonellis |
8/27/2021 1:31:36 PM
Example I fetch stocks, go 100 trading days back (April 6,2021 to today), I lets say I get one stock.
I see the Default: 'Perf(%)' = 22.5%
I'd like to see the Perf(%) 50 days back (April 6th to June 16)
Take the stock(s) from 100 days back and add them to a watchlist. Then in "Watchlist Actions" select run as filter and go back to April 6th and advance 1 day till June 15th. You'll see Perf(%) for each day.
|
nibor100 1,046 posts msg #157452 - Ignore nibor100 |
8/27/2021 5:28:21 PM
@wantonellis,
I'm not quite following how your suggestion will give the Perf(%) 50 days (April 6th to June 16) .
As I understand the Perf(%) column in SF, it is measuring the performance from the date the filter is run on, in the past, to today's date, no matter whether we use offsets or not.
It appears to me that on Jun 15th that performance column will show the percent change from Jun 15th to Aug 27th not the percent change from April 6th to Jun15th on the one test I tried.
Perhaps you have a clarifying example?
Thanks,
Ed S.
|
joepistell 37 posts msg #157457 - Ignore joepistell |
8/28/2021 7:43:14 AM
wow, Awesome sauce Cheese! ;-)
|
Cheese 1,374 posts msg #157458 - Ignore Cheese |
8/28/2021 12:50:38 PM
@joepistell
I'm glad I've been of help.
good luck with your trading.
|