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: : 142477
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142477'
The Shares Amount is 101135000
The cusip is 009606104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '009606104'
Number of Rows :28
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '13817120'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '5.09'
where entryId = '14326288'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.12'
where entryId = '14871519'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '85.28'
where entryId = '15387283'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '16594456'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '15.26'
where entryId = '16673524'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '17103950'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '1.84'
where entryId = '17135086'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.01'
where entryId = '17557245'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '22247366'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.09'
where entryId = '23167066'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '4.25'
where entryId = '24472444'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '33878787'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.63'
where entryId = '36733007'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '21.26'
where entryId = '37685056'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '39415269'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.02'
where entryId = '42083826'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '27.18'
where entryId = '42091810'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.03'
where entryId = '42097058'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '6.88'
where entryId = '42099273'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '1.84'
where entryId = '42148489'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '66.12'
where entryId = '42230892'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0'
where entryId = '42462294'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '7.04'
where entryId = '49185757'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.46'
where entryId = '51207297'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '1.8'
where entryId = '52939849'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '0.1'
where entryId = '65420948'
update current13Fpositions set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496' ,
percentOut = '9.89'
where entryId = '65906188'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '009606104'
Number of Rows :69
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '970299'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66363294'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63484627'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67184755'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68356471'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67856459'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67184383'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68360327'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68361963'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67855177'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66632536'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67520971'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65489232'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66450657'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66420847'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67782360'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68361393'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68374065'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68330175'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66033657'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66784358'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65764789'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64557696'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66589902'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66349931'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66128793'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67430160'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66813975'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '67521566'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68361110'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66722073'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65117430'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66576810'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68486491'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66079206'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '66785101'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65416665'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65345269'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65564849'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65113485'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65499181'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65105636'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65639711'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63395759'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63450141'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63405376'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64307219'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63719028'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64105469'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63464223'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63933400'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64012088'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63853551'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '63510352'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64005146'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64107178'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64387805'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64266060'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64550091'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '65121860'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64318289'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64689273'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64923317'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64807705'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64372058'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64648203'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '64899484'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68802425'
update archive13F set
compid = '142477',
sectorNum = '504001',
sectorDes = 'Diversified Machinery',
issuerCik = '0001089496'
where entryId = '68487908'
End Function
The Script is complete, exiting....