COMPANY | QUALITY CONTROL | PARSING | HOLDERS | FILE TRANSFER | CLIENT SCRIPTS | SCRIPTS | DONORWATCH | INTITUTIONS | MUTUALFUNDS | LINKS | |
|
Pricing Q/A Blank Q/A Ratios Q/A Dashboards DonorWatch Transactions t1 Derivatives t2 |
form
3 S
O
H
form 4 S O H form 5 S O H 13F 13F XML Derivatives-Dash Mutual Funds shares out 144/1 144/2 |
search
filers form 345 problem 345 144 Filings |
SEC All Filings
companies 9th Digit Scrapers |
Altair blank blank blank | scripts
predetermined e-mailing ranking splits Insert Pricing Problem & MV Pricing |
update scripts login Sneak |
update search scripts |
update scripts Show Funds QA Dates QA Matching QA Calulation QA Division QA Archiving QA Cal. Run |
email sec reports sec archive overture |
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SELECT * FROM `secSiteAllFilings` WHERE `rowForm` in ('144', '144/A')
and `processedForm` = 'no';
XXX update secSiteAllFilings set processedForm = 'yes' where rowForm IN ('144','144/A')
;
Keep the Below:
keep 144 144/A |
keep 3 3/A 4 4/A 5 5/A |
keep 13F-HR 13F-NT 13F-HR/A |
keep N-Q N-CSR N-CSRS/A N-CSR/A N-CSRS |
keep NSAR-A NSAR-A/A NSAR-B NSAR-B/A |
keep 15F-15D 15-12G/A 15-12B/A 15-12B 15-12G |
delete from `secSiteAllFilings` WHERE `rowForm` in ( '10-QT/A', '11-KT',
'15F-12B/A', '2-A', '2-AF', '20FR12B', '40-17F2/A', '486APOS', '8-K12B/A', '8-M',
'ADN-MTL', 'APP WDG', 'F-10POS', 'F-3D', 'F-7 POS', 'F-8', 'F-80/A', 'FOCUSN/A',
'N-23C3A/A', 'N-6F/A', 'N-8B-2', 'NSAR-AT/A', 'NT 11-K', 'NTFNSAR', 'QRTLYRPT',
'REG-NR', 'S-4MEF', 'SC14D9F/A', 'STOP ORDER', 'WDL-REQ', '1-E', '13FCONP',
'40-8B25', '40FR12B', '424A', '6B NTC', 'ADV-H-T', 'CERT', 'F-3MEF', 'F-7',
'F-X/A', 'MSD', 'MSDW', 'N-23C-2/A', 'N-5', 'N-5/A', 'NT 20-F', 'POS462B', 'PREC14C',
'SB-2', 'SC14D1F', 'SC14D1F/A', 'SC14D9F', 'TA-1', 'TTW/A', '15F-12G/A', '20FR12B/A',
'40-206A', '6B ORDR', 'CERTBATS', 'DEFA14C', 'DEFM14C', 'N-2MEF', 'NT N-MFP',
'NT-NCSR', 'REGDEX', 'S-B/A', 'TTW', '10-QT', '497H2', 'ANNLRPT', 'DEFN14A',
'F-8/A', 'N-23C3B', 'S-11MEF', '10-KT/A', '20FR12G', 'G-FIN/A', 'NT 10-K/A',
'PREM14C', 'TA-2/A', '20FR12G/A', '40-F/A', '8-K12B', 'APP WD', 'DFRN14A', 'F-6/A',
'NT 10-Q/A', 'NT-NSAR', 'RW WD', 'MSD/A', 'N-54A', 'N-6F', 'S-B', 'F-N', 'N-6',
'X-17A-5/A', '15F-12B', '8-A12G/A', 'DEFR14C', 'F-1MEF', 'N-6/A', 'NTN 10K',
'S-3DPOS', 'PREN14A', '40-17F1', '40-33', '8-K12G3', 'NSAR-AT', 'S-3D', 'TA-W',
'1-A', '1/A', 'N-14 8C/A', 'OIP NTC', 'OIP ORDR', 'TA-2', '486BPOS', 'N-14 8C',
'40-F', '10-12B', '15-15D/A', 'N-18F1', '40-6B/A', '13F-NT/A', 'ADV-NR', 'F-10',
'N-8F/A', 'S-3MEF', 'CB', 'SE', '40-OIP/A', '424B8', 'CB/A', 'DEFC14A', 'DEL
AM', 'F-4', 'N-4/A', 'NSAR-U/A', '25-NSE/A', 'PX14A6G', '18-K', 'N-8F NTC',
'F-10/A', 'N-4', '40-OIP', '1-A/A', 'DEFR14A', '10-D/A', 'SC 13E3', 'NSAR-BT',
'S-11', '8-A12B/A', '15F-12G', 'N-14/A', 'PRRN14A', 'SC 14F1', 'N-23C3A', '10-12B/A',
'APP NTC', 'PREC14A', 'CERTARCA', 'N-1A', 'T-3', 'APP ORDR', 'F-1', 'PRER14C',
'SC 14D9', 'N-8A/A', 'NTN 10Q', '25', 'N-23C-2', 'S-1MEF', 'F-3/A', '20-F/A',
'F-X', 'PREM14A', 'POS 8C', 'N-MFP/A', '24F-2NT/A', 'AW', 'N-8F ORDR', 'TA-1/A',
'N-8A', '10-12G', 'F-3', 'SC14D9C', '11-K', '18-K/A', '8-A12G', '305B2', 'F-4/A',
'20-F', 'DEFM14A', 'N-1A/A', 'POS AMI', 'SC TO-T', 'N-PX/A', 'N-2', 'F-6', 'N-14',
'N-8F', '424B7', 'SUPPL', 'N-Q/A', '6-K/A', '40-24B2', 'SC 13E3/A', 'POS EX',
'S-11/A', 'F-1/A', 'NO ACT', 'RW', '10-12G/A', 'DRSLTR', '497AD', 'CERTNAS',
'PRER14A', '424B1', 'ABS-15G/A', 'F-6 POS', 'SC 14D9/A', 'FOCUSN', 'T-3/A',
'DRS', 'SC TO-C', 'N-2/A', 'PRE 14C', 'N-30B-2', 'ABS-15G', 'DRS/A', 'N-30D',
'IRANNOTICE', 'SC TO-I', 'ARS', 'CERTNYS', 'F-6EF', 'DEF 14C', 'S-6/A', 'DFAN14A',
'SC TO-I/A', 'SC TO-T/A', 'NT 10-K', '40-17G/A', 'F-3ASR', 'X-17A-5', '40-APP',
'487', '424B4', 'PRE 14A', '25-NSE', 'S-1', 'S-6', '8-A12B', 'POS AM', '10-K/A',
'CT ORDER', '40-APP/A', '40-17F2', '19B-4E', 'S-3', '485BXT', 'POSASR', 'S-8
POS', 'S-8', 'S-3ASR', '10-Q/A', 'S-3/A', '485APOS', 'DEF 14A', '10-K', '8-K/A',
'SC 13D', 'S-1/A', '425', 'NSAR-U', '15-15D', 'NT 10-Q', 'DEFA14A', '40-17G',
'N-PX', '497J', '24F-2NT', '10-D', 'REVOKED', 'SC 13G', 'S-4', '485BPOS', '424B5',
'N-MFP', 'SC 13G/A', 'SC 13D/A', 'S-4/A', 'EFFECT', 'D/A', 'FWP', '424B3', '424B2',
'497K', 'CORRESP', 'UPLOAD', '497', '6-K', 'D', '10-Q', '8-K')