Compid = 142480Number Of Rows Found :1
$tempCalculation=-8.49
START :95.57
END :87.46

Compid Found :142480 Tic Found :LRLCY
FINALLRLCY | 142480

Split info : 1

START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =142480 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'

Number Of Rows Found :31

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld0
totalSharesValue0
totalPostionChange-993
totalValueChange-99
totalHolders0
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares30
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld30
totalSharesValue3
totalPostionChange-963
totalValueChange-96
totalHolders1
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares30
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -11
unchangedHoldingTotalShares 2447

totalSharesHeld2477
totalSharesValue235
totalPostionChange-963
totalValueChange-107
totalHolders2
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares30
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-3
oldIncreaseHoldingTotalShares40
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -11
unchangedHoldingTotalShares 2447

totalSharesHeld3253
totalSharesValue305
totalPostionChange-923
totalValueChange-110
totalHolders3
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares30
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-3
oldIncreaseHoldingTotalShares40
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -11
unchangedHoldingTotalShares 2447

totalSharesHeld3776
totalSharesValue355
totalPostionChange-968
totalValueChange-116
totalHolders4
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares30
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue3
oldIncreaseHoldingTotalShares98
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -11
unchangedHoldingTotalShares 2447

totalSharesHeld3893
totalSharesValue366
totalPostionChange-910
totalValueChange-110
totalHolders5
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares30
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue149
oldIncreaseHoldingTotalShares1651
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -11
unchangedHoldingTotalShares 2447

totalSharesHeld5446
totalSharesValue512
totalPostionChange643
totalValueChange36
totalHolders6
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies2
newHoldingTotalValue6
newHoldingTotalShares64
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue149
oldIncreaseHoldingTotalShares1651
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -11
unchangedHoldingTotalShares 2447

totalSharesHeld5480
totalSharesValue515
totalPostionChange677
totalValueChange39
totalHolders7
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies2
newHoldingTotalValue6
newHoldingTotalShares64
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue149
oldIncreaseHoldingTotalShares1651
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld5580
totalSharesValue524
totalPostionChange677
totalValueChange38
totalHolders8
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies2
newHoldingTotalValue6
newHoldingTotalShares64
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares2053
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld7085
totalSharesValue667
totalPostionChange1079
totalValueChange76
totalHolders9
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares2053
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld10700
totalSharesValue1010
totalPostionChange4694
totalValueChange419
totalHolders10
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue405
oldIncreaseHoldingTotalShares4350
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld13021
totalSharesValue1230
totalPostionChange6991
totalValueChange637
totalHolders11
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue386
oldIncreaseHoldingTotalShares4396
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld18210
totalSharesValue1722
totalPostionChange7037
totalValueChange618
totalHolders12
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-45
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue481
oldIncreaseHoldingTotalShares6749
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld48329
totalSharesValue4577
totalPostionChange9390
totalValueChange713
totalHolders13
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue65
oldDecreaseHoldingTotalShares-657
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue481
oldIncreaseHoldingTotalShares6749
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -12
unchangedHoldingTotalShares 2547

totalSharesHeld58483
totalSharesValue5540
totalPostionChange8778
totalValueChange784
totalHolders14
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue65
oldDecreaseHoldingTotalShares-657
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue481
oldIncreaseHoldingTotalShares6749
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -13
unchangedHoldingTotalShares 2803

totalSharesHeld58739
totalSharesValue5564
totalPostionChange8778
totalValueChange783
totalHolders15
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue25
oldDecreaseHoldingTotalShares-826
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue481
oldIncreaseHoldingTotalShares6749
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -13
unchangedHoldingTotalShares 2803

totalSharesHeld63905
totalSharesValue6054
totalPostionChange8609
totalValueChange743
totalHolders16
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue25
oldDecreaseHoldingTotalShares-826
oldIncreaseHoldingTotalCompanies8
oldIncreaseHoldingTotalValue353
oldIncreaseHoldingTotalShares6910
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -13
unchangedHoldingTotalShares 2803

