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: : 168509
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168509'
The Shares Amount is 13250000
The cusip is 228339305
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '228339305'
Number of Rows :22
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '7.13'
where entryId = '132240857'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0.01'
where entryId = '131015794'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '130470196'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '132564429'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0.18'
where entryId = '130794620'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '130781865'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '38.38'
where entryId = '132223711'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '131375169'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '132580991'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '30.5'
where entryId = '131487022'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '15.79'
where entryId = '131599707'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '10.26'
where entryId = '131646942'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '1.52'
where entryId = '127100314'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '32.09'
where entryId = '132642757'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0.12'
where entryId = '131243369'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '2.1'
where entryId = '131577160'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '14.39'
where entryId = '132298516'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '9.21'
where entryId = '132348653'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '131346276'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '1.52'
where entryId = '131336365'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '34.02'
where entryId = '131708025'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '7.73'
where entryId = '132106218'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '228339305'
Number of Rows :35
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '124213754'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126921464'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125460676'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '124648524'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125033930'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126311311'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129654992'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125399693'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125687270'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125793061'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125985191'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126124757'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126171345'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126336729'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126475465'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126340584'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127859245'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129033708'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129433604'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129656226'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127797297'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127822448'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128937947'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128406711'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128368915'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128194152'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129318137'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128661097'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128665950'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128773667'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129711817'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128571791'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129197369'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127969766'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129802390'
End Function
The Script is complete, exiting....