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: : 132858
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '132858'
The Shares Amount is 21498000
The cusip is 576817209
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '576817209'
Number of Rows :26
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '154.44'
where entryId = '3505831'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0'
where entryId = '3685551'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '27.42'
where entryId = '3731157'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '172.26'
where entryId = '4374307'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0'
where entryId = '4416981'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0'
where entryId = '6271953'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '20.23'
where entryId = '7430036'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.93'
where entryId = '9755853'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '176.64'
where entryId = '10241935'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '10.16'
where entryId = '10984484'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '125.03'
where entryId = '11112455'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.41'
where entryId = '11251138'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '43.29'
where entryId = '11449792'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0'
where entryId = '12327285'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.39'
where entryId = '12446570'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '168.5'
where entryId = '13020929'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '64.85'
where entryId = '13151063'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.43'
where entryId = '13468018'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0'
where entryId = '13678598'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.37'
where entryId = '14132609'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '11.82'
where entryId = '14327757'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '31.1'
where entryId = '14330655'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.43'
where entryId = '14661488'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0.04'
where entryId = '14876039'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '53'
where entryId = '15594570'
update current13Fpositions set
compid = '132858',
sectorNum = '402002',
sectorDes = 'Home Health Care',
issuerCik = '0001007228' ,
percentOut = '0'
where entryId = '16434460'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '576817209'
Number of Rows :0
End Function
The Script is complete, exiting....