totalSharesHeld93671
totalSharesValue8874
totalPostionChange8770
totalValueChange615
totalHolders17
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue10
oldDecreaseHoldingTotalShares-886
oldIncreaseHoldingTotalCompanies8
oldIncreaseHoldingTotalValue353
oldIncreaseHoldingTotalShares6910
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -13
unchangedHoldingTotalShares 2803

totalSharesHeld98486
totalSharesValue9344
totalPostionChange8710
totalValueChange600
totalHolders18
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue10
oldDecreaseHoldingTotalShares-886
oldIncreaseHoldingTotalCompanies8
oldIncreaseHoldingTotalValue353
oldIncreaseHoldingTotalShares6910
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -27
unchangedHoldingTotalShares 5768

totalSharesHeld101451
totalSharesValue9625
totalPostionChange8710
totalValueChange586
totalHolders19
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue10
oldDecreaseHoldingTotalShares-886
oldIncreaseHoldingTotalCompanies9
oldIncreaseHoldingTotalValue112
oldIncreaseHoldingTotalShares8243
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -27
unchangedHoldingTotalShares 5768

totalSharesHeld182436
totalSharesValue17302
totalPostionChange10043
totalValueChange345
totalHolders20
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue10
oldDecreaseHoldingTotalShares-886
oldIncreaseHoldingTotalCompanies10
oldIncreaseHoldingTotalValue98
oldIncreaseHoldingTotalShares8270
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -27
unchangedHoldingTotalShares 5768

totalSharesHeld185916
totalSharesValue17632
totalPostionChange10070
totalValueChange331
totalHolders21
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue10
oldDecreaseHoldingTotalShares-886
oldIncreaseHoldingTotalCompanies10
oldIncreaseHoldingTotalValue98
oldIncreaseHoldingTotalShares8270
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue -38
unchangedHoldingTotalShares 8192

totalSharesHeld188340
totalSharesValue17862
totalPostionChange10070
totalValueChange320
totalHolders22
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies1
liquidatedTotalValue-99
liquidatedTotalShares-993
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-1006
oldIncreaseHoldingTotalCompanies10
oldIncreaseHoldingTotalValue98
oldIncreaseHoldingTotalShares8270
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue -38
unchangedHoldingTotalShares 8192

totalSharesHeld193250
totalSharesValue18327
totalPostionChange9950
totalValueChange285
totalHolders23
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46

liquidatedTotalCompanies2
liquidatedTotalValue-136
liquidatedTotalShares-1369
newHoldingTotalCompanies3
newHoldingTotalValue349
newHoldingTotalShares3679
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-824
oldDecreaseHoldingTotalShares-6859
oldIncreaseHoldingTotalCompanies12
oldIncreaseHoldingTotalValue170
oldIncreaseHoldingTotalShares9249
unchangedHoldingTotalCompanies 8
unchangedHoldingTotalValue -40
unchangedHoldingTotalShares 14791

totalSharesHeld250233
totalSharesValue23734
totalPostionChange4700
totalValueChange-481
totalHolders29
COMPID142480
TICLRLCY
CIK0001336216
SHSOUT2800000
NAMELoreal Co. (ADR)
SECTOR502005
CUSIP502117203
PRICE87.46
virgina 0.01

virgina2 0
SELECT * from sectors where level3num = '502005'Number Of Rows Found :1
The Sector is Personal Products

CRAIG TOTAL SHARES VALE : 23734

MKCAP244888000/n/ninsert into institSumNewHoldings values( Null, '0001336216', '142480', 'Loreal Co. (ADR)', 'LRLCY', '87.46', '502117203', '2800000', '0.01', '502005', 'Personal Products', '244888000', '2', '-136', '-1369', '3', '349', '3679', '6', '-824', '-6859', '12', '170', '9249', '250233', '23734', '4700', '-481', '29', '8', '-40', '14791', '0', '0', '0', '0', '97.13', '94.8', '95.57', '-8.49', NULL, NULL,NULL) OKbye