Compid = 130679Number Of Rows Found :1
$tempCalculation=0
START :
END :0.1561
Compid Found :130679 Tic Found :BKYI
FINALBKYI | 130679
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130679 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :10
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-65334
totalValueChange-196
totalHolders0
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 4
totalSharesHeld4
totalSharesValue0
totalPostionChange-65334
totalValueChange-196
totalHolders1
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 41
totalSharesHeld41
totalSharesValue0
totalPostionChange-65334
totalValueChange-196
totalHolders2
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 41
totalSharesHeld41
totalSharesValue0
totalPostionChange-65334
totalValueChange-196
totalHolders3
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1439
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 41
totalSharesHeld4777
totalSharesValue10
totalPostionChange-66773
totalValueChange-205
totalHolders4
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1439
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares10
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 41
totalSharesHeld4787
totalSharesValue10
totalPostionChange-66763
totalValueChange-205
totalHolders5
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1439
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares451
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 41
totalSharesHeld5228
totalSharesValue11
totalPostionChange-66322
totalValueChange-204
totalHolders6
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1439
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares451
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 375
totalSharesHeld5562
totalSharesValue12
totalPostionChange-66322
totalValueChange-204
totalHolders7
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1439
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue2
oldIncreaseHoldingTotalShares692
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 375
totalSharesHeld5803
totalSharesValue13
totalPostionChange-66081
totalValueChange-203
totalHolders8
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561
liquidatedTotalCompanies1
liquidatedTotalValue-196
liquidatedTotalShares-65334
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1439
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares693
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 375
totalSharesHeld6804
totalSharesValue15
totalPostionChange-66080
totalValueChange-204
totalHolders9
COMPID130679
TICBKYI
CIK0001019034
SHSOUT7820
NAMEBio Key International Inc
SECTOR503008
CUSIP09060C507
PRICE0.1561
virgina 0.09
virgina2 -0.85
SELECT * from sectors where level3num = '503008'Number Of Rows Found :1
The Sector is Security & Protection Services
CRAIG TOTAL SHARES VALE : 15
MKCAP1220.702/n/ninsert into institSumNewHoldings values(
Null,
'0001019034',
'130679',
'Bio Key International Inc',
'BKYI',
'0.1561',
'09060C507',
'7820',
'0.09',
'503008',
'Security & Protection Services',
'1220.702',
'1',
'-196',
'-65334',
'0',
'0',
'0',
'1',
'-9',
'-1439',
'4',
'1',
'693',
'6804',
'15',
'-66080',
'-204',
'9',
'4',
'0',
'375',
'-0.85',
'-127.5',
'NULL',
'-127.5',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye