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: : 134306
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '134306'
The Shares Amount is 3681505000
The cusip is 45103B205
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '45103B205'
Number of Rows :8
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.08'
where entryId = '42091343'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.16'
where entryId = '43953465'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.08'
where entryId = '56974780'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.54'
where entryId = '130209411'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.11'
where entryId = '68942045'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.07'
where entryId = '131216937'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.95'
where entryId = '130009752'
update current13Fpositions set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893' ,
percentOut = '0.04'
where entryId = '129886071'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '45103B205'
Number of Rows :64
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '66801076'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '67063293'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '67517988'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '66858860'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '65717854'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '65256239'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '65134908'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '65281595'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '63416363'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '63469045'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '63459683'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '63957335'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '68820781'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '70152119'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '72063701'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '72978188'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '73944264'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '75132512'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '75728456'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '75986943'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '77078526'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '77742840'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '79591015'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '80182522'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '81910646'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '83931588'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '86032756'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '86598686'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '87876823'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '88521483'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '90249578'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '90587584'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '90264112'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '92123110'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '92202525'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '92301246'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '94565003'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '94178969'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '96149787'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '96069337'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '98571396'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '98984363'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '101060123'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '101175911'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '103839163'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '103541386'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '105833596'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '108441443'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '110712616'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '110350273'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '111466637'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '113526621'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '115542117'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '113714032'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '118669230'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '116510485'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '119087261'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '121647209'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '124156106'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '124305232'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '127186392'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '127770955'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '127328541'
update archive13F set
compid = '134306',
sectorNum = '102003',
sectorDes = 'Electronic Equipment',
issuerCik = '0001079893'
where entryId = '127667379'
End Function
The Script is complete, exiting....