Compid = 139549Number Of Rows Found :1
$tempCalculation=0
START :
END :9.48
Compid Found :139549 Tic Found :PCRFY
FINALPCRFY | 139549
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =139549 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :15must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 465
totalSharesHeld465
totalSharesValue4
totalPostionChange0
totalValueChange-1
totalHolders1
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 465
totalSharesHeld37786
totalSharesValue358
totalPostionChange7087
totalValueChange56
totalHolders2
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 465
totalSharesHeld95052
totalSharesValue902
totalPostionChange4891
totalValueChange11
totalHolders3
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 569
totalSharesHeld95156
totalSharesValue903
totalPostionChange4891
totalValueChange11
totalHolders4
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-111
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 569
totalSharesHeld95156
totalSharesValue903
totalPostionChange4780
totalValueChange10
totalHolders4
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies2
liquidatedTotalValue-6
liquidatedTotalShares-601
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 569
totalSharesHeld95156
totalSharesValue903
totalPostionChange4290
totalValueChange5
totalHolders4
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-6
liquidatedTotalShares-601
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -18
unchangedHoldingTotalShares 41291
totalSharesHeld135878
totalSharesValue1289
totalPostionChange4290
totalValueChange-12
totalHolders5
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-6
liquidatedTotalShares-601
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld147178
totalSharesValue1397
totalPostionChange4290
totalValueChange-16
totalHolders6
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies3
liquidatedTotalValue-8
liquidatedTotalShares-789
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld147178
totalSharesValue1397
totalPostionChange4102
totalValueChange-18
totalHolders6
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies4
liquidatedTotalValue-222
liquidatedTotalShares-22501
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2196
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld147178
totalSharesValue1397
totalPostionChange-17610
totalValueChange-232
totalHolders6
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies4
liquidatedTotalValue-222
liquidatedTotalShares-22501
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2198
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue57
oldIncreaseHoldingTotalShares7087
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld147630
totalSharesValue1401
totalPostionChange-17612
totalValueChange-232
totalHolders7
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies4
liquidatedTotalValue-222
liquidatedTotalShares-22501
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2198
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue63
oldIncreaseHoldingTotalShares7761
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld148304
totalSharesValue1407
totalPostionChange-16938
totalValueChange-226
totalHolders8
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies5
liquidatedTotalValue-230
liquidatedTotalShares-23271
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2198
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue63
oldIncreaseHoldingTotalShares7761
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld148304
totalSharesValue1407
totalPostionChange-17708
totalValueChange-234
totalHolders8
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
liquidatedTotalCompanies5
liquidatedTotalValue-230
liquidatedTotalShares-23271
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2198
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue96
oldIncreaseHoldingTotalShares11854
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 52591
totalSharesHeld168034
totalSharesValue1594
totalPostionChange-13615
totalValueChange-201
totalHolders9
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48must have stayed the same
liquidatedTotalCompanies5
liquidatedTotalValue-230
liquidatedTotalShares-23271
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-45
oldDecreaseHoldingTotalShares-2198
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue96
oldIncreaseHoldingTotalShares11854
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue -26
unchangedHoldingTotalShares 65091
totalSharesHeld180534
totalSharesValue1713
totalPostionChange-13615
totalValueChange-205
totalHolders10
COMPID139549
TICPCRFY
CIK0000063271
SHSOUT2330000
NAMEPanasonic Corp
SECTOR102003
CUSIP69832A205
PRICE9.48
virgina 0.01
virgina2 -0
SELECT * from sectors where level3num = '102003'Number Of Rows Found :1
The Sector is Electronic Equipment
CRAIG TOTAL SHARES VALE : 1713
MKCAP22088400/n/ninsert into institSumNewHoldings values(
Null,
'0000063271',
'139549',
'Panasonic Corp',
'PCRFY',
'9.48',
'69832A205',
'2330000',
'0.01',
'102003',
'Electronic Equipment',
'22088400',
'5',
'-230',
'-23271',
'0',
'0',
'0',
'2',
'-45',
'-2198',
'3',
'96',
'11854',
'180534',
'1713',
'-13615',
'-205',
'10',
'5',
'-26',
'65091',
'-0',
'-0',
'-0',
'-0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye