SELECT TOP 5 f.issuerName, f.issuerTradingSymbol, f.transactionDate, CAST(SUM(f.transactionShares) / (10000 * r.ShareOutstanding) AS decimal(7, 3)) AS pshares, AVG(f.transactionPricePerShare) AS aprice FROM na_stock_comp_insider_form4 f INNER JOIN na_stock_comp_reuters r ON f.issuerTradingSymbol = r.symbol WHERE (f.transactionCode = 'P') AND (f.transactionDate BETWEEN '2008-10-29' AND '2008-11-20') AND (f.transactionPricePerShare IS NOT NULL) AND officerTitle Like '%C%' AND r.ShareOutstanding >0 GROUP BY f.issuerName, f.issuerTradingSymbol, f.transactionDate, r.ShareOutstanding ORDER BY SUM(f.transactionShares) / r.ShareOutstanding DESC;SELECT TOP 5 f.issuerName, f.issuerTradingSymbol, f.transactionDate, CAST(SUM(f.transactionShares) / (10000 * r.ShareOutstanding) AS decimal(7, 3)) AS pshares, AVG(f.transactionPricePerShare) AS aprice FROM na_stock_comp_insider_form4 f INNER JOIN na_stock_comp_reuters r ON f.issuerTradingSymbol = r.symbol WHERE (f.transactionCode = 'S') AND (f.transactionDate BETWEEN '2008-10-29' AND '2008-11-20') AND (f.transactionPricePerShare IS NOT NULL) AND officerTitle Like '%C%' AND f.isoption is null AND r.ShareOutstanding >0 GROUP BY f.issuerName, f.issuerTradingSymbol, f.transactionDate, r.ShareOutstanding ORDER BY SUM(f.transactionShares) / r.ShareOutstanding DESC;SELECT TOP 5 f.issuerName, f.issuerTradingSymbol, f.transactionDate, CAST(SUM(f.transactionShares) / (10000 * r.ShareOutstanding) AS decimal(7, 3)) AS pshares, AVG(f.transactionPricePerShare) AS aprice FROM na_stock_comp_insider_form4 f INNER JOIN na_stock_comp_reuters r ON f.issuerTradingSymbol = r.symbol WHERE (f.transactionCode = 'P') AND (f.transactionDate BETWEEN '2008-10-29' AND '2008-11-20') AND (f.transactionPricePerShare IS NOT NULL) AND r.ShareOutstanding >0 GROUP BY f.issuerName, f.issuerTradingSymbol, f.transactionDate, r.ShareOutstanding ORDER BY SUM(f.transactionShares) / r.ShareOutstanding DESC;SELECT TOP 5 f.issuerName, f.issuerTradingSymbol, f.transactionDate, CAST(SUM(f.transactionShares) / (10000 * r.ShareOutstanding) AS decimal(7, 3)) AS pshares, AVG(f.transactionPricePerShare) AS aprice FROM na_stock_comp_insider_form4 f INNER JOIN na_stock_comp_reuters r ON f.issuerTradingSymbol = r.symbol WHERE (f.transactionCode = 'S') AND (f.transactionDate BETWEEN '2008-10-29' AND '2008-11-20') AND (f.transactionPricePerShare IS NOT NULL) AND r.ShareOutstanding >0 AND f.isoption is null GROUP BY f.issuerName, f.issuerTradingSymbol, f.transactionDate, r.ShareOutstanding ORDER BY SUM(f.transactionShares) / r.ShareOutstanding DESC;SELECT TOP 5 issuerName, issuerTradingSymbol, transactionDate, SUM(transactionShares) AS sshares, AVG(transactionPricePerShare) AS aprice FROM na_stock_comp_insider_form4 WHERE (transactionCode = 'P') AND (transactionDate BETWEEN '2008-10-29' AND '2008-11-20') AND (transactionPricePerShare IS NOT NULL) GROUP BY issuerName, issuerTradingSymbol, transactionDate ORDER BY SUM(transactionShares) DESC;SELECT TOP 5 issuerName, issuerTradingSymbol, transactionDate, SUM(transactionShares) AS sshares, AVG(transactionPricePerShare) AS aprice FROM na_stock_comp_insider_form4 WHERE (transactionCode = 'S') AND (transactionDate BETWEEN '2008-10-29' AND '2008-11-20') AND (transactionPricePerShare IS NOT NULL) AND isoption is null GROUP BY issuerName, issuerTradingSymbol, transactionDate ORDER BY SUM(transactionShares) DESC
ChineseWorldNet.com 環球財經 北美股票-投資工具-內部交易報告
|
