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: : 151588
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151588'
The Shares Amount is 1380000
The cusip is 871628301
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '871628301'
Number of Rows :1
update current13Fpositions set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063' ,
percentOut = '0'
where entryId = '93815520'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '871628301'
Number of Rows :55
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '85826554'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87204484'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87200416'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '86465299'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '86677737'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '86962658'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87308708'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87555023'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87569940'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87587474'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '87766737'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '88776194'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89292068'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '88418193'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '88525531'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '88626020'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '88955763'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '88739006'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89163348'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89242371'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89268885'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89409698'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89548258'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89607656'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89621252'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '89639705'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90354146'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90733711'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91621681'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90049607'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91767692'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90552680'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90955010'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91731777'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91500989'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91887486'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91770338'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91808293'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90895979'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91920792'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91587521'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '90229954'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91344066'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93876555'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93878329'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93867423'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '92621807'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93843629'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93877079'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93854662'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93877258'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93798050'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93820637'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '93878420'
update archive13F set
compid = '151588',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0001375063'
where entryId = '91740633'
End Function
The Script is complete, exiting....