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: : 159812
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159812'
The Shares Amount is 9000000
The cusip is S53435103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'S53435103'
Number of Rows :1
update current13Fpositions set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278' ,
percentOut = '132.21'
where entryId = '129943580'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'S53435103'
Number of Rows :53
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '66265250'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '68378944'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '63805213'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '69516404'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '71593951'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '71468850'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '72731755'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '73010967'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '73783827'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '74015114'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '74061743'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '75309584'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '75939487'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '76611842'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '76724247'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '77174813'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '78142423'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '77868671'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '78202920'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '78562976'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '80362657'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '79816478'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '82101692'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '81961329'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '83947936'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '85466213'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '86543693'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '86836988'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '88061248'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '89688942'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '90539475'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '90616875'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '93731604'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '92965420'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '95033006'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '95167587'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '96592610'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '96461481'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '97727723'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '98494950'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '100619300'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '99754791'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '101139080'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '103057009'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '103386589'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '104512153'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '106092579'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '106379848'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '116398262'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '121183789'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '121910439'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '124204706'
update archive13F set
compid = '159812',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004278'
where entryId = '127095456'
End Function
The Script is complete, exiting....