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 PSMB Charts Yahoo PSMB Profile
  Run PSMB Institutional Summary Yahoo PSMB Key Statisics
  J3 Open PSMB Pricing Yahoo PSMB Pricing
  J3 PSMB Insider   J3 PSMB Insitutions Yahoo PSMB Holders
     
  Open up Sector/Exchange Map Fidelity PSMB Lookup
  Open up sec.gov For Market Ca MSN PSMB 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 : 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:166940
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
5318227 5318227 EQUITY CHANGE 46090A200 BALANCED MULTI-ASSET ALLOCATION ETF 0 A 2018-06-04 ? 4 no no no ? 2018-06-05 ? 20230626.ifs 2023-06-26 2023-06-27
5318228 5318227 EQUITY CHANGE 46090A200 BALANCED MULTI-ASSET ALLOCATION ETF L A 2018-06-04 2023-06-26 4 no no no ? 2023-06-26 ? 20230626.ifs 2023-06-26 2023-06-27
5314509 5314509 DIVIDEND ADD 46090A200 0 0 1 0 .11243 00 2023-06-21 2023-06-22 2023-06-30 2023-06-20 0 2023-06-20 ? 0 0006741378 20230620.ifs 2023-06-20 2023-06-21
5250637 5250637 DIVIDEND ADD 46090A200 0 0 1 0 .09808 00 2023-03-20 2023-03-21 2023-03-24 2023-03-17 0 2023-03-17 ? 0 0006697139 20230317.ifs 2023-03-17 2023-03-18
5174456 5174456 DIVIDEND ADD 46090A200 0 0 1 0 .11084 00 2022-12-19 2022-12-20 2022-12-23 2022-12-16 0 2022-12-16 ? 0 0006641134 20221216.ifs 2022-12-16 2022-12-17
5099164 5099164 DIVIDEND ADD 46090A200 0 0 1 0 .12705 00 2022-09-19 2022-09-20 2022-09-23 2022-09-16 0 2022-09-16 ? 0 0006584701 20220916.ifs 2022-09-16 2022-09-17
5036270 5036270 DIVIDEND ADD 46090A200 0 0 1 0 .11212 00 2022-06-21 2022-06-22 2022-06-30 2022-06-17 0 2022-06-17 ? 0 0006540530 20220617.ifs 2022-06-17 2022-06-18
4973890 4973890 DIVIDEND ADD 46090A200 0 0 1 0 .06271 00 2022-03-21 2022-03-22 2022-03-31 2022-03-18 0 2022-03-18 ? 0 0006496256 20220318.ifs 2022-03-18 2022-03-19
4900433 4900433 DIVIDEND ADD 46090A200 0 0 1 0 .14255 00 2021-12-20 2021-12-21 2021-12-31 2021-12-17 0 2021-12-17 ? 0 0006435415 20211217.ifs 2021-12-17 2021-12-18
4804742 4804742 DIVIDEND ADD 46090A200 0 0 1 0 .06857 00 2021-09-20 2021-09-21 2021-09-30 2021-09-17 0 2021-09-17 ? 0 0006369345 20210917.ifs 2021-09-17 2021-09-18
4733212 4733212 DIVIDEND ADD 46090A200 0 0 1 0 .06004 00 2021-06-21 2021-06-22 2021-06-30 2021-06-18 0 2021-06-18 ? 0 0006324403 20210618.ifs 2021-06-18 2021-06-19
4657514 4657514 DIVIDEND ADD 46090A200 0 0 1 0 .04737 00 2021-03-22 2021-03-23 2021-03-31 2021-03-19 0 2021-03-19 ? 0 0006279636 20210319.ifs 2021-03-19 2021-03-20
4558862 4558862 DIVIDEND ADD 46090A200 0 0 1 0 .13338 00 2020-12-21 2020-12-22 2020-12-31 2020-12-18 0 2020-12-18 ? 0 0006224483 20201218.ifs 2020-12-18 2020-12-19
4465639 4465639 DIVIDEND ADD 46090A200 0 0 1 0 .06509 00 2020-09-21 2020-09-22 2020-09-30 2020-09-18 0 2020-09-18 ? 0 0006160943 20200918.ifs 2020-09-18 2020-09-19
4395973 4395973 DIVIDEND ADD 46090A200 0 0 1 0 .08173 00 2020-06-22 2020-06-23 2020-06-30 2020-06-19 0 2020-06-19 ? 0 0006115709 20200619.ifs 2020-06-19 2020-06-20
4246567 4246567 DIVIDEND ADD 46090A200 0 0 1 0 .05762 00 2020-03-23 2020-03-24 2020-03-31 2020-03-20 0 2020-03-20 ? 0 0006071691 20200320.ifs 2020-03-20 2020-03-21
4246649 4246649 DIVIDEND ADD 46090A200 0 0 1 0 .05762 00 2020-03-23 2020-03-24 2020-03-31 2020-03-20 0 2020-03-20 ? 0 0006071691 20200320.ifs 2020-03-20 2020-03-21
4107234 4107234 DIVIDEND ADD 46090A200 8 0 1 9 .06667 95 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 2 0006019366 20191220.ifs 2019-12-20 2019-12-21
4107236 4107236 DIVIDEND ADD 46090A200 8 0 1 9 .28333 96 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 1 0006019365 20191220.ifs 2019-12-20 2019-12-21
4107238 4107238 DIVIDEND ADD 46090A200 0 0 1 0 .24667 00 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 0 0006019363 20191220.ifs 2019-12-20 2019-12-21
4108103 4108103 DIVIDEND ADD 46090A200 8 0 1 9 .06667 95 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 2 0006019366 20191220.ifs 2019-12-20 2019-12-21
4108105 4108105 DIVIDEND ADD 46090A200 8 0 1 9 .28333 96 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 1 0006019365 20191220.ifs 2019-12-20 2019-12-21
4108107 4108107 DIVIDEND ADD 46090A200 0 0 1 0 .24667 00 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 0 0006019363 20191220.ifs 2019-12-20 2019-12-21
3931446 3931446 DIVIDEND ADD 46090A200 0 0 1 0 .09518 00 2019-09-23 2019-09-24 2019-09-30 2019-09-20 0 2019-09-20 ? 0 0005948347 20190920.ifs 2019-09-20 2019-09-21
3931658 3931658 DIVIDEND ADD 46090A200 0 0 1 0 .09518 00 2019-09-23 2019-09-24 2019-09-30 2019-09-20 0 2019-09-20 ? 0 0005948347 20190920.ifs 2019-09-20 2019-09-21
3793421 3793421 DIVIDEND ADD 46090A200 0 0 1 0 .08763 00 2019-06-24 2019-06-25 2019-06-28 2019-06-21 0 2019-06-21 ? 0 0005902475 20190621.ifs 2019-06-21 2019-06-22
3793424 3793424 DIVIDEND ADD 46090A200 0 0 1 0 .08763 00 2019-06-24 2019-06-25 2019-06-28 2019-06-21 0 2019-06-21 ? 0 0005902475 20190621.ifs 2019-06-21 2019-06-22
3633698 3633698 DIVIDEND ADD 46090A200 0 0 1 0 .05115 00 2019-03-18 2019-03-19 2019-03-29 2019-03-15 0 2019-03-15 ? 0 0005853270 20190315.ifs 2019-03-15 2019-03-16
3633724 3633724 DIVIDEND ADD 46090A200 0 0 1 0 .05115 00 2019-03-18 2019-03-19 2019-03-29 2019-03-15 0 2019-03-15 ? 0 0005853270 20190315.ifs 2019-03-15 2019-03-16
3493979 3493979 DIVIDEND ADD 46090A200 8 0 1 9 .03076 95 2018-12-26 2018-12-27 2018-12-31 2018-12-24 0 2018-12-24 ? 1 0005804194 20181224.ifs 2018-12-24 2018-12-25
3493980 3493980 DIVIDEND ADD 46090A200 8 0 1 9 .00955 96 2018-12-26 2018-12-27 2018-12-31 2018-12-24 0 2018-12-24 ? 0 0005804193 20181224.ifs 2018-12-24 2018-12-25
3495252 3495252 DIVIDEND ADD 46090A200 8 0 1 9 .03076 95 2018-12-26 2018-12-27 2018-12-31 2018-12-24 0 2018-12-24 ? 1 0005804194 20181224.ifs 2018-12-24 2018-12-25
3495253 3495253 DIVIDEND ADD 46090A200 8 0 1 9 .00955 96 2018-12-26 2018-12-27 2018-12-31 2018-12-24 0 2018-12-24 ? 0 0005804193 20181224.ifs 2018-12-24 2018-12-25
3489962 3489962 DIVIDEND ADD 46090A200 0 0 1 0 .15063 00 2018-12-24 2018-12-26 2018-12-31 2018-12-21 0 2018-12-21 ? 0 0005803710 20181221.ifs 2018-12-21 2018-12-22
3489965 3489965 DIVIDEND ADD 46090A200 0 0 1 0 .15063 00 2018-12-24 2018-12-26 2018-12-31 2018-12-21 0 2018-12-21 ? 0 0005803710 20181221.ifs 2018-12-21 2018-12-22
3294592 3294592 DIVIDEND ADD 46090A200 0 0 1 0 .06869 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 0 2018-09-21 ? 0 0005727321 20180921.ifs 2018-09-21 2018-09-22
3294605 3294605 DIVIDEND ADD 46090A200 0 0 1 0 .06869 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 0 2018-09-21 ? 0 0005727321 20180921.ifs 2018-09-21 2018-09-22
3142096 3142096 DIVIDEND ADD 46090A200 0 0 1 0 .07402 00 2018-06-18 2018-06-19 2018-06-29 2018-06-15 0 2018-06-15 ? 0 0005675888 20180615.ifs 2018-06-15 2018-06-16
3142133 3142133 DIVIDEND ADD 46090A200 0 0 1 0 .07402 00 2018-06-18 2018-06-19 2018-06-29 2018-06-15 0 2018-06-15 ? 0 0005675888 20180615.ifs 2018-06-15 2018-06-16
3126200 3126200 EQUITY ADD 46090A200 NEW ISSUE 0 0 2018-06-04 ? 0 no no no ? ? ? 20180604.ifs 2018-06-04 2018-06-05
3126203 3126203 EQUITY CHANGE 46090A200 NEW ISSUE 0 0 2018-06-04 ? 0 no no no ? ? ? 20180604.ifs 2018-06-04 2018-06-05
3126205 3126204 EQUITY CHANGE 46090A200 BALANCED MULTI-ASSET ALLOCATION ETF N A 2018-06-04 ? 0 no no no ? 2018-06-04 ? 20180604.ifs 2018-06-04 2018-06-05
3126209 3126209 EQUITY ADD 46090A200 NEW ISSUE 0 0 2018-06-04 ? 0 no no no ? ? ? 20180604.ifs 2018-06-04 2018-06-05
3126211 3126211 EQUITY CHANGE 46090A200 NEW ISSUE 0 0 2018-06-04 ? 0 no no no ? ? ? 20180604.ifs 2018-06-04 2018-06-05
3126213 3126212 EQUITY CHANGE 46090A200 BALANCED MULTI-ASSET ALLOCATION ETF N A 2018-06-04 ? 0 no no no ? 2018-06-04 ? 20180604.ifs 2018-06-04 2018-06-05


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