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: : 131013
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131013'
The Shares Amount is 90000000
The cusip is 207142308
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '207142308'
Number of Rows :28
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.13'
where entryId = '15461012'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '1.11'
where entryId = '15626710'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.02'
where entryId = '15803715'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.29'
where entryId = '16938130'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.13'
where entryId = '17098383'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.04'
where entryId = '17107504'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '19.25'
where entryId = '17135157'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.01'
where entryId = '17529028'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '134.33'
where entryId = '17859071'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.03'
where entryId = '18660120'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.17'
where entryId = '19147579'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '65.73'
where entryId = '20167843'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '28.27'
where entryId = '22449110'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '2.22'
where entryId = '22560272'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '2.22'
where entryId = '22560462'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '2.22'
where entryId = '23165299'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.26'
where entryId = '23169667'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '24519875'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '24921659'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '24928519'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '4.2'
where entryId = '26091247'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '26332782'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0.01'
where entryId = '26733771'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '27406860'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '28642264'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '28779157'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '4.67'
where entryId = '29137191'
update current13Fpositions set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353' ,
percentOut = '0'
where entryId = '130458768'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '207142308'
Number of Rows :22
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '77780372'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '79944604'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '81762895'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '83866106'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '86101694'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '87802692'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '90134080'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '92204092'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '94253165'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '96027724'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '98416619'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '100988648'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '103549062'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '105763718'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '109067369'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '111854621'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '114286112'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '116760108'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '119645207'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '122409210'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '124953995'
update archive13F set
compid = '131013',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001069353'
where entryId = '127815134'
End Function
The Script is complete, exiting....