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: : 159748
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159748'
The Shares Amount is 9000000
The cusip is 19761R802
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '19761R802'
Number of Rows :3
update current13Fpositions set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214' ,
percentOut = '0.12'
where entryId = '51209370'
update current13Fpositions set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214' ,
percentOut = '0.54'
where entryId = '65087373'
update current13Fpositions set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214' ,
percentOut = '28.43'
where entryId = '69269750'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '19761R802'
Number of Rows :36
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '65585883'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '68054278'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '68084211'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '68257768'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '67467459'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '67688818'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '67893552'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '66350441'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '66320105'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '66130787'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '66830620'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '66614958'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '65765374'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '65155418'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '66591245'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '63391939'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '63705567'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '64075326'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '63751224'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '64591024'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '64924386'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '64374045'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '64650327'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '64863352'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '68546148'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '69149065'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '69557320'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '69396309'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '69590949'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '70027272'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '70514967'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '71810335'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '70690988'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '71794728'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '71800967'
update archive13F set
compid = '159748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004214'
where entryId = '71802131'
End Function
The Script is complete, exiting....