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: : 130760
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130760'
The Shares Amount is 61466000
The cusip is 293848107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '293848107'
Number of Rows :23
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '38.53'
where entryId = '2827673'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '21.9'
where entryId = '3504679'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '16.46'
where entryId = '3728673'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '126.95'
where entryId = '5813926'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '15.89'
where entryId = '10234544'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0'
where entryId = '12888680'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '8.13'
where entryId = '12956771'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.16'
where entryId = '13023052'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0'
where entryId = '13817626'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '5.69'
where entryId = '13975885'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.16'
where entryId = '14678213'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '4.12'
where entryId = '14873882'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '5.69'
where entryId = '15626749'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.16'
where entryId = '16194477'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.79'
where entryId = '17015018'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '96.72'
where entryId = '17350520'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.19'
where entryId = '17529676'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0'
where entryId = '17819831'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '153.66'
where entryId = '17859120'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.16'
where entryId = '17978108'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0.16'
where entryId = '19147908'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '10.94'
where entryId = '22449163'
update current13Fpositions set
compid = '130760',
sectorNum = '602007',
sectorDes = 'Security Software & Services',
issuerCik = '0001031283' ,
percentOut = '0'
where entryId = '23406564'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '293848107'
Number of Rows :0
End Function
The Script is complete, exiting....