mrstocky 2 posts msg #149412 - Ignore mrstocky |
10/25/2019 4:11:32 AM
Could I please ask if there is a filter tool/phrase that provides results of only new filtered results that was not in prior day's filtered results?
E.g
yesterday the filter results were FB, MSFT
today's filter results are FB, MSFT, AMZN
Can I use a phrase to exclude FB & MSFT from today's filtered results and just give the new name that has appeared ie. AMZN?
You can imagine if the filtered results return many names everyday.
|
xarlor 585 posts msg #149416 - Ignore xarlor modified |
10/25/2019 10:43:35 AM
My solution would be to use count for past 2 days and only return the results where the condition happened once. This will exclude any results that happen 2 days in a row.
Example without count.
AAPL condition triggered yesterday and today
MSFT condition only triggered today
Example with count:
Only show results that triggered today but not yesterday.
|
nibor100 1,042 posts msg #149418 - Ignore nibor100 |
10/25/2019 2:11:03 PM
Here's an alternative to consider without a set statement for those with the basic subscriptions and longer filters.
:
Ed S.
|
mrstocky 2 posts msg #149458 - Ignore mrstocky |
10/28/2019 9:37:35 AM
Thanks. I will try out the suggestions!
|