分享

市场平均成本指标公式和例题

 燕舞m 2017-01-09
RSV:=(HIGH+LOW+OPEN+CLOSE)/4;
A1:=(SUM(RSV*AMOUNT,360)/SUM(AMOUNT,360));
A2:=(SUM(RSV*AMOUNT,350)/SUM(AMOUNT,350));
A3:=(SUM(RSV*AMOUNT,340)/SUM(AMOUNT,340));
A4:=(SUM(RSV*AMOUNT,330)/SUM(AMOUNT,330));
A5:=(SUM(RSV*AMOUNT,320)/SUM(AMOUNT,320));
A6:=(SUM(RSV*AMOUNT,310)/SUM(AMOUNT,310));
A7:=(SUM(RSV*AMOUNT,300)/SUM(AMOUNT,300));
A8:=(SUM(RSV*AMOUNT,270)/SUM(AMOUNT,270));
A9:=(SUM(RSV*AMOUNT,260)/SUM(AMOUNT,260));
A10:=(SUM(RSV*AMOUNT,250)/SUM(AMOUNT,250));
A11:=(SUM(RSV*AMOUNT,240)/SUM(AMOUNT,240));
A12:=(SUM(RSV*AMOUNT,230)/SUM(AMOUNT,230));
A13:=(SUM(RSV*AMOUNT,220)/SUM(AMOUNT,220));
A14:=(SUM(RSV*AMOUNT,210)/SUM(AMOUNT,210));
A15:=(SUM(RSV*AMOUNT,180)/SUM(AMOUNT,180));
A16:=(SUM(RSV*AMOUNT,170)/SUM(AMOUNT,170));
A17:=(SUM(RSV*AMOUNT,160)/SUM(AMOUNT,160));
A18:=(SUM(RSV*AMOUNT,150)/SUM(AMOUNT,150));
A19:=(SUM(RSV*AMOUNT,140)/SUM(AMOUNT,140));
A20:=(SUM(RSV*AMOUNT,130)/SUM(AMOUNT,130));
A21:=(SUM(RSV*AMOUNT,120)/SUM(AMOUNT,120));
A22:=(SUM(RSV*AMOUNT,90)/SUM(AMOUNT,90));
A23:=(SUM(RSV*AMOUNT,80)/SUM(AMOUNT,80));
A24:=(SUM(RSV*AMOUNT,70)/SUM(AMOUNT,70));
A25:=(SUM(RSV*AMOUNT,60)/SUM(AMOUNT,60));
A26:=(SUM(RSV*AMOUNT,50)/SUM(AMOUNT,50));
A27:=(SUM(RSV*AMOUNT,40)/SUM(AMOUNT,40));
A28:=(SUM(RSV*AMOUNT,30)/SUM(AMOUNT,30));
B1:(A1+A2+A3+A4+A5+A6+A7)/7;
B2:(A8+A9+A10+A11+A12+A13+A14)/7;
B3:(A15+A16+A17+A18+A19+A20+A21)/7;
B4:(A22+A23+A24+A25+A26+A27+A28)/7;

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约

    类似文章 更多