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: : 130842
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130842'
The Shares Amount is 30177000
The cusip is 170404305
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '170404305'
Number of Rows :26
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '87.41'
where entryId = '9341093'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '1.19'
where entryId = '9753961'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '44.31'
where entryId = '10230960'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '310.16'
where entryId = '11102819'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '328.26'
where entryId = '11194791'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0.6'
where entryId = '11450934'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '12328197'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '12562588'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0.38'
where entryId = '13451092'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '13817368'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0.51'
where entryId = '13900123'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '33.91'
where entryId = '13902703'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '47.85'
where entryId = '14326745'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '14822351'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '2.25'
where entryId = '14872893'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '15.25'
where entryId = '15246305'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '182.32'
where entryId = '15468073'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '73.11'
where entryId = '16675790'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0.11'
where entryId = '16938089'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0.84'
where entryId = '17014695'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '19063137'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '326.67'
where entryId = '23169228'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '24519737'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '24928445'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0'
where entryId = '130447717'
update current13Fpositions set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134' ,
percentOut = '0.02'
where entryId = '131053000'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '170404305'
Number of Rows :10
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '113837809'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '116708812'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '116222248'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '119056342'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '120080357'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '122135089'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '125934607'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '124893537'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '127721846'
update archive13F set
compid = '130842',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001042134'
where entryId = '127556847'
End Function
The Script is complete, exiting....