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: : 132082
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '132082'
The Shares Amount is 116471000
The cusip is 161133103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '161133103'
Number of Rows :63
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '4.05'
where entryId = '1264311'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '295.39'
where entryId = '1569497'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '1.61'
where entryId = '1701053'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.02'
where entryId = '1827235'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.07'
where entryId = '2831158'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '3133972'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '2.93'
where entryId = '3503953'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '12.76'
where entryId = '3727341'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '152.62'
where entryId = '3916601'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '4415234'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '152.63'
where entryId = '7529624'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '5.4'
where entryId = '9753920'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '193.49'
where entryId = '10230678'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '30.65'
where entryId = '11102806'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.99'
where entryId = '11177032'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '3.29'
where entryId = '11449224'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '4.76'
where entryId = '12228408'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '1.46'
where entryId = '12286518'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '12326144'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '12423742'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '3.4'
where entryId = '13467592'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '13677457'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '36.67'
where entryId = '14326724'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '14552360'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '37.91'
where entryId = '14603673'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '3.86'
where entryId = '14660930'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '14822276'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '15.11'
where entryId = '14872800'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '8.78'
where entryId = '14951714'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '8.51'
where entryId = '15070137'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '15261228'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '3.43'
where entryId = '15301808'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '15336657'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '39.92'
where entryId = '15339831'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '2.58'
where entryId = '15340977'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.3'
where entryId = '15449443'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.01'
where entryId = '16193973'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '16614581'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.29'
where entryId = '16834691'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '16919800'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '2.2'
where entryId = '17014668'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '17073929'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '17104110'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '75.81'
where entryId = '17196470'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '3.87'
where entryId = '17540388'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '17787056'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '8.56'
where entryId = '17859048'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '4.95'
where entryId = '18048383'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '3.26'
where entryId = '18176077'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.01'
where entryId = '18374236'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.03'
where entryId = '19052716'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0.05'
where entryId = '19880237'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '1.18'
where entryId = '20167762'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '12.45'
where entryId = '21940832'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '1.29'
where entryId = '22536268'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '7.14'
where entryId = '23169093'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '24519688'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '10.7'
where entryId = '24569580'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '24928404'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '8.57'
where entryId = '29956866'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '31253825'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '36595638'
update current13Fpositions set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353' ,
percentOut = '0'
where entryId = '130458619'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '161133103'
Number of Rows :22
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '77780256'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '79944488'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '81762433'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '83865988'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '86101579'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '87802575'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '90133967'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '92203984'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '94253055'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '96027614'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '98416505'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '100988533'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '103548942'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '105763583'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '109067229'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '111854480'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '114285974'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '116759971'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '119645066'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '122409065'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '124953843'
update archive13F set
compid = '132082',
sectorNum = '105001',
sectorDes = 'Apparel Stores',
issuerCik = '0000019353'
where entryId = '127814981'
End Function
The Script is complete, exiting....