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: : 130560
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130560'
The Shares Amount is 14500000
The cusip is 595626102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '595626102'
Number of Rows :44
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.21'
where entryId = '2207776'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '15.95'
where entryId = '3731442'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '4077372'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '32.83'
where entryId = '5455490'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '1.45'
where entryId = '9755966'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '64.61'
where entryId = '10242672'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '73.86'
where entryId = '11431560'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '72.19'
where entryId = '11449834'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '12327303'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '79.31'
where entryId = '12959742'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.43'
where entryId = '13468050'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '13678615'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '22.9'
where entryId = '13887581'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '9.24'
where entryId = '14327829'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '25.59'
where entryId = '14330661'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '64.51'
where entryId = '14653446'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.43'
where entryId = '14661532'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '14825408'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.04'
where entryId = '14876205'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '15262385'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '4.88'
where entryId = '15450163'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '60.28'
where entryId = '16105526'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.16'
where entryId = '16117731'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '16394326'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '16615752'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '4.88'
where entryId = '16835388'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '16955109'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.75'
where entryId = '17015783'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '17074685'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '42.29'
where entryId = '17529946'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.16'
where entryId = '17541000'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '5.08'
where entryId = '18298498'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '27.59'
where entryId = '19109233'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.23'
where entryId = '19115945'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '11.03'
where entryId = '20470626'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '7.43'
where entryId = '20693409'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0.01'
where entryId = '23174380'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '24521419'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '4.04'
where entryId = '31799739'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '6.58'
where entryId = '32908229'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '27.06'
where entryId = '33103858'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '14'
where entryId = '36507794'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '41122872'
update current13Fpositions set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131' ,
percentOut = '0'
where entryId = '130460186'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '595626102'
Number of Rows :22
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '77781518'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '79945728'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '81762775'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '83867196'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '86102775'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '87803801'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '90135169'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '92205176'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '94254251'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '96028815'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '98417711'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '100989742'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '103550186'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '105764976'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '109068642'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '111855911'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '114287405'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '116761398'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '119646525'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '122410581'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '124955374'
update archive13F set
compid = '130560',
sectorNum = '105002',
sectorDes = 'Auto Parts Stores',
issuerCik = '0001046131'
where entryId = '127816526'
End Function
The Script is complete, exiting....