INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | ||||||||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||||||||
|
|||||||||||||||||
the compid is:159980 |
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 | ||
4636536 | 4636536 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 1 | 0 | 643.47 | 05 | ? | 2021-03-16 | 2021-03-31 | 2021-02-25 | 0 | 2021-02-25 | ? | 0 | 0006267442 | 20210225.ifs | 2021-02-25 | 2021-02-26 | |||||||
4636537 | 4636537 | EQUITY | CHANGE | G7S86Z172 | ORD | 0 | 0 | 2012-06-07 | ? | 0 | no | no | no | 2012-06-07 | 2018-09-28 | ? | 20210225.ifs | 2021-02-25 | 2021-02-26 | ||||||||||
4636538 | 4636537 | EQUITY | CHANGE | G7S86Z172 | ORD | 0 | 0 | 2012-06-07 | ? | 4 | no | no | no | 2012-06-07 | 2018-09-28 | ? | 20210225.ifs | 2021-02-25 | 2021-02-26 | ||||||||||
4636539 | 4636539 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 1 | 0 | 649.21 | 05 | ? | 2020-12-16 | 2020-12-31 | 2020-11-24 | 0 | 2020-11-24 | ? | 0 | 0006190548 | 20210225.ifs | 2021-02-25 | 2021-02-26 | |||||||
4636540 | 4636539 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 1 | 0 | 649.21 | 05 | ? | 2020-12-16 | 2020-12-31 | 2020-11-24 | 1 | 2020-11-24 | 2021-02-25 | 0 | 0006190548 | 20210225.ifs | 2021-02-25 | 2021-02-26 | |||||||
4636541 | 4636541 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 1 | 0 | 671.57 | 05 | ? | 2020-09-15 | 2020-09-30 | 2020-08-27 | 0 | 2020-08-27 | ? | 0 | 0006147454 | 20210225.ifs | 2021-02-25 | 2021-02-26 | |||||||
4636542 | 4636541 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 1 | 0 | 671.57 | 05 | ? | 2020-09-15 | 2020-09-30 | 2020-08-27 | 1 | 2020-08-27 | 2021-02-25 | 0 | 0006147454 | 20210225.ifs | 2021-02-25 | 2021-02-26 | |||||||
4512838 | 4512838 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 1 | 0 | 649.21 | 05 | ? | 2020-12-16 | 2020-12-31 | 2020-11-24 | 0 | 2020-11-24 | ? | 0 | 0006190548 | 20201124.ifs | 2020-11-24 | 2020-11-25 | |||||||
4446022 | 4446022 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 1 | 0 | 671.57 | 05 | ? | 2020-09-15 | 2020-09-30 | 2020-08-27 | 0 | 2020-08-27 | ? | 0 | 0006147454 | 20200827.ifs | 2020-08-27 | 2020-08-28 | |||||||
4425068 | 4425068 | CORPACTION | ADD | G7S86Z172 | 66 | # | 2020-07-28 | G7S86Z172 | 66 | 2020-07-28 | 20200728.ifs | 2020-07-28 | 2020-07-29 | ||||||||||||||||
4425069 | 4425069 | CORPACTIONAUX | ADD | G7S86Z172 | 66 | 2020-07-28 | RBSPF | ROYAL BANK OF SCOTLAND GROUPPL | ORD | RBSPF | NATWEST GROUP PLC | ORD | ? | 2020-07-28 | 20200728.ifs | 2020-07-28 | 2020-07-29 | ||||||||||||
4425070 | 4425070 | EXCHANGE | CHANGE | G7S86Z172 | 66 | 2012-06-07 | 2020-07-24 | RBSPF | 0 | 0 | 2012-06-07 | 2012-07-03 | 20200728.ifs | 2020-07-28 | 2020-07-29 | ||||||||||||||
4425071 | 4425070 | EXCHANGE | CHANGE | G7S86Z172 | 66 | 2012-06-07 | 2020-07-24 | RBSPF | 0 | 0 | 2012-06-07 | 2020-07-28 | 20200728.ifs | 2020-07-28 | 2020-07-29 | ||||||||||||||
4277758 | 4277758 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 0 | .03 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-18 | 0 | 2020-02-19 | ? | 0 | 0006056347 | 20200402.ifs | 2020-04-02 | 2020-04-03 | |||||||
4277759 | 4277759 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 9 | .05 | 0 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | 2020-02-20 | 1 | 0006056348 | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||
4277813 | 4277813 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 0 | .03 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-18 | 0 | 2020-02-19 | ? | 0 | 0006056347 | 20200402.ifs | 2020-04-02 | 2020-04-03 | |||||||
4277815 | 4277815 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 9 | .05 | 0 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | 2020-02-20 | 1 | 0006056348 | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||
4210188 | 4210188 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .05 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | ? | 1 | 0006056348 | 20200220.ifs | 2020-02-20 | 2020-02-21 | |||||||
4210189 | 4210188 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .05 | 0 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | 2020-02-20 | 1 | 0006056348 | 20200220.ifs | 2020-02-20 | 2020-02-21 | ||||||
4210249 | 4210249 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .05 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | ? | 1 | 0006056348 | 20200220.ifs | 2020-02-20 | 2020-02-21 | |||||||
4210251 | 4210250 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .05 | 0 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | 2020-02-20 | 1 | 0006056348 | 20200220.ifs | 2020-02-20 | 2020-02-21 | ||||||
4209096 | 4209096 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .05 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | ? | 1 | 0006056348 | 20200219.ifs | 2020-02-19 | 2020-02-20 | |||||||
4209097 | 4209097 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .03 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-18 | 0 | 2020-02-19 | ? | 0 | 0006056347 | 20200219.ifs | 2020-02-19 | 2020-02-20 | |||||||
4209133 | 4209133 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .05 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-19 | 0 | 2020-02-19 | ? | 1 | 0006056348 | 20200219.ifs | 2020-02-19 | 2020-02-20 | |||||||
4209135 | 4209135 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .03 | 28 | ? | 2020-03-27 | 2020-05-04 | 2020-02-18 | 0 | 2020-02-19 | ? | 0 | 0006056347 | 20200219.ifs | 2020-02-19 | 2020-02-20 | |||||||
3913604 | 3913604 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 3 | 2019-08-02 | 2019-09-05 | 1 | 0005928272 | 20190906.ifs | 2019-09-06 | 2019-09-07 | ||||||
3913605 | 3913605 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 3 | 2019-08-02 | 2019-09-05 | 1 | 0005928272 | 20190906.ifs | 2019-09-06 | 2019-09-07 | ||||||
3913606 | 3913605 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 3 | 2019-08-02 | 2019-09-06 | 1 | 0005928272 | 20190906.ifs | 2019-09-06 | 2019-09-07 | ||||||
3913607 | 3913606 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 3 | 2019-08-02 | 2019-09-06 | 1 | 0005928272 | 20190906.ifs | 2019-09-06 | 2019-09-07 | ||||||
3912867 | 3912867 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-15 | 1 | 0005928272 | 20190905.ifs | 2019-09-05 | 2019-09-06 | ||||||
3912869 | 3912868 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 3 | 2019-08-02 | 2019-09-05 | 1 | 0005928272 | 20190905.ifs | 2019-09-05 | 2019-09-06 | ||||||
3912870 | 3912870 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-15 | 1 | 0005928272 | 20190905.ifs | 2019-09-05 | 2019-09-06 | ||||||
3912871 | 3912871 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-01 | 2 | 2019-08-02 | 2019-08-14 | 0 | 0005928271 | 20190905.ifs | 2019-09-05 | 2019-09-06 | |||||||
3912872 | 3912871 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 3 | 2019-08-02 | 2019-09-05 | 1 | 0005928272 | 20190905.ifs | 2019-09-05 | 2019-09-06 | ||||||
3912873 | 3912872 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-01 | 3 | 2019-08-02 | 2019-09-05 | 0 | 0005928271 | 20190905.ifs | 2019-09-05 | 2019-09-06 | |||||||
3912874 | 3912874 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-01 | 2 | 2019-08-02 | 2019-08-14 | 0 | 0005928271 | 20190905.ifs | 2019-09-05 | 2019-09-06 | |||||||
3912876 | 3912875 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-01 | 3 | 2019-08-02 | 2019-09-05 | 0 | 0005928271 | 20190905.ifs | 2019-09-05 | 2019-09-06 | |||||||
3879666 | 3879666 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-14 | 1 | 0005928272 | 20190815.ifs | 2019-08-15 | 2019-08-16 | ||||||
3879667 | 3879667 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-14 | 1 | 0005928272 | 20190815.ifs | 2019-08-15 | 2019-08-16 | ||||||
3879668 | 3879667 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-15 | 1 | 0005928272 | 20190815.ifs | 2019-08-15 | 2019-08-16 | ||||||
3879669 | 3879668 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-15 | 1 | 0005928272 | 20190815.ifs | 2019-08-15 | 2019-08-16 | ||||||
3879242 | 3879242 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-12 | 1 | 0005928272 | 20190814.ifs | 2019-08-14 | 2019-08-15 | ||||||
3879243 | 3879243 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-12 | 1 | 0005928272 | 20190814.ifs | 2019-08-14 | 2019-08-15 | ||||||
3879244 | 3879244 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-14 | 1 | 0005928272 | 20190814.ifs | 2019-08-14 | 2019-08-15 | ||||||
3879245 | 3879245 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-02 | 2 | 2019-08-02 | 2019-08-14 | 1 | 0005928272 | 20190814.ifs | 2019-08-14 | 2019-08-15 | ||||||
3879246 | 3879246 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 1 | 2019-08-02 | 2019-08-09 | 0 | 0005928271 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||||
3879247 | 3879247 | DIVIDEND | DELETE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 1 | 2019-08-02 | 2019-08-09 | 0 | 0005928271 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||||
3879248 | 3879248 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-01 | 2 | 2019-08-02 | 2019-08-14 | 0 | 0005928271 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||||
3879249 | 3879249 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-09-20 | 2019-08-01 | 2 | 2019-08-02 | 2019-08-14 | 0 | 0005928271 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||||
3877062 | 3877062 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-09 | 1 | 0005928272 | 20190812.ifs | 2019-08-12 | 2019-08-13 | |||||||
3877063 | 3877063 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-09 | 1 | 0005928272 | 20190812.ifs | 2019-08-12 | 2019-08-13 | |||||||
3877064 | 3877063 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-12 | 1 | 0005928272 | 20190812.ifs | 2019-08-12 | 2019-08-13 | ||||||
3877065 | 3877064 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .12 | 0 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-12 | 1 | 0005928272 | 20190812.ifs | 2019-08-12 | 2019-08-13 | ||||||
3876298 | 3876298 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 0 | 2019-08-02 | ? | 1 | 0005928272 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876299 | 3876299 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 0 | 2019-08-02 | ? | 1 | 0005928272 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876300 | 3876299 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-09 | 1 | 0005928272 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876301 | 3876300 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 1 | 2019-08-02 | 2019-08-09 | 1 | 0005928272 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876302 | 3876302 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 0 | 2019-08-02 | ? | 0 | 0005928271 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876303 | 3876303 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 0 | 2019-08-02 | ? | 0 | 0005928271 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876304 | 3876303 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 1 | 2019-08-02 | 2019-08-09 | 0 | 0005928271 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3876305 | 3876304 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 1 | 2019-08-02 | 2019-08-09 | 0 | 0005928271 | 20190809.ifs | 2019-08-09 | 2019-08-10 | |||||||
3868686 | 3868686 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 0 | 2019-08-02 | ? | 1 | 0005928272 | 20190802.ifs | 2019-08-02 | 2019-08-03 | |||||||
3868687 | 3868687 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .12 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-02 | 0 | 2019-08-02 | ? | 1 | 0005928272 | 20190802.ifs | 2019-08-02 | 2019-08-03 | |||||||
3868688 | 3868688 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 0 | 2019-08-02 | ? | 0 | 0005928271 | 20190802.ifs | 2019-08-02 | 2019-08-03 | |||||||
3868689 | 3868689 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2019-08-16 | 2019-08-20 | 2019-08-01 | 0 | 2019-08-02 | ? | 0 | 0005928271 | 20190802.ifs | 2019-08-02 | 2019-08-03 | |||||||
3679118 | 3679118 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-08 | 1 | 0005851297 | 20190409.ifs | 2019-04-09 | 2019-04-10 | |||||||
3679119 | 3679119 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-08 | 1 | 0005851297 | 20190409.ifs | 2019-04-09 | 2019-04-10 | |||||||
3679120 | 3679119 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .075 | 0 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-09 | 1 | 0005851297 | 20190409.ifs | 2019-04-09 | 2019-04-10 | ||||||
3679121 | 3679120 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 9 | .075 | 0 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-09 | 1 | 0005851297 | 20190409.ifs | 2019-04-09 | 2019-04-10 | ||||||
3678561 | 3678561 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 0 | 2019-03-11 | ? | 1 | 0005851297 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678562 | 3678561 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-08 | 1 | 0005851297 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678564 | 3678564 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .035 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-08 | 0 | 2019-03-11 | ? | 0 | 0005851296 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678566 | 3678565 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .035 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-08 | 1 | 2019-03-11 | 2019-04-08 | 0 | 0005851296 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678573 | 3678573 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 0 | 2019-03-11 | ? | 1 | 0005851297 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678575 | 3678574 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-08 | 1 | 0005851297 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678577 | 3678577 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .035 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-08 | 0 | 2019-03-11 | ? | 0 | 0005851296 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3678578 | 3678577 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .035 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-08 | 1 | 2019-03-11 | 2019-04-08 | 0 | 0005851296 | 20190408.ifs | 2019-04-08 | 2019-04-09 | |||||||
3622820 | 3622820 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 0 | 2019-03-11 | ? | 1 | 0005851297 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3622821 | 3622821 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .035 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-08 | 0 | 2019-03-11 | ? | 0 | 0005851296 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3622914 | 3622914 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .075 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-11 | 0 | 2019-03-11 | ? | 1 | 0005851297 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3622916 | 3622916 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .035 | 28 | ? | 2019-03-22 | 2019-04-30 | 2019-03-08 | 0 | 2019-03-11 | ? | 0 | 0005851296 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3385856 | 3385856 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 1 | 2018-08-15 | 2018-09-27 | 0 | 0005708339 | 20181129.ifs | 2018-11-29 | 2018-11-30 | |||||||
3385858 | 3385857 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 2 | 2018-08-15 | 2018-11-29 | 0 | 0005708339 | 20181129.ifs | 2018-11-29 | 2018-11-30 | |||||||
3385874 | 3385874 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 1 | 2018-08-15 | 2018-09-27 | 0 | 0005708339 | 20181129.ifs | 2018-11-29 | 2018-11-30 | |||||||
3385876 | 3385875 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 2 | 2018-08-15 | 2018-11-29 | 0 | 0005708339 | 20181129.ifs | 2018-11-29 | 2018-11-30 | |||||||
3303533 | 3303533 | EQUITY | CHANGE | G7S86Z172 | ORD | N | 0 | 2012-06-07 | ? | 0 | no | no | no | 2012-06-07 | ? | ? | 20180928.ifs | 2018-09-28 | 2018-09-29 | ||||||||||
3303535 | 3303534 | EQUITY | CHANGE | G7S86Z172 | ORD | 0 | 0 | 2012-06-07 | ? | 0 | no | no | no | 2012-06-07 | 2018-09-28 | ? | 20180928.ifs | 2018-09-28 | 2018-09-29 | ||||||||||
3303550 | 3303550 | EQUITY | CHANGE | G7S86Z172 | ORD | N | 0 | 2012-06-07 | ? | 0 | no | no | no | 2012-06-07 | ? | ? | 20180928.ifs | 2018-09-28 | 2018-09-29 | ||||||||||
3303552 | 3303551 | EQUITY | CHANGE | G7S86Z172 | ORD | 0 | 0 | 2012-06-07 | ? | 0 | no | no | no | 2012-06-07 | 2018-09-28 | ? | 20180928.ifs | 2018-09-28 | 2018-09-29 | ||||||||||
3300738 | 3300738 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 0 | 2018-08-15 | ? | 0 | 0005708339 | 20180927.ifs | 2018-09-27 | 2018-09-28 | |||||||
3300739 | 3300739 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 0 | 2018-08-15 | ? | 0 | 0005708339 | 20180927.ifs | 2018-09-27 | 2018-09-28 | |||||||
3300740 | 3300739 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 1 | 2018-08-15 | 2018-09-27 | 0 | 0005708339 | 20180927.ifs | 2018-09-27 | 2018-09-28 | |||||||
3300741 | 3300740 | DIVIDEND | CHANGE | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 1 | 2018-08-15 | 2018-09-27 | 0 | 0005708339 | 20180927.ifs | 2018-09-27 | 2018-09-28 | |||||||
3239903 | 3239903 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 0 | 2018-08-15 | ? | 0 | 0005708339 | 20180815.ifs | 2018-08-15 | 2018-08-16 | |||||||
3239921 | 3239921 | DIVIDEND | ADD | G7S86Z172 | 6 | 0 | 3 | 0 | .02 | 28 | ? | 2018-08-24 | 2018-10-12 | 2018-08-15 | 0 | 2018-08-15 | ? | 0 | 0005708339 | 20180815.ifs | 2018-08-15 | 2018-08-16 | |||||||
906521 | 906521 | CORPACTION | ADD | G7S86Z172 | 66 | # | 2012-07-03 | G7S86Z172 | 66 | ? | 20120703.ifs | 2012-07-03 | 2012-07-04 | ||||||||||||||||
906522 | 906522 | CORPACTIONAUX | ADD | G7S86Z172 | 66 | 2012-07-03 | RBSPD | ROYAL BANK OF SCOTLAND GRP | ORD | RBSPF | ROYAL BANK OF SCOTLAND GRP | ORD | 2012-07-03 | ? | 20120703.ifs | 2012-07-03 | 2012-07-04 | ||||||||||||
906523 | 906523 | EXCHANGE | CHANGE | G7S86Z172 | 66 | 2012-06-07 | 2012-06-29 | RBSPD | 0 | 0 | 2012-06-07 | ? | 20120703.ifs | 2012-07-03 | 2012-07-04 | ||||||||||||||
906524 | 906523 | EXCHANGE | CHANGE | G7S86Z172 | 66 | 2012-06-07 | 2012-06-29 | RBSPF | 0 | 0 | 2012-06-07 | 2012-07-03 | 20120703.ifs | 2012-07-03 | 2012-07-04 | ||||||||||||||
881448 | 881448 | EQUITY | ADD | G7S86Z172 | ORD | N | 0 | 2012-06-07 | ? | 0 | no | no | no | 2012-06-07 | ? | ? | 20120607.ifs | 2012-06-07 | 2012-06-08 | ||||||||||
881452 | 881452 | EXCHANGE | ADD | G7S86Z172 | 66 | 2012-06-07 | 2012-06-07 | RBSPD | 0 | 0 | 2012-06-07 | ? | 20120607.ifs | 2012-06-07 | 2012-06-08 |
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 | ||
881447 | 881447 | CORPACTION | ADD | G76891111 | 66 | Q | 2012-06-07 | G7S86Z172 | 66 | ? | 20120607.ifs | 2012-06-07 | 2012-06-08 | ||||||||||||||||
881449 | 881449 | EQUITY | CHANGE | G76891111 | ORD | 0 | 0 | 1996-07-01 | ? | 9 | no | no | no | 2001-04-27 | ? | ? | 20120607.ifs | 2012-06-07 | 2012-06-08 | ||||||||||
881450 | 881449 | EQUITY | CHANGE | G76891111 | ORD | Q | 0 | 1996-07-01 | 2012-06-07 | 9 | no | no | G7S86Z172 | no | 2001-04-27 | 2012-06-07 | ? | 20120607.ifs | 2012-06-07 | 2012-06-08 |
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 = 159980
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