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: : 151495
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151495'
The Shares Amount is 52065000
The cusip is 890088107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '890088107'
Number of Rows :32
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '2.98'
where entryId = '9757538'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '29.78'
where entryId = '10251097'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '96.52'
where entryId = '11103722'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '12216165'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '117.43'
where entryId = '12291218'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '19.34'
where entryId = '12817402'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '14.37'
where entryId = '12926808'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '185.21'
where entryId = '13243150'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '13617982'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '125.26'
where entryId = '13809447'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '183.9'
where entryId = '14310575'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '5.52'
where entryId = '14328650'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '4.1'
where entryId = '14333194'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '14878814'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '15123000'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '236.85'
where entryId = '15215106'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '2.8'
where entryId = '15478656'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '79.72'
where entryId = '16353648'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '79.72'
where entryId = '16354902'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '160.68'
where entryId = '16636878'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '16955245'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0.63'
where entryId = '17016604'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '17776395'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '49.08'
where entryId = '17859446'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '145.95'
where entryId = '18306038'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '19629232'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0.29'
where entryId = '23178476'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '24504891'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '24522713'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '8.3'
where entryId = '29957112'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '32219374'
update current13Fpositions set
compid = '151495',
sectorNum = '402005',
sectorDes = 'Medical Appliances & Equipment',
issuerCik = '0001317872' ,
percentOut = '0'
where entryId = '41122997'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '890088107'
Number of Rows :0
End Function
The Script is complete, exiting....