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: : 168594
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168594'
The Shares Amount is 16250000
The cusip is 84757T105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '84757T105'
Number of Rows :28
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '1.05'
where entryId = '132086219'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '10.8'
where entryId = '132304852'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '6.15'
where entryId = '130544239'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '2.09'
where entryId = '131553539'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '36.32'
where entryId = '132108902'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0.33'
where entryId = '131718493'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '12.31'
where entryId = '132096159'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '2.33'
where entryId = '132243547'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0.04'
where entryId = '131240047'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0'
where entryId = '130477378'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0.03'
where entryId = '130805462'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0.06'
where entryId = '132007927'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '129.53'
where entryId = '130508946'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '466.82'
where entryId = '131467609'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '11.87'
where entryId = '131649939'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '37.87'
where entryId = '131083468'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '7.39'
where entryId = '132348972'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '14.92'
where entryId = '130841941'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '553.85'
where entryId = '130654027'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '8.25'
where entryId = '131648350'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '24.62'
where entryId = '132230247'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '50.02'
where entryId = '131526949'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0'
where entryId = '131375026'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '268.38'
where entryId = '131950951'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '18.46'
where entryId = '130541949'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '9.38'
where entryId = '131673009'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '10.97'
where entryId = '132643472'
update current13Fpositions set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498' ,
percentOut = '0'
where entryId = '132581840'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '84757T105'
Number of Rows :25
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '126928592'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '125277425'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '125452367'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '125577215'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '125627196'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '125998532'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '126127528'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '126470030'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '125052210'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '129796102'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '127866504'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '128281349'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '129425342'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '127833513'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '128424096'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '127885337'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '129320849'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '128672330'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '129192800'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '128596952'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '128451027'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '129042780'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '129200082'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '127980309'
update archive13F set
compid = '168594',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001833498'
where entryId = '128554216'
End Function
The Script is complete, exiting....