Update Company
Name Pricing Date  2024-03-31(LQAP)    
CompId   Stop Date volume LQStart
Ticker Price avevol LQEnd
Cusip Last Trade open LQAve
Sector Country high
    
MktCap CompNum low
 yearlylow
Shares Out Type1 prevClose
 yearlyhigh
Last_ShsOut    Exchange  
      
  09-30 12-25 sic Code      
Description cik  Updated
  Notes PAGE RESET
  Run BOMSF Charts Yahoo BOMSF Profile
  Run BOMSF Institutional Summary Yahoo BOMSF Key Statisics
  J3 Open BOMSF Pricing Yahoo BOMSF Pricing
  J3 BOMSF Insider   J3 BOMSF Insitutions Yahoo BOMSF Holders
     
  Open up Sector/Exchange Map Fidelity BOMSF Lookup
  Open up sec.gov For Market Ca MSN BOMSF Lookup
     
  2001-01-01 shsout made up date to make % good  
  0009-09-09 sdate Dead Company  
  2010-12-25 shsout Took From Yahoo  
  9000010176 Next Fake CIK to use
   

INSITITUIONS Dynamic newInstitTable Changed the Cusip/Sector/Shs Out?
Old Cusips
 

Fix Cusip issue where all new and deleted Instittuional Holdings
Current Quarter Date: ie: 2012-06-30
Should We Update The database:
BackUp query is below under BACK UP Institutions before committing.

Total Insititutions : N/A 0   Update Insititution By Cusips
% Owned by Insititutions: N/A % 0 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:145619
New Old Cusip
 
Splits :
 reportDate : 
  ratio : 
  endQuaterAffected : 
  dayFrom  :
  dayTo  :
  

reportDate ratio endQuaterAffected dayFrom dayTo

To Upper  



