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: : 131600
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131600'
The Shares Amount is 260686000
The cusip is 577729205
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '577729205'
Number of Rows :14
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0.63'
where entryId = '1141475'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '2.6'
where entryId = '1264995'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '24.22'
where entryId = '1375181'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '2.11'
where entryId = '1378524'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0.07'
where entryId = '1827783'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0'
where entryId = '2307815'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '24.93'
where entryId = '2608327'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0.09'
where entryId = '2832415'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '1.2'
where entryId = '3505846'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0'
where entryId = '3596542'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0'
where entryId = '3685741'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0'
where entryId = '3746516'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0'
where entryId = '16437903'
update current13Fpositions set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039' ,
percentOut = '0'
where entryId = '130460109'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '577729205'
Number of Rows :23
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '1427470'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '77781453'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '79945665'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '81762066'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '83867133'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '86102712'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '87803738'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '90135102'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '92205112'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '94254188'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '96028750'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '98417649'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '100989679'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '103550121'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '105764908'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '109068570'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '111855843'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '114287337'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '116761329'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '119646457'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '122410510'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '124955304'
update archive13F set
compid = '131600',
sectorNum = '601003',
sectorDes = 'Data Storage Devices',
issuerCik = '0000711039'
where entryId = '127816455'
End Function
The Script is complete, exiting....