The Purpose of this work is to use of Excel and VBA (Visual Basic for Applications) facilities to determine the correctness of economic and financial decision making on prices. In this work we will highlight the strengths of price movements, their simulation and their prediction. On the basis of the analysis, we can conclude the advantages of the decisions made with the application of the MS Excel and VBA financial functions regarding prices. This work promotes how to properly track prices. For this we do not have various applications because the price influences various factors. Often work with approximations or simulations to keep up with the risks that might be. The results of the work may be useful for developing a business plan, planning financial developments, pricing planning for an investment and in all economic and financial activities. Stock prices change every day by market forces. By this we mean that share prices change because of supply and demand. If more people want to buy a stock (demand) than sell it (supply), then the price moves up. Conversely, if more people wanted to sell a stock than buy it, there would be greater supply than demand, and the price would fall. I will share some of the crucial learning’s.