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: : 130656
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130656'
The Shares Amount is 1000
The cusip is 914906102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '914906102'
Number of Rows :32
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '24042740'
where entryId = '1224707'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '1599593'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '210600'
where entryId = '1741490'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '16190'
where entryId = '1828289'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '1011300'
where entryId = '2354894'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '583110'
where entryId = '2374757'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '13938000'
where entryId = '2608470'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '925410'
where entryId = '2828261'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '6780'
where entryId = '2833582'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '337500'
where entryId = '2883273'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '5986000'
where entryId = '3312086'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '4182980'
where entryId = '3507507'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '4988540'
where entryId = '3734782'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '320870'
where entryId = '3917855'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '390100'
where entryId = '4113364'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '1200000'
where entryId = '4374473'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '4428261'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '80000'
where entryId = '5219055'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '4060000'
where entryId = '6059325'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '6253502'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '159680'
where entryId = '6470135'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '30000000'
where entryId = '6793668'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '6578780'
where entryId = '6911146'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '70500'
where entryId = '7430462'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '7562061'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '8159923'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '8489513'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '8489976'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '8499805'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '1940800'
where entryId = '9158181'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '0'
where entryId = '10526682'
update current13Fpositions set
compid = '130656',
sectorNum = '104003',
sectorDes = 'Broadcasting - TV',
issuerCik = '0001017008' ,
percentOut = '400000'
where entryId = '23821032'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '914906102'
Number of Rows :0
End Function
The Script is complete, exiting....