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: : 130778
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130778'
The Shares Amount is 40600000
The cusip is 63607P208
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '63607P208'
Number of Rows :106
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '17.85'
where entryId = '1570029'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '10.27'
where entryId = '2827965'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '6.46'
where entryId = '2832596'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '123.32'
where entryId = '3506124'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '11.21'
where entryId = '3731691'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.21'
where entryId = '3917346'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.55'
where entryId = '3948495'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.93'
where entryId = '8392128'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.82'
where entryId = '9756099'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '115.23'
where entryId = '10243391'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '40.67'
where entryId = '11103385'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.45'
where entryId = '11265857'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.79'
where entryId = '11778491'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.94'
where entryId = '11794211'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '11.77'
where entryId = '12288049'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '12328283'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.01'
where entryId = '12424237'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.1'
where entryId = '12629337'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.4'
where entryId = '12846887'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '487.37'
where entryId = '13242904'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.92'
where entryId = '13244865'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.1'
where entryId = '14193483'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '116.14'
where entryId = '14310275'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '5.12'
where entryId = '14327896'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.01'
where entryId = '14552842'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '14825593'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.29'
where entryId = '14876421'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '11.16'
where entryId = '14952063'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '15262399'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.98'
where entryId = '15450200'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.13'
where entryId = '15730561'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.05'
where entryId = '16117765'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '16287238'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '117.18'
where entryId = '16353315'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '117.18'
where entryId = '16354569'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '16615765'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.94'
where entryId = '16835427'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '16938969'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '17001100'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.78'
where entryId = '17015854'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '17074731'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.01'
where entryId = '17202943'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.23'
where entryId = '17468527'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.05'
where entryId = '17541036'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '17673967'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '131.28'
where entryId = '17728121'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '17785514'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '17786728'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '6.77'
where entryId = '17989776'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '18261324'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '5.14'
where entryId = '18298538'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '222'
where entryId = '18493285'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '7.29'
where entryId = '18804977'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '246.31'
where entryId = '19086486'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.12'
where entryId = '19115981'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '55.57'
where entryId = '20167196'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.5'
where entryId = '20693418'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '20747824'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.78'
where entryId = '23174673'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '439.29'
where entryId = '23245382'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '24505435'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '24521520'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '24927222'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.59'
where entryId = '31799794'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.67'
where entryId = '32166900'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '7.26'
where entryId = '32908267'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '1.94'
where entryId = '33103904'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '34254709'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '26.12'
where entryId = '35645174'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.11'
where entryId = '37277676'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.31'
where entryId = '40852328'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.91'
where entryId = '40875411'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.73'
where entryId = '41651753'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.86'
where entryId = '41675048'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '52.44'
where entryId = '42076711'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '101.97'
where entryId = '42078464'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '23.89'
where entryId = '42079082'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '29.51'
where entryId = '42085656'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '162.98'
where entryId = '42087150'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.54'
where entryId = '42090031'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.01'
where entryId = '42094675'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '17.22'
where entryId = '42106651'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '11.61'
where entryId = '42108428'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '81.45'
where entryId = '42112568'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.08'
where entryId = '42115024'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '4.39'
where entryId = '42140032'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '6.45'
where entryId = '42146416'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.07'
where entryId = '42149473'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '2.88'
where entryId = '42158541'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.02'
where entryId = '42168941'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '77.89'
where entryId = '42172119'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '6.64'
where entryId = '42177293'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.32'
where entryId = '42181769'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.11'
where entryId = '42190398'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.62'
where entryId = '42203822'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '40.55'
where entryId = '42207930'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '5.49'
where entryId = '42222220'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '7.87'
where entryId = '42225304'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '38.87'
where entryId = '42227277'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '23.18'
where entryId = '42244786'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '42268879'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '42269026'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0'
where entryId = '42469021'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.73'
where entryId = '43979816'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '69.02'
where entryId = '44142052'
update current13Fpositions set
compid = '130778',
sectorNum = '303002',
sectorDes = 'Insurance Brokers',
issuerCik = '0001183186' ,
percentOut = '0.93'
where entryId = '44309539'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '63607P208'
Number of Rows :0
End Function
The Script is complete, exiting....