本集内容是数据分析的可视化。 一看全是数字,会让人头痛。如何让人感觉 不头痛呢,往往采用数据可视化。 本集目标是股票数据分析的可视化,把 用EXCEL就可以搞定复杂的数据分析(三)和 建立股票评价体系,预测股票价格,你会吗?这两篇文章的数据进行可视化。 用计算出来的数据进行拟合,以下是指标在各只股票的图形。 小编根据上面分析,用通达信编写的一股票指标,如下: T0:=1/LN(FINANCE(42)); VN:=V/10000; C00:=C/(C+L+H+O+VN); C0:=C00/SUM(C,FINANCE(42)); C1:=C0*LN(C0); C2:=SUM(C1,FINANCE(42)); C3:=T0*C2+1; H00:=H/(C+L+H+O+VN); H0:=H00/SUM(H,FINANCE(42)); H1:=H0*LN(H0); H2:=SUM(H1,FINANCE(42)); H3:=T0*H2+1; L00:=L/(C+L+H+O+VN); L0:=L00/SUM(L,FINANCE(42)); L1:=L0*LN(L0); L2:=SUM(L1,FINANCE(42)); L3:=T0*L2+1; O00:=O/(C+L+H+O+VN); O0:=O00/SUM(O,FINANCE(42)); O1:=O0*LN(O0); O2:=SUM(O1,FINANCE(42)); O3:=T0*O2+1; V0:=VN/SUM(VN,FINANCE(42)); V1:=O0*LN(V0); V2:=SUM(V1,FINANCE(42)); V3:=T0*V2+1; YC:=(C*C3+H*H3+L*L3+O*O3+VN*V3)/5; X1:=YC-SUM(YC,FINANCE(42))/FINANCE(42); X2:=H-SUM(H,FINANCE(42))/FINANCE(42); B:=SUM(X1*X2,FINANCE(42))/SUM(X1*X1,FINANCE(42)); A:=SUM(C,FINANCE(42))/FINANCE(42)-B*SUM(YC,FINANCE(42))/FINANCE(42); NC:A+B*YC; CC:C; |
|