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: : 130728
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130728'
The Shares Amount is 58310000
The cusip is 45169U105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '45169U105'
Number of Rows :71
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '1061.69'
where entryId = '1115273'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '30.57'
where entryId = '3683001'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '3.81'
where entryId = '3729989'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '3.94'
where entryId = '9341586'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.41'
where entryId = '9755191'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '16.91'
where entryId = '10238350'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.01'
where entryId = '11251099'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '1.41'
where entryId = '12287419'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.01'
where entryId = '12446532'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '4.79'
where entryId = '12987106'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '260.42'
where entryId = '13020886'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.23'
where entryId = '14106520'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '14132574'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '23.74'
where entryId = '14332777'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '257.05'
where entryId = '14676717'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '14824136'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.15'
where entryId = '14874910'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '15087036'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '15453525'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '241.53'
where entryId = '16192440'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.08'
where entryId = '16938640'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.3'
where entryId = '17015406'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.01'
where entryId = '17035506'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '17074423'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '17105163'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '7.28'
where entryId = '17135228'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '222.95'
where entryId = '17191254'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '18541507'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '18658984'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '220.05'
where entryId = '18695628'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '13.63'
where entryId = '19053644'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.98'
where entryId = '19130667'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '10.74'
where entryId = '19684712'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '10.74'
where entryId = '19697777'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '19880448'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.94'
where entryId = '22449222'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '23406466'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '24520822'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '28811095'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.13'
where entryId = '31799446'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '3.45'
where entryId = '32907999'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.02'
where entryId = '37277207'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.18'
where entryId = '40853827'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.68'
where entryId = '41651369'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.17'
where entryId = '41674727'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.3'
where entryId = '42102368'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '10.41'
where entryId = '42106172'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.03'
where entryId = '42117889'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '3.41'
where entryId = '42136351'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '3.8'
where entryId = '42146032'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '5.23'
where entryId = '42151059'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.38'
where entryId = '42158265'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '29.39'
where entryId = '42171890'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '10.62'
where entryId = '42178273'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '17.78'
where entryId = '42195830'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.01'
where entryId = '42198172'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.15'
where entryId = '42203365'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '2.62'
where entryId = '42222431'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '4.37'
where entryId = '42224867'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.06'
where entryId = '42247959'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '26.07'
where entryId = '42252848'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '42269133'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '42467913'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.3'
where entryId = '43979463'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '1.45'
where entryId = '46539795'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.41'
where entryId = '51211987'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '22.84'
where entryId = '51751418'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '52385603'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0.04'
where entryId = '56365079'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '58106220'
update current13Fpositions set
compid = '130728',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001024732' ,
percentOut = '0'
where entryId = '58112215'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '45169U105'
Number of Rows :0
End Function
The Script is complete, exiting....