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 :12
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '6.5'
where entryId = '134364539'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.06'
where entryId = '143869544'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '124.41'
where entryId = '143651741'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0'
where entryId = '143987781'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '63.18'
where entryId = '144829258'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.09'
where entryId = '143268431'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.47'
where entryId = '144875282'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.91'
where entryId = '145410760'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '15.2'
where entryId = '144388238'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '6.5'
where entryId = '143125599'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '3.86'
where entryId = '145002945'
update current13Fpositions set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168' ,
percentOut = '0.02'
where entryId = '145322185'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '29268T508'
Number of Rows :84
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'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '130470877'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '130646855'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '130021281'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '130795585'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '131075206'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '131018594'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '132241109'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '131974968'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '131580023'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '132618705'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '131133782'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '132106490'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135503417'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135500458'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135497483'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '132519685'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '133210018'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '133715024'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '133691483'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '134530676'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135420233'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135731040'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135271696'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135547320'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '136229455'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '134415050'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135077364'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135723629'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135354982'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '134893250'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138285692'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138152901'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138561238'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '136908779'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138116027'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '135985750'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138366619'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138696653'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '137901914'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138787405'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '138329481'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '137676049'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '137461425'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '139978146'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '140335589'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '141175310'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '140515384'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '140996332'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '140905628'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '142084185'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '140892201'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '141586789'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '142023020'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '141370822'
update archive13F set
compid = '132435',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0000924168'
where entryId = '141499549'
End Function
The Script is complete, exiting....