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: : 132537
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '132537'
The Shares Amount is 75777000
The cusip is 281760108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '281760108'
Number of Rows :34
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '1.74'
where entryId = '1223815'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '1.83'
where entryId = '1264525'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '1.06'
where entryId = '1271957'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.65'
where entryId = '1569656'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.95'
where entryId = '1701117'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0'
where entryId = '1827414'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.02'
where entryId = '2207624'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '17.48'
where entryId = '2827657'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.05'
where entryId = '2831562'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '2.15'
where entryId = '3504579'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '68.64'
where entryId = '3728486'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.05'
where entryId = '3846514'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0'
where entryId = '5099768'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.98'
where entryId = '5217773'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '1.17'
where entryId = '5482816'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '1.02'
where entryId = '6910279'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '4.66'
where entryId = '7529724'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.02'
where entryId = '7793147'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0'
where entryId = '8273024'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '20.4'
where entryId = '9341286'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '3.33'
where entryId = '9754454'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '3.96'
where entryId = '10023453'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '75.22'
where entryId = '10142686'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '5.77'
where entryId = '10223116'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '97.7'
where entryId = '10234086'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.44'
where entryId = '10719757'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.92'
where entryId = '11077029'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '6.24'
where entryId = '11093672'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0'
where entryId = '11115619'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0.2'
where entryId = '11177086'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '11.46'
where entryId = '11449397'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0'
where entryId = '12562353'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '0'
where entryId = '13401948'
update current13Fpositions set
compid = '132537',
sectorNum = '302008',
sectorDes = 'Investment Brokerage - Regional',
issuerCik = '0000718482' ,
percentOut = '143.13'
where entryId = '15983078'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '281760108'
Number of Rows :0
End Function
The Script is complete, exiting....