Constructions Of A Logical Statement Language With Compiler For Finance-oriented Business

As the global financial information continues to accelerate, finance has become the core and lifeline of modern economy. Financial globalization has become the major symbol of economic globalization. As the foundation of the modern financial services industry and the source of financial innovation, financial information service is accompanied by the wide use of computer technology in the financial system. Now the information and data are crucial for a company engaged in financial information services, but there are many kinds of financial data (as stock, bonds and index etc), large amounts of data, and high accuracy requirements. By the means of certain technical, obtained data in all areas can be calculated in first time, feedback to customers with low delay. It is the primary task of financial information service agency. However, it is the data analyst’s expertise that dealing with the wide range of financial data reasonably and effectively according to user’s requirements. The data analysts also analyze data by excel, so it is a certain significance that the excel file with the data and calculation logic is compiled into dynamic-link library.Based on the data analyst’s needs, this article aims to deal with the business logic of financial data in Excel in real-time through compiling Excel to achieve real-time calculations on financial data. My main work consists of three parts:First of all, it is construction of computing logic description language, including designing the meta model, symbol tables, and so on; Second, turn Excel into custom description language; Then, go to the compilation’s processes, lexical analysis, syntax analysis, semantic analysis, intermediate code generation, intermediate code optimization, object code generation. During compilation, select appropriate tools and frameworks for the development work of the project, including ANTLR for generating lexical analyzer and parser, and intermediate code uses IR language of LLVM, and so on.The project is written in C++and a small amount of Java, which data analysts who don’t know programming can only edit the business logic of excel as same as programming. It is able to deal with streaming financial data in real time, and better and easier to provide financial institutions with the financial information services.