Compid = 130791Number Of Rows Found :1<BR>$tempCalculation=0<BR>START :<BR>END :0.0119<BR><BR>Compid Found :130791 Tic Found :ANDR<BR>FINALANDR | 130791<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130791 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes'  AND reportDate >= '2024-03-31' <BR><BR>Number Of Rows Found :1must have stayed the same<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies0<BR>oldDecreaseHoldingTotalValue0<BR>oldDecreaseHoldingTotalShares0<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 1<BR>unchangedHoldingTotalValue 0<BR>unchangedHoldingTotalShares 8000<BR><BR><BR>totalSharesHeld8000<BR>totalSharesValue0<BR>totalPostionChange0<BR>totalValueChange0<BR>totalHolders1<BR>COMPID130791<BR>TICANDR<BR>CIK0000006494<BR>SHSOUT64915<BR>NAMEAndrea Electronics Corp<BR>SECTOR102003<BR>CUSIP034393108<BR>PRICE0.0119<BR>virgina 0.01<BR><BR>virgina2 0<BR>SELECT * from sectors where level3num = '102003'Number Of Rows Found :1<BR>The Sector is Electronic Equipment<BR><BR>CRAIG TOTAL SHARES VALE : 0<BR><BR>MKCAP772.4885/n/ninsert into institSumNewHoldings values(
								 Null,
								'0000006494',
								'130791',
								'Andrea Electronics Corp',
								'ANDR',
								'0.0119',
								'034393108',
								'64915',
								'0.01',
								'102003',
								'Electronic Equipment',
								 '772.4885',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '8000',
								 '0',
								 '0',
								 '0',
								 '1',
								 '1',
								 '0',
								 '8000',
								 '0',
								 '0',
								 '0',
								 '0',
								 '', 
 								 '', 
 								 '', 
 								 '0', 


								  NULL,  NULL,NULL)

OKbye