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: : 130695
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130695'
The Shares Amount is 29614000
The cusip is 402040109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '402040109'
Number of Rows :25
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '1367064'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '3.82'
where entryId = '1701165'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '107.56'
where entryId = '2374451'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '18.23'
where entryId = '2827760'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '1.2'
where entryId = '3505110'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '10.55'
where entryId = '3729591'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '4077356'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '10.84'
where entryId = '6416315'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '1.84'
where entryId = '6811832'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '73.16'
where entryId = '7429835'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '8160034'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '8172033'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '23.77'
where entryId = '8392104'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '2.43'
where entryId = '8638226'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '9639868'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '4.2'
where entryId = '9754951'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '130.72'
where entryId = '10236942'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '1.55'
where entryId = '11077123'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '1.66'
where entryId = '11093721'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '19.55'
where entryId = '11112410'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '290.63'
where entryId = '11263702'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '67.68'
where entryId = '11449539'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '12029122'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '8.58'
where entryId = '12287270'
update current13Fpositions set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113' ,
percentOut = '0'
where entryId = '12556433'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '402040109'
Number of Rows :1
update archive13F set
compid = '130695',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0001021113'
where entryId = '970048'
End Function
The Script is complete, exiting....