ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
VVODCHDWRBFICONIJNPRCNXCAXSGLPG#REF!#REF!--1/29/202234,576NI#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!--1/29/2022
2
123456789101112DJIA123456789101112
3
Stock Screener - Gap up on Volume
(results in cells A1 to L1)
-
Screener - New High on 3x Volume
(results in cells P1 to AA1)
Original Idea from
4
https://finviz.com/screener.ashx?v=111&f=cap_midover,sh_relvol_o2,ta_change_u3,ta_sma50_pa&ft=4&o=-marketcap
screener link
https://finviz.com/screener.ashx?v=111&s=ta_newhigh&f=cap_smallover,sh_relvol_o3&o=-marketcap
https://jbmarwood.com/scrape-stock-data-from-finviz/
5
|B|A12,26,9|0
-
6
CONCATENATE(A15,",",B15,",",C15,",",D15,",",E15,",",F15,",",G15,",",H15,",",I15,",",J15,",",K15,",",L15,",",A5)
-
CONCATENATE(P15,",",Q15,",",R15,",",S15,",",T15,",",U15,",",V15,",",W15,",",X15,",",Y15,",",Z15,",",AA15,",",A5))
7
V V V click on cell A9 to open stockcharts.com in a new tab
-
V V V click on cell P9 to open stockcharts.com in a new tab
8
#REF!link to SC#REF!
9
https://stockcharts.com/freecharts/candleglance.html?
https://stockcharts.com/freecharts/candleglance.html?
10
11
SPXSPX
12
dMACD
wMACD
8dMA21dMA
13
ULVODTRVDVNMTBFOXACFCNXCKSSMCYIBOC#REF!--1/24/202234,330BTI--1/24/2022
14
NEMGOLDKLAEMSSLGFIAUWUSILPAASTGNAPSLV--1/19/202235,015ZGNX--1/19/2022
15
WFCLVSWYNNBPOPONTOMLCOUCTTODPHMHC--1/14/202235,849KENMOLN--1/14/2022
16
BMYBTORPRXZNGAJAZZWFIRTCAJRDTHRMPTCTBCRXNMIH--1/10/202235,942WFSGMLMOLNSBRACV--1/10/2022
17
TSMFCNCACITISBCGHCFOLDTACPTCTIBRXVSTOCGAUVRRM--1/07/202236,427TACKENITOSVECOAPTS--1/07/2022
18
TSMFCNCACITISBCGHCFOLDTACPTCTIBRXVSTOCGAUVRRM--1/03/202236,427TACKENITOSVECOAPTS--1/03/2022
19
ZBRAUREGDDYOPKARCBGDYNOASHLTH--12/30/202136,153#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A--12/30/2021
20
ZBRAUREGDDYOPKARCBGDYNOASHLTH--12/27/202136,153BRDGINVE--12/27/2021
21
OCDXSIMMRCYOPKBRDG--12/23/202135,848BRDGACV--12/23/2021
22
PAYXVOYAITCIACADLEN-BCNNE--12/22/202135,663PAYXITCIBRT--12/22/2021
23
NKEMUEXPEHNPCTXSAGLBHCHITCIARNCCNNEERJ--12/21/202135,398ITCIEPAY--12/21/2021
24
ARGXAGLROIVQDELCOKECITACADITCIFLGT--12/20/202134,907ITCIAPTSVRSBRGJWEL--12/20/2021
25
PFEACNNVSBTINEMEDRVIRHCMTMXNEOGAJRDCUBI--12/16/202135,725CUBILWLGCSVTCDAPFIS--12/16/2021
26
PFETMLLYPGRFERGPKITNDMIIVIVIRPACCCMPLOB--12/15/202135,825FERGGCPIMKTAUVEITMR--12/15/2021
27
CNCESLTLITEVIRTMXVIRTNEOGMCG--12/14/202135,505SOLY--12/14/2021
28
ORCLAVGOCOSTBTIBZJBLLITERRRASOHHREPAYLWLG--12/10/202135,888ORCLAVGOCOSTFERGOCN--12/10/2021
29
CVSHRLBZHNPCIENLITEEVGO--12/09/202135,630CIENBSIGPLAB--12/09/2021
30
EPAMSWKNVRARGXEMBKPAYUNFIMFA--12/08/202135,746SIMOUNFIKENLWLGNFHPLABSPLPTACO--12/08/2021
31
INTCMRVLASXBLDRZIMTRUPHCMMIMEMGYKNBECPGRXRX--12/07/202135,755MRVLFRTRUPSIMOKENLWLGPTNRTACO--12/07/2021
32
LIUREPCGHNPHTZTOLOMCLKBRMCWAWICIVIUNVR--12/06/202135,233NNIEVTCGCPPTNRTACOCBAH--12/06/2021
33
MRVLAPPTNDMEVTCCBTDNUTSIMO--12/03/202134,559MRVL--12/03/2021
34
SNOWSNPSCTASROK
FWONA
KRSUICLVTRHIFIVEDRVNUBSI--12/02/202134,508--12/02/2021
35
AMATVRTXHPQUMCNVRCIBAMBAROIVFNMSPBOX--12/01/202134,105NVRAMBAMDPGCPMGPIAOSLCARSBBW--12/01/2021
36
AAPLXPEVCVACVIRIFSSWIMNVTS--11/30/202134,592MAAUDRNUANNVEECARSCPLP--11/30/2021
37
MRNAMCOLITLKMAAENTGHTZBERYPSTGCVACVIRPDCO--11/29/202135,128SITMUFSCVAFLNGCLMTCARSKRYSREAXIRMD--11/29/2021
38
PFEMRNABNTXBRKRCVACFLGTENTANVEE--11/26/202134,630NVEECARSMPB--11/26/2021
39
DERBLXXPEVDELLHPQHTZPSTGRLXSITMDADAGOEV--11/24/202135,827HPQPSTGMOVDHILLGVNIRMDADEX--11/24/2021
40
SQMENIABCHBSACRLXVGHCMURBNASTRTRQGOEVNVTS--11/22/202135,608RBLXVGFRGPTNRAOSLSGMLCLMTTMSTTITNRMUFPTDMYQ--11/22/2021
41
INTULCIDMURBLXZTOTLKAURBMRNAXONKRNTMTZZIM--11/19/202135,581INTUTLKAURKRNTFLOWAMTBSIGASTXBDMYQ--11/19/2021
42
NVDAUZTOAURMGPSKSSBJKRNTARWRHGVZIM--11/18/202135,804QCOMRBLXONONDOCNALVMTTRHAYWIONQTBKLFGPIEXTR--11/18/2021
43
HDQCOMLCIDRBLXTTDMFCLISUIMNDYFNDONONDOCN--11/16/202136,086QCOMRBLXONONDOCNALVMTTRHAYWIONQTBKLFGPIEXTR--11/16/2021
44
BATTDTSNDLTRPFGQSCONELAZRCORNEGGMTTRAMEH--11/15/202136,038TDDLTRCONECORAMEHVGRGGPIMGICPERIACCLFDREAX--11/15/2021
45
SHOPABNBDASHRBLXTTDSMFGLHFTCHCONESMARDNBMP--11/12/202136,028SHOPSTXCONENFGCAMTASTLPDFSXPOFBWTRNSKRUSIRMD--11/12/2021
46
DASHRBLXUAPPAFRMSTXNICESOFIQSTECKOPENDISCA--11/11/202135,909APPIASNVMIMLIPVGASTLSEAHTHRYSFLLEUPDFSBGFV--11/11/2021
47
DASHDIDIRNGRRRSAILNARICARGEVGOCOKESSRMPAYSTEM--11/10/202135,964UCARGPVGZETAPDFSIHCFCCRFNVTSRLGT--11/10/2021
48
AMDFLCIDXLNXTTDMLMEXPEVTRSQSBKICHPTCOTY--11/08/202136,288XLNXRYAAYCOTYNEWRIONQNPOTSLXAOSLALRSSNIIEYPTOCN--11/08/2021
49
PFEQCOMABNBBKNGLCIDAMXDDOGCNQMNSTBILLDALCCL--11/05/202136,173DDOGLYVCFLTSYNAPGNYVGNVMIIONQCDXSMNRLNTHENTA--11/05/2021
50
NVDAQCOMFANSSETSYPATHTTWOTXGSQMLUMNOPENTS--11/04/202135,986NVDAETSYSQMGILPLNTWKESIPZZAPRFTNVMIPRMWVSTO--11/04/2021
51
CVSVRTXDDANETWAKAMGMEACIFMCUAASYNHCPRI--11/03/202136,038RACECPRILIVNNTCTVLDWFRDSMCIVRTVFRGMGPIDFINTVTY--11/03/2021
52
PFEELKKRSPGRACEDDROKANETMCKAMEZBRAIT--11/02/202135,920NTRROKANETZIBENSQMUAROGUNVRFNBDCFWRD--11/02/2021
53
TSLAIBKRCSONPLUGSBNYSOFIBENWOLFPLTKPSXPSGMS--11/01/202135,788RACEON
FWONK
HLISINVMIIONQRXDXPERICAPLNOTVANIP--11/01/2021
54
MRKSHOPNOWBUDGSKFLCIDSPOTKLACABEVSUENPH--10/28/202135,649FWPPMXLLCBOOTBSIGCDMOASLESMLRNOAFMNBHUDI--10/28/2021
55
MSFT
GOOGL
GOOGSPOTENPHTERSEDGMNDYHNPMASFFIVBG--10/27/202135,423
GOOGL
RDS-AMQFFIVJNPRSLABESLTSEAHASLEHUDIKULR--10/27/2021
56
UPSCNCMQEDRMEDPESLTDDLCRSSTKMECALXTTGT--10/26/202135,624TSLARACEMEDPCDMOSEAHPERIFPACHBMDCNDTCI--10/26/2021
57
TSLAIBNSTLALCIDXPEVMQICLCHKBESMPLEVAHHR--10/25/202135,646TSLAIBNSMPLAUPHCTLPIPIBFSTNRPAMNB--10/25/2021
58
LYGAPOSTXSKMWRBCLFOLNBLDMESMPLPAY
RUSHA
--10/22/202135,493MCBXPDINVSA--10/22/2021
59
NFLXMTCHDIDIAPPHPQXMGPCBMBLKNXCROXANTHC--10/21/2021RJFSTNUNITKDMNTSCMCBMGTXCEPUNRPPBTGWGH--10/21/2021
60
ANTMPINSNTRSMQCONEKNXWTFCHWCWNSSIIASSFNC--10/20/202135,425NDAQWTFCHWCWNSMGTXSHPWXPDIUROYNRPPBTGPP--10/20/2021
61
COINAPOASANATHXPROIQBBFSLYSPWRMARATRUPFLR--10/19/202135,327APOMGTXBRYNRPPBT--10/19/2021
62
COINNETAFRMVEDLSOFIIEPOPENCCJMDVMARANXE--10/18/202135,113EVANEXACEIXFLNGASLELEUMGTX--10/18/2021
63
DDOGAFRMHUBSTTMPLUGCCJVSTPNFPCYBRINMDTASKBLDP--10/14/202134,301TTMNXEBCYCSMLRLEUFLMN--10/14/2021
64
AFRMHUBSTTMMGMDNASEDGSOFIAZPNCCJVVVMATXNXE--10/12/202134,310HUBSTTMMGMAZPNVVVFBNCIPIFLMNINSE--10/12/2021
65
SOFIICLAZPNCIGSPWRCWENPAM--10/11/202134,340TWNKPAMFBNCCCRNSBOW--10/11/2021
66
AFRMAPAUNMMNTVINSMCCXISTGW--10/08/202134,620BCYCCLMTRENNBFSTEZPWEBTC--10/08/2021
67
Missed checking at the end of the day
--10/07/202134,672TTMTGLSBCYCCPRXRGPBFSTRENNSLCT--10/08/2021
68
PTRHSBCICEMRVLNETAFRMGFLDNBAYISITMSISDC--10/06/202134,296MRVLAYITWNKRMNIRVISLCT--10/06/2021
69
NFLXNETDAVAOMCLJAMFSWXMEOHSIHP--10/05/202134,180EVICRMEOHNAPAEURNXENECEIXCLMTSBRVISTFLMNREI--10/05/2021
70
APTVWMBLNGOVVEQTVICRPDCEVNESIHPAVIRWHD--10/04/202133,893MRKTGPARLPXENECEIXAVDLRVIVISTFLMNSBOWREINRP--10/04/2021
71
MRKMARNTRHLTLYVCFICLARMKCHHWCCTRIPSPWR--10/01/202134,230MRKCFSTMPLAURGOGOCDXSOPRXFLNGMETC--10/01/2021
72
EAWMGCCJPRGOGENIINSMAVIREVHARCB--9/30/202133,811PRGOUNFIGOGODOLEOPRXARLPCINR--9/30/2021
73
LCIDDLTRXECCOGTHODAVANEORBCINMDSPRHAINUNFI--9/29/202134,335XLRNXECCOGUNFIEVHSLI--9/29/2021
74
FITBECTTMSBNYKLGRFSBAPXLRNAPAHESMEQTCIB--9/27/202134,737MUFGEXLRNHESMSWNLAURGOSSMCBAPYXERC--9/27/2021
75
CRMDELLUAFRMMGMDRIDLONWSANWSCFQSACM--9/23/202134,654INMDMICPAVMDMLPTHTXTCI--9/23/2021
76
MGMHNPSOFIAPAAMBANOVTSPSCARQQSBSBBUTSEMSPIR--9/22/202134,197AMBAARQQSPIRDVAXCLS--9/22/2021
77
RDS-ARDS-BUBERMUFGLCIDSGENWMGBHCQSXLRNNOVTTGNA--9/21/202133,758WMGXLRNTGNAARQQNOTVCVLGCNF--9/21/2021
78
LCIDBRKSACHCIRNTARQQAVIR--9/20/202133,804ARQQ--9/20/2021
79
TMOLCIDBGNEMOHSEDGFANGIVZGLBEGRFSTASKIMABTWST--9/17/202134,370TMOBXHCABGNEHIGASANTECHRGENPCTYMBTDOCNWK--9/17/2021
80
KKRPLTRAFRMASANDOCNCARFIGSANGIELYABCLCWMTTR--9/16/202134,575ASANDCBOIRNTGSKYOPADMCBITMRDEHUROYCNF--9/16/2021
81
CNQCPRTFSVXECWSCALGMCANORRCABCLSANAMTTRJAMF--9/15/202134,716FSVALGMASODCBOIRNTGSKYUUUUNSSCHIFSSBVERAUEC--9/15/2021
82
ZIRPRXTECKDECKCROXANGIOSCRTROXTSEM--9/14/202134,486AVTRCROXSTNGSKYUUUUISEEITMRBLUCNF--9/14/2021
83
DELLACHSSLGLBEDOCNALGMCERTUMPQYPFVGTROXRLAY--9/13/202134,803ACHCCJDOCNSTNYPFTROXNXEGGALBMABBARRDWRGSKY--9/13/202144downdown
84
MTCHPTONAFRMAPPPLTKISBMBLGLBECCJDAVACANOALIT--9/10/202134,526IXCCJMEDPNXEISEEECHOAMRKMETCERC--9/10/2021
85
LULUWLTWAFRMACHRHUAASMARRKLBAMBACIGSANAKFY--9/09/202134,919LULUACHWMGRKLBAMBAGSKYSLRCPMTS--9/09/2021
86
GISACHRERKLBPRGOICUIGENISPBGSAT--9/08/202135,012LBTYACCJICUISPBGSKYKDMNCLMTPMTSKZR--9/08/2021
87
PDDMTCHRLXCCJTNDMRKLBSHICLOVLYELRLAYPHRFYBR--9/07/202135,070CCJTNDMRKLBSHILYELFYBRKENCODIGDYNMTLALEXTGP--9/07/2021
88
DOCUMDBHNPPCORGWRENTNXCCJDOCNRKLBSHIAMBAMTTR--9/03/202135,341CNIMDBCCJAMBANXECODIALEXTGP--9/03/2021
89
SPOTBAXAPPACHPWRACIASANCACCHRCASNDNTNXCCJ--9/02/202135,432PWRASANCACCHRCNTNXAMBACODIGSMCSRBCYC--9/02/2021
90
CNIAPPKSUGRUBDLOCEAPLANASNDPVHCANODADACIG--9/01/202135,288CNIDLOPVHDVAXCODIGSMRMRBCYCPAVMEVC--9/01/2021
91
CNIWBAYNDXMBTPFGCASHBRPVGWDSEERDVAXLGND--8/31/202135,382SECNIYNDXTDYDVAXECPGRMRGSMATLCPXLW--8/31/2021
92
PYPLAFRMACHGLBEHRCPSTGIRDMFLYWGSATMTTRGGALBMA--8/30/202135,395HRCVEONGGALDVAXGSMMTLPLYMIHCDSPGCVLG--8/30/2021
93
WDAYBILLUIASXBMRNPCORJOBYDCTUMBFSANAAGIVEON--8/27/202135,410BILLDVAXGSMGAMB--8/27/2021
94
SNOWNTAPWSMDKSMRTXASNDCOTYPSTGPHIAPLSALITYY--8/26/202135,195
FWONA
ULTANTAPWSMDKSBLFSDVAXRMRGTSSPRT--8/26/2021
95
TSMDKNGULTAWMGSUZPENNDKSISOLOKCEYEMIME--8/25/202135,383CRWDPANWULTADKSOLOHTAMIMEOPCHBLFSDVAXRMRSCVL--8/25/2021
96
MDTJDABNBCRWDPANWBBYGMEJWNNRZURBNCWHERJ--8/24/202135,303PANWHNPWKOCSLGTS--8/24/2021
97
BTOXLNXMXIMASXHNPDOCNZIMSPSCVEONALXOTRILETWO--8/23/202135,328MXIMHNPKENMTLCIOLMRK--8/23/2021
98
MWOOFSANACWSTJBI--8/20/202135,065MCWSTVALU--8/20/2021
99
CSCONFLXSNPSDLOCBOEHNPKSSMINOVAXNXHHR--8/19/202134,859SNPSDLOINOV--8/19/2021
100
LOWTJXPLTRALCMNDYAVALVIRDOCNPINCTASKDCBOLAC--8/18/202134,869PFEALCCBOE--8/18/2021