Administration

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 ARE.PE Charts	Yahoo ARE.PE Profile
	Run ARE.PE Institutional Summary	Yahoo ARE.PE Key Statisics
	J3 Open ARE.PE Pricing	Yahoo ARE.PE Pricing
	J3 ARE.PE Insider J3 ARE.PE Insitutions	Yahoo ARE.PE Holders

	Open up Sector/Exchange Map	Fidelity ARE.PE Lookup
	Open up sec.gov For Market Ca	MSN ARE.PE 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

Total Insititutions :

N/A

Update Insititution By Cusips

% Owned by Insititutions:

N/A %

0 %

pricingQuarterAdminPageOn:

2024-03-31

New %

the compid is:160331

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

2542258 2542258 CORPACTION ADD 015271703 01 C 2017-04-14 ? 20170417.ifs 2017-04-17 2017-04-18

2542259 2542259 EQUITY CHANGE 015271703 PFD SER E 0 1 2012-03-09 ? 4 no no no 2012-03-09 2012-03-09 ? 20170417.ifs 2017-04-17 2017-04-18

2542260 2542259 EQUITY CHANGE 015271703 PFD SER E C 1 2012-03-09 2017-04-14 4 no no no 2012-03-09 2017-04-14 ? 20170417.ifs 2017-04-17 2017-04-18

2511674 2511674 DIVIDEND ADD 015271703 0 0 C 0 25 12 ? ? 2017-04-14 2017-03-06 0 ? 2017-03-14 0 20170314.ifs 2017-03-14 2017-03-15

2511609 2511609 DIVIDEND CHANGE 015271703 0 0 1 0 .403125 00 2017-03-29 2017-03-31 2017-04-17 2017-03-06 0 2017-03-06 ? 0 0005400274 20170313.ifs 2017-03-13 2017-03-14

2511610 2511609 DIVIDEND CHANGE 015271703 0 0 1 0 .403125 00 2017-03-29 2017-03-31 2017-04-17 2017-03-06 1 2017-03-06 2017-03-13 0 0005400274 20170313.ifs 2017-03-13 2017-03-14

2508285 2508285 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2017-03-29 2017-03-31 2017-04-17 2017-03-06 0 2017-03-06 ? 0 0005400274 20170306.ifs 2017-03-06 2017-03-07

2433734 2433734 EQUITY CHANGE 015271703 PFD SER E 0 1 2012-03-09 ? 0 no no no 2012-03-09 2012-03-09 ? 20170123.ifs 2017-01-23 2017-01-24

2433735 2433734 EQUITY CHANGE 015271703 PFD SER E 0 1 2012-03-09 ? 4 no no no 2012-03-09 2012-03-09 ? 20170123.ifs 2017-01-23 2017-01-24

2361610 2361610 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2016-12-28 2016-12-30 2017-01-17 2016-12-05 0 2016-12-05 ? 0 0005323628 20161205.ifs 2016-12-05 2016-12-06

2289013 2289013 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2016-09-28 2016-09-30 2016-10-17 2016-09-05 0 2016-09-06 ? 0 0005277981 20160906.ifs 2016-09-06 2016-09-07

2215735 2215735 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2016-06-28 2016-06-30 2016-07-15 2016-06-03 0 2016-06-06 ? 0 0005230395 20160606.ifs 2016-06-06 2016-06-07

2131396 2131396 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2016-03-29 2016-03-31 2016-04-15 2016-03-07 0 2016-03-07 ? 0 0005185011 20160307.ifs 2016-03-07 2016-03-08

2028277 2028277 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2015-12-29 2015-12-31 2016-01-15 2015-12-08 0 2015-12-08 ? 0 0005107451 20151208.ifs 2015-12-08 2015-12-09

1965178 1965178 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2015-09-28 2015-09-30 2015-10-15 2015-09-14 0 2015-09-14 ? 0 0005061918 20150914.ifs 2015-09-14 2015-09-15

