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: : 137860
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '137860'
The Shares Amount is 19774000
The cusip is 00211W104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00211W104'
Number of Rows :34
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.27'
where entryId = '15242028'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '15262098'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '120.16'
where entryId = '15773512'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.18'
where entryId = '16116981'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '11.51'
where entryId = '16352630'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '11.51'
where entryId = '16353884'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '16615421'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '5.37'
where entryId = '16834363'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '15.32'
where entryId = '16865907'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.33'
where entryId = '16937969'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.86'
where entryId = '17014166'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '161.98'
where entryId = '17043658'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '17073602'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '17104998'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '169.17'
where entryId = '17193857'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.18'
where entryId = '17540232'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.59'
where entryId = '17542206'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '15.08'
where entryId = '17727468'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '17786107'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '1.62'
where entryId = '18035032'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '5.4'
where entryId = '18297605'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '140.15'
where entryId = '18382033'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '15.96'
where entryId = '18492730'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '18658818'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.22'
where entryId = '19115184'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '23.92'
where entryId = '19116811'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.77'
where entryId = '19146680'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '428.63'
where entryId = '21466201'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '16.99'
where entryId = '22449000'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0.01'
where entryId = '23167792'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '24505354'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '24519261'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '28642307'
update current13Fpositions set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405' ,
percentOut = '0'
where entryId = '29693393'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00211W104'
Number of Rows :2
update archive13F set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405'
where entryId = '19475065'
update archive13F set
compid = '137860',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000933405'
where entryId = '128389230'
End Function
The Script is complete, exiting....