定量分析的第一步，是获取数据。

获取股票历史行情数据最方便的途径，就是直接读取股票行情软件留在你电脑中的日线数据文件。

但如果不是程序员，电脑里一般不会有VB、VC之类的编程语言。

怎么办呢？

其实，大家的电脑中一般都有OFFICE。OFFICE中的EXCEL自带了一个VBA语言的编程环境。功能也很强大。

我用EXCEL里的VBA编写了一段代码，读取通达信股票行情软件的日线文件。已经测试通过。

代码如下。与爱好定量分析的朋友分享。

-The quantitative analysis of the first step is to obtain the data. Get the stock historical market data is the most convenient way to stay in daily data file on your computer is directly read the stock quotes software. If you are not a programmer, computer are generally not a programming language like VB, VC. How to do it? In fact, everyone' s computer generally have OFFICE. OFFICE in the EXCEL comes a VBA language programming environment. The function is also very powerful. I wrote a piece of code using VBA in EXCEL, read the daily paper Letter Mastery stock quotes software. Has been tested. The code is as follows. Share with friends hobby quantitative analysis.