Compid = 130873Number Of Rows Found :1
$tempCalculation=0
START :
END :116.96
Compid Found :130873 Tic Found :RTN
FINALRTN | 130873
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130873 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :4must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 111
unchangedHoldingTotalShares 8307
totalSharesHeld8307
totalSharesValue810
totalPostionChange0
totalValueChange111
totalHolders1
COMPID130873
TICRTN
CIK0001047122
SHSOUT289000
NAMERaytheon Co
SECTOR501001
CUSIP755111507
PRICE116.96
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue773
oldDecreaseHoldingTotalShares-623
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 111
unchangedHoldingTotalShares 8307
totalSharesHeld69879
totalSharesValue6816
totalPostionChange-623
totalValueChange884
totalHolders2
COMPID130873
TICRTN
CIK0001047122
SHSOUT289000
NAMERaytheon Co
SECTOR501001
CUSIP755111507
PRICE116.96
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue773
oldDecreaseHoldingTotalShares-623
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue224
oldIncreaseHoldingTotalShares300
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 111
unchangedHoldingTotalShares 8307
totalSharesHeld84758
totalSharesValue8267
totalPostionChange-323
totalValueChange1108
totalHolders3
COMPID130873
TICRTN
CIK0001047122
SHSOUT289000
NAMERaytheon Co
SECTOR501001
CUSIP755111507
PRICE116.96
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue493
oldDecreaseHoldingTotalShares-9260
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue224
oldIncreaseHoldingTotalShares300
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 111
unchangedHoldingTotalShares 8307
totalSharesHeld91765
totalSharesValue8958
totalPostionChange-8960
totalValueChange828
totalHolders4
COMPID130873
TICRTN
CIK0001047122
SHSOUT289000
NAMERaytheon Co
SECTOR501001
CUSIP755111507
PRICE116.96
virgina 0.03
virgina2 -0
SELECT * from sectors where level3num = '501001'Number Of Rows Found :1
The Sector is Aerospace/Defense - Major Diversified
CRAIG TOTAL SHARES VALE : 8958
MKCAP33801440/n/ninsert into institSumNewHoldings values(
Null,
'0001047122',
'130873',
'Raytheon Co',
'RTN',
'116.96',
'755111507',
'289000',
'0.03',
'501001',
'Aerospace/Defense - Major Diversified',
'33801440',
'0',
'0',
'0',
'0',
'0',
'0',
'2',
'493',
'-9260',
'1',
'224',
'300',
'91765',
'8958',
'-8960',
'828',
'4',
'1',
'111',
'8307',
'-0',
'-0',
'-0',
'-0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye