用VBA实现股票的马尔可夫法预测  

Forecast of Stock with Markov Chain Based on VBA

作　　者：付明柏[1] 

机构地区：[1]昭通师范高等专科学校,云南昭通657000

出　　处：《现代电子技术》2009年第16期100-102,106,共4页Modern Electronics Technique

摘　　要：马尔可夫预测法是一种预测事件发生的概率的方法,是对地理、天气、市场、进行预测的基本方法。根据马尔可夫预测法的基本原理和过程,利用语法简单、容易理解和掌握的与Excel绑定的VBA编程实现了股票的预测,旨在普及和推广电脑的应用,使程序设计大众化。通过应用证明,该程序比较适用、操作简单、预测结果和实际结果有很好的一致性。对于非专业软件开发人员,用Excel及VBA开发本领域的实用系统是一个非常不错的选择。The forecast of Markov chain is a kind of way to predict event probability. It is often used to predict the change of geography,climate and market. A forecast model based on Markov analysis by using Excel VBA to predict the change of stock is implemented. The purpose of this program is quickly popularize the computer applications and programming. The application shows that the case is appropriate style and operation is easy,the forecast value based on the model agrees with the original values. It is a very good choice to develop practical system in its spheres for non - experts to apply Excel VBA.

关 键 词：EXCEL VBA 马尔可夫预测法 股票 预测 

分 类 号：TP311.51[自动化与计算机技术—计算机软件与理论]