INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 2151 | 2049 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 89.73 % | 89.62 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152193 |
reportDate | ratio | endQuaterAffected | dayFrom | dayTo |
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 | ||
5578000 | 5578000 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4607 | 00 | 2024-06-21 | 2024-06-21 | 2024-06-25 | 2024-06-18 | 0 | 2024-06-18 | ? | 0 | 0006934285 | 20240618.ifs | 2024-06-18 | 2024-06-19 | |||||||
5516150 | 5516150 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .2865 | 00 | 2024-03-15 | 2024-03-18 | 2024-03-20 | 2024-03-13 | 0 | 2024-03-14 | ? | 0 | 0006889689 | 20240314.ifs | 2024-03-14 | 2024-03-15 | |||||||
5440900 | 5440900 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .6097 | 00 | 2023-12-18 | 2023-12-19 | 2023-12-21 | 2023-12-14 | 0 | 2023-12-14 | ? | 0 | 0006832980 | 20231214.ifs | 2023-12-14 | 2023-12-15 | |||||||
5373030 | 5373030 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .3099 | 00 | 2023-09-18 | 2023-09-19 | 2023-09-21 | 2023-09-14 | 0 | 2023-09-14 | ? | 0 | 0006783150 | 20230914.ifs | 2023-09-14 | 2023-09-15 | |||||||
5312788 | 5312788 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4319 | 00 | 2023-06-20 | 2023-06-21 | 2023-06-23 | 2023-06-15 | 0 | 2023-06-16 | ? | 0 | 0006739698 | 20230616.ifs | 2023-06-16 | 2023-06-17 | |||||||
5250106 | 5250106 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1597 | 00 | 2023-03-20 | 2023-03-21 | 2023-03-23 | 2023-03-16 | 0 | 2023-03-17 | ? | 0 | 0006696661 | 20230317.ifs | 2023-03-17 | 2023-03-18 | |||||||
5169486 | 5169486 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4895 | 00 | 2022-12-19 | 2022-12-20 | 2022-12-22 | 2022-12-15 | 0 | 2022-12-15 | ? | 0 | 0006637673 | 20221215.ifs | 2022-12-15 | 2022-12-16 | |||||||
5098732 | 5098732 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1196 | 00 | 2022-09-19 | 2022-09-20 | 2022-09-22 | 2022-09-15 | 0 | 2022-09-16 | ? | 0 | 0006584242 | 20220916.ifs | 2022-09-16 | 2022-09-17 | |||||||
5035505 | 5035505 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .53 | 00 | 2022-06-21 | 2022-06-22 | 2022-06-24 | 2022-06-16 | 0 | 2022-06-17 | ? | 0 | 0006539652 | 20220617.ifs | 2022-06-17 | 2022-06-18 | |||||||
4973368 | 4973368 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .0828 | 00 | 2022-03-21 | 2022-03-22 | 2022-03-24 | 2022-03-17 | 0 | 2022-03-18 | ? | 0 | 0006495656 | 20220318.ifs | 2022-03-18 | 2022-03-19 | |||||||
4891675 | 4891675 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .7693 | 00 | 2021-12-20 | 2021-12-21 | 2021-12-23 | 2021-12-16 | 0 | 2021-12-16 | ? | 0 | 0006431454 | 20211216.ifs | 2021-12-16 | 2021-12-17 | |||||||
4803071 | 4803071 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .2 | 00 | 2021-09-20 | 2021-09-21 | 2021-09-23 | 2021-09-16 | 0 | 2021-09-16 | ? | 0 | 0006368612 | 20210916.ifs | 2021-09-16 | 2021-09-17 | |||||||
4732621 | 4732621 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4135 | 00 | 2021-06-21 | 2021-06-22 | 2021-06-24 | 2021-06-17 | 0 | 2021-06-18 | ? | 0 | 0006323817 | 20210618.ifs | 2021-06-18 | 2021-06-19 | |||||||
4655796 | 4655796 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .2312 | 00 | 2021-03-22 | 2021-03-23 | 2021-03-25 | 2021-03-18 | 0 | 2021-03-18 | ? | 0 | 0006278760 | 20210318.ifs | 2021-03-18 | 2021-03-19 | |||||||
4549718 | 4549718 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4147 | 00 | 2020-12-21 | 2020-12-22 | 2020-12-24 | 2020-12-17 | 0 | 2020-12-17 | ? | 0 | 0006219685 | 20201217.ifs | 2020-12-17 | 2020-12-18 | |||||||
4464011 | 4464011 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .2208 | 00 | 2020-09-21 | 2020-09-22 | 2020-09-24 | 2020-09-17 | 0 | 2020-09-17 | ? | 0 | 0006159993 | 20200917.ifs | 2020-09-17 | 2020-09-18 | |||||||
4395454 | 4395454 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1981 | 00 | 2020-06-22 | 2020-06-23 | 2020-06-25 | 2020-06-18 | 0 | 2020-06-19 | ? | 0 | 0006114689 | 20200619.ifs | 2020-06-19 | 2020-06-20 | |||||||
4243744 | 4243744 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1312 | 00 | 2020-03-23 | 2020-03-24 | 2020-03-26 | 2020-03-19 | 0 | 2020-03-19 | ? | 0 | 0006070702 | 20200319.ifs | 2020-03-19 | 2020-03-20 | |||||||
4243780 | 4243780 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1312 | 00 | 2020-03-23 | 2020-03-24 | 2020-03-26 | 2020-03-19 | 0 | 2020-03-19 | ? | 0 | 0006070702 | 20200319.ifs | 2020-03-19 | 2020-03-20 | |||||||
4092416 | 4092416 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4399 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-19 | 0 | 2019-12-19 | ? | 0 | 0006014461 | 20191219.ifs | 2019-12-19 | 2019-12-20 | |||||||
4092801 | 4092801 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4399 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-19 | 0 | 2019-12-19 | ? | 0 | 0006014461 | 20191219.ifs | 2019-12-19 | 2019-12-20 | |||||||
3930521 | 3930521 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .2754 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-20 | 0 | 2019-09-20 | ? | 0 | 0005948317 | 20190920.ifs | 2019-09-20 | 2019-09-21 | |||||||
3930581 | 3930581 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .2754 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-20 | 0 | 2019-09-20 | ? | 0 | 0005948317 | 20190920.ifs | 2019-09-20 | 2019-09-21 | |||||||
3777586 | 3777586 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .45 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-20 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897716 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3777587 | 3777587 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .45 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-20 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897716 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3648137 | 3648137 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .175 | 00 | 2019-03-28 | 2019-03-29 | 2019-04-02 | 2019-03-26 | 0 | 2019-03-26 | ? | 0 | 0005858174 | 20190326.ifs | 2019-03-26 | 2019-03-27 | |||||||
3648140 | 3648140 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .175 | 00 | 2019-03-28 | 2019-03-29 | 2019-04-02 | 2019-03-26 | 0 | 2019-03-26 | ? | 0 | 0005858174 | 20190326.ifs | 2019-03-26 | 2019-03-27 | |||||||
3474255 | 3474255 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .3837 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-28 | 2018-12-20 | 0 | 2018-12-20 | ? | 0 | 0005799603 | 20181220.ifs | 2018-12-20 | 2018-12-21 | |||||||
3474281 | 3474281 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .3837 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-28 | 2018-12-20 | 0 | 2018-12-20 | ? | 0 | 0005799603 | 20181220.ifs | 2018-12-20 | 2018-12-21 | |||||||
3296606 | 3296606 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1584 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-01 | 2018-09-24 | 0 | 2018-09-24 | ? | 0 | 0005727895 | 20180924.ifs | 2018-09-24 | 2018-09-25 | |||||||
3296607 | 3296607 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1584 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-01 | 2018-09-24 | 0 | 2018-09-24 | ? | 0 | 0005727895 | 20180924.ifs | 2018-09-24 | 2018-09-25 | |||||||
3148466 | 3148466 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .5402 | 00 | 2018-06-22 | 2018-06-25 | 2018-06-27 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678213 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148471 | 3148471 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .5402 | 00 | 2018-06-22 | 2018-06-25 | 2018-06-27 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678213 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3002280 | 3002280 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1615 | 00 | 2018-03-26 | 2018-03-27 | 2018-03-29 | 2018-03-22 | 0 | 2018-03-22 | ? | 0 | 0005633453 | 20180322.ifs | 2018-03-22 | 2018-03-23 | |||||||
3002405 | 3002405 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .1615 | 00 | 2018-03-26 | 2018-03-27 | 2018-03-29 | 2018-03-22 | 0 | 2018-03-22 | ? | 0 | 0005633453 | 20180322.ifs | 2018-03-22 | 2018-03-23 | |||||||
2841714 | 2841714 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4315 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-27 | 2017-12-19 | 0 | 2017-12-19 | ? | 0 | 0005567454 | 20171219.ifs | 2017-12-19 | 2017-12-20 | |||||||
2841834 | 2841834 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .4315 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-27 | 2017-12-19 | 0 | 2017-12-19 | ? | 0 | 0005567454 | 20171219.ifs | 2017-12-19 | 2017-12-20 | |||||||
2675878 | 2675878 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .179 | 00 | 2017-09-20 | 2017-09-21 | 2017-09-25 | 2017-09-18 | 0 | 2017-09-18 | ? | 0 | 0005498871 | 20170918.ifs | 2017-09-18 | 2017-09-19 | |||||||
2675886 | 2675886 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .179 | 00 | 2017-09-20 | 2017-09-21 | 2017-09-25 | 2017-09-18 | 0 | 2017-09-18 | ? | 0 | 0005498871 | 20170918.ifs | 2017-09-18 | 2017-09-19 | |||||||
2598531 | 2598531 | DIVIDEND | DELETE | 921943858 | 0 | 0 | 1 | 0 | .482 | 00 | 2017-06-20 | 2017-06-19 | 2017-06-21 | 2017-06-19 | 0 | 2017-06-21 | ? | 0 | 0005452557 | 20170622.ifs | 2017-06-22 | 2017-06-23 | |||||||
2597242 | 2597242 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .482 | 00 | 2017-06-20 | 2017-06-19 | 2017-06-21 | 2017-06-19 | 0 | 2017-06-21 | ? | 0 | 0005452557 | 20170621.ifs | 2017-06-21 | 2017-06-22 | |||||||
2594902 | 2594902 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .482 | 00 | 2017-06-21 | 2017-06-23 | 2017-06-27 | 2017-06-19 | 0 | 2017-06-19 | ? | 0 | 0005451107 | 20170619.ifs | 2017-06-19 | 2017-06-20 | |||||||
2518643 | 2518643 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .15 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-22 | 0 | 2017-03-23 | ? | 0 | 0005406289 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2446820 | 2446820 | EQUITY | CHANGE | 921943858 | VANGUARD FTSE DEVELOPED MKTS ETF | 0 | A | 2007-07-26 | ? | 0 | no | no | no | 2007-07-26 | 2013-05-29 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2446821 | 2446820 | EQUITY | CHANGE | 921943858 | VANGUARD FTSE DEVELOPED MKTS ETF | 0 | A | 2007-07-26 | ? | 4 | no | no | no | 2007-07-26 | 2013-05-29 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2390371 | 2390371 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .3 | 00 | 2016-12-22 | 2016-12-27 | 2016-12-29 | 2016-12-20 | 0 | 2016-12-21 | ? | 0 | 0005347877 | 20161221.ifs | 2016-12-21 | 2016-12-22 | |||||||
2290610 | 2290610 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .175 | 00 | 2016-09-13 | 2016-09-15 | 2016-09-19 | 2016-09-09 | 0 | 2016-09-09 | ? | 0 | 0005279233 | 20160909.ifs | 2016-09-09 | 2016-09-10 | |||||||
2219052 | 2219052 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .482 | 00 | 2016-06-14 | 2016-06-16 | 2016-06-20 | 2016-06-10 | 0 | 2016-06-13 | ? | 0 | 0005231562 | 20160613.ifs | 2016-06-13 | 2016-06-14 | |||||||
2134623 | 2134623 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .157 | 00 | 2016-03-15 | 2016-03-17 | 2016-03-21 | 2016-03-11 | 0 | 2016-03-14 | ? | 0 | 0005186414 | 20160314.ifs | 2016-03-14 | 2016-03-15 | |||||||
2045235 | 2045235 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .221 | 00 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-17 | 0 | 2015-12-17 | ? | 0 | 0005125320 | 20151217.ifs | 2015-12-17 | 2015-12-18 | |||||||
1970899 | 1970899 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .156 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-23 | 0 | 2015-09-23 | ? | 0 | 0005066486 | 20150923.ifs | 2015-09-23 | 2015-09-24 | |||||||
1894471 | 1894471 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .513 | 00 | 2015-06-26 | 2015-06-30 | 2015-07-02 | 2015-06-24 | 0 | 2015-06-24 | ? | 0 | 0005019284 | 20150624.ifs | 2015-06-24 | 2015-06-25 | |||||||
1818372 | 1818372 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .181 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-23 | 0 | 2015-03-23 | ? | 0 | 0004972106 | 20150323.ifs | 2015-03-23 | 2015-03-24 | |||||||
1730616 | 1730616 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .24 | 00 | 2014-12-22 | 2014-12-24 | 2014-12-29 | 2014-12-18 | 0 | 2014-12-19 | ? | 0 | 0004910301 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1635315 | 1635315 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .212 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-22 | 0 | 2014-09-22 | ? | 0 | 0004846127 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1555183 | 1555183 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .513 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-20 | 0 | 2014-06-20 | ? | 0 | 0004799890 | 20140620.ifs | 2014-06-20 | 2014-06-21 | |||||||
1473364 | 1473364 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .429 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-21 | 0 | 2014-03-21 | ? | 0 | 0004753888 | 20140321.ifs | 2014-03-21 | 2014-03-22 | |||||||
1392059 | 1392059 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .213 | 00 | 2013-12-20 | 2013-12-24 | 2013-12-27 | 2013-12-18 | 0 | 2013-12-18 | ? | 0 | 0004692454 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1392060 | 1392059 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .213 | 00 | 2013-12-20 | 2013-12-24 | 2013-12-27 | 2013-12-18 | 1 | 2013-12-18 | 2013-12-23 | 0 | 0004692454 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1379141 | 1379141 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .213 | 00 | 2013-12-20 | 2013-12-24 | 2013-12-27 | 2013-12-18 | 0 | 2013-12-18 | ? | 0 | 0004692454 | 20131218.ifs | 2013-12-18 | 2013-12-19 | |||||||
1295513 | 1295513 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .164 | 00 | 2013-09-23 | 2013-09-25 | 2013-09-27 | 2013-09-19 | 0 | 2013-09-19 | ? | 0 | 0004631299 | 20130924.ifs | 2013-09-24 | 2013-09-25 | |||||||
1295514 | 1295513 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .164 | 00 | 2013-09-23 | 2013-09-25 | 2013-09-27 | 2013-09-19 | 1 | 2013-09-19 | 2013-09-24 | 0 | 0004631299 | 20130924.ifs | 2013-09-24 | 2013-09-25 | |||||||
1290845 | 1290845 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .164 | 00 | 2013-09-23 | 2013-09-25 | 2013-09-27 | 2013-09-19 | 0 | 2013-09-19 | ? | 0 | 0004631299 | 20130919.ifs | 2013-09-19 | 2013-09-20 | |||||||
1283506 | 1283506 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .545 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-20 | 1 | 2013-06-20 | 2013-06-25 | 0 | 0004586848 | 20130909.ifs | 2013-09-09 | 2013-09-10 | |||||||
1283507 | 1283506 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .545 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-20 | 1 | 2013-06-20 | 2013-09-09 | 0 | 0004586848 | 20130909.ifs | 2013-09-09 | 2013-09-10 | |||||||
1217062 | 1217062 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .545 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-20 | 0 | 2013-06-20 | ? | 0 | 0004586848 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1217063 | 1217062 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .545 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-20 | 1 | 2013-06-20 | 2013-06-25 | 0 | 0004586848 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1212974 | 1212974 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .545 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-20 | 0 | 2013-06-20 | ? | 0 | 0004586848 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1194050 | 1194050 | CORPACTION | ADD | 921943858 | 04 | # | 2013-05-29 | 921943858 | 04 | ? | 20130529.ifs | 2013-05-29 | 2013-05-30 | ||||||||||||||||
1194051 | 1194051 | CORPACTIONAUX | ADD | 921943858 | 04 | 2013-05-29 | VEA | VANGUARD TAX-MANAGED FD | VANGUARD TAX-MA | VEA | VANGUARD TAX-MANAGED FD | VANGUARD FTSE D | 2013-05-29 | ? | 20130529.ifs | 2013-05-29 | 2013-05-30 | ||||||||||||
1194052 | 1194052 | EQUITY | CHANGE | 921943858 | MSCI EAFE ETF | 0 | A | 2007-07-26 | ? | 0 | no | no | no | 2007-07-26 | 2011-02-28 | ? | 20130529.ifs | 2013-05-29 | 2013-05-30 | ||||||||||
1194053 | 1194052 | EQUITY | CHANGE | 921943858 | VANGUARD FTSE DEVELOPED MKTS ETF | 0 | A | 2007-07-26 | ? | 0 | no | no | no | 2007-07-26 | 2013-05-29 | ? | 20130529.ifs | 2013-05-29 | 2013-05-30 | ||||||||||
1141263 | 1141263 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .161 | 00 | 2013-03-22 | 2013-03-26 | 2013-03-28 | 2013-03-20 | 0 | 2013-03-20 | ? | 0 | 0004543707 | 20130325.ifs | 2013-03-25 | 2013-03-26 | |||||||
1141264 | 1141263 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .161 | 00 | 2013-03-22 | 2013-03-26 | 2013-03-28 | 2013-03-20 | 1 | 2013-03-20 | 2013-03-25 | 0 | 0004543707 | 20130325.ifs | 2013-03-25 | 2013-03-26 | |||||||
1137464 | 1137464 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .161 | 00 | 2013-03-22 | 2013-03-26 | 2013-03-28 | 2013-03-20 | 0 | 2013-03-20 | ? | 0 | 0004543707 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1046588 | 1046588 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .346 | 00 | 2012-12-20 | 2012-12-24 | 2012-12-27 | 2012-12-18 | 0 | 2012-12-18 | ? | 0 | 0004486092 | 20121218.ifs | 2012-12-18 | 2012-12-19 | |||||||
965481 | 965481 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .689 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-20 | 1 | 2012-09-20 | 2012-09-21 | 0 | 0004432003 | 20120926.ifs | 2012-09-26 | 2012-09-27 | |||||||
965482 | 965481 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .689 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-20 | 2 | 2012-09-20 | 2012-09-26 | 0 | 0004432003 | 20120926.ifs | 2012-09-26 | 2012-09-27 | |||||||
961769 | 961769 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .689 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-20 | 0 | 2012-09-20 | ? | 0 | 0004432003 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
961770 | 961769 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 0 | .689 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-20 | 1 | 2012-09-20 | 2012-09-21 | 0 | 0004432003 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
960115 | 960115 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .689 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-20 | 0 | 2012-09-20 | ? | 0 | 0004432003 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
809393 | 809393 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 9 | .011 | 03 | 2012-03-22 | 2012-03-26 | 2012-03-28 | 2012-03-20 | 1 | 2012-03-20 | 2012-03-22 | 0 | 0004347546 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
809394 | 809393 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 9 | .011 | 03 | 2012-03-22 | 2012-03-26 | 2012-03-28 | 2012-03-20 | 2 | 2012-03-20 | 2012-03-23 | 0 | 0004347546 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
807965 | 807965 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 9 | .011 | 03 | 2012-03-22 | 2012-03-26 | 2012-03-28 | 2012-03-20 | 0 | 2012-03-20 | ? | 0 | 0004347546 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
807966 | 807965 | DIVIDEND | CHANGE | 921943858 | 0 | 0 | 1 | 9 | .011 | 03 | 2012-03-22 | 2012-03-26 | 2012-03-28 | 2012-03-20 | 1 | 2012-03-20 | 2012-03-22 | 0 | 0004347546 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
805673 | 805673 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 9 | .011 | 03 | 2012-03-22 | 2012-03-26 | 2012-03-28 | 2012-03-20 | 0 | 2012-03-20 | ? | 0 | 0004347546 | 20120320.ifs | 2012-03-20 | 2012-03-21 | |||||||
730085 | 730085 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | 1.046 | 00 | 2011-12-21 | 2011-12-23 | 2011-12-28 | 2011-12-19 | 0 | 2011-12-19 | ? | 0 | 0004295514 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
475753 | 475753 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 9 | .012 | 03 | 2011-03-23 | 2011-03-25 | 2011-03-29 | 2011-03-21 | 0 | 2011-03-21 | ? | 0 | 0004161814 | 20110321.ifs | 2011-03-21 | 2011-03-22 | |||||||
453823 | 453823 | EQUITY | CHANGE | 921943858 | EUROPE PACIFIC ETF | 0 | A | 2007-07-26 | ? | 0 | no | no | no | 2007-07-26 | 2007-07-26 | ? | 20110228.ifs | 2011-02-28 | 2011-03-01 | ||||||||||
453824 | 453823 | EQUITY | CHANGE | 921943858 | MSCI EAFE ETF | 0 | A | 2007-07-26 | ? | 0 | no | no | no | 2007-07-26 | 2011-02-28 | ? | 20110228.ifs | 2011-02-28 | 2011-03-01 | ||||||||||
453825 | 453825 | CORPACTION | ADD | 921943858 | 04 | # | 2011-02-28 | 921943858 | 04 | 2011-02-28 | 20110228.ifs | 2011-02-28 | 2011-03-01 | ||||||||||||||||
453826 | 453826 | CORPACTIONAUX | ADD | 921943858 | 04 | 2011-02-28 | VEA | VANGUARD TAX-MANAGED FD | EUROPE PACIFIC | VEA | VANGUARD TAX-MANAGED FD | MSCI EAFE ETF | ? | 2011-02-28 | 20110228.ifs | 2011-02-28 | 2011-03-01 | ||||||||||||
385589 | 385589 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .886 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-20 | 0 | 2010-12-20 | ? | 0 | 0004112281 | 20101220.ifs | 2010-12-20 | 2010-12-21 | |||||||
135716 | 135716 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 9 | .011 | 03 | 2010-03-23 | 2010-03-25 | 2010-03-29 | 2010-03-19 | 0 | 2010-03-19 | ? | 0 | 0003979876 | 20100319.ifs | 2010-03-19 | 2010-04-07 | |||||||
61591 | 61591 | DIVIDEND | ADD | 921943858 | 0 | 0 | 1 | 0 | .797 | 00 | 2009-12-24 | 2009-12-29 | 2009-12-31 | 2009-12-22 | 0 | 2009-12-22 | ? | 0 | 0003936651 | 20091222.ifs | 2009-12-22 | 2010-04-07 |
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 |
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 = 152193
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