Cusip
entryId groupId EQUITY CHANGE CUSIP DESCRIPTION ISSUE
STATUS
CODE		 ISSUE
TYPE
CODE		 ADD
DATE		 EXPIRATION
DATE		 PAYMENT
FREQUENCY
CODE		 MARGIN
FLAG		 OPTION
FLAG		 CONVERTED
CUSIP		 NASDAQ
MARKET
CODE		 INDEX
ISSUER		 CHANGE
DATE		 MERGENT
CHANGE
DATE		 MATURE
DATE		 undefined1 undefined2 undefined3 undefined4 temp1 temp2 fileName fileDate processDate
1863104 1863104 EXCHANGE CHANGE 58508Q305 66 2012-09-26 2015-04-13 BOMSF 0 0 ? 2012-10-24 20150514.ifs 2015-05-14 2015-05-15
1863105 1863104 EXCHANGE CHANGE 58508Q305 66 2012-09-26 2015-05-13 BOMSF 0 0 ? 2015-05-14 20150514.ifs 2015-05-14 2015-05-15
1863106 1863106 DIVIDEND DELETE 58508Q305 0 0 6 0 .096154 54 2015-05-14 2015-05-14 2015-05-14 2015-05-13 0 2015-05-13 ? 0 0005000066 20150514.ifs 2015-05-14 2015-05-15
1863107 1863107 DIVIDEND ADD 58508Q305 0 0 6 0 .096154 0 54 2015-05-14 2015-05-14 2015-05-14 2015-05-14 0 ? 2015-05-14 0 0005000066 20150514.ifs 2015-05-14 2015-05-15
1863127 1863127 CORPACTION ADD 58508Q305 66 D 2015-05-14 2015-05-14 20150514.ifs 2015-05-14 2015-05-15
1863128 1863128 EQUITY CHANGE 58508Q305 COM NEW N 0 2012-09-26 ? 0 no no no ? 2012-09-26 ? 20150514.ifs 2015-05-14 2015-05-15
1863129 1863128 EQUITY CHANGE 58508Q305 COM NEW D 0 2012-09-26 2015-05-14 0 no no no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1863130 1863130 CORPACTION DELETE 58508Q305 66 D 2015-05-14 2015-05-14 20150514.ifs 2015-05-14 2015-05-15
1863137 1863137 CORPACTION ADD 58508Q305 66 D 2015-05-14 2015-05-14 20150514.ifs 2015-05-14 2015-05-15
1863138 1863138 EQUITY CHANGE 58508Q305 COM NEW D 0 2012-09-26 2015-05-14 0 no no no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1863139 1863138 EQUITY CHANGE 58508Q305 COM NEW Q 0 2012-09-26 2015-05-14 0 no no 361569205 no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1863140 1863140 DIVIDEND DELETE 58508Q305 0 0 6 0 .096154 0 54 2015-05-14 2015-05-14 2015-05-14 2015-05-14 0 ? 2015-05-14 0 0005000066 20150514.ifs 2015-05-14 2015-05-15
1863280 1863280 EQUITY CHANGE 58508Q305 COM NEW Q 0 2012-09-26 2015-05-14 0 no no 361569205 no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1863281 1863280 EQUITY CHANGE 58508Q305 COM NEW M 0 2012-09-26 2015-05-14 0 no no 361569205 no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1863283 1863282 EQUITY CHANGE 58508Q305 66 D 2015-05-14 2015-05-14 20150514.ifs 2015-05-14 2015-05-15
1863284 1863283 EQUITY CHANGE 58508Q305 66 M 2015-05-14 2015-05-14 20150514.ifs 2015-05-14 2015-05-15
1863285 1863285 EQUITY CHANGE 58508Q305 COM NEW M 0 2012-09-26 2015-05-14 0 no no 361569205 no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1863286 1863285 EQUITY CHANGE 58508Q305 COM NEW M 0 2012-09-26 2015-05-14 0 no no 361569205 no ? 2015-05-14 ? 20150514.ifs 2015-05-14 2015-05-15
1862775 1862775 DIVIDEND ADD 58508Q305 0 0 6 0 .096154 54 2015-05-14 2015-05-14 2015-05-14 2015-05-13 0 2015-05-13 ? 0 0005000066 20150513.ifs 2015-05-13 2015-05-14
1862776 1862776 SPLIT ADD 58508Q305 10.4 2015-05-14 54 2015-05-13 ? 20150513.ifs 2015-05-13 2015-05-14
1762656 1762656 SPLIT ADD 58508Q305 .4082075472 2015-01-05 20 ? 2015-01-05 20150105.ifs 2015-01-05 2015-01-06
1703575 1703575 DIVIDEND CHANGE 58508Q305 0 0 7 0 2.25 0 20 2015-01-05 2014-12-15 2015-01-02 2014-11-27 847574100 1 2014-12-01 2014-12-08 0 0004881692 20141209.ifs 2014-12-09 2014-12-10
1703576 1703575 DIVIDEND CHANGE 58508Q305 2.25 shs. of Spectral Diagnostics Inc. for each sh. held. 0 0 7 0 2.25 0 20 2015-01-05 2014-12-15 2015-01-02 2014-11-27 847574100 1 2014-12-01 2014-12-09 0 0004881692 20141209.ifs 2014-12-09 2014-12-10
1703052 1703052 DIVIDEND DELETE 58508Q305 2.25 shs. of Spectral Diagnostics Inc. for each sh. held. 0 0 7 0 2.25 0 20 ? 2014-12-15 2015-01-02 2014-11-27 847574100 0 2014-12-01 2014-12-02 0 0004881692 20141208.ifs 2014-12-08 2014-12-09
1703053 1703053 DIVIDEND ADD 58508Q305 0 0 7 0 2.25 0 20 2015-01-05 2014-12-15 2015-01-02 2014-11-27 847574100 1 2014-12-01 2014-12-08 0 0004881692 20141208.ifs 2014-12-08 2014-12-09
1694430 1694430 DIVIDEND ADD 58508Q305 0 0 7 0 2.25 20 ? 2014-12-15 2015-01-02 2014-11-27 847574100 0 2014-12-01 ? 0 0004881692 20141201.ifs 2014-12-01 2014-12-02
1351262 1351262 DIVIDEND DELETE 58508Q305 2 shs. of Spectral Diagnostics Inc. Warrant for each sh held. 0 0 A 0 2 0 13 2013-11-07 2013-11-12 2013-11-29 2013-10-30 0 ? 2013-11-07 0 0004656112 20131202.ifs 2013-12-02 2013-12-03
1351263 1351263 DIVIDEND ADD 58508Q305 2 shs. of Spectral Diagnostics Inc. Warrant for each sh held. 0 0 A 0 2 0 13 2013-11-07 2013-11-12 2013-12-06 2013-10-30 0 ? 2013-12-02 0 0004656112 20131202.ifs 2013-12-02 2013-12-03
1336632 1336632 DIVIDEND DELETE 58508Q305 0 1 13 ? ? ? 2013-11-05 0 ? 2013-11-05 0 20131107.ifs 2013-11-07 2013-11-08
1336633 1336633 DIVIDEND DELETE 58508Q305 2 shs. of Spectral Diagnostics Inc. Warrant for each sh held. 0 0 A 0 2 13 ? 2013-11-12 2013-11-29 2013-10-30 0 ? 2013-11-05 0 0004656112 20131107.ifs 2013-11-07 2013-11-08
1336634 1336634 DIVIDEND ADD 58508Q305 2 shs. of Spectral Diagnostics Inc. Warrant for each sh held. 0 0 A 0 2 0 13 2013-11-07 2013-11-12 2013-11-29 2013-10-30 0 ? 2013-11-07 0 0004656112 20131107.ifs 2013-11-07 2013-11-08
1335252 1335252 DIVIDEND ADD 58508Q305 0 1 13 ? ? ? 2013-11-05 0 ? 2013-11-05 0 20131105.ifs 2013-11-05 2013-11-06
1335253 1335253 DIVIDEND ADD 58508Q305 2 shs. of Spectral Diagnostics Inc. Warrant for each sh held. 0 0 A 0 2 13 ? 2013-11-12 2013-11-29 2013-10-30 0 ? 2013-11-05 0 0004656112 20131105.ifs 2013-11-05 2013-11-06
991499 991499 CORPACTION ADD 58508Q305 66 # 2012-10-24 58508Q305 66 ? 20121024.ifs 2012-10-24 2012-10-25
991500 991500 CORPACTIONAUX ADD 58508Q305 66 2012-10-24 BOMSD MEDWELL CAP CORP COM NEW BOMSF MEDWELL CAP CORP COM NEW 2012-10-24 ? 20121024.ifs 2012-10-24 2012-10-25
991501 991501 EXCHANGE CHANGE 58508Q305 66 2012-09-26 2012-09-26 BOMSD 0 0 ? 2012-09-26 20121024.ifs 2012-10-24 2012-10-25
991502 991501 EXCHANGE CHANGE 58508Q305 66 2012-09-26 2012-09-26 BOMSF 0 0 ? 2012-10-24 20121024.ifs 2012-10-24 2012-10-25
964937 964937 EQUITY ADD 58508Q305 NEW ISSUE 0 0 2012-09-26 ? 0 no no no ? ? ? 20120926.ifs 2012-09-26 2012-09-27
964938 964938 EQUITY CHANGE 58508Q305 NEW ISSUE 0 0 2012-09-26 ? 0 no no no ? ? ? 20120926.ifs 2012-09-26 2012-09-27
964939 964938 EQUITY CHANGE 58508Q305 COM NEW N 0 2012-09-26 ? 0 no no no ? 2012-09-26 ? 20120926.ifs 2012-09-26 2012-09-27
964940 964940 EXCHANGE ADD 58508Q305 66 2012-09-26 2012-09-26 BOMSD 0 0 ? 2012-09-26 20120926.ifs 2012-09-26 2012-09-27
964945 964945 SPLIT ADD 58508Q305 20 2012-09-26 54 2012-09-25 2012-09-26 20120926.ifs 2012-09-26 2012-09-27
964947 964947 DIVIDEND ADD 58508Q305 0 0 6 0 .05 0 54 2012-09-26 2012-09-26 2012-09-26 2012-09-26 0 ? 2012-09-26 0 0004433396 20120926.ifs 2012-09-26 2012-09-27


Old Cusip
entryId groupId EQUITY CHANGE CUSIP DESCRIPTION ISSUE
STATUS
CODE		 ISSUE
TYPE
CODE		 ADD
DATE		 EXPIRATION
DATE		 PAYMENT
FREQUENCY
CODE		 MARGIN
FLAG		 OPTION
FLAG		 CONVERTED
CUSIP		 NASDAQ
MARKET
CODE		 INDEX
ISSUER		 CHANGE
DATE		 MERGENT
CHANGE
DATE		 MATURE
DATE		 undefined1 undefined2 undefined3 undefined4 temp1 temp2 fileName fileDate processDate


Your Name Click here to open the child window


BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 145619
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC