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: : 132398
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '132398'
The Shares Amount is 24913000
The cusip is 670009109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '670009109'
Number of Rows :40
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '2306375'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '1.43'
where entryId = '3506278'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '18.08'
where entryId = '3732012'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '5580213'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '9028367'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '133.03'
where entryId = '9342015'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '1.11'
where entryId = '9756260'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '679.76'
where entryId = '10244208'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '7.23'
where entryId = '11206726'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '7.76'
where entryId = '11449911'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '1.53'
where entryId = '12288158'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '12327330'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '12562192'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '159.23'
where entryId = '13151081'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.11'
where entryId = '13468106'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '13678642'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '5.66'
where entryId = '14327979'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '22.15'
where entryId = '14332967'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.11'
where entryId = '14661612'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '14825788'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '10.87'
where entryId = '14876663'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '15262414'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '5.1'
where entryId = '15450260'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '1518.96'
where entryId = '15462815'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.04'
where entryId = '16117810'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '16615780'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '5.05'
where entryId = '16835484'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.79'
where entryId = '17015930'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '17074789'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '17104603'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '28.67'
where entryId = '17210849'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.01'
where entryId = '17526277'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.04'
where entryId = '17541083'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '17786653'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '80.77'
where entryId = '18149707'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '5.26'
where entryId = '18298600'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '18658445'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '153.33'
where entryId = '18836127'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0.04'
where entryId = '19116027'
update current13Fpositions set
compid = '132398',
sectorNum = '401003',
sectorDes = 'Drug Delivery',
issuerCik = '0000815838' ,
percentOut = '0'
where entryId = '23406599'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '670009109'
Number of Rows :0
End Function
The Script is complete, exiting....