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: : 151957
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151957'
The Shares Amount is 79020000
The cusip is 929352102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '929352102'
Number of Rows :59
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '11237236'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '19.62'
where entryId = '11894202'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.63'
where entryId = '13672150'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.05'
where entryId = '13968821'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '14827849'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '1.44'
where entryId = '15133053'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '16288996'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '17035709'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.03'
where entryId = '17558393'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '17675739'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '18274596'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.01'
where entryId = '18356507'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '18541669'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '19063672'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '19240250'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '18.98'
where entryId = '23074973'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '24523096'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '24927976'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '67.36'
where entryId = '25062694'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '9.78'
where entryId = '27897558'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '491.63'
where entryId = '28047205'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '7.24'
where entryId = '28296938'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '3.48'
where entryId = '29446630'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '29793248'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '3.81'
where entryId = '30709374'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '34607650'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '2.18'
where entryId = '38467420'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '1.28'
where entryId = '40849584'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '43.58'
where entryId = '42089389'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '1.93'
where entryId = '42102157'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '35.14'
where entryId = '42108793'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '44.51'
where entryId = '42118768'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '5.06'
where entryId = '42121132'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '46.44'
where entryId = '42122674'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '29.54'
where entryId = '42156040'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '68.12'
where entryId = '42175236'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '3.41'
where entryId = '42177227'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '4.68'
where entryId = '42187768'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.01'
where entryId = '42198611'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.12'
where entryId = '42204108'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '2.28'
where entryId = '42229662'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '14.82'
where entryId = '42232375'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '42268596'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '42269300'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '42269567'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '42466293'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '3.56'
where entryId = '44931261'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '3.82'
where entryId = '46539353'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '1.8'
where entryId = '47068099'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '50909834'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '9.15'
where entryId = '51218283'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '4.48'
where entryId = '51751827'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '17.72'
where entryId = '52914604'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '1.77'
where entryId = '53430494'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '46.68'
where entryId = '56367431'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0.05'
where entryId = '57889690'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '4.81'
where entryId = '58270374'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '58399701'
update current13Fpositions set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132' ,
percentOut = '0'
where entryId = '60057730'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '929352102'
Number of Rows :5
update archive13F set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132'
where entryId = '67773392'
update archive13F set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132'
where entryId = '47198500'
update archive13F set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132'
where entryId = '67780449'
update archive13F set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132'
where entryId = '43461438'
update archive13F set
compid = '151957',
sectorNum = '401004',
sectorDes = 'Drug Manufacturers - Major',
issuerCik = '0001403132'
where entryId = '63755973'
End Function
The Script is complete, exiting....