内容导航：

Q1：用Excel公式实现文本转Java输出文本的问题

public class Excel {

private jxl.Workbook rwb = null;

/**

* 得到当前工作薄的总列数

*

* @parma sheetIndex 工作薄号

* @return int

*/

public int getColCount(int sheetIndex) {

int colCnt = 0;

try {

jxl.Sheet rs = rwb.getSheet(sheetIndex);

colCnt = rs.getColumns();

} catch (Exception e) {

colCnt = 0;

} finally {

try {

} catch (Exception e) {

colCnt = 0;

}

}

return colCnt;

}

/**

* 得到当前工作薄的总行数

*

* @parma sheetIndex 工作薄号

* @return int

*/

public int getRowCount(int sheetIndex) {

int colCnt = 0;

try {

jxl.Sheet rs = rwb.getSheet(sheetIndex);

colCnt = rs.getRows();

} catch (Exception e) {

colCnt = 0;

} finally {

try {

} catch (Exception e) {

colCnt = 0;

}

}

return colCnt;

}

/**

* 打开Excel.

*

* @parma fileName Excel文件名+文件路径(绝对路径)

* @return boolean

*/

public boolean openExcel(String fileName) {

boolean Rtn = false;

try {

is = new FileInputStream(fileName);

rwb = Workbook.getWorkbook(is);

Rtn = true;

} catch (Exception e) {

Rtn = false;

} finally {

try {} catch (Exception e) {}

}

return Rtn;

}

/**

* 取得某个单元格的内容。不论单元格是何种数据类型都将返回字符型。

*

* @parma int col 列号 int row 行号

* @return String

*/

public String getCellContent(int col, int row) {

String cellContent = "";

try {

// 默认打开第一张工作薄。

Sheet rs = rwb.getSheet(0);

// 取得某一单元格的内容

Cell c00 = rs.getCell(col, row);

cellContent = c00.getContents();

} catch (Exception e) {

cellContent = "";

} finally {

try {

} catch (Exception e) {

cellContent = "";

}

}

return cellContent;

}

public static void main(String[] args) {

Excel ex = new Excel();

ex.openExcel("你自己的*.xls");

for (int i = 1; i < ex.getRowCount(0); i++) {

for (int j = 0; j < ex.getColCount(0); j++) {

System.out.println(ex.getCellContent(j, i));

}

}

}

}

Q2：一个非常不错的股票公式需要转换通达信格式

VAR3:=(CLOSE-MA(CLOSE,6))/MA(CLOSE,6)*100;

VAR4:=(CLOSE-MA(CLOSE,24))/MA(CLOSE,24)*100;

VAR5:=(CLOSE-MA(CLOSE,32))/MA(CLOSE,32)*100;

VAR6:=(VAR3+VAR4+VAR5)/3;

VAR7:=EMA(VAR6,5);

指标: EMA(EMA(VAR3,5),5)*3, COLORSTICK;

VAR8:=IF(VAR6<=-20,10,0);

VAR9:=HHV(VAR8,10);

STICKLINE(VAR8=10,20,10,5,0),COLOR6666FF;

VARA:=IF(VAR9 AND CROSS(MA(CLOSE,3),MA(CLOSE,5)),20,0);

DRAWTEXT(VARA=20,15,'底部'),LINETHICK1,COLORWHITE;

STICKLINE((VARA=20),0,10,5,0),COLORWHITE;

VARC:=(ZIG(3,5)>REF(ZIG(3,5),1)) AND (REF(ZIG(3,5),1)<=REF(ZIG(3,5),2)) AND (REF(ZIG

(3,5),2)<=REF(ZIG(3,5),3));

VARD:=(ZIG(3,5)=REF(ZIG(3,5),2)) AND (REF(ZIG

(3,5),2)>=REF(ZIG(3,5),3));

STICKLINE((VARC=1),(-14),0,4,0),COLOR0000FF;

