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: : 130773
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130773'
The Shares Amount is 413032000
The cusip is 073325102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '073325102'
Number of Rows :77
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '2.18'
where entryId = '1223498'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.22'
where entryId = '1264192'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '1827131'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.57'
where entryId = '2374261'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '15.11'
where entryId = '2827462'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.02'
where entryId = '2830940'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '20.38'
where entryId = '3127774'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '7.97'
where entryId = '3503615'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '140.37'
where entryId = '3726601'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.26'
where entryId = '3916483'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '4416999'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '4436263'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.33'
where entryId = '5468739'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '5580381'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '6271429'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '7.98'
where entryId = '6294800'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '4.2'
where entryId = '6415987'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '6530656'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.34'
where entryId = '6811778'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.46'
where entryId = '7429477'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '8489603'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.99'
where entryId = '8638168'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '9169410'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '2.13'
where entryId = '9340916'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.01'
where entryId = '9753526'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '192.34'
where entryId = '10152415'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '64.76'
where entryId = '10228522'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '31.96'
where entryId = '10302619'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '10874153'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.21'
where entryId = '11326817'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.75'
where entryId = '11794097'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.46'
where entryId = '11894525'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '12055771'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.7'
where entryId = '12075466'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '84.63'
where entryId = '12170463'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.02'
where entryId = '12317962'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '2.21'
where entryId = '12389335'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '3.12'
where entryId = '12447484'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '12560455'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '12562507'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.82'
where entryId = '12655256'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.66'
where entryId = '12778821'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '12790696'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.96'
where entryId = '12808150'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '198.46'
where entryId = '12895675'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.02'
where entryId = '12933891'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.82'
where entryId = '12956666'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.1'
where entryId = '13022258'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '28.77'
where entryId = '13457151'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '13553364'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.08'
where entryId = '13625920'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.08'
where entryId = '13626220'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.08'
where entryId = '13626623'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.08'
where entryId = '13627025'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.08'
where entryId = '13627425'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.08'
where entryId = '13627841'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.05'
where entryId = '13628219'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.05'
where entryId = '13628685'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.05'
where entryId = '13629126'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.05'
where entryId = '13648690'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '13817246'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.02'
where entryId = '13937265'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.82'
where entryId = '13975782'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '23.71'
where entryId = '14330565'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '14454602'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '14575475'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.99'
where entryId = '14582692'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0.1'
where entryId = '14677424'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '14821746'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '4.3'
where entryId = '14872167'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '23.36'
where entryId = '14951668'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '6.78'
where entryId = '16077487'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '16411388'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '0'
where entryId = '16434499'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '1.55'
where entryId = '19987550'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '5.57'
where entryId = '20128626'
update current13Fpositions set
compid = '130773',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001031798' ,
percentOut = '5.57'
where entryId = '20128746'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '073325102'
Number of Rows :0
End Function
The Script is complete, exiting....