COMPANY QUALITY CONTROL PARSING HOLDERS FILE TRANSFER CLIENT SCRIPTS SCRIPTS DONORWATCH INTITUTIONS MUTUALFUNDS LINKS

 

Update
Settings
Summary


Contact Organizer

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
google
sec archive
overture


  Table secSiteAllFilings processed and not processed
 
Form Name Need To Be Processed Already Processed
3 38990
3/A 1912
4 529877
4/A 9939
5 6384
5/A 172
144 84538
144/A 1180
13F-HR 0 7233 (2024-03-31)
7307 (2023-12-31)
13F-HR/A 0
13F-NT 0
N-Q 0
N-CSR 7867
N-CSRS 7366
NSAR-B 0
NSAR-A 0
N-SAR 0
15-12B 124
15-12G 1206
15F-15D 20
# of Filers Names Not Fixed 59159


Insider 3, 3/A, 4, 4/A, 5, 5/A
13Fs 13F, 13F/A, 13F-NT
Mutual Funds

N-Q, N-CSR, N-CSRS, (We Need These) NSAR-B, NSAR-A, N-SAR(Don't think we need these)
144s 144, 144/A
Registation Termination 15F-15D, 15-12G, 15-12B
   
SELECT * FROM`secSiteAllFilings` WHERE`rowForm` IN ('13F-HR','13F-HR/A','13F-NT') and processedForm ='no';
XXX update secSiteAllFilings set processedForm = 'yes' where rowForm IN ('13F-HR','13F-HR/A','13F-NT');



/var/www/html_j3sg/forms
Folders


File Count
       
masterFiles-New 0        
tarFiles-New 1        
tarFilesUnpacked 0        


         
forms-Insider 0        
forms-Insider-XML 0        
forms-Institution 58        
forms-Institution-Done 51001        
            

 

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')