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: : 133208
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133208'
The Shares Amount is 35150000
The cusip is 026375105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '026375105'
Number of Rows :112
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '2.55'
where entryId = '1264090'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '6.07'
where entryId = '1569333'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '8.45'
where entryId = '1701007'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.18'
where entryId = '1827036'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.11'
where entryId = '2830706'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '3133992'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.29'
where entryId = '3503252'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '32.48'
where entryId = '3725951'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '4436130'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.06'
where entryId = '5086597'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '9.64'
where entryId = '6415924'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '8.47'
where entryId = '9340779'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '9.77'
where entryId = '9753212'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '387.14'
where entryId = '10226639'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '144.23'
where entryId = '11102630'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.06'
where entryId = '11125451'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '14.15'
where entryId = '11449010'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '2.05'
where entryId = '11450911'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '10.44'
where entryId = '11451464'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '12326092'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.01'
where entryId = '12423582'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.3'
where entryId = '12581714'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.07'
where entryId = '12972367'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '17.29'
where entryId = '12992392'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.34'
where entryId = '13022044'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '1.56'
where entryId = '13467424'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.01'
where entryId = '13628495'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '13679193'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '39.39'
where entryId = '14326360'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.01'
where entryId = '14552202'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '1.79'
where entryId = '14660718'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.48'
where entryId = '14662485'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.34'
where entryId = '14677206'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '14821233'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.46'
where entryId = '14871695'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.06'
where entryId = '14912894'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '25.9'
where entryId = '14951608'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '15261175'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '15279528'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '15336504'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.42'
where entryId = '15449195'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.06'
where entryId = '15914503'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '1.79'
where entryId = '16116924'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.34'
where entryId = '16193407'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '16616325'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.06'
where entryId = '16786366'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.42'
where entryId = '16834441'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.38'
where entryId = '16908446'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '16919647'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '16946239'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.14'
where entryId = '17014289'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '17073673'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.27'
where entryId = '17144910'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '19.31'
where entryId = '17194421'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '1.79'
where entryId = '17540177'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.16'
where entryId = '17542197'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.28'
where entryId = '17977075'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '9.66'
where entryId = '17989372'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '18293281'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.38'
where entryId = '18297542'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.27'
where entryId = '18572761'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '2.48'
where entryId = '19115133'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.28'
where entryId = '19146851'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.06'
where entryId = '19269720'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.71'
where entryId = '19880107'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.27'
where entryId = '19902365'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.54'
where entryId = '23167362'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '23401197'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '24519101'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '2.99'
where entryId = '24632584'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '24928119'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '28642323'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.72'
where entryId = '29136887'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '7.78'
where entryId = '29956830'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '23.84'
where entryId = '29979093'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.59'
where entryId = '31888827'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '7.94'
where entryId = '32165540'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.22'
where entryId = '32907326'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '34255101'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '36599996'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.02'
where entryId = '36610136'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '9.99'
where entryId = '38075641'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.41'
where entryId = '38324633'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '5.88'
where entryId = '38693733'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.24'
where entryId = '40856849'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '41123180'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '4.28'
where entryId = '41650412'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '519.2'
where entryId = '42076656'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '83.93'
where entryId = '42076679'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '14.55'
where entryId = '42078483'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '286.56'
where entryId = '42090624'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.08'
where entryId = '42094111'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '15.82'
where entryId = '42104949'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '2.56'
where entryId = '42112410'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '2.84'
where entryId = '42141767'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '6.16'
where entryId = '42145063'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.43'
where entryId = '42147661'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '7.25'
where entryId = '42157565'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.03'
where entryId = '42165857'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '65.88'
where entryId = '42171322'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.17'
where entryId = '42180829'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.47'
where entryId = '42184323'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.11'
where entryId = '42202296'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '5.58'
where entryId = '42221861'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '6.9'
where entryId = '42223775'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '6.63'
where entryId = '42245297'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '42462711'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '42468296'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0'
where entryId = '42685496'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.43'
where entryId = '43978758'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '3.02'
where entryId = '44020307'
update current13Fpositions set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133' ,
percentOut = '0.64'
where entryId = '60995993'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '026375105'
Number of Rows :2
update archive13F set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133'
where entryId = '969927'
update archive13F set
compid = '133208',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0000005133'
where entryId = '1427401'
End Function
The Script is complete, exiting....