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: : 130847
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130847'
The Shares Amount is 45801000
The cusip is 46114T508
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '46114T508'
Number of Rows :53
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '68.72'
where entryId = '1569843'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '879.24'
where entryId = '1679270'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '12.47'
where entryId = '2389665'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '8.54'
where entryId = '2827822'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '6.82'
where entryId = '2832123'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '13.74'
where entryId = '3730242'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '43.06'
where entryId = '3917103'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '4416913'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '4436070'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '26.86'
where entryId = '6294818'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.87'
where entryId = '9679700'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '3.38'
where entryId = '9755300'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '9987174'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '2.18'
where entryId = '10023496'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '686.78'
where entryId = '10238969'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '11068249'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '11115725'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.59'
where entryId = '11450983'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '408.33'
where entryId = '11674267'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '4.37'
where entryId = '11893998'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.59'
where entryId = '12188106'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '1.31'
where entryId = '12448989'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '12562361'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.66'
where entryId = '12987124'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '563.43'
where entryId = '13180662'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '13817971'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '1.31'
where entryId = '13928603'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '9.63'
where entryId = '14106529'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '52.79'
where entryId = '14327513'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '14455585'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '728.62'
where entryId = '14514071'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '14824278'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '12.43'
where entryId = '14875107'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '7.1'
where entryId = '15062500'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '1.92'
where entryId = '15071114'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '1.92'
where entryId = '15085077'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.59'
where entryId = '15098787'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '15279536'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.15'
where entryId = '16938699'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.79'
where entryId = '17015469'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '17105174'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '16.33'
where entryId = '17200477'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '23.77'
where entryId = '17275249'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '431.96'
where entryId = '17322784'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '17787492'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '1.31'
where entryId = '18154261'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '5.13'
where entryId = '18260181'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '12.81'
where entryId = '18298282'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.7'
where entryId = '18304512'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '18658994'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0.06'
where entryId = '19115758'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '20890061'
update current13Fpositions set
compid = '130847',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001042431' ,
percentOut = '0'
where entryId = '20919936'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '46114T508'
Number of Rows :0
End Function
The Script is complete, exiting....