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: : 132435
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '132435'
The Shares Amount is 5070000
The cusip is 29268T508
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '29268T508'
Number of Rows :13
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '6.5'
where entryId = '131018594'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.49'
where entryId = '131133782'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '8.66'
where entryId = '132241109'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.91'
where entryId = '131580023'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.04'
where entryId = '130646855'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '23.37'
where entryId = '131075206'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0'
where entryId = '132618705'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.04'
where entryId = '130795585'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0'
where entryId = '130470877'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '24.4'
where entryId = '132106490'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0'
where entryId = '130021281'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.02'
where entryId = '131974968'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.02'
where entryId = '132519685'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '29268T508'
Number of Rows :29
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '121706173'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '121738139'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '123289656'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '123655142'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '122888909'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '123607059'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '123368164'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '123809617'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '124862425'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '124205160'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '124461596'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '125461686'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '125605517'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '126012472'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '126125049'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '126174278'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '126336998'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '126953834'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '127417721'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '127263727'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '127859944'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '127823442'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '128940784'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '129823865'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '129318406'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '129069100'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '128574271'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '129197653'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '127970822'
End Function
The Script is complete, exiting....