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: : 133404
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133404'
The Shares Amount is 54073000
The cusip is 555904101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '555904101'
Number of Rows :38
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '9.84'
where entryId = '2827907'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0.84'
where entryId = '3505765'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '18.7'
where entryId = '3731018'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '14.52'
where entryId = '4113197'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0.13'
where entryId = '4129434'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '5.48'
where entryId = '4374300'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '6.68'
where entryId = '6416465'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '13.3'
where entryId = '7916315'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '6.43'
where entryId = '9341844'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0.65'
where entryId = '9755790'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '614.02'
where entryId = '10241541'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '11115770'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '2.35'
where entryId = '11449770'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '12085456'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '5.29'
where entryId = '12188168'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '14.85'
where entryId = '12228627'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '12326297'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '12424168'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '125.42'
where entryId = '13020923'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '81.28'
where entryId = '13242832'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0.14'
where entryId = '13468000'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '13677614'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '13755739'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '13755741'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '13818171'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '3.26'
where entryId = '14310188'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '35.65'
where entryId = '14327722'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '159.09'
where entryId = '14330652'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '14458126'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '14552774'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '38.83'
where entryId = '14628774'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0.16'
where entryId = '14661468'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '125.4'
where entryId = '14676749'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '14825090'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '1.04'
where entryId = '14875927'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '6.84'
where entryId = '14952015'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '7.33'
where entryId = '15098850'
update current13Fpositions set
compid = '133404',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001027443' ,
percentOut = '0'
where entryId = '15356454'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '555904101'
Number of Rows :0
End Function
The Script is complete, exiting....