千股金:=IF(C<10,FLOOR(10000/C),FLOOR(20000/C)),NODRAW; 股数:ROUND(千股金/100)*100,NODRAW,COLORGREEN; 涨跌幅:(C-REF(C,1))/REF(C,1)*100,NODRAW,COLORGREEN; 涨跌额:(C-REF(C,1)),NODRAW,COLORGREEN; 赢亏:涨跌额*REF(股数,1),NODRAW,COLORGREEN; 实盘价:=6.3;{手动填写} 实盘涨跌额:=C-实盘价; 实股数:1000{手动填写},NODRAW,COLORYELLOW; 实盘赢亏:实盘涨跌额*REF(实股数,1),NODRAW,COLORYELLOW;
看股 吧公式 www.kangub a.com