s****h
发帖数: 1286 | 1 神医payment给了个oxps格式的，搞了半天打不开
笨死了
人穷是有原因的 |
|
m********0
发帖数: 2717 | 2 Symbol AvgVolume (No column name) Volume Ratio
AAU 348363 2010/12/01 1623500 4.66
ABAT 848698 2010/12/01 2683700 3.16
ABM 246261 2010/12/02 1101500 4.47
ABM 246261 2010/12/03 1189700 4.83
ACPW 302000 2010/12/03 927000 3.07
AEL 596058 2010/12/03 2003500 3.36
AFFY 655734 2010/12/02 1987100 3.03
AIT 290638 2010/12/02 970500 3.34
AMRN 681435 2010/12/01 6431400 9.44
AMRN 681435 ... 阅读全帖 |
|
m********0
发帖数: 2717 | 3 JUST FYI, no more comments
SELECT a.Symbol, b.AvgVolume, a.[Date], a.Volume
FROM Stock.dbo.stock_daily a
Join (
SELECT Symbol, AVG(Volume) as AvgVolume
FROM Stock.dbo.stock_daily
WHERE Date >= '20100101'
GROUP BY Symbol
) b
ON a.Symbol = b.Symbol
WHERE 1=1
AND a.Volume > 5*b.AvgVolume
AND a.[Date] >= '20101131'
AND b.AvgVolume > 0
ORDER BY a.Symbol, a.[Date]
Symbol Year_AvgVolume Date Volume Ratio
AERL 74756 12/3/2010 667100 8.923698432
AMAC 9247 12/3/2010 78400 ... 阅读全帖 |
|
|
I**C
发帖数: 1513 | 5 另外一支股票OXPS: optionsXpress也有类似的情况,难道都这么巧出错么? |
|
|
|
|
w****r
发帖数: 245 | 9 大侠，分类都分好了，求神签
# Basic Materials, Agricultural Chemicals
AGU Agrium Inc.
AVD American Vanguard Corp.
CAGC China Agritech Inc.
CF CF Industries Holdings, Inc.
CGA China Green Agriculture, Inc.
CMP Compass Minerals International
COIN Converted Organics Inc.
IPI Intrepid Potash, Inc.
MON Monsanto Co.
MOS Mosaic Co.
NOEC New Oriental Energy & Chemical
POT Potas... 阅读全帖 |
|
M*****8
发帖数: 17722 | 10 股票符号 日期 最后价 跌幅 百分比
AAR, 20110520, 24.4999, -0.1624, -0.7
AAUKY, 20110520, 23.8300, -0.0513, -0.2
AAWW, 20110520, 63.9700, -1.4313, -2.2
AAXJ, 20110520, 62.6625, -0.3633, -0.6
AB, 20110520, 21.5300, -0.0545, -0.3
ABAX, 20110520, 30.8500, -1.4335, -4.6
ABB, 20110520, 26.3200, -0.0229, -0.1
ABCO, 20110520, 50.9300, -0.4103, -0.8
ABFS, 20110520, 25.3500, -0.7916, -3.1
ABW-A, 20110520, 25.2... 阅读全帖 |
|
n**x
发帖数: 606 | 11 Russell 2000:
AAON
AAT
AATI
AAWW
ABAX
ABBC
ABCB
ABCD
ABCO
ABD
ABFS
ABG
ABM
ABMD
ABVT
ACAT
ACC
ACCL
ACET
ACHN
ACIW
ACLS
ACO
ACOM
ACOR
ACPW
ACTG
ACTV
ACUR
ACW
ACXM
ADC
ADPI
ADTN
ADVS
AEA
AEC
AEGR
AEIS
AEL
AEPI
AF
AFAM
AFCE
AFFX
AFFY
AFP
AFSI
AGII
AGM
AGX
AGYS
AH
AHC
AHS
AHT
AI
AIMC
AIN
AINV
AIQ
AIR
AIRM
AIS
AIT
AKR
AKRX
ALC
ALCO
ALE
ALG
ALGN
ALGT
ALIM
ALJ
ALK
ALKS
ALNC
ALNY
ALOG
ALSK
ALTE
ALTH
ALX
AM
AMAG
AMCC
AMED
AMKR
AMN
AMPE
AMRC
AMRI
AMRS
AMSC
AMSF
AMSG
AMSWA
AMWD
ANAC
ANAD
ANDE
ANEN
ANGO
ANH... 阅读全帖 |
|
|
|
|
q****x
发帖数: 7404 | 15 in term of public firms, they are indeed small in market cap... |
|
N***i
发帖数: 2063 | 16 Best-Rated Financial Stocks Updated June 23, 2010
http://www.nasd100.com/2010/06/bestrated-financial-stocks-updated-june-23-2010.html
Ranking | Company (Ticker) | Average Rating Value | Average Rating
1 IRSA Inversiones Representaciones (ADR) (NYSE:IRS) 1.00 Strong Buy
2 Primus Guaranty, Ltd. (NYSE:PRS) 1.00 Strong Buy
3 China Life Insurance Company Ltd. (ADR) (NYSE:LFC) 1.00 Strong Buy
4 National Bank of Greece (ADR) (NYSE:NBG) 1.00 Strong Buy
5 HDFC Bank Limited (ADR) (NYSE:HDB) 1.00 ... 阅读全帖 |
|
y*****l
发帖数: 5997 | 17 盘中动态 -- 美股周一盘中续挫
美股周一盘中续挫。南北韩在美韩联合军演期间不对放话互相挑衅，南北韩对立情势升
高，加上爱尔兰金融体系仍不稳定，导致市场信心溃散，三大指数开低走跌，盘中续挫
。
道琼工业指数盘中下跌140.24点，来到10951.76点，跌幅1.264%。那斯达克指数下跌33
.86点，来到2500.7点，跌幅1.336%。S&P 500下跌12.91点，来到1176.49点，跌幅1.
085%。
欧盟财长周日(28日)达成协议，同意对爱尔兰纾困850亿欧元，拯救该国的银行体系。
中海油(CNOOC)宣布，该公司与Bridas Energy持股各半的Bridas与英国石油(BP)签订协
议，将以70.6亿美元跟英国石油收购60%的Pan American Energy(PAE)股权，这件交易
不包括PAE在波利维亚的资产。CNOOC与Bridas Energy同意对Bridas注资49.4亿美元，
相当於收购价的70%，其余21.2亿美元将由第三方贷款支付或是未来双方再出资，这件
交易将在2011年上半年完成。
Beacon Roofing Supply (B... 阅读全帖 |
|
