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: : 130986
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130986'
The Shares Amount is 67525000
The cusip is 573083102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '573083102'
Number of Rows :65
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '3.49'
where entryId = '3731134'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '5580250'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.01'
where entryId = '9180396'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.07'
where entryId = '9679820'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.52'
where entryId = '9755838'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '14.28'
where entryId = '10241847'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.01'
where entryId = '10860393'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '12255982'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '1.62'
where entryId = '12287850'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.02'
where entryId = '13024068'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.02'
where entryId = '13626121'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.02'
where entryId = '13626487'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '13627654'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '13628072'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '13628473'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '13628935'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '13709705'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '2.28'
where entryId = '14327748'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.02'
where entryId = '14679190'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.01'
where entryId = '14876017'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '23.04'
where entryId = '15064504'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '11.21'
where entryId = '15473514'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '6.69'
where entryId = '15632516'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '1.48'
where entryId = '15998802'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '22.83'
where entryId = '16080276'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.04'
where entryId = '16195537'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '16938910'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.3'
where entryId = '17015708'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.2'
where entryId = '17468477'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.04'
where entryId = '17979184'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '108.47'
where entryId = '18170837'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '18274022'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '18355933'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '13.43'
where entryId = '18840113'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.04'
where entryId = '19148936'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.48'
where entryId = '23174018'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '24505090'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '24521299'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '24929102'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '28811117'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.06'
where entryId = '32979238'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '28.29'
where entryId = '33103816'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '36600132'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '1.74'
where entryId = '36944026'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.1'
where entryId = '37277580'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '41975497'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.03'
where entryId = '42072383'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '29.58'
where entryId = '42087125'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '7.5'
where entryId = '42106488'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '28.14'
where entryId = '42108358'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '2.65'
where entryId = '42146283'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.37'
where entryId = '42166839'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '6.09'
where entryId = '42172045'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.01'
where entryId = '42196453'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '42197881'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.11'
where entryId = '42202925'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '72.59'
where entryId = '42231265'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '42685368'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.03'
where entryId = '44902052'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '44930322'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '2.71'
where entryId = '47291355'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '29.62'
where entryId = '48741842'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0.23'
where entryId = '51213421'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '1.1'
where entryId = '51751501'
update current13Fpositions set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801' ,
percentOut = '0'
where entryId = '53273158'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '573083102'
Number of Rows :9
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '65629385'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '16592654'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '51704416'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '81491225'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '51037712'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '96633253'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '51677764'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '58073873'
update archive13F set
compid = '130986',
sectorNum = '104008',
sectorDes = 'Publishing',
issuerCik = '0001091801'
where entryId = '105466000'
End Function
The Script is complete, exiting....