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: : 130524
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130524'
The Shares Amount is 139466000
The cusip is 881451108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '881451108'
Number of Rows :24
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '9.19'
where entryId = '11429706'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '3.29'
where entryId = '12288980'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '8.75'
where entryId = '12868965'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '8.75'
where entryId = '13902793'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '106.68'
where entryId = '14581447'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '1880.2'
where entryId = '14629277'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '15.14'
where entryId = '14878688'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '8.75'
where entryId = '15246395'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0.02'
where entryId = '16939545'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '10.76'
where entryId = '17005523'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0.33'
where entryId = '17016569'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '106.68'
where entryId = '17427047'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '106.32'
where entryId = '19049599'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '124.26'
where entryId = '19055722'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0.89'
where entryId = '19068445'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0.07'
where entryId = '19078657'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '104.52'
where entryId = '20377166'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0.07'
where entryId = '21940874'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '97.35'
where entryId = '23589672'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0'
where entryId = '24522650'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '2268.39'
where entryId = '27204283'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '834.78'
where entryId = '27220436'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '10.76'
where entryId = '28313237'
update current13Fpositions set
compid = '130524',
sectorNum = '605002',
sectorDes = 'Integrated Telecommunication Services',
issuerCik = '0000913665' ,
percentOut = '0'
where entryId = '40503841'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '881451108'
Number of Rows :0
End Function
The Script is complete, exiting....