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: : 151568
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151568'
The Shares Amount is 225546000
The cusip is 53261M203
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '53261M203'
Number of Rows :37
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '6.53'
where entryId = '131075023'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.02'
where entryId = '131429749'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.01'
where entryId = '130883056'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '1.62'
where entryId = '132106431'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.35'
where entryId = '131570153'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '130224729'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.53'
where entryId = '131801845'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '2.41'
where entryId = '130260537'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '1.71'
where entryId = '131883474'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.49'
where entryId = '131253403'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.01'
where entryId = '131795637'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '130757529'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '2.04'
where entryId = '131018119'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.06'
where entryId = '131994384'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132084991'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.5'
where entryId = '130816476'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.64'
where entryId = '131708880'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.62'
where entryId = '130481324'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.03'
where entryId = '131979172'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '130795426'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '131319514'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132246559'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.88'
where entryId = '131956857'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '131054471'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '131787833'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.4'
where entryId = '130565879'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132383172'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132703871'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.07'
where entryId = '130859586'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '131088102'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.16'
where entryId = '130838573'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.57'
where entryId = '131409409'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0.58'
where entryId = '130240597'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '130934224'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132392682'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132482892'
update current13Fpositions set
compid = '151568',
sectorNum = '503001',
sectorDes = 'Business Services',
issuerCik = '0001391127' ,
percentOut = '0'
where entryId = '132641948'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '53261M203'
Number of Rows :0
End Function
The Script is complete, exiting....