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: : 136391
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '136391'
The Shares Amount is 10129000
The cusip is 37245X203
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '37245X203'
Number of Rows :24
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '235.63'
where entryId = '1788640'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '506.84'
where entryId = '7290586'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '1.06'
where entryId = '9754855'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '9987187'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '56.4'
where entryId = '10236405'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '28.51'
where entryId = '10984475'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '25.86'
where entryId = '11103069'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '3.1'
where entryId = '11194895'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '50.19'
where entryId = '12925942'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '18.44'
where entryId = '12987040'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0.2'
where entryId = '13023290'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '13645050'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '13817762'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '48.02'
where entryId = '14332714'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '14823684'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '6.47'
where entryId = '14874389'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '15778342'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '16633301'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0.71'
where entryId = '17015200'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '18057759'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '3.64'
where entryId = '22449188'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '23406458'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '80.16'
where entryId = '23458773'
update current13Fpositions set
compid = '136391',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001077552' ,
percentOut = '0'
where entryId = '24520508'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '37245X203'
Number of Rows :0
End Function
The Script is complete, exiting....