Update Company
Name Pricing Date  2024-03-31(LQAP)    
CompId   Stop Date volume LQStart
Ticker Price avevol LQEnd
Cusip Last Trade open LQAve
Sector Country high
   
MktCap CompNum low
yearlylow
Shares Out Type1 prevClose
yearlyhigh
Last_ShsOut    Exchange  
     
  09-30 12-25 sic Code      
Description cik  Updated
  Notes PAGE RESET
  Run PHG Charts Yahoo PHG Profile
  Run PHG Institutional Summary Yahoo PHG Key Statisics
  J3 Open PHG Pricing Yahoo PHG Pricing
  J3 PHG Insider   J3 PHG Insitutions Yahoo PHG Holders
     
  Open up Sector/Exchange Map Fidelity PHG Lookup
  Open up sec.gov For Market Ca MSN PHG Lookup
     
  2001-01-01 shsout made up date to make % good  
  0009-09-09 sdate Dead Company  
  2010-12-25 shsout Took From Yahoo  
  9000010176 Next Fake CIK to use
   


INSITITUIONS Dynamic newInstitTable Changed the Cusip/Sector/Shs Out?
Old Cusips
 

Fix Cusip issue where all new and deleted Instittuional Holdings
Current Quarter Date: ie: 2012-06-30
Should We Update The database:
BackUp query is below under BACK UP Institutions before committing.

Total Insititutions : 317 297   Update Insititution By Cusips
% Owned by Insititutions: 7.57 % 4.72 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:139551
New Old Cusip
 

Splits :
 reportDate : 
  ratio : 
  endQuaterAffected : 
  dayFrom  :
  dayTo  :
 

reportDate ratio endQuaterAffected dayFrom dayTo

To Upper  



