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: : 166983
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166983'
The Shares Amount is 10710000
The cusip is 655186500
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '655186500'
Number of Rows :10
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '0'
where entryId = '132618943'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '2.89'
where entryId = '132242656'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '0'
where entryId = '130475267'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '0'
where entryId = '132597998'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '0.13'
where entryId = '131739356'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '44.78'
where entryId = '132108008'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '0.06'
where entryId = '130802116'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '16.79'
where entryId = '131780518'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '25.62'
where entryId = '131080417'
update current13Fpositions set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180' ,
percentOut = '0'
where entryId = '132621181'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '655186500'
Number of Rows :59
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '114884920'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '114403189'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '114578851'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '115345556'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '115379830'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '115025065'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '115769675'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '114540699'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '115421056'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '114841143'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '118209906'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '117163322'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '117448132'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '116890689'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '117941757'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '117732219'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '116500112'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '117600447'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '118057743'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '118362263'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '118566602'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '119258875'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '120852960'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '119907226'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '120711903'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '119686350'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '120326077'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '121383316'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '121006521'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '121075108'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '121392853'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '122459606'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '122640785'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '122657536'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '123296487'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '122085949'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '123815194'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '123954715'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '123991922'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '124466098'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '125468403'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '125376653'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '125776181'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '125796566'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '126772730'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '125954226'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '126126592'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '126338534'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '126959077'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '127864380'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '127830104'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '129829124'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '129319953'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '128777069'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '128866167'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '129199180'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '128710939'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '127977128'
update archive13F set
compid = '166983',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001756180'
where entryId = '128998920'
End Function
The Script is complete, exiting....