styliten
303 posts
msg #149562
- Ignore styliten |
11/9/2019 3:12:42 AM
Need to combine 4 distinct groups of stocks into 1 dynamically updated combined list:
1. Group 1 criteria:
a. Market Cap > 300
b. Average volume(30) > 600000
c. Day change > 4.5%
2. Group 2 criteria:
a. Market is S&P 500
b. Day change > 3.5%
3. Group 3 criteria:
a. Market is Nasdaq 100
b. Day change > 2.5% (so if a ticker belongs to both S&P 500 and Nasdaq 100 with a day change of 3.0% should be picked up here, because it failed to meet the Group 2 criteria)
4. Group 4 criteria:
a. Market is Dow 30
b. Day change > 1.5% (Dow 30 stocks are also part of S&P 500 and Nasdaq 100, but their average day change is typically smaller since they are Blue Chip stocks, so any day change > 1.5% would be picked up right here.)
Now how to combine groups 1 thru 4 into a "Total_Group"?
|
compound_gains
222 posts
msg #149566
- Ignore compound_gains |
11/10/2019 3:07:05 PM
|
styliten
303 posts
msg #149567
- Ignore styliten |
11/10/2019 6:11:14 PM
Thank you compound_gains!
The only minor change I could think of is that there is a "market cap" keyword already, i.e., count(market cap > 300, 1) > 0.5
|
styliten
303 posts
msg #149573
- Ignore styliten
modified |
11/11/2019 1:21:14 PM
Issue solved.
Sorry.
|