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: : 133596
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133596'
The Shares Amount is 13111000
The cusip is 78427V102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '78427V102'
Number of Rows :43
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '8.45'
where entryId = '2833188'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '270.28'
where entryId = '3506957'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '9.74'
where entryId = '3733533'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '272.52'
where entryId = '3917611'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '9.13'
where entryId = '9342281'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.72'
where entryId = '9756932'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '303.57'
where entryId = '10247796'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '91.09'
where entryId = '11266393'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '135.95'
where entryId = '11450144'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '12327427'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '89.74'
where entryId = '12410561'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '89.74'
where entryId = '12430315'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '114.67'
where entryId = '12847443'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.03'
where entryId = '12987387'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '13.21'
where entryId = '13243072'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.87'
where entryId = '13468794'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '13678726'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '141.35'
where entryId = '14232294'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '10.93'
where entryId = '14328392'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.87'
where entryId = '14661851'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '14826630'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '1.86'
where entryId = '14877815'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '5.34'
where entryId = '15071218'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '5.34'
where entryId = '15085181'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '51.85'
where entryId = '15212737'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '15262517'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '5.18'
where entryId = '15450544'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '155.86'
where entryId = '15775731'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.32'
where entryId = '16118048'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '16615864'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '5.12'
where entryId = '16835716'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '16954984'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '15.25'
where entryId = '16978727'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.81'
where entryId = '17016295'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '17075029'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '149.25'
where entryId = '17432887'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '17482525'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '23.23'
where entryId = '17529654'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0.32'
where entryId = '17541324'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '17547315'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '6.71'
where entryId = '17560674'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '17674770'
update current13Fpositions set
compid = '133596',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001143363' ,
percentOut = '0'
where entryId = '19239268'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '78427V102'
Number of Rows :0
End Function
The Script is complete, exiting....