Compid = 139546Number Of Rows Found :1
$tempCalculation=0
START :
END :176.99

Compid Found :139546 Tic Found :HTHIY
FINALHTHIY | 139546

Split info : 1

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

Number Of Rows Found :23

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue73
newHoldingTotalShares414
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld414
totalSharesValue73
totalPostionChange414
totalValueChange73
totalHolders1
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue73
newHoldingTotalShares414
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue63
oldDecreaseHoldingTotalShares-492
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld3725
totalSharesValue686
totalPostionChange-78
totalValueChange136
totalHolders2
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue73
newHoldingTotalShares414
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue63
oldDecreaseHoldingTotalShares-492
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 33

totalSharesHeld3758
totalSharesValue692
totalPostionChange-78
totalValueChange137
totalHolders3
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue73
newHoldingTotalShares414
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue46
oldDecreaseHoldingTotalShares-1059
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 33

totalSharesHeld5478
totalSharesValue1005
totalPostionChange-645
totalValueChange120
totalHolders4
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue73
newHoldingTotalShares414
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue375
oldDecreaseHoldingTotalShares-11438
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 33

totalSharesHeld54206
totalSharesValue9862
totalPostionChange-11024
totalValueChange449
totalHolders5
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue73
newHoldingTotalShares414
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue519
oldDecreaseHoldingTotalShares-11575
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 33

totalSharesHeld58569
totalSharesValue10657
totalPostionChange-11161
totalValueChange593
totalHolders6
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue519
oldDecreaseHoldingTotalShares-11575
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 33

totalSharesHeld58631
totalSharesValue10668
totalPostionChange-11099
totalValueChange604
totalHolders7
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue519
oldDecreaseHoldingTotalShares-11575
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 26
unchangedHoldingTotalShares 678

totalSharesHeld59276
totalSharesValue10786
totalPostionChange-11099
totalValueChange629
totalHolders8
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue519
oldDecreaseHoldingTotalShares-11575
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue37
oldIncreaseHoldingTotalShares117
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 26
unchangedHoldingTotalShares 678

totalSharesHeld60049
totalSharesValue10927
totalPostionChange-10982
totalValueChange666
totalHolders9
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue693
oldDecreaseHoldingTotalShares-11658
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue37
oldIncreaseHoldingTotalShares117
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 26
unchangedHoldingTotalShares 678

totalSharesHeld64980
totalSharesValue11826
totalPostionChange-11065
totalValueChange840
totalHolders10
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue741
oldDecreaseHoldingTotalShares-11937
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue37
oldIncreaseHoldingTotalShares117
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 26
unchangedHoldingTotalShares 678

totalSharesHeld67319
totalSharesValue12252
totalPostionChange-11344
totalValueChange888
totalHolders11
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue741
oldDecreaseHoldingTotalShares-11937
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue37
oldIncreaseHoldingTotalShares117
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 718

totalSharesHeld67359
totalSharesValue12259
totalPostionChange-11344
totalValueChange889
totalHolders12
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue741
oldDecreaseHoldingTotalShares-11937
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue45
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 718

totalSharesHeld67523
totalSharesValue12289
totalPostionChange-11335
totalValueChange897
totalHolders13
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue743
oldDecreaseHoldingTotalShares-11947
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue45
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 718

totalSharesHeld67611
totalSharesValue12305
totalPostionChange-11345
totalValueChange899
totalHolders14
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue84
newHoldingTotalShares476
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue743
oldDecreaseHoldingTotalShares-11947
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue45
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 322
unchangedHoldingTotalShares 8485

totalSharesHeld75378
totalSharesValue13721
totalPostionChange-11345
totalValueChange1194
totalHolders15
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies3
newHoldingTotalValue86
newHoldingTotalShares487
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue743
oldDecreaseHoldingTotalShares-11947
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue45
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 322
unchangedHoldingTotalShares 8485

totalSharesHeld75389
totalSharesValue13723
totalPostionChange-11334
totalValueChange1196
totalHolders16
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies3
newHoldingTotalValue86
newHoldingTotalShares487
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue743
oldDecreaseHoldingTotalShares-11947
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue385
oldIncreaseHoldingTotalShares751
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 322
unchangedHoldingTotalShares 8485

totalSharesHeld82023
totalSharesValue14932
totalPostionChange-10709
totalValueChange1536
totalHolders17
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies3
newHoldingTotalValue86
newHoldingTotalShares487
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue743
oldDecreaseHoldingTotalShares-11947
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue11454
oldIncreaseHoldingTotalShares19651
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 322
unchangedHoldingTotalShares 8485

totalSharesHeld303211
totalSharesValue55236
totalPostionChange8191
totalValueChange12605
totalHolders18
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies3
newHoldingTotalValue86
newHoldingTotalShares487
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue2653
oldDecreaseHoldingTotalShares-12263
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue11454
oldIncreaseHoldingTotalShares19651
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 322
unchangedHoldingTotalShares 8485

totalSharesHeld353939
totalSharesValue64512
totalPostionChange7875
totalValueChange14515
totalHolders19
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99

liquidatedTotalCompanies1
liquidatedTotalValue-15744
liquidatedTotalShares-108900
newHoldingTotalCompanies3
newHoldingTotalValue86
newHoldingTotalShares487
oldDecreaseHoldingTotalCompanies9
oldDecreaseHoldingTotalValue3199
oldDecreaseHoldingTotalShares-13056
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue11459
oldIncreaseHoldingTotalShares19679
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 322
unchangedHoldingTotalShares 8489

totalSharesHeld371582
totalSharesValue67719
totalPostionChange-101790
totalValueChange-678
totalHolders22
COMPID139546
TICHTHIY
CIK0000047710
SHSOUT483420
NAMEHitachi Ltd (ADR)
SECTOR102003
CUSIP433578507
PRICE176.99
virgina 0.08

virgina2 -0.02
SELECT * from sectors where level3num = '102003'Number Of Rows Found :1
The Sector is Electronic Equipment

CRAIG TOTAL SHARES VALE : 67719

MKCAP85560505.8/n/ninsert into institSumNewHoldings values( Null, '0000047710', '139546', 'Hitachi Ltd (ADR)', 'HTHIY', '176.99', '433578507', '483420', '0.08', '102003', 'Electronic Equipment', '85560505.8', '1', '-15744', '-108900', '3', '86', '487', '9', '3199', '-13056', '5', '11459', '19679', '371582', '67719', '-101790', '-678', '22', '5', '322', '8489', '-0.02', '-13543.8', 'NULL', '-13543.8', '', '', '', '0', NULL, NULL,NULL) OKbye