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: : 142469
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142469'
The Shares Amount is 488723000
The cusip is 423012202
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '423012202'
Number of Rows :31
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.04'
where entryId = '8301349'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '8617212'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.02'
where entryId = '9755051'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '11032153'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.79'
where entryId = '11794170'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.14'
where entryId = '12473108'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '111.34'
where entryId = '12621004'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.35'
where entryId = '13262019'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.35'
where entryId = '14033288'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '100.39'
where entryId = '14052663'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.41'
where entryId = '14149290'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.14'
where entryId = '15102704'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.44'
where entryId = '15301174'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.64'
where entryId = '15397370'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.41'
where entryId = '15503273'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '15803551'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.75'
where entryId = '16637135'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.44'
where entryId = '16716066'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '16727367'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '17144428'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '17254074'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.41'
where entryId = '17383502'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.02'
where entryId = '17520819'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.59'
where entryId = '18166282'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.43'
where entryId = '18292790'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '3.76'
where entryId = '18548607'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '18567639'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.02'
where entryId = '19104162'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.01'
where entryId = '22313184'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0'
where entryId = '33174563'
update current13Fpositions set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593' ,
percentOut = '0.36'
where entryId = '39915030'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '423012202'
Number of Rows :15
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '66810156'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '34123305'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '65079567'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '63386647'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '68413177'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '70082149'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '72000491'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '73956116'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '75795897'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '77749670'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '79805027'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '81720023'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '83758675'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '85843053'
update archive13F set
compid = '142469',
sectorNum = '201001',
sectorDes = 'Beverage - Brewers',
issuerCik = '0000789593'
where entryId = '87796813'
End Function
The Script is complete, exiting....