DRAWTEXT((VARC=1),(-14),'高抛低吸。买入'),COLOR0000FF;

STICKLINE((VARD=1),14,0,4,0),COLOR00FF00;

DRAWTEXT((VARD=1),18,'高抛低吸。卖出'),COLOR00FF00;

VARE:=MA(100*(CLOSE-LLV(CLOSE,34))/(HHV(HIGH,34)-LLV(LOW,34)),5)-20;

VARF:=100-3*SMA((CLOSE-LLV(LOW,75))/(HHV(HIGH,75)-LLV(LOW,75))*100,20,1)+2*SMA(SMA

((CLOSE-LLV(LOW,75))/(HHV(HIGH,75)-LLV(LOW,75))*100,20,1),15,1);

VAR10:=100-3*SMA((OPEN-LLV(LOW,75))/(HHV(HIGH,75)-LLV(LOW,75))*100,20,1)+2*SMA(SMA

((OPEN-LLV(LOW,75))/(HHV(HIGH,75)-LLV(LOW,75))*100,20,1),15,1);

VAR11:=VARFREF(VOL,1) AND CLOSE>REF(CLOSE,1);

DRAWTEXT(VAR11 AND COUNT(VAR11,30)=1,15,'大资金活动'),LINETHICK1,COLORFF00FF;

STICKLINE(VAR11 AND COUNT(VAR11,30)=1,1,10,5,0),COLORFF00FF;

VAR12:=(HIGH+LOW+CLOSE)/3;

VAR13:=(VAR12-MA(VAR12,14))/(0.015*AVEDEV(VAR12,14));

VAR14:=(VAR12-MA(VAR12,70))/(0.015*AVEDEV(VAR12,70));

VAR15:=IF(VAR13>=150 AND VAR13<200 AND VAR14>=150 AND VAR14<200,10,0);

VAR16:=IF(VAR13<=-150 AND VAR13>-200 AND VAR14<=-150 AND VAR14>-200,-10,VAR15);

VAR17:=(CLOSE-MA(CLOSE,13))/MA(CLOSE,13)*100;

VAR18:=100-ABS(VAR17);

VAR19:=IF(VAR18<90,VAR18,100);V1:=ZIG(3,12);

V2:IF(REF(V1,2)>REF(V1,1) AND V1>REF(V1,1),50,0),COLORRED,LINETHICK2;

V3:IF(REF(V1,2)

VAR1:=ZIG(3,12)REF(ZIG(3,12),2);

VAR2:=ZIG(3,12)>REF(ZIG(3,12),1) AND REF(ZIG(3,12),1)

DRAWTEXT(VAR1,50,'趋势跌。卖出'),COLORYELLOW;

DRAWTEXT(VAR2,50,'趋势升。买入'),COLORYELLOW;

资金趋势:EMA(30*(C-LLV(LOW,34))/(HHV(H,34)-LLV(LOW,34)),3)*3, COLORRED,LINETHICK1;

VA3:=IF(TROUGHBARS(3,16,1)=0 AND HIGH>LOW+0.04,4,0);

买点:= VA3,COLORRED;

DRAWTEXT(买点>0,45,'低吸点'),COLORMAGENTA;

STICKLINE(买点,0,50,2,0),COLORMAGENTA,LINETHICK1;

Q3：编写一个java程序 利用公式 求 cosx的值 需把度数转换成弧度

java.math包里面好像是有cos函数的，度数转弧度就是度数除以180乘以2pi，pi在math里好像也是有的(没有可以自己定义

Q4：能把这段通达信公式转换为同花顺公式吗？

当然可以转换了，没问题完全可以正常使用下面分别是同花顺和通达信的截图。

Q5：如何抓住翻倍牛股？

1,有钱

2，更多的钱

Q6：8月份哪些板块最有可能会诞生翻倍大牛股？

由于内循环信号的传递，新基建、5G技术等板块有可能会吸引大量的资金，出现利好的局面。不过投资需要谨慎，避免出现巨大的损失。