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: : 130676
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130676'
The Shares Amount is 14663000
The cusip is P8744Y102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'P8744Y102'
Number of Rows :75
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '1.51'
where entryId = '1265474'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '90.97'
where entryId = '1276992'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '1599561'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '30.01'
where entryId = '2828355'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '241.02'
where entryId = '3031788'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.14'
where entryId = '3733884'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '156.26'
where entryId = '3918001'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '4073723'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '167.72'
where entryId = '4374425'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '5.42'
where entryId = '5219233'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '11.26'
where entryId = '6227985'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '50.5'
where entryId = '7530461'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '9415549'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.72'
where entryId = '9758169'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '250.41'
where entryId = '10225078'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '54.95'
where entryId = '11266505'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '1.09'
where entryId = '12289446'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '12328329'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '56.47'
where entryId = '12847543'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '12888712'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '84.13'
where entryId = '14232404'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '6.27'
where entryId = '14328485'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '14354282'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '6.56'
where entryId = '14871248'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '98.4'
where entryId = '15775846'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '16041892'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.04'
where entryId = '16193190'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '31.61'
where entryId = '16598239'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.06'
where entryId = '16939421'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.88'
where entryId = '17016932'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '141.63'
where entryId = '17045900'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '109.68'
where entryId = '17209376'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '17769712'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '17772127'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '17786200'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.03'
where entryId = '17976860'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '135.48'
where entryId = '18384229'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '7.93'
where entryId = '18402227'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '18552196'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.21'
where entryId = '19104644'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.73'
where entryId = '19146631'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.11'
where entryId = '22313617'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '6.85'
where entryId = '23177834'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '24522478'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '59.4'
where entryId = '29137735'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '20.07'
where entryId = '30099435'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '7.95'
where entryId = '32167436'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '34254504'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '376.51'
where entryId = '34876567'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '9.35'
where entryId = '40849006'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '41123031'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '4.91'
where entryId = '41652281'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '36.45'
where entryId = '42055022'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '3.75'
where entryId = '42081469'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.62'
where entryId = '42084613'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '306.73'
where entryId = '42089348'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '17.43'
where entryId = '42107299'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '607.83'
where entryId = '42122802'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '159.01'
where entryId = '42135018'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '9.82'
where entryId = '42136440'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '4.1'
where entryId = '42138680'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '6.78'
where entryId = '42146955'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '77.05'
where entryId = '42155858'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '2.34'
where entryId = '42163846'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '21.92'
where entryId = '42171242'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.14'
where entryId = '42201973'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '7.72'
where entryId = '42226397'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '251.65'
where entryId = '42227600'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '106.71'
where entryId = '42236184'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0'
where entryId = '42469737'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '3.71'
where entryId = '46540265'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '4.56'
where entryId = '50673075'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.29'
where entryId = '51216720'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '50.97'
where entryId = '54515799'
update current13Fpositions set
compid = '130676',
sectorNum = '503005',
sectorDes = 'Personal Services',
issuerCik = '0001018946' ,
percentOut = '0.58'
where entryId = '56367813'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'P8744Y102'
Number of Rows :0
End Function
The Script is complete, exiting....