To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 130875
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130875'
The Shares Amount is 59651000
The cusip is 374276103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '374276103'
Number of Rows :60
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '271.61'
where entryId = '1115250'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.92'
where entryId = '1223941'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '97.34'
where entryId = '1569750'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.82'
where entryId = '1701156'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '1827528'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '2311966'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '5.02'
where entryId = '2827743'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '1.2'
where entryId = '2831844'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '21.98'
where entryId = '3505002'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.59'
where entryId = '3729380'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.38'
where entryId = '3916964'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '4415240'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.05'
where entryId = '5086782'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '7.88'
where entryId = '5747360'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '13.36'
where entryId = '6416293'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '1.47'
where entryId = '6910400'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.41'
where entryId = '7429816'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.98'
where entryId = '9341450'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '2.33'
where entryId = '9625532'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.78'
where entryId = '9754872'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '41.89'
where entryId = '10236493'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '1.11'
where entryId = '10548871'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '12.27'
where entryId = '11442902'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '16.02'
where entryId = '11451530'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '5.03'
where entryId = '11818276'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '1.74'
where entryId = '11894006'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '34.53'
where entryId = '12228523'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.7'
where entryId = '12287211'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '12326226'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '12390496'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '12423972'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '10.06'
where entryId = '12441895'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '5.03'
where entryId = '12540616'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '12562089'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.02'
where entryId = '12934304'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.34'
where entryId = '13467807'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '13677540'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '5.03'
where entryId = '13686214'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '13877966'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.52'
where entryId = '13968443'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '15.01'
where entryId = '14327263'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '37.58'
where entryId = '14330616'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.01'
where entryId = '14552584'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '14575573'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.39'
where entryId = '14661226'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '2.62'
where entryId = '14874415'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '15261312'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.01'
where entryId = '15336875'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '2.48'
where entryId = '15447511'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.24'
where entryId = '15449808'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '1.17'
where entryId = '15473104'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '5.03'
where entryId = '15504925'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '15983488'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '98.41'
where entryId = '16006094'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '108.11'
where entryId = '16049423'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0.39'
where entryId = '16117426'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '17226240'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '17776257'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '17804296'
update current13Fpositions set
compid = '130875',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001047202' ,
percentOut = '0'
where entryId = '17822892'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '374276103'
Number of Rows :0
End Function
The Script is complete, exiting....