MODELING STOCK TRANSACTIONS IN EXCEL USING NUMERICAL METHODS

Abstract

This paper presents a modeling of stock exchange transactions using the abovementioned methods in the Microsoft Excel environment. The main focus is on developing algorithms and tools for analyzing stock price dynamics, forecasting market trends, assessing volatility, and optimizing portfolios. The model uses a number of methods, such as interpolation, regression analysis, and solving optimization problems, to ensure the accuracy and flexibility of data analysis. Excel provides a convenient platform for data manipulation with accessibility, analytical capabilities, and visualization capabilities. The practical innovation of the study is to create a tool that analysts, investors, and researchers can use to make informed decisions in the stock market. The results of the work show that the combination of mathematical methods and available tools significantly simplifies the modeling of exchange transactions and increases its efficiency. The purpose of the study: to create a model for analyzing and forecasting exchange transactions in Excel using quantitative methods to improve the efficiency of decisions. Ideas and key areas: to study market volatility and create models in Excel using built-in functions and macros. Scientific significance: deepens the understanding of the principles of exchange activity and the practical application of a number of modeling methods. Practical significance: creating methods for combining and solving complex mathematical calculations using the Excel tool, simplifying the analysis process in practice. Conclusions of the research work: to show that the use of numerical methods simplifies the modeling of exchange transactions in Excel and increases its efficiency. The essence of the study: aimed at solving problems that combine ease of use and mathematical accuracy for solving problems in the field of binary analysis.