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:145499 |
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 | ||
4165390 | 4165390 | DIVIDEND | ADD | 04040P207 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-12-17 | 2019-09-09 | 0 | ? | 2020-01-08 | 0 | 0005943179 | 20200108.ifs | 2020-01-08 | 2020-01-09 | |||||||
4165391 | 4165391 | DIVIDEND | ADD | 04040P207 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-12-17 | 2019-09-09 | 0 | ? | 2020-01-08 | 0 | 0005943179 | 20200108.ifs | 2020-01-08 | 2020-01-09 | |||||||
4164001 | 4164001 | CORPACTION | ADD | 04040P207 | 66 | D | 2020-01-07 | ? | 20200107.ifs | 2020-01-07 | 2020-01-08 | ||||||||||||||||||
4164003 | 4164003 | EQUITY | CHANGE | 04040P207 | GDR REG S | 0 | 0 | 1998-03-16 | ? | 1 | no | no | no | 2002-04-04 | 2005-02-09 | ? | 20200107.ifs | 2020-01-07 | 2020-01-08 | ||||||||||
4164004 | 4164003 | EQUITY | CHANGE | 04040P207 | GDR REG S | D | 0 | 1998-03-16 | 2020-01-07 | 1 | no | no | no | 2002-04-04 | 2020-01-07 | ? | 20200107.ifs | 2020-01-07 | 2020-01-08 | ||||||||||
4164116 | 4164116 | CORPACTION | ADD | 04040P207 | 66 | D | 2020-01-07 | ? | 20200107.ifs | 2020-01-07 | 2020-01-08 | ||||||||||||||||||
4164118 | 4164118 | EQUITY | CHANGE | 04040P207 | GDR REG S | 0 | 0 | 1998-03-16 | ? | 1 | no | no | no | 2002-04-04 | 2005-02-09 | ? | 20200107.ifs | 2020-01-07 | 2020-01-08 | ||||||||||
4164120 | 4164119 | EQUITY | CHANGE | 04040P207 | GDR REG S | D | 0 | 1998-03-16 | 2020-01-07 | 1 | no | no | no | 2002-04-04 | 2020-01-07 | ? | 20200107.ifs | 2020-01-07 | 2020-01-08 | ||||||||||
3823598 | 3823598 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .139056 | 00 | ? | 2019-03-29 | 2019-07-09 | ? | 0 | 2019-07-01 | ? | 0 | 0005851323 | 20190702.ifs | 2019-07-02 | 2019-07-03 | ||||||||
3823599 | 3823599 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .139056 | 0 | 00 | ? | 2019-03-29 | 2019-07-09 | 2019-03-11 | 0 | ? | 2019-07-02 | 0 | 0005851323 | 20190702.ifs | 2019-07-02 | 2019-07-03 | |||||
3823677 | 3823677 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .139056 | 00 | ? | 2019-03-29 | 2019-07-09 | ? | 0 | 2019-07-01 | ? | 0 | 0005851323 | 20190702.ifs | 2019-07-02 | 2019-07-03 | ||||||||
3823679 | 3823679 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .139056 | 0 | 00 | ? | 2019-03-29 | 2019-07-09 | 2019-03-11 | 0 | ? | 2019-07-02 | 0 | 0005851323 | 20190702.ifs | 2019-07-02 | 2019-07-03 | |||||
3822839 | 3822839 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .139056 | 00 | ? | 2019-03-29 | 2019-07-09 | ? | 0 | 2019-07-01 | ? | 0 | 0005851323 | 20190701.ifs | 2019-07-01 | 2019-07-02 | ||||||||
3822945 | 3822945 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .139056 | 00 | ? | 2019-03-29 | 2019-07-09 | ? | 0 | 2019-07-01 | ? | 0 | 0005851323 | 20190701.ifs | 2019-07-01 | 2019-07-02 | ||||||||
3624696 | 3624696 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-03-29 | ? | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851323 | 20190312.ifs | 2019-03-12 | 2019-03-13 | |||||||
3624713 | 3624713 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-03-29 | ? | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851323 | 20190312.ifs | 2019-03-12 | 2019-03-13 | |||||||
3623378 | 3623378 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-03-29 | ? | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851323 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3623446 | 3623446 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-03-29 | ? | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851323 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3495683 | 3495683 | DIVIDEND | ADD | 04040P207 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-12-31 | 2018-09-10 | 0 | ? | 2018-12-26 | 0 | 0005721271 | 20181226.ifs | 2018-12-26 | 2018-12-27 | |||||||
3495684 | 3495684 | DIVIDEND | ADD | 04040P207 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-12-31 | 2018-09-10 | 0 | ? | 2018-12-26 | 0 | 0005721271 | 20181226.ifs | 2018-12-26 | 2018-12-27 | |||||||
3171569 | 3171569 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .15354 | 00 | ? | 2018-03-29 | 2018-07-09 | ? | 0 | 2018-06-29 | ? | 0 | 0005627030 | 20180702.ifs | 2018-07-02 | 2018-07-03 | ||||||||
3171570 | 3171570 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .15354 | 0 | 00 | ? | 2018-03-29 | 2018-07-09 | 2018-03-05 | 0 | ? | 2018-07-02 | 0 | 0005627030 | 20180702.ifs | 2018-07-02 | 2018-07-03 | |||||
3172259 | 3172259 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .15354 | 00 | ? | 2018-03-29 | 2018-07-09 | ? | 0 | 2018-06-29 | ? | 0 | 0005627030 | 20180702.ifs | 2018-07-02 | 2018-07-03 | ||||||||
3172260 | 3172260 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .15354 | 0 | 00 | ? | 2018-03-29 | 2018-07-09 | 2018-03-05 | 0 | ? | 2018-07-02 | 0 | 0005627030 | 20180702.ifs | 2018-07-02 | 2018-07-03 | |||||
3171183 | 3171183 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .15354 | 00 | ? | 2018-03-29 | 2018-07-09 | ? | 0 | 2018-06-29 | ? | 0 | 0005627030 | 20180629.ifs | 2018-06-29 | 2018-06-30 | ||||||||
3171190 | 3171190 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .15354 | 00 | ? | 2018-03-29 | 2018-07-09 | ? | 0 | 2018-06-29 | ? | 0 | 0005627030 | 20180629.ifs | 2018-06-29 | 2018-06-30 | ||||||||
2983373 | 2983373 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-03-29 | ? | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005627030 | 20180306.ifs | 2018-03-06 | 2018-03-07 | |||||||
2983943 | 2983943 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-03-29 | ? | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005627030 | 20180306.ifs | 2018-03-06 | 2018-03-07 | |||||||
2982044 | 2982044 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-03-29 | ? | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005627030 | 20180305.ifs | 2018-03-05 | 2018-03-06 | |||||||
2982665 | 2982665 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-03-29 | ? | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005627030 | 20180305.ifs | 2018-03-05 | 2018-03-06 | |||||||
2610883 | 2610883 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .088648 | 00 | ? | 2017-03-31 | 2017-07-10 | 2017-03-15 | 0 | ? | 2017-07-03 | 0 | 0005402306 | 20170703.ifs | 2017-07-03 | 2017-07-04 | ||||||
2456663 | 2456663 | EQUITY | CHANGE | 04040P207 | GDR REG S | 0 | 0 | 1998-03-16 | ? | 8 | no | no | no | 2002-04-04 | 2005-02-09 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2456664 | 2456663 | EQUITY | CHANGE | 04040P207 | GDR REG S | 0 | 0 | 1998-03-16 | ? | 1 | no | no | no | 2002-04-04 | 2005-02-09 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2232106 | 2232106 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .112815 | 00 | ? | 2016-03-31 | 2016-07-07 | ? | 0 | 2016-06-27 | ? | 0 | 0005186066 | 20160628.ifs | 2016-06-28 | 2016-06-29 | ||||||||
2232107 | 2232107 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .112815 | 0 | 00 | ? | 2016-03-31 | 2016-07-07 | 2016-03-10 | 0 | ? | 2016-06-28 | 0 | 0005186066 | 20160628.ifs | 2016-06-28 | 2016-06-29 | |||||
2232023 | 2232023 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .112815 | 00 | ? | 2016-03-31 | 2016-07-07 | ? | 0 | 2016-06-27 | ? | 0 | 0005186066 | 20160627.ifs | 2016-06-27 | 2016-06-28 | ||||||||
2133591 | 2133591 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2016-03-31 | ? | 2016-03-10 | 0 | 2016-03-10 | ? | 0 | 0005186066 | 20160311.ifs | 2016-03-11 | 2016-03-12 | |||||||
2133452 | 2133452 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2016-03-31 | ? | 2016-03-10 | 0 | 2016-03-10 | ? | 0 | 0005186066 | 20160310.ifs | 2016-03-10 | 2016-03-11 | |||||||
1904601 | 1904601 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .142056 | 00 | ? | 2015-03-31 | 2015-07-09 | ? | 0 | 2015-06-30 | ? | 0 | 0004968273 | 20150701.ifs | 2015-07-01 | 2015-07-02 | ||||||||
1904602 | 1904602 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .142056 | 0 | 00 | ? | 2015-03-31 | 2015-07-09 | 2015-06-30 | 0 | ? | 2015-07-01 | 0 | 0004968273 | 20150701.ifs | 2015-07-01 | 2015-07-02 | |||||
1904135 | 1904135 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .142056 | 00 | ? | 2015-03-31 | 2015-07-09 | ? | 0 | 2015-06-30 | ? | 0 | 0004968273 | 20150630.ifs | 2015-06-30 | 2015-07-01 | ||||||||
1813517 | 1813517 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2015-03-31 | ? | 2015-03-13 | 0 | 2015-03-13 | ? | 0 | 0004968273 | 20150316.ifs | 2015-03-16 | 2015-03-17 | |||||||
1812138 | 1812138 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2015-03-31 | ? | 2015-03-13 | 0 | 2015-03-13 | ? | 0 | 0004968273 | 20150313.ifs | 2015-03-13 | 2015-03-14 | |||||||
1569718 | 1569718 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .122958 | 00 | ? | 2014-03-28 | 2014-07-07 | 2014-03-06 | 0 | ? | 2014-07-01 | 0 | 0004748438 | 20140701.ifs | 2014-07-01 | 2014-07-02 | ||||||
1231996 | 1231996 | DIVIDEND | CHANGE | 04040P207 | 0 | 0 | 1 | 0 | .040249 | 00 | ? | 2013-03-28 | 2013-07-08 | 2013-03-06 | 1 | 2013-03-06 | 2013-07-01 | 0 | 0004539107 | 20130702.ifs | 2013-07-02 | 2013-07-03 | |||||||
1231997 | 1231996 | DIVIDEND | CHANGE | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .040249 | 0 | 00 | ? | 2013-03-28 | 2013-07-08 | 2013-03-06 | 1 | 2013-03-06 | 2013-07-02 | 0 | 0004539107 | 20130702.ifs | 2013-07-02 | 2013-07-03 | |||||
1231722 | 1231722 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2013-03-28 | ? | 2013-03-06 | 0 | 2013-03-06 | ? | 0 | 0004539107 | 20130701.ifs | 2013-07-01 | 2013-07-02 | |||||||
1231723 | 1231723 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 0 | .040249 | 00 | ? | 2013-03-28 | 2013-07-08 | 2013-03-06 | 1 | 2013-03-06 | 2013-07-01 | 0 | 0004539107 | 20130701.ifs | 2013-07-01 | 2013-07-02 | |||||||
1129711 | 1129711 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2013-03-28 | ? | 2013-03-06 | 0 | 2013-03-06 | ? | 0 | 0004539107 | 20130306.ifs | 2013-03-06 | 2013-03-07 | |||||||
906384 | 906384 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .031375 | 00 | ? | 2012-03-29 | 2012-07-09 | 2012-03-12 | 0 | ? | 2012-07-03 | 0 | 0004344777 | 20120703.ifs | 2012-07-03 | 2012-07-04 | ||||||
582108 | 582108 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .037124 | 00 | ? | 2011-03-30 | 2011-07-11 | ? | 0 | 2011-07-01 | ? | 0 | 0004157281 | 20110705.ifs | 2011-07-05 | 2011-07-06 | ||||||||
582109 | 582109 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .037124 | 0 | 00 | ? | 2011-03-30 | 2011-07-11 | 2011-03-03 | 0 | ? | 2011-07-05 | 0 | 0004157281 | 20110705.ifs | 2011-07-05 | 2011-07-06 | |||||
581717 | 581717 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .037124 | 00 | ? | 2011-03-30 | 2011-07-11 | ? | 0 | 2011-07-01 | ? | 0 | 0004157281 | 20110701.ifs | 2011-07-01 | 2011-07-02 | ||||||||
464943 | 464943 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2011-03-30 | ? | 2011-03-03 | 0 | 2011-03-03 | ? | 0 | 0004157281 | 20110304.ifs | 2011-03-04 | 2011-03-05 | |||||||
464056 | 464056 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2011-03-30 | ? | 2011-03-03 | 0 | 2011-03-03 | ? | 0 | 0004157281 | 20110303.ifs | 2011-03-03 | 2011-03-04 | |||||||
249094 | 249094 | DIVIDEND | DELETE | 04040P207 | 0 | 1 | 0 | .04502 | 00 | ? | 2010-03-30 | 2010-07-16 | ? | 0 | 2010-07-13 | ? | 0 | 0003976515 | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||
249095 | 249095 | DIVIDEND | ADD | 04040P207 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .04502 | 0 | 00 | ? | 2010-03-30 | 2010-07-16 | 2010-03-09 | 0 | ? | 2010-07-14 | 0 | 0003976515 | 20100714.ifs | 2010-07-14 | 2010-07-15 | |||||
248995 | 248995 | DIVIDEND | ADD | 04040P207 | 0 | 1 | 0 | .04502 | 00 | ? | 2010-03-30 | 2010-07-16 | ? | 0 | 2010-07-13 | ? | 0 | 0003976515 | 20100713.ifs | 2010-07-13 | 2010-07-14 | ||||||||
129693 | 129693 | DIVIDEND | DELETE | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2010-03-30 | ? | 2010-03-09 | 0 | 2010-03-09 | ? | 0 | 0003976515 | 20100310.ifs | 2010-03-10 | 2010-04-07 | |||||||
129628 | 129628 | DIVIDEND | ADD | 04040P207 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2010-03-30 | ? | 2010-03-09 | 0 | 2010-03-09 | ? | 0 | 0003976515 | 20100309.ifs | 2010-03-09 | 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 = 145499
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