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: : 133636
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133636'
The Shares Amount is 14968000
The cusip is 48880L107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '48880L107'
Number of Rows :86
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '159.85'
where entryId = '1569887'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '6.05'
where entryId = '2832201'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '332.64'
where entryId = '3031551'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '12.44'
where entryId = '3505550'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.8'
where entryId = '3730515'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '14.16'
where entryId = '3917148'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '3.02'
where entryId = '9755526'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '9987173'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '48.39'
where entryId = '10240000'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '146.78'
where entryId = '11103235'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '15.53'
where entryId = '11424692'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '763.82'
where entryId = '11449683'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '5.21'
where entryId = '12144905'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '12327243'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '147.32'
where entryId = '12539376'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '12562170'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.03'
where entryId = '12987149'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.33'
where entryId = '13023843'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.48'
where entryId = '13468706'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '9.02'
where entryId = '13644339'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '13678555'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '13755731'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '13818017'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '147.44'
where entryId = '13988595'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '19.11'
where entryId = '14327596'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '13.61'
where entryId = '14332842'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.48'
where entryId = '14661388'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.33'
where entryId = '14678970'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '14824726'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.03'
where entryId = '14875523'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '5.08'
where entryId = '15105102'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '6.88'
where entryId = '15160685'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '15230998'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '15263330'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '147.91'
where entryId = '15418763'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '4.42'
where entryId = '15449996'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '408.1'
where entryId = '15593960'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.01'
where entryId = '15803639'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '150.32'
where entryId = '16103549'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.18'
where entryId = '16117587'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.33'
where entryId = '16195298'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '7.98'
where entryId = '16582151'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '16615691'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '369.21'
where entryId = '16645317'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '4.74'
where entryId = '16666271'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.01'
where entryId = '16727371'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '4.47'
where entryId = '16835212'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.28'
where entryId = '16938751'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '405.74'
where entryId = '16963595'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.69'
where entryId = '17015544'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '3.81'
where entryId = '17044916'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '17074517'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '17105189'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '17226973'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.73'
where entryId = '17520940'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.18'
where entryId = '17540852'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '17772175'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '45.7'
where entryId = '17859698'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.33'
where entryId = '17978946'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '1.07'
where entryId = '18035070'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '7.98'
where entryId = '18114162'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '7.98'
where entryId = '18137318'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '18220937'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '18.73'
where entryId = '18258696'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '4.69'
where entryId = '18298332'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '6.63'
where entryId = '18383240'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '8.55'
where entryId = '18567405'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '15.37'
where entryId = '18572866'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '18659008'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '50.11'
where entryId = '18842050'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '378.01'
where entryId = '19064841'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.32'
where entryId = '19104268'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.27'
where entryId = '19115802'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.42'
where entryId = '19148710'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '5.81'
where entryId = '20167161'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '173.25'
where entryId = '20168386'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0.17'
where entryId = '22313233'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '24.38'
where entryId = '22449254'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '13.7'
where entryId = '23173330'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '5.65'
where entryId = '23258859'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '24505130'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '24521066'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '68.81'
where entryId = '28836500'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '8.3'
where entryId = '29956969'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '4.24'
where entryId = '31799564'
update current13Fpositions set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151' ,
percentOut = '0'
where entryId = '32966327'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '48880L107'
Number of Rows :1
update archive13F set
compid = '133636',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001039151'
where entryId = '65629118'
End Function
The Script is complete, exiting....