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: : 134213
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '134213'
The Shares Amount is 564611000
The cusip is 247126105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '247126105'
Number of Rows :31
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '6.29'
where entryId = '597707'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '1367007'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '2337342'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0.35'
where entryId = '2374353'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '3091421'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '3579021'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '3746612'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '4077350'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0.22'
where entryId = '5194242'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '9180246'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '12230570'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '12256129'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '29.22'
where entryId = '12956744'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '13626857'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '13627254'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '13627648'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '13628067'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0.01'
where entryId = '13628484'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '13628938'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '13681386'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '33.65'
where entryId = '13975862'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '15158764'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '15333201'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '33.65'
where entryId = '15626728'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '16582410'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '33.65'
where entryId = '17527113'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '17770346'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '18273500'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '18355411'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '33.65'
where entryId = '18664528'
update current13Fpositions set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342' ,
percentOut = '0'
where entryId = '130458917'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '247126105'
Number of Rows :18
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '1119082'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '65629319'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '90814042'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '92568985'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '94371617'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '96558397'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '98785839'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '100815678'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '103292924'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '105763846'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '109067498'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '111854753'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '114286247'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '116760244'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '119645348'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '122409349'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '124954138'
update archive13F set
compid = '134213',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001072342'
where entryId = '127815279'
End Function
The Script is complete, exiting....