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 CNPF Charts Yahoo CNPF Profile
  Run CNPF Institutional Summary Yahoo CNPF Key Statisics
  J3 Open CNPF Pricing Yahoo CNPF Pricing
  J3 CNPF Insider   J3 CNPF Insitutions Yahoo CNPF Holders
     
  Open up Sector/Exchange Map Fidelity CNPF Lookup
  Open up sec.gov For Market Ca MSN CNPF 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
37950E481 DELETE RUN
 

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 : N/A 0   Update Insititution By Cusips
% Owned by Insititutions: N/A % 0 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:159667
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
1658966 1658966 CORPACTION ADD 37950E481 04 S 2014-10-17 2014-10-17 20141017.ifs 2014-10-17 2014-10-18
1658967 1658967 EQUITY CHANGE 37950E481 GLOBAL X CDA PFD ETF 0 A 2011-05-24 ? 0 no no no 2011-05-24 2011-05-26 ? 20141017.ifs 2014-10-17 2014-10-18
1658968 1658967 EQUITY CHANGE 37950E481 GLOBAL X CDA PFD ETF S A 2011-05-24 2014-10-17 0 no no no 2011-05-24 2014-10-17 ? 20141017.ifs 2014-10-17 2014-10-18
1645068 1645068 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-10-01 2014-10-03 2014-10-10 2014-09-30 0 2014-09-30 ? 0 0004850791 20140930.ifs 2014-09-30 2014-10-01
1636603 1636603 DIVIDEND CHANGE 37950E481 0 0 1 0 .0415 00 2014-09-02 2014-09-04 2014-09-11 2014-08-29 0 2014-08-29 ? 0 0004834087 20140923.ifs 2014-09-23 2014-09-24
1636604 1636603 DIVIDEND CHANGE 37950E481 0 0 1 0 .0415 00 2014-09-02 2014-09-04 2014-09-11 2014-08-29 1 2014-08-29 2014-09-23 0 0004834087 20140923.ifs 2014-09-23 2014-09-24
1617669 1617669 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-09-02 2014-09-04 2014-09-11 2014-08-29 0 2014-08-29 ? 0 0004834087 20140829.ifs 2014-08-29 2014-08-30
1592734 1592734 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-08-01 2014-08-05 2014-08-12 2014-07-31 0 2014-07-31 ? 0 0004820240 20140731.ifs 2014-07-31 2014-08-01
1567658 1567658 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-07-01 2014-07-03 2014-07-11 2014-06-30 0 2014-06-30 ? 0 0004805792 20140630.ifs 2014-06-30 2014-07-01
1535256 1535256 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-06-02 2014-06-04 2014-06-11 2014-05-30 0 2014-05-30 ? 0 0004787384 20140530.ifs 2014-05-30 2014-05-31
1506558 1506558 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-05-01 2014-05-05 2014-05-12 2014-04-30 0 2014-04-30 ? 0 0004773447 20140430.ifs 2014-04-30 2014-05-01
1482820 1482820 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-04-01 2014-04-03 2014-04-10 2014-03-31 0 2014-03-31 ? 0 0004759441 20140331.ifs 2014-03-31 2014-04-01
1453721 1453721 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-03-03 2014-03-05 2014-03-12 2014-02-28 0 2014-02-28 ? 0 0004741629 20140228.ifs 2014-02-28 2014-03-01
1432924 1432924 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2014-02-03 2014-02-05 2014-02-12 2014-01-31 0 2014-01-31 ? 0 0004728600 20140131.ifs 2014-01-31 2014-02-01
1397055 1397055 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-12-27 2013-12-31 2014-01-08 2013-12-26 0 2013-12-26 ? 0 0004705391 20131226.ifs 2013-12-26 2013-12-27
1349920 1349920 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-12-02 2013-12-04 2013-12-11 2013-11-29 0 2013-11-29 ? 0 0004663130 20131129.ifs 2013-11-29 2013-11-30
1328238 1328238 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-11-01 2013-11-05 2013-11-12 2013-10-31 0 2013-10-31 ? 0 0004650354 20131031.ifs 2013-10-31 2013-11-01
1303091 1303091 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-10-01 2013-10-03 2013-10-10 2013-09-30 0 2013-09-30 ? 0 0004637172 20130930.ifs 2013-09-30 2013-10-01
1285738 1285738 DIVIDEND CHANGE 37950E481 0 0 1 0 .0415 00 2013-09-03 2013-09-05 2013-09-12 2013-08-30 0 2013-08-30 ? 0 0004620362 20130911.ifs 2013-09-11 2013-09-12
1285739 1285738 DIVIDEND CHANGE 37950E481 0 0 1 0 .0415 00 2013-09-03 2013-09-05 2013-09-12 2013-08-30 1 2013-08-30 2013-09-11 0 0004620362 20130911.ifs 2013-09-11 2013-09-12
1275370 1275370 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-09-03 2013-09-05 2013-09-12 2013-08-30 0 2013-08-30 ? 0 0004620362 20130830.ifs 2013-08-30 2013-08-31
1252090 1252090 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-08-01 2013-08-05 2013-08-12 2013-07-31 0 2013-07-31 ? 0 0004606955 20130731.ifs 2013-07-31 2013-08-01
1224124 1224124 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-07-01 2013-07-03 2013-07-11 2013-06-28 0 2013-06-28 ? 0 0004591656 20130628.ifs 2013-06-28 2013-06-29
1198113 1198113 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-06-03 2013-06-05 2013-06-12 2013-05-31 0 2013-05-31 ? 0 0004575919 20130531.ifs 2013-05-31 2013-06-01
1172475 1172475 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-05-01 2013-05-03 2013-05-10 2013-04-30 0 2013-04-30 ? 0 0004562794 20130430.ifs 2013-04-30 2013-05-01
1145790 1145790 DIVIDEND ADD 37950E481 0 0 1 0 .0415 00 2013-04-01 2013-04-03 2013-04-10 2013-03-28 0 2013-03-28 ? 0 0004548615 20130328.ifs 2013-03-28 2013-03-29
1121484 1121484 DIVIDEND ADD 37950E481 0 0 1 0 .0401 00 2013-03-01 2013-03-05 2013-03-12 2013-02-28 0 2013-02-28 ? 0 0004532571 20130228.ifs 2013-02-28 2013-03-01
1101412 1101412 DIVIDEND ADD 37950E481 0 0 1 0 .043276 00 2013-02-01 2013-02-05 2013-02-12 2013-01-31 0 2013-01-31 ? 0 0004520166 20130131.ifs 2013-01-31 2013-02-01
1061069 1061069 DIVIDEND ADD 37950E481 0 0 1 0 .052639 00 2012-12-27 2012-12-31 2013-01-09 2012-12-26 0 2012-12-26 ? 0 0004495934 20121226.ifs 2012-12-26 2012-12-27
1020451 1020451 DIVIDEND ADD 37950E481 0 0 1 0 .038623 00 2012-12-03 2012-12-05 2012-12-12 2012-11-30 0 2012-11-30 ? 0 0004463487 20121130.ifs 2012-11-30 2012-12-01
997721 997721 DIVIDEND ADD 37950E481 0 0 1 0 .04444 00 2012-11-01 2012-11-05 2012-11-13 2012-10-31 0 2012-10-31 ? 0 0004449821 20121031.ifs 2012-10-31 2012-11-01
970047 970047 DIVIDEND ADD 37950E481 0 0 1 0 .047765 00 2012-10-01 2012-10-03 2012-10-10 2012-09-28 0 2012-09-28 ? 0 0004436787 20120928.ifs 2012-09-28 2012-09-29
944356 944356 DIVIDEND ADD 37950E481 0 0 1 0 .043779 00 2012-09-04 2012-09-06 2012-09-13 2012-08-31 0 2012-08-31 ? 0 0004420598 20120831.ifs 2012-08-31 2012-09-01
900323 900323 DIVIDEND ADD 37950E481 0 0 1 0 .049507 00 2012-07-02 2012-07-05 2012-07-12 2012-06-29 0 2012-06-29 ? 0 0004394385 20120629.ifs 2012-06-29 2012-06-30
872434 872434 DIVIDEND ADD 37950E481 0 0 1 0 .032911 00 2012-06-01 2012-06-05 2012-06-12 2012-05-31 0 2012-05-31 ? 0 0004378653 20120531.ifs 2012-05-31 2012-06-01
847527 847527 DIVIDEND ADD 37950E481 0 0 1 0 .053414 00 2012-05-01 2012-05-03 2012-05-10 2012-04-30 0 2012-04-30 ? 0 0004366274 20120430.ifs 2012-04-30 2012-05-01
819160 819160 DIVIDEND ADD 37950E481 0 0 1 0 .066453 00 2012-04-02 2012-04-04 2012-04-12 2012-03-30 0 2012-03-30 ? 0 0004352884 20120330.ifs 2012-03-30 2012-03-31
790086 790086 DIVIDEND ADD 37950E481 0 0 1 0 .032812 00 2012-03-01 2012-03-05 2012-03-12 2012-02-29 0 2012-02-29 ? 0 0004337117 20120229.ifs 2012-02-29 2012-03-01
767238 767238 DIVIDEND ADD 37950E481 0 0 1 0 .035367 00 2012-02-01 2012-02-03 2012-02-10 2012-01-31 0 2012-01-31 ? 0 0004324905 20120131.ifs 2012-01-31 2012-02-01
739438 739438 DIVIDEND ADD 37950E481 0 0 1 0 .067779 00 2011-12-28 2011-12-30 2012-01-09 2011-12-27 0 2011-12-27 ? 0 0004304131 20111227.ifs 2011-12-27 2011-12-28
704503 704503 DIVIDEND ADD 37950E481 0 0 1 0 .020322 00 2011-12-01 2011-12-05 2011-12-12 2011-11-30 0 2011-11-30 ? 0 0004274388 20111130.ifs 2011-11-30 2011-12-01
682650 682650 DIVIDEND ADD 37950E481 0 0 1 0 .044821 00 2011-11-01 2011-11-03 2011-11-10 2011-10-31 0 2011-10-31 ? 0 0004262225 20111031.ifs 2011-10-31 2011-11-01
660078 660078 DIVIDEND ADD 37950E481 0 0 1 0 .071218 00 2011-10-03 2011-10-05 2011-10-12 2011-09-30 0 2011-09-30 ? 0 0004249193 20110930.ifs 2011-09-30 2011-10-01
630676 630676 DIVIDEND ADD 37950E481 0 0 1 0 .019776 00 2011-09-01 2011-09-06 2011-09-13 2011-08-31 0 2011-08-31 ? 0 0004234478 20110831.ifs 2011-08-31 2011-09-01
598105 598105 DIVIDEND ADD 37950E481 0 0 1 0 .043976 00 2011-08-01 2011-08-03 2011-08-10 2011-07-29 0 2011-07-29 ? 0 0004221443 20110729.ifs 2011-07-29 2011-07-30
575649 575649 DIVIDEND ADD 37950E481 0 0 1 4 .064906 00 2011-07-01 2011-07-06 2011-07-13 2011-06-30 0 2011-06-30 ? 0 0004208469 20110630.ifs 2011-06-30 2011-07-01
535624 535624 EQUITY CHANGE 37950E481 GLOBAL X CDA PFD ETF N A 2011-05-24 ? 0 no no no 2011-05-24 2011-05-24 ? 20110526.ifs 2011-05-26 2011-05-27
535625 535624 EQUITY CHANGE 37950E481 GLOBAL X CDA PFD ETF 0 A 2011-05-24 ? 0 no no no 2011-05-24 2011-05-26 ? 20110526.ifs 2011-05-26 2011-05-27
534316 534316 EXCHANGE DELETE 37950E481 04 2011-05-24 2011-05-25 CNPF 0 A 2011-05-24 ? 20110525.ifs 2011-05-25 2011-05-26
534317 534317 EXCHANGE ADD 37950E481 04 2011-05-25 2011-05-25 0 A ? 2011-05-25 20110525.ifs 2011-05-25 2011-05-26
534318 534318 EXCHANGE CHANGE 37950E481 04 2011-05-25 2011-05-25 0 A ? 2011-05-25 20110525.ifs 2011-05-25 2011-05-26
534319 534318 EXCHANGE CHANGE 37950E481 04 2011-05-25 2011-05-25 CNPF 0 A ? 2011-05-25 20110525.ifs 2011-05-25 2011-05-26
533097 533097 EQUITY ADD 37950E481 GLOBAL X CDA PFD ETF N 1 2011-05-24 ? 0 no no no 2011-05-24 ? ? 20110524.ifs 2011-05-24 2011-05-25
533098 533098 EXCHANGE ADD 37950E481 04 2011-05-24 ? CNPF 0 A 2011-05-24 ? 20110524.ifs 2011-05-24 2011-05-25
533160 533160 EQUITY CHANGE 37950E481 GLOBAL X CDA PFD ETF N 1 2011-05-24 ? 0 no no no 2011-05-24 ? ? 20110524.ifs 2011-05-24 2011-05-25
533161 533160 EQUITY CHANGE 37950E481 GLOBAL X CDA PFD ETF N A 2011-05-24 ? 0 no no no 2011-05-24 2011-05-24 ? 20110524.ifs 2011-05-24 2011-05-25


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 = 159667
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