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: : 132576
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '132576'
The Shares Amount is 133006000
The cusip is 20449H109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '20449H109'
Number of Rows :30
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.73'
where entryId = '1144835'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '1.48'
where entryId = '1223684'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '1366992'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.02'
where entryId = '1827300'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.01'
where entryId = '1983437'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '4.66'
where entryId = '2374330'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '1.44'
where entryId = '2827573'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.08'
where entryId = '2831313'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '3.02'
where entryId = '3504179'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '3685621'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '7.94'
where entryId = '3727742'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '1.24'
where entryId = '3916674'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '11.96'
where entryId = '5217615'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.59'
where entryId = '5482834'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '1.77'
where entryId = '6910156'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '1.13'
where entryId = '7429151'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '2'
where entryId = '9341149'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '4.16'
where entryId = '9754090'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '6.2'
where entryId = '10023440'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '42.67'
where entryId = '10142705'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.9'
where entryId = '10222981'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '77.76'
where entryId = '10231836'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '10563548'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '11038303'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '11980933'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '12086269'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '18273247'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0'
where entryId = '18355158'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.41'
where entryId = '24144586'
update current13Fpositions set
compid = '132576',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0000018568' ,
percentOut = '0.73'
where entryId = '24144782'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '20449H109'
Number of Rows :0
End Function
The Script is complete, exiting....