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: : 130827
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130827'
The Shares Amount is 82300000
The cusip is 457733103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '457733103'
Number of Rows :39
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '1367081'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '8.51'
where entryId = '1792993'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '1.44'
where entryId = '3505363'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '3596537'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '3685891'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '8.21'
where entryId = '3730119'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '6252350'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '8.97'
where entryId = '9341608'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '1.46'
where entryId = '9424625'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '13.6'
where entryId = '10238640'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '16.77'
where entryId = '11293767'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '96.37'
where entryId = '11424682'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '7.52'
where entryId = '12115603'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0.86'
where entryId = '12287459'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '6.11'
where entryId = '13615419'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '14266390'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '14824190'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0.98'
where entryId = '14875009'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '204.22'
where entryId = '16103547'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '16110831'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '16286125'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '16795453'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '16874030'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0.08'
where entryId = '16938685'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0.41'
where entryId = '17015431'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '31.46'
where entryId = '17452832'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '17776281'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '17787471'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '17815985'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '18261244'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '18273826'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '18355737'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '21430165'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '23406709'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '24520874'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '24921575'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '24929025'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '2.67'
where entryId = '29136301'
update current13Fpositions set
compid = '130827',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001040416' ,
percentOut = '0'
where entryId = '31252953'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '457733103'
Number of Rows :0
End Function
The Script is complete, exiting....