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: : 130717
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130717'
The Shares Amount is 1666630000
The cusip is 873168108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '873168108'
Number of Rows :95
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.06'
where entryId = '597776'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.04'
where entryId = '1145044'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.06'
where entryId = '1209401'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.58'
where entryId = '1224622'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.22'
where entryId = '1265582'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '8.48'
where entryId = '1570370'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.1'
where entryId = '1701377'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '1828264'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.01'
where entryId = '1983889'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.02'
where entryId = '2207918'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.09'
where entryId = '2282187'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '2.85'
where entryId = '2374746'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.68'
where entryId = '2828210'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.01'
where entryId = '2833519'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.29'
where entryId = '2883266'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '12.48'
where entryId = '3031813'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '3190632'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.12'
where entryId = '3302240'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.26'
where entryId = '3507409'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.22'
where entryId = '3682914'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '2.01'
where entryId = '3734572'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.81'
where entryId = '3917752'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.4'
where entryId = '3928039'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.08'
where entryId = '3948547'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '4.93'
where entryId = '4374466'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '4428221'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.03'
where entryId = '5194350'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.97'
where entryId = '5218934'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.25'
where entryId = '5264868'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.14'
where entryId = '5455684'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.12'
where entryId = '5468975'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.18'
where entryId = '5708371'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.16'
where entryId = '6227999'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '6252723'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.49'
where entryId = '6911061'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.04'
where entryId = '6950235'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.08'
where entryId = '7296440'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.13'
where entryId = '7430437'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '7775464'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.03'
where entryId = '7793454'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.06'
where entryId = '7954787'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '8172019'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.04'
where entryId = '8273668'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '23.51'
where entryId = '8276628'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '8301391'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.3'
where entryId = '8392151'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.01'
where entryId = '8616724'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.04'
where entryId = '8779463'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.02'
where entryId = '9158171'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.28'
where entryId = '9227311'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '3.22'
where entryId = '9342448'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '9680092'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.16'
where entryId = '9757383'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.36'
where entryId = '10023562'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.18'
where entryId = '10119569'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '6.32'
where entryId = '10142752'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.09'
where entryId = '10224076'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '28.54'
where entryId = '10250240'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.03'
where entryId = '10453749'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.04'
where entryId = '10899337'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '11038683'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.2'
where entryId = '11077599'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.82'
where entryId = '11103738'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '122.34'
where entryId = '11217678'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.07'
where entryId = '11225674'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '11251242'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.03'
where entryId = '11251943'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.51'
where entryId = '11266720'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '11274535'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '3.37'
where entryId = '11340242'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.07'
where entryId = '11341484'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.02'
where entryId = '11407017'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.21'
where entryId = '11424756'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.11'
where entryId = '11450302'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '1.66'
where entryId = '11893845'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '11987083'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '12086317'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.01'
where entryId = '12196455'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.14'
where entryId = '12288927'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '12390548'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '13401834'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '77.79'
where entryId = '15983107'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.03'
where entryId = '16680728'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.28'
where entryId = '16680988'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.14'
where entryId = '16681214'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.07'
where entryId = '16681860'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.07'
where entryId = '16682183'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.06'
where entryId = '16682515'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.06'
where entryId = '16682844'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.06'
where entryId = '16683162'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.07'
where entryId = '16683483'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.04'
where entryId = '19987989'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.09'
where entryId = '20128721'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0.27'
where entryId = '20128844'
update current13Fpositions set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291' ,
percentOut = '0'
where entryId = '130461265'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '873168108'
Number of Rows :23
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '3035203'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '77782372'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '79946577'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '81762116'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '83868032'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '86103601'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '87804641'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '90135992'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '92205999'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '94255087'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '96029650'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '98418552'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '100990600'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '103551051'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '105765948'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '109069622'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '111856901'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '114288397'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '116762382'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '119647531'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '122411651'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '124956438'
update archive13F set
compid = '130717',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001023291'
where entryId = '127817581'
End Function
The Script is complete, exiting....