1883614 1883614 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2015-06-26 2015-06-30 2015-07-15 2015-06-08 0 2015-06-08 ? 0 0005012176 20150608.ifs 2015-06-08 2015-06-09

1813532 1813532 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2015-03-27 2015-03-31 2015-04-15 2015-03-16 0 2015-03-16 ? 0 0004968686 20150316.ifs 2015-03-16 2015-03-17

1695944 1695944 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2014-12-29 2014-12-31 2015-01-15 2014-12-01 0 2014-12-01 ? 0 0004880004 20141201.ifs 2014-12-01 2014-12-02

1630498 1630498 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2014-09-26 2014-09-30 2014-10-15 2014-09-15 0 2014-09-15 ? 0 0004842848 20140915.ifs 2014-09-15 2014-09-16

1550721 1550721 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2014-06-26 2014-06-30 2014-07-15 2014-06-16 0 2014-06-16 ? 0 0004796446 20140616.ifs 2014-06-16 2014-06-17

1468982 1468982 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2014-03-27 2014-03-31 2014-04-15 2014-03-17 0 2014-03-17 ? 0 0004750949 20140317.ifs 2014-03-17 2014-03-18

1364950 1364950 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2013-12-27 2013-12-31 2014-01-15 2013-12-11 0 2013-12-11 ? 0 0004675725 20131211.ifs 2013-12-11 2013-12-12

1285184 1285184 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2013-09-26 2013-09-30 2013-10-15 2013-09-10 0 2013-09-10 ? 0 0004627475 20130910.ifs 2013-09-10 2013-09-11

1209465 1209465 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2013-06-26 2013-06-28 2013-07-15 2013-06-13 0 2013-06-13 ? 0 0004583400 20130613.ifs 2013-06-13 2013-06-14

1133513 1133513 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2013-03-26 2013-03-28 2013-04-15 2013-03-14 0 2013-03-14 ? 0 0004540999 20130314.ifs 2013-03-14 2013-03-15

1016574 1016574 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2012-12-27 2012-12-31 2013-01-15 2012-11-27 0 2012-11-27 ? 0 0004461049 20121127.ifs 2012-11-27 2012-11-28

953593 953593 DIVIDEND ADD 015271703 0 0 1 0 .403125 00 2012-09-26 2012-09-28 2012-10-15 2012-09-10 0 2012-09-10 ? 0 0004427560 20120910.ifs 2012-09-10 2012-09-11

883991 883991 DIVIDEND ADD 015271703 0 0 1 4 .5375 00 2012-06-27 2012-06-29 2012-07-16 2012-06-12 0 2012-06-12 ? 0 0004385577 20120612.ifs 2012-06-12 2012-06-13

802511 802511 CORPACTION ADD 015271703 66 X 2012-03-15 015271703 01 ? 20120315.ifs 2012-03-15 2012-03-16

802512 802512 EXCHANGE ADD 015271703 01 2012-03-15 2012-03-15 ARE_PE 0 1 2012-03-15 ? 20120315.ifs 2012-03-15 2012-03-16

799681 799681 EQUITY ADD 015271703 COM N 0 2012-03-09 ? 0 no no no 2012-03-09 ? ? 20120309.ifs 2012-03-09 2012-03-10

799682 799682 EXCHANGE ADD 015271703 66 2012-03-09 2012-03-09 AREEO 0 1 2012-03-09 ? 20120309.ifs 2012-03-09 2012-03-10

799799 799799 EQUITY CHANGE 015271703 COM N 0 2012-03-09 ? 0 no no no 2012-03-09 ? ? 20120309.ifs 2012-03-09 2012-03-10

799800 799799 EQUITY CHANGE 015271703 PFD SER E N 1 2012-03-09 ? 0 no no no 2012-03-09 2012-03-09 ? 20120309.ifs 2012-03-09 2012-03-10

800017 800017 EQUITY CHANGE 015271703 PFD SER E N 1 2012-03-09 ? 0 no no no 2012-03-09 2012-03-09 ? 20120309.ifs 2012-03-09 2012-03-10