Cusip
entryId groupId EQUITY CHANGE CUSIP DESCRIPTION ISSUE
STATUS
CODE
ISSUE
TYPE
CODE
ADD
DATE
EXPIRATION
DATE
PAYMENT
FREQUENCY
CODE
MARGIN
FLAG
OPTION
FLAG
CONVERTED
CUSIP
NASDAQ
MARKET
CODE
INDEX
ISSUER
CHANGE
DATE
MERGENT
CHANGE
DATE
MATURE
DATE
undefined1 undefined2 undefined3 undefined4 temp1 temp2 fileName fileDate processDate
5563019 5563019 DIVIDEND DELETE 500472303 B 1 0 .9154 02 2024-05-09 2024-05-10 2024-05-16 ? 0 2024-05-28 ? 0 0006917838 20240529.ifs 2024-05-29 2024-05-30
5563020 5563020 DIVIDEND ADD 500472303 Optional B 0 1 0 .9154 0 02 2024-05-09 2024-05-10 2024-05-16 2024-05-07 0 ? 2024-05-29 0 0006917838 20240529.ifs 2024-05-29 2024-05-30
5562826 5562826 DIVIDEND ADD 500472303 B 1 0 .9154 02 2024-05-09 2024-05-10 2024-05-16 ? 0 2024-05-28 ? 0 0006917838 20240528.ifs 2024-05-28 2024-05-29
5296995 5296995 DIVIDEND CHANGE 500472303 B 0 1 0 .925352 02 2023-05-11 2023-05-12 2023-05-18 2023-05-10 2 2023-05-10 2023-05-17 0 0006724659 20230525.ifs 2023-05-25 2023-05-26
5296996 5296995 DIVIDEND CHANGE 500472303 B 0 1 0 .925352 02 2023-05-11 2023-05-12 2023-05-18 2023-05-10 3 2023-05-10 2023-05-25 0 0006724659 20230525.ifs 2023-05-25 2023-05-26
5293048 5293048 DIVIDEND DELETE 500472303 B 0 1 5 .9326 39 2023-05-11 2023-05-12 2023-05-18 2023-05-10 1 2023-05-10 2023-05-16 0 0006724659 20230517.ifs 2023-05-17 2023-05-18
5293049 5293049 DIVIDEND ADD 500472303 B 0 1 0 .925352 02 2023-05-11 2023-05-12 2023-05-18 2023-05-10 2 2023-05-10 2023-05-17 0 0006724659 20230517.ifs 2023-05-17 2023-05-18
5292160 5292160 DIVIDEND DELETE 500472303 B 0 1 5 .9326 39 2023-05-11 2023-05-12 ? 2023-05-10 0 2023-05-10 ? 0 0006724659 20230516.ifs 2023-05-16 2023-05-17
5292161 5292161 DIVIDEND ADD 500472303 B 0 1 5 .9326 39 2023-05-11 2023-05-12 2023-05-18 2023-05-10 1 2023-05-10 2023-05-16 0 0006724659 20230516.ifs 2023-05-16 2023-05-17
5289435 5289435 DIVIDEND ADD 500472303 B 0 1 5 .9326 39 2023-05-11 2023-05-12 ? 2023-05-10 0 2023-05-10 ? 0 0006724659 20230510.ifs 2023-05-10 2023-05-11
5030793 5030793 DIVIDEND CHANGE 500472303 B 0 1 0 .775278 02 2022-05-12 2022-05-13 2022-06-08 2022-01-24 1 2022-01-24 2022-06-08 0 0006470201 20220609.ifs 2022-06-09 2022-06-10
5030794 5030793 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .775278 0 02 2022-05-12 2022-05-13 2022-06-08 2022-01-24 1 2022-01-24 2022-06-09 0 0006470201 20220609.ifs 2022-06-09 2022-06-10
5030795 5030795 DIVIDEND CHANGE 500472303 B 0 1 0 .878921 0 02 2021-05-10 2021-05-11 2021-06-09 2021-01-26 3 2021-01-26 2022-04-07 0 0006254072 20220609.ifs 2022-06-09 2022-06-10
5030796 5030795 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .878921 0 02 2021-05-10 2021-05-11 2021-06-09 2021-01-26 3 2021-01-26 2022-06-09 0 0006254072 20220609.ifs 2022-06-09 2022-06-10
5030014 5030014 DIVIDEND DELETE 500472303 B 0 1 5 .819495 39 2022-05-12 2022-05-13 2022-06-08 2022-01-24 0 2022-01-24 ? 0 0006470201 20220608.ifs 2022-06-08 2022-06-09
5030015 5030015 DIVIDEND ADD 500472303 B 0 1 0 .775278 02 2022-05-12 2022-05-13 2022-06-08 2022-01-24 1 2022-01-24 2022-06-08 0 0006470201 20220608.ifs 2022-06-08 2022-06-09
4991273 4991273 DIVIDEND DELETE 500472303 Optional B 0 1 5 .878921 0 39 2021-05-10 2021-05-11 2021-06-09 2021-01-26 2 2021-01-26 2021-06-09 0 0006254072 20220407.ifs 2022-04-07 2022-04-08
4991274 4991274 DIVIDEND ADD 500472303 B 0 1 0 .878921 0 02 2021-05-10 2021-05-11 2021-06-09 2021-01-26 3 2021-01-26 2022-04-07 0 0006254072 20220407.ifs 2022-04-07 2022-04-08
4938438 4938438 DIVIDEND ADD 500472303 B 0 1 5 .819495 39 2022-05-12 2022-05-13 2022-06-08 2022-01-24 0 2022-01-24 ? 0 0006470201 20220124.ifs 2022-01-24 2022-01-25
4725235 4725235 DIVIDEND CHANGE 500472303 B 0 1 5 .878921 0 39 2021-05-10 2021-05-11 2021-06-09 2021-01-26 2 2021-01-26 2021-06-08 0 0006254072 20210609.ifs 2021-06-09 2021-06-10
4725236 4725235 DIVIDEND CHANGE 500472303 Optional B 0 1 5 .878921 0 39 2021-05-10 2021-05-11 2021-06-09 2021-01-26 2 2021-01-26 2021-06-09 0 0006254072 20210609.ifs 2021-06-09 2021-06-10
4724940 4724940 DIVIDEND DELETE 500472303 Optional 0 0 1 5 1.033107 0 19 2021-05-10 2021-05-11 2021-06-09 2021-01-26 1 2021-01-26 2021-01-28 0 0006254072 20210608.ifs 2021-06-08 2021-06-09
4724941 4724941 DIVIDEND ADD 500472303 B 0 1 5 .878921 0 39 2021-05-10 2021-05-11 2021-06-09 2021-01-26 2 2021-01-26 2021-06-08 0 0006254072 20210608.ifs 2021-06-08 2021-06-09
4612986 4612986 DIVIDEND CHANGE 500472303 0 0 1 5 1.033107 0 19 2021-05-10 2021-05-11 2021-06-09 2021-01-26 1 2021-01-26 2021-01-27 0 0006254072 20210128.ifs 2021-01-28 2021-01-29
4612987 4612986 DIVIDEND CHANGE 500472303 Optional 0 0 1 5 1.033107 0 19 2021-05-10 2021-05-11 2021-06-09 2021-01-26 1 2021-01-26 2021-01-28 0 0006254072 20210128.ifs 2021-01-28 2021-01-29
4612571 4612571 DIVIDEND CHANGE 500472303 Optional 0 0 1 5 1.033107 0 19 2021-05-10 2021-05-11 2021-06-09 2021-01-26 0 2021-01-26 2021-01-27 0 0006254072 20210127.ifs 2021-01-27 2021-01-28
4612572 4612571 DIVIDEND CHANGE 500472303 0 0 1 5 1.033107 0 19 2021-05-10 2021-05-11 2021-06-09 2021-01-26 1 2021-01-26 2021-01-27 0 0006254072 20210127.ifs 2021-01-27 2021-01-28
4611903 4611903 DIVIDEND ADD 500472303 0 0 1 5 1.033107 19 2021-05-10 2021-05-11 2021-06-09 2021-01-26 0 2021-01-26 ? 0 0006254072 20210126.ifs 2021-01-26 2021-01-27
4296173 4296173 DIVIDEND DELETE 500472303 B 0 1 5 .795263 39 2020-05-05 2020-05-06 2020-06-04 2020-04-20 0 2020-04-20 ? 0 0006046875 20200421.ifs 2020-04-21 2020-04-22
4296178 4296178 DIVIDEND DELETE 500472303 B 0 1 5 .795263 39 2020-05-05 2020-05-06 2020-06-04 2020-04-20 0 2020-04-20 ? 0 0006046875 20200421.ifs 2020-04-21 2020-04-22
4297061 4297061 DIVIDEND DELETE 500472303 Optional B 0 1 5 .795263 0 39 2020-05-05 2020-05-06 2020-06-04 2020-01-31 0 2020-01-31 2020-02-03 0 0006046875 20200421.ifs 2020-04-21 2020-04-22
4297062 4297062 DIVIDEND DELETE 500472303 Optional B 0 1 5 .795263 0 39 2020-05-05 2020-05-06 2020-06-04 2020-01-31 0 2020-01-31 2020-02-03 0 0006046875 20200421.ifs 2020-04-21 2020-04-22
4297063 4297063 DIVIDEND ADD 500472303 0 0 E 0 0 0 58 ? ? 2020-06-04 2020-01-31 1 2020-01-31 2020-04-21 0 0006046875 20200421.ifs 2020-04-21 2020-04-22
4297064 4297064 DIVIDEND ADD 500472303 0 0 E 0 0 0 58 ? ? 2020-06-04 2020-01-31 1 2020-01-31 2020-04-21 0 0006046875 20200421.ifs 2020-04-21 2020-04-22
4295131 4295131 DIVIDEND ADD 500472303 B 0 1 5 .795263 39 2020-05-05 2020-05-06 2020-06-04 2020-04-20 0 2020-04-20 ? 0 0006046875 20200420.ifs 2020-04-20 2020-04-21
4295250 4295250 DIVIDEND ADD 500472303 B 0 1 5 .795263 39 2020-05-05 2020-05-06 2020-06-04 2020-04-20 0 2020-04-20 ? 0 0006046875 20200420.ifs 2020-04-20 2020-04-21
4186149 4186149 DIVIDEND ADD 500472303 B 0 1 5 .795263 39 2020-05-05 2020-05-06 2020-06-04 2020-01-31 0 2020-01-31 ? 0 0006046875 20200131.ifs 2020-01-31 2020-02-01
4186230 4186230 DIVIDEND ADD 500472303 B 0 1 5 .795263 39 2020-05-05 2020-05-06 2020-06-04 2020-01-31 0 2020-01-31 ? 0 0006046875 20200131.ifs 2020-01-31 2020-02-01
3782464 3782464 DIVIDEND CHANGE 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 2 2019-04-18 2019-06-14 0 0005871475 20190617.ifs 2019-06-17 2019-06-18
3782466 3782465 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 2 2019-04-18 2019-06-17 0 0005871475 20190617.ifs 2019-06-17 2019-06-18
3782503 3782503 DIVIDEND CHANGE 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 2 2019-04-18 2019-06-14 0 0005871475 20190617.ifs 2019-06-17 2019-06-18
3782505 3782504 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 2 2019-04-18 2019-06-17 0 0005871475 20190617.ifs 2019-06-17 2019-06-18
3780734 3780734 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-13 0 0005871475 20190614.ifs 2019-06-14 2019-06-15
3780736 3780735 DIVIDEND CHANGE 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 2 2019-04-18 2019-06-14 0 0005871475 20190614.ifs 2019-06-14 2019-06-15
3780762 3780762 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-13 0 0005871475 20190614.ifs 2019-06-14 2019-06-15
3780764 3780763 DIVIDEND CHANGE 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 2 2019-04-18 2019-06-14 0 0005871475 20190614.ifs 2019-06-14 2019-06-15
3776979 3776979 DIVIDEND CHANGE 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-12 0 0005871475 20190613.ifs 2019-06-13 2019-06-14
3776981 3776980 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-13 0 0005871475 20190613.ifs 2019-06-13 2019-06-14
3776996 3776996 DIVIDEND CHANGE 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-12 0 0005871475 20190613.ifs 2019-06-13 2019-06-14
3776998 3776997 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-13 0 0005871475 20190613.ifs 2019-06-13 2019-06-14
3775949 3775949 DIVIDEND DELETE 500472303 Optional B 0 1 5 .816099 0 39 2019-05-13 2019-05-14 2019-06-13 2019-04-18 0 2019-04-18 2019-04-22 0 0005871475 20190612.ifs 2019-06-12 2019-06-13
3775951 3775951 DIVIDEND ADD 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-12 0 0005871475 20190612.ifs 2019-06-12 2019-06-13
3776022 3776022 DIVIDEND DELETE 500472303 Optional B 0 1 5 .816099 0 39 2019-05-13 2019-05-14 2019-06-13 2019-04-18 0 2019-04-18 2019-04-22 0 0005871475 20190612.ifs 2019-06-12 2019-06-13
3776024 3776024 DIVIDEND ADD 500472303 B 0 1 0 .817039 0 02 2019-05-13 2019-05-14 2019-06-13 2019-04-18 1 2019-04-18 2019-06-12 0 0005871475 20190612.ifs 2019-06-12 2019-06-13
3688427 3688427 DIVIDEND ADD 500472303 B 0 1 5 .816099 39 2019-05-13 2019-05-14 2019-06-13 2019-04-18 0 2019-04-18 ? 0 0005871475 20190418.ifs 2019-04-18 2019-04-19
3688430 3688430 DIVIDEND ADD 500472303 B 0 1 5 .816099 39 2019-05-13 2019-05-14 2019-06-13 2019-04-18 0 2019-04-18 ? 0 0005871475 20190418.ifs 2019-04-18 2019-04-19
3130470 3130470 DIVIDEND CHANGE 500472303 B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 2 2018-01-30 2018-06-07 0 0005605671 20180608.ifs 2018-06-08 2018-06-09
3130471 3130471 DIVIDEND CHANGE 500472303 B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 2 2018-01-30 2018-06-07 0 0005605671 20180608.ifs 2018-06-08 2018-06-09
3130472 3130471 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 2 2018-01-30 2018-06-08 0 0005605671 20180608.ifs 2018-06-08 2018-06-09
3130473 3130472 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 2 2018-01-30 2018-06-08 0 0005605671 20180608.ifs 2018-06-08 2018-06-09
3130092 3130092 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 1 2018-01-30 2018-06-06 0 0005605671 20180607.ifs 2018-06-07 2018-06-08
3130094 3130093 DIVIDEND CHANGE 500472303 B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 2 2018-01-30 2018-06-07 0 0005605671 20180607.ifs 2018-06-07 2018-06-08
3130185 3130185 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 1 2018-01-30 2018-06-06 0 0005605671 20180607.ifs 2018-06-07 2018-06-08
3130187 3130186 DIVIDEND CHANGE 500472303 B 0 1 0 .79849 0 02 2018-05-07 2018-05-08 2018-06-06 2018-01-30 2 2018-01-30 2018-06-07 0 0005605671 20180607.ifs 2018-06-07 2018-06-08
2934030 2934030 DIVIDEND ADD 500472303 B 0 1 5 .842948 39 2018-05-07 2018-05-08 2018-06-06 2018-01-30 0 2018-01-30 ? 0 0005605671 20180130.ifs 2018-01-30 2018-01-31
2934986 2934986 DIVIDEND ADD 500472303 B 0 1 5 .842948 39 2018-05-07 2018-05-08 2018-06-06 2018-01-30 0 2018-01-30 ? 0 0005605671 20180130.ifs 2018-01-30 2018-01-31
2592907 2592907 DIVIDEND CHANGE 500472303 B 0 1 0 .762926 02 2017-05-12 2017-05-16 2017-06-14 2017-02-03 0 ? 2017-06-15 0 0005386477 20170616.ifs 2017-06-16 2017-06-17
2592908 2592907 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .762926 0 02 2017-05-12 2017-05-16 2017-06-14 2017-02-03 0 ? 2017-06-16 0 0005386477 20170616.ifs 2017-06-16 2017-06-17
2592256 2592256 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .762926 02 2017-05-12 2017-05-16 2017-06-14 2017-02-03 0 ? 2017-06-14 0 0005386477 20170615.ifs 2017-06-15 2017-06-16
2592257 2592256 DIVIDEND CHANGE 500472303 B 0 1 0 .762926 02 2017-05-12 2017-05-16 2017-06-14 2017-02-03 0 ? 2017-06-15 0 0005386477 20170615.ifs 2017-06-15 2017-06-16
2589970 2589970 DIVIDEND ADD 500472303 Optional B 0 1 0 .762926 02 2017-05-12 2017-05-16 2017-06-14 2017-02-03 0 ? 2017-06-14 0 0005386477 20170614.ifs 2017-06-14 2017-06-15
2223463 2223463 DIVIDEND CHANGE 500472303 B 0 1 0 .766224 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-16 0 0005175118 20160617.ifs 2016-06-17 2016-06-18
2223464 2223463 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .766224 0 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-17 0 0005175118 20160617.ifs 2016-06-17 2016-06-18
2222775 2222775 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .766224 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-15 0 0005175118 20160616.ifs 2016-06-16 2016-06-17
2222776 2222775 DIVIDEND CHANGE 500472303 B 0 1 0 .766224 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-16 0 0005175118 20160616.ifs 2016-06-16 2016-06-17
2220564 2220564 DIVIDEND ADD 500472303 B 0 1 0 .766224 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-15 0 0005175118 20160615.ifs 2016-06-15 2016-06-16
2220565 2220565 DIVIDEND CHANGE 500472303 B 0 1 0 .759016 0 52 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2015-06-11 0 0004957378 20160615.ifs 2016-06-15 2016-06-16
2220566 2220565 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .759016 0 52 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2016-06-15 0 0004957378 20160615.ifs 2016-06-15 2016-06-16
2220567 2220567 DIVIDEND CHANGE 500472303 B 0 1 0 .766224 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-15 0 0005175118 20160615.ifs 2016-06-15 2016-06-16
2220568 2220567 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .766224 02 2016-05-13 2016-05-17 2016-06-15 2016-02-24 0 ? 2016-06-15 0 0005175118 20160615.ifs 2016-06-15 2016-06-16
1942926 1942926 EQUITY CHANGE 500472303 NY RGSRY SH2000 0 0 2000-07-14 ? 8 yes yes no 2001-03-20 2003-04-03 ? 20150819.ifs 2015-08-19 2015-08-20
1942927 1942926 EQUITY CHANGE 500472303 NY RGSRY SH2000 0 0 2000-07-14 ? 1 yes no no 2001-03-20 2015-08-19 ? 20150819.ifs 2015-08-19 2015-08-20
1884825 1884825 DIVIDEND DELETE 500472303 Optional B 0 1 0 .759016 0 02 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2015-06-10 0 0004957378 20150611.ifs 2015-06-11 2015-06-12
1884826 1884826 DIVIDEND ADD 500472303 B 0 1 0 .759016 0 52 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2015-06-11 0 0004957378 20150611.ifs 2015-06-11 2015-06-12
1883788 1883788 DIVIDEND DELETE 500472303 B 1 0 .759016 02 2015-05-08 2015-05-12 2015-06-10 ? 0 2015-06-09 ? 0 0004957378 20150610.ifs 2015-06-10 2015-06-11
1883789 1883789 DIVIDEND ADD 500472303 B 0 1 0 .759016 0 02 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2015-06-10 0 0004957378 20150610.ifs 2015-06-10 2015-06-11
1883790 1883790 DIVIDEND CHANGE 500472303 B 0 1 0 .759016 0 02 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2015-06-10 0 0004957378 20150610.ifs 2015-06-10 2015-06-11
1883791 1883790 DIVIDEND CHANGE 500472303 Optional B 0 1 0 .759016 0 02 2015-05-08 2015-05-12 2015-06-10 2015-06-09 0 ? 2015-06-10 0 0004957378 20150610.ifs 2015-06-10 2015-06-11
1606489 1606489 DIVIDEND CHANGE 500472303 B 0 1 0 .925548 0 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-08-13 0 0004739589 20140814.ifs 2014-08-14 2014-08-15
1606490 1606489 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional B 0 1 0 .925548 0 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-08-14 0 0004739589 20140814.ifs 2014-08-14 2014-08-15
1606191 1606191 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 0 .925548 0 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-06-04 0 0004739589 20140813.ifs 2014-08-13 2014-08-14
1606192 1606191 DIVIDEND CHANGE 500472303 B 0 1 0 .925548 0 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-08-13 0 0004739589 20140813.ifs 2014-08-13 2014-08-14
1542063 1542063 DIVIDEND CHANGE 500472303 B 0 1 0 .925548 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-06-03 0 0004739589 20140604.ifs 2014-06-04 2014-06-05
1542064 1542063 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 0 .925548 0 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-06-04 0 0004739589 20140604.ifs 2014-06-04 2014-06-05
1541472 1541472 DIVIDEND DELETE 500472303 Ex-date corresponds with foreign ex-date. Optional B 0 1 5 .933368 39 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-02-28 0 0004739589 20140603.ifs 2014-06-03 2014-06-04
1541473 1541473 DIVIDEND ADD 500472303 B 0 1 0 .925548 02 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-06-03 0 0004739589 20140603.ifs 2014-06-03 2014-06-04
1451497 1451497 DIVIDEND ADD 500472303 B 0 1 5 .933368 39 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-02-28 0 0004739589 20140228.ifs 2014-02-28 2014-03-01
1451498 1451498 DIVIDEND CHANGE 500472303 B 0 1 0 .82926 0 02 2013-05-07 2013-05-09 2013-06-05 2013-02-27 2 2013-02-27 2013-06-06 0 0004531035 20140228.ifs 2014-02-28 2014-03-01
1451499 1451498 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional B 0 1 0 .82926 0 02 2013-05-07 2013-05-09 2013-06-05 2013-02-27 2 2013-02-27 2014-02-28 0 0004531035 20140228.ifs 2014-02-28 2014-03-01
1451500 1451500 DIVIDEND CHANGE 500472303 B 0 1 5 .933368 39 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-02-28 0 0004739589 20140228.ifs 2014-02-28 2014-03-01
1451501 1451500 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional B 0 1 5 .933368 39 2014-05-05 2014-05-07 2014-06-04 2014-02-26 0 ? 2014-02-28 0 0004739589 20140228.ifs 2014-02-28 2014-03-01
1205782 1205782 DIVIDEND CHANGE 500472303 B 0 1 0 .82926 0 02 2013-05-07 2013-05-09 2013-06-05 2013-02-27 1 2013-02-27 2013-06-03 0 0004531035 20130606.ifs 2013-06-06 2013-06-07
1205783 1205782 DIVIDEND CHANGE 500472303 B 0 1 0 .82926 0 02 2013-05-07 2013-05-09 2013-06-05 2013-02-27 2 2013-02-27 2013-06-06 0 0004531035 20130606.ifs 2013-06-06 2013-06-07
1201897 1201897 DIVIDEND DELETE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 5 .834615 0 39 2013-05-07 2013-05-09 2013-06-05 2013-02-27 0 2013-02-27 2013-02-28 0 0004531035 20130603.ifs 2013-06-03 2013-06-04
1201898 1201898 DIVIDEND ADD 500472303 B 0 1 0 .82926 0 02 2013-05-07 2013-05-09 2013-06-05 2013-02-27 1 2013-02-27 2013-06-03 0 0004531035 20130603.ifs 2013-06-03 2013-06-04
1187295 1187295 CORPACTION DELETE 500472303 01 # 2013-05-15 500472303 01 2013-05-15 20130517.ifs 2013-05-17 2013-05-18
1187297 1187296 CORPACTION DELETE 500472303 01 2013-05-15 PHG KONINKLIJKE PHILIPS ELECT NV NY RGSRY SH2000 PHG KONINKLIJKE PHILIPS NV NY RGSRY SH2000 ? 2013-05-15 20130517.ifs 2013-05-17 2013-05-18
1187732 1187732 CORPACTION ADD 500472303 01 # 2013-05-17 500472303 01 2013-05-17 20130517.ifs 2013-05-17 2013-05-18
1187733 1187733 CORPACTIONAUX ADD 500472303 01 2013-05-17 PHG KONINKLIJKE PHILIPS ELECT NV NY RGSRY SH2000 PHG KONINKLIJKE PHILIPS NV NY RGSRY SH2000 ? 2013-05-17 20130517.ifs 2013-05-17 2013-05-18
1187734 1187734 EXCHANGE CHANGE 500472303 01 2000-08-01 2013-05-16 PHG 0 0 2001-01-29 2013-05-15 20130517.ifs 2013-05-17 2013-05-18
1187735 1187734 EXCHANGE CHANGE 500472303 01 2000-08-01 2013-05-16 PHG 0 0 2001-01-29 2013-05-17 20130517.ifs 2013-05-17 2013-05-18
1185832 1185832 CORPACTION ADD 500472303 01 # 2013-05-15 500472303 01 2013-05-15 20130515.ifs 2013-05-15 2013-05-16
1185833 1185833 CORPACTIONAUX ADD 500472303 01 2013-05-15 PHG KONINKLIJKE PHILIPS ELECT NV NY RGSRY SH2000 PHG KONINKLIJKE PHILIPS NV NY RGSRY SH2000 ? 2013-05-15 20130515.ifs 2013-05-15 2013-05-16
1118943 1118943 DIVIDEND ADD 500472303 B 0 1 5 .834615 39 2013-05-07 2013-05-09 2013-06-05 2013-02-27 0 2013-02-27 ? 0 0004531035 20130227.ifs 2013-02-27 2013-02-28
877698 877698 DIVIDEND CHANGE 500472303 B 0 1 0 .801082 0 02 2012-05-02 2012-05-04 2012-05-31 2012-02-23 2 2012-02-23 2012-06-01 0 0004334986 20120604.ifs 2012-06-04 2012-06-05
877699 877698 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional. B 0 1 0 .801082 0 02 2012-05-02 2012-05-04 2012-05-31 2012-02-23 2 2012-02-23 2012-06-04 0 0004334986 20120604.ifs 2012-06-04 2012-06-05
875970 875970 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional. 1 sh. for ev B 0 1 0 .801082 0 02 2012-05-02 2012-05-04 2012-05-31 2012-02-23 1 2012-02-23 2012-05-30 0 0004334986 20120601.ifs 2012-06-01 2012-06-02
875971 875970 DIVIDEND CHANGE 500472303 B 0 1 0 .801082 0 02 2012-05-02 2012-05-04 2012-05-31 2012-02-23 2 2012-02-23 2012-06-01 0 0004334986 20120601.ifs 2012-06-01 2012-06-02
869055 869055 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional. 1 sh. for ev B 0 1 0 .801082 0 02 2012-05-02 2012-05-04 2012-05-31 2012-02-23 1 2012-02-23 2012-05-30 0 0004334986 20120531.ifs 2012-05-31 2012-06-01
869056 869055 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional. 1 sh. for ev B 0 1 0 .801082 0 02 2012-05-02 2012-05-04 2012-05-31 2012-02-23 1 2012-02-23 2012-05-30 0 0004334986 20120531.ifs 2012-05-31 2012-06-01
784304 784304 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 5 .848321 0 39 2012-05-02 2012-05-04 2012-05-31 2012-02-23 0 2012-02-23 2012-02-24 0 0004334986 20120224.ifs 2012-02-24 2012-02-25
784305 784304 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional. B 0 1 5 .848321 0 39 2012-05-02 2012-05-04 2012-05-31 2012-02-23 0 2012-02-23 2012-02-24 0 0004334986 20120224.ifs 2012-02-24 2012-02-25
784041 784041 DIVIDEND ADD 500472303 B 0 1 5 .848321 39 2012-05-02 2012-05-04 2012-05-31 2012-02-23 0 2012-02-23 ? 0 0004334986 20120223.ifs 2012-02-23 2012-02-24
711903 711903 DIVIDEND CHANGE 500472303 B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 3 2011-02-18 2011-12-02 0 0004148150 20111205.ifs 2011-12-05 2011-12-06
711904 711903 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. Optional. B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 3 2011-02-18 2011-12-05 0 0004148150 20111205.ifs 2011-12-05 2011-12-06
711190 711190 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 2 2011-02-18 2011-05-11 0 0004148150 20111202.ifs 2011-12-02 2011-12-03
711191 711190 DIVIDEND CHANGE 500472303 B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 3 2011-02-18 2011-12-02 0 0004148150 20111202.ifs 2011-12-02 2011-12-03
523836 523836 DIVIDEND CHANGE 500472303 B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 2 2011-02-18 2011-05-10 0 0004148150 20110511.ifs 2011-05-11 2011-05-12
523837 523836 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 2 2011-02-18 2011-05-11 0 0004148150 20110511.ifs 2011-05-11 2011-05-12
523628 523628 DIVIDEND CHANGE 500472303 Optional. Ex-date corresponds with foreign ex-date. B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 1 2011-02-18 2011-05-03 0 0004148150 20110510.ifs 2011-05-10 2011-05-11
523629 523628 DIVIDEND CHANGE 500472303 B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 2 2011-02-18 2011-05-10 0 0004148150 20110510.ifs 2011-05-10 2011-05-11
517981 517981 DIVIDEND CHANGE 500472303 B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 1 2011-02-18 2011-05-02 0 0004148150 20110503.ifs 2011-05-03 2011-05-04
517982 517981 DIVIDEND CHANGE 500472303 Optional. Ex-date corresponds with foreign ex-date. B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 1 2011-02-18 2011-05-03 0 0004148150 20110503.ifs 2011-05-03 2011-05-04
516592 516592 DIVIDEND DELETE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 5 .864195 0 39 2011-04-04 2011-04-06 2011-05-04 2011-02-18 0 2011-02-18 2011-02-22 0 0004148150 20110502.ifs 2011-05-02 2011-05-03
516593 516593 DIVIDEND ADD 500472303 B 0 1 0 .945859 0 02 2011-04-04 2011-04-06 2011-05-04 2011-02-18 1 2011-02-18 2011-05-02 0 0004148150 20110502.ifs 2011-05-02 2011-05-03
445722 445722 DIVIDEND ADD 500472303 B 0 1 5 .864195 39 2011-04-04 2011-04-06 2011-05-04 2011-02-18 0 2011-02-18 ? 0 0004148150 20110218.ifs 2011-02-18 2011-02-19
169000 169000 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. appx B 0 1 0 .7926 0 02 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-04-27 0 0003967383 20100428.ifs 2010-04-28 2010-04-29
169001 169000 DIVIDEND CHANGE 500472303 Ex-date corresponds with foreign ex-date. B 0 1 0 .7926 0 02 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-04-28 0 0003967383 20100428.ifs 2010-04-28 2010-04-29
168707 168707 DIVIDEND DELETE 500472303 Ex-date corresponds with foreign ex-date. appx B 0 1 5 .80837 0 39 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-03-25 0 0003967383 20100427.ifs 2010-04-27 2010-04-28
168708 168708 DIVIDEND ADD 500472303 Ex-date corresponds with foreign ex-date. appx B 0 1 0 .7926 0 02 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-04-27 0 0003967383 20100427.ifs 2010-04-27 2010-04-28
140572 140572 DIVIDEND DELETE 500472303 Ex-date corresponds with foreign ex-date. appx 0 0 4 0 .95102 0 04 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-02-23 0 0003967383 20100325.ifs 2010-03-25 2010-04-07
140573 140573 DIVIDEND ADD 500472303 Ex-date corresponds with foreign ex-date. appx B 0 1 5 .80837 0 39 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-03-25 0 0003967383 20100325.ifs 2010-03-25 2010-04-07
114725 114725 DIVIDEND DELETE 500472303 0 0 1 5 .95102 19 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 2010-02-22 ? 0 0003967383 20100223.ifs 2010-02-23 2010-04-07
114726 114726 DIVIDEND ADD 500472303 Ex-date corresponds with foreign ex-date. appx 0 0 4 0 .95102 0 04 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 ? 2010-02-23 0 0003967383 20100223.ifs 2010-02-23 2010-04-07
114488 114488 DIVIDEND ADD 500472303 0 0 1 5 .95102 19 2010-03-29 2010-03-31 2010-04-28 2010-02-22 0 2010-02-22 ? 0 0003967383 20100222.ifs 2010-02-22 2010-04-07


Old Cusip
entryId groupId EQUITY CHANGE CUSIP DESCRIPTION ISSUE
STATUS
CODE
ISSUE
TYPE
CODE
ADD
DATE
EXPIRATION
DATE
PAYMENT
FREQUENCY
CODE
MARGIN
FLAG
OPTION
FLAG
CONVERTED
CUSIP
NASDAQ
MARKET
CODE
INDEX
ISSUER
CHANGE
DATE
MERGENT
CHANGE
DATE
MATURE
DATE
undefined1 undefined2 undefined3 undefined4 temp1 temp2 fileName fileDate processDate


Your Name Click here to open the child window


BACK UP Institutions before committing

SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 139551
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC