ZADNAG STOCK INVESTORS

Mr.P.Vijay Anand1, C.Kasi Vishwanathan2, S.Sajan3, R.Surya4

1
Asssociate.Professor, 2, 3,4U.G.Student
Department of Information Technology
Vel Tech Multi Tech Dr.Rangarajan Dr.Sakunthala Engineering College
[email protected]

Abstract- Business intelligence is an important through analysis to meet the business objective
concept which combines architectures, tools, of the user, by enabling the user to interactively
databases, analytical tools, applications, and manipulate the data, and apply different analysis
methodologies. The efficiency of making in the way she/he needs for extracting
decisions can increase significantly using information, and get valuable insights from the
business intelligence solutions, by taking data.
advantage of the existing historical or real time
The stock market is a public market with strict
data of the business. Trading in stock markets is
regulation for the trading of companies’ stocks,
imminent with taking risks of losing money,
where each stock is a share of company
which requires extensive experience in the
permitted to be traded called listed company
market, to make efficient decisions. In this
ownership. Investors make money by buying
paper, we propose a framework that makes use
stocks at a lower price while selling them at a
of stock prices historical data, to help investors
higher price, stocks prices are determined by the
in making more efficient trading decisions.
success of the company, supply and demand,
Keywords— Business Intelligence, Business and external factors like government regulations.
Analytics, Data Analytics, Decision Support
Investors take risks in determining the best time
Systems, Stock Market.
for selling or buying stocks, that’s why they
need an efficient help to reduce the risks of this
1. INTRODUCTION decision. In this paper, a business intelligence
framework is proposed using the historical stock
Business Intelligence (BI) is defined as a market data, with the objective of analyzing
collective term that combines different stock market attributes for a collection of
technologies, applications, and tools used for the companies, and enhance the efficiency of
gathering of data from sources, storing, choosing the appropriate time for buying or
analyzing and visualizing it, with the purpose of selling specific company stocks, in order to
helping users to make better decisions. In the reduce the risk of losing money.
last few years, data has been increasing rapidly,
and with the ease of acquiring and storing this The proposed framework covers the conversion
data, organizations have started to leverage it for of the data to useful information satisfying the
enhancing the decision making the process. BI’s business objective. The framework contains the
objective is transforming data to information processes of acquiring the data from its source,
transformations applied on the data, storing the proposed to be used in the business intelligence
data into an appropriate data warehouse, the system. Second, Extract Transform and Load
analytics (ETL), the data extracted from the data sources
are integrated and transformed in the staging
area, to ensure the data quality. Third, Data
2. BUSINESS INTELLIGENCE storage tier, this tier composed of two
components, data warehouse and three types of
Martin et al proposed a business intelligence data mart (Operational data mart, Medical
framework consist of Quantitative bankruptcy claims data mart, and financial data mart).
prediction components, where financial features Fourth, Analytics tier, in this tier, the authors
found using Genetic Algorithm are applied to suggested applying diagnostic, descriptive and
predict the business performance quantitatively, predictive analytics on the data. Fifth,
Qualitative Bankruptcy prediction components, Optimization tier, the results obtained from the
in which the features are found using expert analytics tier is modified in this tier. Finally,
analysis and predict the business performance Presentation tier, in this tier the result of the
qualitatively using Ant Miner Algorithm and a system is presented visually to the user, which
Customized reporting where the right makes it easier to make decisions.
information is delivered to the right user in the
requested presentation using Fuzzy Multi- Olexova presented a case study by applying BI
Criteria Decision Support System (FMCDS). in the retail chain, the study was conducted in a
sports-fashion multi-brand chain of retail stores.
Jadi et al suggested a framework for collecting In this study, the BI life cycle was analyzed,
data, as the first step of implementing an e- besides evaluating the factors impacting the BI
government business intelligence system. For adoption. The main findings of this study are
the purpose of taking benefits of the immense considering the most important benefit of BI
data collected in enhancing decision making and adoption is improving decision-making in both
effectively enhance public services, the authors speed and quality, and according to the
took the morocco e-government system as a case managers, the customization of the BI system is
study for collecting the data. They suggested the more important factor for a successful BI
three sources of data: First, government-to- adoption.
government, where they suggest enabling the
interaction between government departments’
databases. Second, government-to-business, this
source of data depends on the organization's way 3. REQUIREMENTS
of storing data, instead of storing each The system requirements describe the
government organization separately, store them
capabilities and functions that will be
in one database. Third, government-to-citizen,
implemented to satisfy the user’s business
the authors proposed an approach for collecting objectives. Requirements are supposed to define
information related to citizen interaction with what the system is supposed to do and to be,
government organizations.
which distinguishes each system from its
Khedr et al proposed a framework of a business competitors, they range from high-level
intelligence system for healthcare analytics. The requirements defining the system performance to
framework contains six tiers: First, Data source the very basic functionalities that will be needed
tier, in this tier, twelve different sources are in the system. Defining high-quality
requirements is considered a critical phase in the between them . The system requirements defined
Business Intelligence earlier are interpreted into structures to meet the
business objectives. In our business intelligence
system developments, because of their framework, we provide four types of
importance in developing effective systems, and architectures:
detecting errors in early stages of the
development process. In the proposed A. Information Architecture
framework, the requirements are divided as
follows: Defines the processes needed to transform the
data obtained from the source, to readable
A. Business Requirements information in the BI system (Fig 1).

• Show each company’s stock price and quantity

trend over time.

• Compare companies’ trends.

• Predict the better investment in terms of

expected profit.

• Dashboard to perform visual analytics and

Fig. 1. Information Architecture.
prediction.
1- Data Creation: This process is done by the
B. Data Requirements
data source, where the data is created.
1- Data Source: The data can be collected from
2- Data Integration: This process is done after
Google Finance.
collecting the data from sources, where the data
2- Data Acquisition: Historical data of four is integrated, cleaned, and ensure the quality of
companies’ stock prices will be collected from the data.
the source and saved in a place for preparations.
3- Data Analytics: Analytics is applied to the
Company names: Apple, Nike, Disney,
Microsoft. data after storing it in the data warehouse. 4-
Business Intelligence Application: The results of
3- Data Transformation: the collected data the analytics will be represented to the
should be prepared for the analysis before decisionmakers.
storing it, the preparation consists of:
B. Data Architecture
4- Data Storage: Data must be stored to be
Define the processes of data integration,
ready for being viewed or used for reports and
analytics anywhere and at any time. transformation, storage and workflow needed to
meet the requirements of the information
architecture(see Fig 2).

4. ARCHITECTURE FRAMEWORK

The proposed business intelligence system is

represented through a set of architectures
identifying system components and the relations
 Fig. 3. Technical Architecture.

Therefore it will be extracted, transformed, and

then loaded in the data warehouse before OLAP
can be applied on the data, finally, the data will
Fig. 2. Data Architecture. be displayed to the user using the dashboard.
1- System of Record (SOR): 5. BUSINESS INTELLIGENCE
The authorized data source for a particular data APPLICATION
that can be found in multiple sources. In this The information extracted from the data must be
framework the data type that will be used is presented to the end-user in an understandable
historical data, the historical data contains the way, using an application of BI to display the
stock price at the opening of the market, the requested metrics, the application is
price at the closing of the market, the highest implemented to help monitoring the progress of
and the lowest prices of the stock at the day, and the business, and embower making efficient
the volume of the traded stocks. decisions to improve the business. In the
2- System of Integration (SOI): proposed framework, we suggest using a
dashboard, which is a data visualization tool that
The process of integrating the data. After the displays several metrics on the same page,
data gathering, techniques to ensure the quality allowing the user to compare the results of
of the data, like detect missing data, and different metrics. For the obtained data, the
duplication will be applied, then the relevant dashboard will contain companies’ different
features will be selected before storing the data attributes plots; a line plot to show the trend of
in the data warehouse. the company stocks, and boxplot to show the
quantiles and make it easier to spot outliers
3- System of Analytics (SOA): easily, in addition to the presentation of the
standard deviation, and mean for each year. The
The discovery of meaningful patterns in the
dashboard will also have the ability to compare
data, the requested analysis will be applied in
more than one company, and year together in the
this process.
same plot. A prototype of the proposed
C. Technical Architecture dashboard.

It illustrate the techniques that will be used in

implementing the business intelligence system.
Fig. 3. Technical Architecture. The required data
is available on the internet,
 useful for the both Intraday and Delivery
traders.

8. REFERENCES

Martin A., Lakshmi T., and Venkatesan V., “A

Business Intelligence Framework for Business
Performance using Data Mining Techniques”,
2019.

Gaonka A., Kulkarni R. et al, “Analysis of Stock

Fig. 4. Application Interface Market using Streaming Data Framework”,
International Conference on Advances in
Computing, Communications and Informatics,
6. CONCLUSION 2018
Business Intelligence plays an important role in Azeroual O, Theel H, “The Effects of Using
the success and survival of the business, Business Intelligence Systems on an Excellence
nowadays it became easier to apply the business Management and Decision-Making Process by
intelligence, because of the easiness of Start-Up Companies: A Case Study”, 2018.
collecting data using the internet. In this work,
we proposed a framework that makes use of the Chang V., Larson D., “A Review and Future
historical stock market of companies, to help the Direction of Agile, Business Intelligence,
investors in making future trading decisions. Analytics and Data Science”, International
Journal of Information Management, 2016,
The framework proposed the techniques and
pp.700-710.
tools to collect data, transform, store, analyze
and present them to the end-user, in our case the Gaonka A., Kulkarni R. et al, “Analysis of Stock
investor Market using Streaming Data Framework”,
International Conference on Advances in
Computing, Communications and Informatics,
8. FUTURE SCOPE 2018, pp.1388-1390.
Through this proposed system we would satisfy Alraddadi R., “Statistical Analysis of Stock
the long term traders but it doesn’t means that Prices in John Wiley & Sons”, Journal of
they are buying at the absolute low and selling at Emerging Trends in Computing and Info
the peak. On contrary they could buy or sell a Sciences, 2015, pp. 38-47.
share on the average high or low values.

In future we could use the synergy of indicators

to analyse the price action and to predict the
stock movement on the live market.

It also generates the targets and stop loss for the

respective scripts. Besides this approach will be