800018 800017 EQUITY CHANGE 015271703 PFD SER E 0 1 2012-03-09 ? 0 no no no 2012-03-09 2012-03-09 ? 20120309.ifs 2012-03-09 2012-03-10

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

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

Splits	:
reportDate :		ratio :		endQuaterAffected :		dayFrom :		dayTo :

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
2542258	2542258	CORPACTION	ADD	015271703	01	C	2017-04-14			?															20170417.ifs	2017-04-17	2017-04-18
2542259	2542259	EQUITY	CHANGE	015271703	PFD SER E	0	1	2012-03-09	?	4	no	no		no		2012-03-09	2012-03-09	?							20170417.ifs	2017-04-17	2017-04-18
2542260	2542259	EQUITY	CHANGE	015271703	PFD SER E	C	1	2012-03-09	2017-04-14	4	no	no		no		2012-03-09	2017-04-14	?							20170417.ifs	2017-04-17	2017-04-18
2511674	2511674	DIVIDEND	ADD	015271703		0	0	C	0	25		12	?	?	2017-04-14	2017-03-06		0	?	2017-03-14	0				20170314.ifs	2017-03-14	2017-03-15
2511609	2511609	DIVIDEND	CHANGE	015271703		0	0	1	0	.403125		00	2017-03-29	2017-03-31	2017-04-17	2017-03-06		0	2017-03-06	?	0	0005400274			20170313.ifs	2017-03-13	2017-03-14
2511610	2511609	DIVIDEND	CHANGE	015271703		0	0	1	0	.403125		00	2017-03-29	2017-03-31	2017-04-17	2017-03-06		1	2017-03-06	2017-03-13	0	0005400274			20170313.ifs	2017-03-13	2017-03-14
2508285	2508285	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2017-03-29	2017-03-31	2017-04-17	2017-03-06		0	2017-03-06	?	0	0005400274			20170306.ifs	2017-03-06	2017-03-07
2433734	2433734	EQUITY	CHANGE	015271703	PFD SER E	0	1	2012-03-09	?	0	no	no		no		2012-03-09	2012-03-09	?							20170123.ifs	2017-01-23	2017-01-24
2433735	2433734	EQUITY	CHANGE	015271703	PFD SER E	0	1	2012-03-09	?	4	no	no		no		2012-03-09	2012-03-09	?							20170123.ifs	2017-01-23	2017-01-24
2361610	2361610	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2016-12-28	2016-12-30	2017-01-17	2016-12-05		0	2016-12-05	?	0	0005323628			20161205.ifs	2016-12-05	2016-12-06
2289013	2289013	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2016-09-28	2016-09-30	2016-10-17	2016-09-05		0	2016-09-06	?	0	0005277981			20160906.ifs	2016-09-06	2016-09-07
2215735	2215735	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2016-06-28	2016-06-30	2016-07-15	2016-06-03		0	2016-06-06	?	0	0005230395			20160606.ifs	2016-06-06	2016-06-07
2131396	2131396	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2016-03-29	2016-03-31	2016-04-15	2016-03-07		0	2016-03-07	?	0	0005185011			20160307.ifs	2016-03-07	2016-03-08
2028277	2028277	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2015-12-29	2015-12-31	2016-01-15	2015-12-08		0	2015-12-08	?	0	0005107451			20151208.ifs	2015-12-08	2015-12-09
1965178	1965178	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2015-09-28	2015-09-30	2015-10-15	2015-09-14		0	2015-09-14	?	0	0005061918			20150914.ifs	2015-09-14	2015-09-15
1883614	1883614	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2015-06-26	2015-06-30	2015-07-15	2015-06-08		0	2015-06-08	?	0	0005012176			20150608.ifs	2015-06-08	2015-06-09
1813532	1813532	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2015-03-27	2015-03-31	2015-04-15	2015-03-16		0	2015-03-16	?	0	0004968686			20150316.ifs	2015-03-16	2015-03-17
1695944	1695944	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2014-12-29	2014-12-31	2015-01-15	2014-12-01		0	2014-12-01	?	0	0004880004			20141201.ifs	2014-12-01	2014-12-02
1630498	1630498	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2014-09-26	2014-09-30	2014-10-15	2014-09-15		0	2014-09-15	?	0	0004842848			20140915.ifs	2014-09-15	2014-09-16
1550721	1550721	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2014-06-26	2014-06-30	2014-07-15	2014-06-16		0	2014-06-16	?	0	0004796446			20140616.ifs	2014-06-16	2014-06-17
1468982	1468982	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2014-03-27	2014-03-31	2014-04-15	2014-03-17		0	2014-03-17	?	0	0004750949			20140317.ifs	2014-03-17	2014-03-18
1364950	1364950	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2013-12-27	2013-12-31	2014-01-15	2013-12-11		0	2013-12-11	?	0	0004675725			20131211.ifs	2013-12-11	2013-12-12
1285184	1285184	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2013-09-26	2013-09-30	2013-10-15	2013-09-10		0	2013-09-10	?	0	0004627475			20130910.ifs	2013-09-10	2013-09-11
1209465	1209465	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2013-06-26	2013-06-28	2013-07-15	2013-06-13		0	2013-06-13	?	0	0004583400			20130613.ifs	2013-06-13	2013-06-14
1133513	1133513	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2013-03-26	2013-03-28	2013-04-15	2013-03-14		0	2013-03-14	?	0	0004540999			20130314.ifs	2013-03-14	2013-03-15
1016574	1016574	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2012-12-27	2012-12-31	2013-01-15	2012-11-27		0	2012-11-27	?	0	0004461049			20121127.ifs	2012-11-27	2012-11-28
953593	953593	DIVIDEND	ADD	015271703		0	0	1	0	.403125		00	2012-09-26	2012-09-28	2012-10-15	2012-09-10		0	2012-09-10	?	0	0004427560			20120910.ifs	2012-09-10	2012-09-11
883991	883991	DIVIDEND	ADD	015271703		0	0	1	4	.5375		00	2012-06-27	2012-06-29	2012-07-16	2012-06-12		0	2012-06-12	?	0	0004385577			20120612.ifs	2012-06-12	2012-06-13
802511	802511	CORPACTION	ADD	015271703	66	X	2012-03-15	015271703	01	?															20120315.ifs	2012-03-15	2012-03-16
802512	802512	EXCHANGE	ADD	015271703	01	2012-03-15	2012-03-15	ARE_PE	0	1	2012-03-15	?													20120315.ifs	2012-03-15	2012-03-16
799681	799681	EQUITY	ADD	015271703	COM	N	0	2012-03-09	?	0	no	no		no		2012-03-09	?	?							20120309.ifs	2012-03-09	2012-03-10
799682	799682	EXCHANGE	ADD	015271703	66	2012-03-09	2012-03-09	AREEO	0	1	2012-03-09	?													20120309.ifs	2012-03-09	2012-03-10
799799	799799	EQUITY	CHANGE	015271703	COM	N	0	2012-03-09	?	0	no	no		no		2012-03-09	?	?							20120309.ifs	2012-03-09	2012-03-10
799800	799799	EQUITY	CHANGE	015271703	PFD SER E	N	1	2012-03-09	?	0	no	no		no		2012-03-09	2012-03-09	?							20120309.ifs	2012-03-09	2012-03-10
800017	800017	EQUITY	CHANGE	015271703	PFD SER E	N	1	2012-03-09	?	0	no	no		no		2012-03-09	2012-03-09	?							20120309.ifs	2012-03-09	2012-03-10
800018	800017	EQUITY	CHANGE	015271703	PFD SER E	0	1	2012-03-09	?	0	no	no		no		2012-03-09	2012-03-09	?							20120309.ifs	2012-03-09	2012-03-10