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: : 142144
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142144'
The Shares Amount is 20095000
The cusip is 35952W103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '35952W103'
Number of Rows :73
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '6518216'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.95'
where entryId = '9754787'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '26.14'
where entryId = '10235973'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '12192487'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '98.72'
where entryId = '12987026'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '13671681'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '14455639'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '1.75'
where entryId = '14874261'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '15132478'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '16285640'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '16616722'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '37.86'
where entryId = '16673632'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '51.27'
where entryId = '16918751'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.28'
where entryId = '16938447'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.48'
where entryId = '17015161'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '14.11'
where entryId = '17051551'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '17074265'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '17105135'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '11.4'
where entryId = '17135199'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '14.43'
where entryId = '17145000'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '8.25'
where entryId = '17561653'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '17787317'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '17801676'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.12'
where entryId = '18181393'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '65.61'
where entryId = '18253062'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.35'
where entryId = '18260161'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '18273648'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '4.53'
where entryId = '18298102'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.18'
where entryId = '18355559'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '50.38'
where entryId = '18493944'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '5'
where entryId = '18567406'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '19.91'
where entryId = '18572832'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '18609578'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '18658955'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '2.65'
where entryId = '18783773'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '4.98'
where entryId = '18842036'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '18842077'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.07'
where entryId = '19880382'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '37.2'
where entryId = '21466370'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '3.09'
where entryId = '23171402'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '175.4'
where entryId = '23355632'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.05'
where entryId = '24138329'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '24520463'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '7.45'
where entryId = '24632686'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '24907664'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '24919236'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '24928834'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '26905312'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '28642231'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '2.16'
where entryId = '28779353'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '32249410'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '34254895'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '39099682'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '360.75'
where entryId = '39203860'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '41123249'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.02'
where entryId = '42077270'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '12.18'
where entryId = '42105905'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '5.3'
where entryId = '42156168'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '5.23'
where entryId = '42165462'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.04'
where entryId = '42166400'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '17.62'
where entryId = '42171774'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.25'
where entryId = '42203866'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0.2'
where entryId = '42211249'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '6.48'
where entryId = '42224632'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '205.04'
where entryId = '42239348'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '5.63'
where entryId = '42242749'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '42461278'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '42469045'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '23.8'
where entryId = '46539724'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '47650044'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '17.8'
where entryId = '51211142'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '10.77'
where entryId = '57102889'
update current13Fpositions set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786' ,
percentOut = '0'
where entryId = '60388574'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '35952W103'
Number of Rows :2
update archive13F set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786'
where entryId = '51677719'
update archive13F set
compid = '142144',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001340786'
where entryId = '105465978'
End Function
The Script is complete, exiting....