This site uses cookies for learning about our traffic, we store no personal details. ACCEPT COOKIES DECLINE COOKIES What are cookies?
univerge site banner
Original Article | Open Access | Can. J. Bus. Inf. Stud., 2024; 6(6), 251-260 | doi: 10.34104/cjbis.024.02510260

Evaluating Portfolio Performance Using Technical Indicators and Financial Ratio for Stocks in NSE by PyPortfolioOpt

Monjurul Hoque Bhuiyan* Mail Img Orcid Img ,
Afrina Khanam Moni Mail Img Orcid Img ,
Marium Benty Halim Mail Img Orcid Img ,
Hasan M Sami Mail Img Orcid Img

Abstract

Financial indicators play a crucial role in stock market investment. Generally, a financial ratio engulfs a stocks financial condition. "Technicals" are heuristics that play a crucial role in identifying a stock based on short-term price movement indications. As a statistically dependent stock market, the NSE remains a well-suited stock exchange for observing technical indicator movements. Our research considered 7 stocks highly dependent on market capitalization (among the top 50 stocks by market capitalization). Our selection criteria were supported by their strong emphasis on financial ratios through EPS, current ratio, and P/E ratio. Also, these stocks were tested within the parameters of successful technical price movements. Finally, we applied portfolio optimization to support investment guidelines proposed by technical measurements and financial ratios. We have proposed the successful creation of a portfolio for the next 8 days, expecting a price rise. We successfully affiliated a portfolio that amplified a Sharpe ratio generation of more than 1. Our overall portfolio return is more than 8.525% in 8 days, resulting in a yearly expected return greater than 4.633 times that of the original investment. Hence, this proves our claim that a mixture of financial ratios and technical indicators provides sufficient evidence for a quality portfolio return.

INTRODUCTION

Stock investment remains a strong alternative earning opportunity (HM Sami et al., 2022). Financial ratios play a critical role in making effective stock selections based on the performance parameters of these ratios (Sami HM, 2021). Technical indicators have also suggested effective methods to create an efficient portfolio with higher returns than general market return standards (HM Sami et al., 2023). Despite the worldwide depth of stock markets, Indian markets remain unhinged by heavy financial changes (Kumar et al., 2023). Moreover, the US treasury surge led to a loss in the Indian market in the year opening (Agarwal, R., 2023). However, the threat of a US market shutdown led to a win in Indian stock market growth for the year 2023 (Agarwal, R., 2023). 

Similarly, Indias October to December FMCG growth led to vibrant support for the Indian stock market (Chakraborty, O. 2023). In comparison to overall world inflation, it was observed that the Indian stock market remained less volatile, with more opportunity for sustainable growth (Goyal, A., 2020). With a reassuring outcome from an Indian economic perspective concerning her neighboring counterparts, we observe that the Indian stock market remains remarkably stable based on the standard deviation of price movements and sustainable growth. Consequently, the NSE stocks portray the lower risk involved with attaining effective gain (Venkatesh et al., 2021). We have only considered large-cap stocks for our research, which will highly correlate with market movement. We have also considered the financial ratios of these stocks. 

Our research would only consider stocks from an excellent financial standpoint for investment purposes (Wibagdo et al., 2020). This experiment considers technical indicators important after primary selection by financial ratios. Our research aims to emphasize the importance of EPS, current ratio, and P/E ratio as the basis for selection. We also emphasize the importance of MACD in determining the buy or sell signal of stocks. The research data corpus would test stock price rises for the next 10 days. We researched to determine a portfolio performance that will provide a Sharpe ratio return greater than 1 based on stock selections using both financial ratios and technical indicators.

Research Motivation

The experimentation is motivated to deliver the following aspects in general:

a) The selected assets are evaluated based on standard financial ratios and conventional aspects of technical indicators. If the assets are justified using technical indicators with standard features, then the general public can consider investing and retaining secondary earnings based on standard investment parameters.

b) Moreover, open-source knowledge could be helpful for investment in the stock market and provide additional earnings for stock market investors.

c) A market return that generates a higher return than risk-free returns will allow stock investments to be a better investment alternative. Hence, reliability on standard technical indicators and a suitable financial ratio would contribute to a better investment alternative.

Research Objective

The research aims to create portfolio-based returns using stocks based on their technical indication results and financial ratios. Based on our main objective, we will emphasize the following issues:

a) Proving the effectiveness of technical indicators for stock selection as well.

b) Proving the effectiveness of financial ratios for selection

c) Applying the selected stocks for investment purposes to generate a positive portfolio return.

d) The portfolio return needs to generate a return that will be a better alternative to a risk-free return.

REVIEW OF LITERATURE

The financial ratio remains an essential criterion for stock selection. Adam has proven that for investment purposes, EPS, current ratio, and P/E remain important investment alternatives (MHM Adam, 2014). Although Sami has proven that by using EPS and current ratios, we can make successful stock selections, there has yet to be any proof regarding investment success in the study (Sami HM, 2021). Moreover, in our research on the Dhaka stock exchange, a very volatile stock market with comparatively fewer stocks, we have observed success in stock selection using financial ratio analysis (Sami HM et al., 2021). Sami et al. have only mentioned that their predictions were effective because of effective financial ratio-based selections, but their research did not perform any selection based on technical indicators (Sami HM et al., 2021). To predict the effectivity of financial markets, Sami et al. also performed one more study on 07 different stock exchanges, utilizing technical indicators on MACD and RSI (Sami et al., 2022). The stocks are selected as vital market indicator parameters based on their market capitalization, price movements, and technical parameters. In this research, we specifically emphasize the portfolio performance of selected stocks from both a financial ratio standpoint and a technical indicator of success. We also needed to perform research on a statistically independent stock index, which has been successful in the Indian stock index (Khan et al., 2011). Our experimentation further proceeded to prove if the selected stocks had been able to indicate better market performance based on portfolio-based returns. Hasan & Arifuzzaman have proved that by using LSTM, we can effectively predict stock prices while using the portfolio optimizer of PyPortfolioOpt as a vital optimization tool for reducing risk and gaining an effective return (Hasan & Arifuzzaman, 2021). In this research, we did not perform prediction, but we performed stock selection based on both financial ratios and technical parameters like MACD4 and RSI5. EPS1 remained a critical criterion for the selection of stocks. The current ratio2 also performs the vital task of selecting stocks based on the leveraging ratio. Finally, the P/E ratio is essential in selecting stocks for investment purposes.

Moreover, NSE remained a statistically significant stock exchange due to the large number of stocks and the stable financial condition in India (Dhali & Singh, 2020). This study did not look at unsupervised learning-based selection by technical indicators or financial ratios, but it did come up with suggestions for choosing stocks based on majority success (Jais et al., 2012). The research accompanies the following GAP analysis to motivate and define the research.

Table 1: Relevant Research & Gap Analysis.

Based on the previous research, we concluded that, despite all of this research, no one has tried to make suggestions about choosing stocks based on both MACD and RSI signals for price increases that have good financial ratios and good portfolio performance. It finally depicts that our research should suggest success for stocks with an effective price rise that can offset the growth of risk-free gain.

METHODOLOGY

The following steps accompany the research:

1) Selection of Stocks from NSE: Our research would involve selecting stocks that are representative of NSE 100 and would remain a firm representative of large-cap stocks.

2) In order to select these stocks, we would also indulge in stocks with lower prices. In this research, we utilized portfolio optimization, proposing a suggestive stock portfolio to ensure a higher return with a smaller investment margin. We considered stocks with prices ranging from rupee 500 to rupee 1500.

3) From the NSE100, our selected stocks had an acceptable financial ratio. After good financial ratio indication, we performed MACD, RSI, and Bollinger Band-based analysis to successfully predict stocks that were supposed to perform well during our testing period.

4) Based on empirical selection, we have considered stocks with a technical indication of a price rise. These stocks are used for portfolio-based prediction to effectively identify a mix that will outperform the risk-free return of the market.

Fig. 1: Research Diagram.

In the research process, we have concluded the selection of assets based on the following criteria: Li et al. have designated that an EPS value greater than 1 is a good indicator for stock selection (Li et al., 2021). Similarly, Rahmadi has exhibited a current ratio value greater than 1 but less than 2 to be perfect for investment (Rahmadi, Z.T., 2020). Moreover, industry relevance to the P/E ratio plays a pivotal role in selecting assets for investments (Guerard et al., 2015). The following diagram describes the benchmark for financial ratio selection.
Fig. 2: Current Ratio, EPS & P/E Ratio.
 
Technical indicators play an efficient role in financial investment through price movement indications (Wang & Kim, 2018). Wang & Kim also showed that the MACD line is greater than the signal line, indicating a potential for future price gain with higher earning potential. Gumparthi has shown that the indicative rise from 60 to 70 and the drop from 40 to 30 indicate overbuy and oversold signals (Gumparthi, S. 2017). Laugico et al. have shown how the Bollinger Band influences the selection of stocks for trading.

Fig. 3: Technical Indicators and Parameters.

Portfolio Optimization depends on minimizing the risk of investment by increasing assets for investment (Sami et al., 2023). Moreover, it increases the investment outcome by selecting assets with a lower standard deviation. In this research, we focus on applying the theoretical concept of efficient frontier for reducing investment risk by involving assets with reasonable indications for investment by both technical indicators and financial ratios.

RESULTS

We have selected 7 stocks from the NSE 100 index. These stocks are strong market indicators and are well-responsive to market movements. Our research accompanies portfolio performance in coherence with well-performing market-suiting stocks. Our research criterion accompanies stocks with 3 financial ratio parameters where the current ratio is greater than 2, EPS is positive, and the P/E ratio is less than the industry P/E. Similarly, this research accompanies a minimum of 2 technical analyses suitable for the rise in stock prices, considering it positive. However, in our cases, we considered all of them. Henceforth, there is growth accompanying all of the stocks shown in the table below on our tested ten days, starting from 1/31/2022 to 2/10/2022.

Table 2: Justifications.

Moreover, we accompany the stocks that have greater than 2 current ratios but we considered them as they potentially have more assets than liabilities. Our research emphasized the performance of portfolios that provide significant performance through effective market returns higher than the savings account return rate. Gautam and Kalyan have suggested that the long-term bond yield rate remains the riskless earning for Indian investors (Gautam & Kalyan, 2018). Similarly, Pandow and Butt have suggested that a risk-free return plays a crucial role in making investment decisions (Pandow & Butt, 2017). Our research would focus on making returns more significant than 7.135% for 1 year. Hasan & Arifuzzaman have shown that in an efficient portfolio7, a Sharpe ratio6 value greater than 1 ensures more return than risk (Hasan & Arifuzzaman, 2021). Finally, we will assign a portfolio that would generate a more significant than 7.135% return for 1 year using the selected assets. The following diagram describes it below:

Fig. 4: Process diagram.

In this research, we have accumulated stocks that have all acceptable financial ratios. These ratios play a key role in the acceptance of assets for investment.  The following table provides the financial ratio of selected stocks:

Table 3: Financial ratios. 

After considering these assets through the basis for financial ratios we performed a technical analysis of these assets. Our performance analysis suggested that the same 7 stocks are showing positive price growth suggestion in at least two among three parameters. Hence, we considered these stocks for portfolio optimization.

Table 4: Financial Indicators.

To make the portfolio optimization risk-adjusted, we will allocate this to the minimum variance of the risky portfolio. The following results are demonstrated:

Fig. 5: Calculation of portfolio variance, volatility, and annual return.

Research Outcome
Our experimentation thus focuses on outperforming the standard market returns by conventional financial theory and MACD and RSI suggestions for stock price rise observation. Finally, technical analysis also helps us understand stock movements better. We found an approximate gain of Rs.2983.20 with a portfolio variance of 0.001128, portfolio volatility (standard deviation) is 0.03359, and annual portfolio return of 0.0740 or 7.4% (approximately).
Fig. 6: Portfolio Optimization Outcome.
Fig. 7: Discrete Allocation.
Fig. 8: Sharpe Ratio Generation.

It is shown in the picture that, the expected annual return is 4633.5%, the annual volatility is 11.6% and the sharp ratio is 398.94 approximately.

Drawbacks
1) Navigating many financial variables and risk factors to define an optimally risky portfolio is complex. One must understand market dynamics, investor preferences, and the ever-changing economy to balance potential returns and tolerable risk. A clear definition is needed to emphasize the complexity of building a portfolio that optimizes returns while meeting an investors risk tolerance and financial goals. Thus, an optimal risk portfolio is unclear.
2) The portfolio perspective of the investment strategy needs more explanation. Withers may need to explain this perspective to choose and manage portfolio assets. Investors need a clear portfolio perspective to make informed decisions and improve investment transparency and accessibility. Thus, the portfolio perspective is not extensively discussed.
3) Stock price forecasting is essential for strategic planning, so excluding it from investment creates a gap. Forecasting helps investors capitalize on opportunities and reduce risk by adapting their portfolios to market changes. Resilient stock price prediction can help investment strategies identify patterns, reduce risks, and capitalize on opportunities, improving portfolio management with knowledge and proactive decision-making. Future stock price forecasts are discontinued.

CONCLUSION

In conclusion, technical analysis and financial ratios remain powerful indicators for stock selection and investment. In an optimized portfolio, we see the inclusion of 4 stocks with a Sharpe ratio value greater than 1. We also conclude that the overall return in 8 days in a minimum-variance portfolio is Rs. 2983.305, which indicates that in an 8-day empirical study based on standard financial and technical parameters, we can make a return of nearly 8.5% with an annual return capability of 4.63 times the original investment. Hence, financial ratios and technical analysis help generate good portfolio performance. 

AUTHOR CONTRIBUTIONS

H.M.S.: Conceptualization, visualization, and contribution in investigation. M.H.B.: writing and checking the manuscript, investigation, editing, and funding acquisition. A.K.M.: writing the manuscript, investigation, and funding acquisition. M.B.H.: writing the manuscript, investigation, and funding acquisition. All the authors who are involved in this research read and approved the manuscript for publication.

ACKNOWLEDGEMENT

The authors would like to thank the Correspondence, Hasan M Sami, Senior Lecturer, School of Business and Economics, North South University, for his support in this research.

CONFLICTS OF INTEREST

There is no conflict of research for this study.

Supplemental Materials:

| 4.00 KB

Article References:

  1. Adam, M. H. M. (2014). Evaluating the Financial Performance of Banks using financial ratios-A case study of Erbil Bank for Investment and Finance. European Journal of Accounting Auditing and Finance Research, 2(6), 162-177.
  2. Agarwal, R. (2023). The Past & Future of Indian Finance. M-RCBG Associate Working Paper Series.
  3. Chakraborty, O. (2023). Inflation and COVID-19 Supply Chain Disruption. In Managing Inflation and Supply Chain Disruptions in the Global Economy (pp. 10-23). IGI Global.
  4. Dhall, R., & Singh, B. (2020). The COVID-19 pandemic and herding behaviour: Evidence from Indias stock market. Millennial Asia, 11(3), 366-390.
  5. Gautami, S., & Kalyan, N. B. (2018). A comparative study on risk & return analysis of selected stocks in India. Inter J. of Management and Economics Invention, 4(5), 1730-1736.
  6. Goyal, A. (2020). Post COVID-19: recovering and sustaining Indias growth. Indian Economic Review, 55, 161-181.
  7. Guerard Jr, J. B., Markowitz, H., & Xu, G. (2015). Earnings forecasting in a global stock selection model and efficient portfolio construction and management. Inter J. of Forecasting, 31(2), 550-560.
  8. Gumparthi, S. (2017). Relative strength index for developing effective trading strategies in constructing optimal portfolio. Inter J. of Applied Engineering Research, 12(19), 8926-8936.
  9. Jais, M., Jakpar, S., Doris, T. K. P., & Shaikh, J. M. (2012). The financial ratio usage towards predicting stock returns in Malaysia. Inter J. of Managerial and Financial Accounting, 4(4), 377-401.
  10. Khan, A. Q., Ikram, S., & Mehtab, M. (2011). Testing weak form market efficiency of Indian capital market: A case of national stock exchange (NSE) and Bombay stock exchange (BSE). African J. of Marketing Management, 3(6), 115-127.
  11. Kumar, D., Sharma, I., & Yadav, S. (2023). A Study on relationships between stock market and foreign investment in India. Boletin de Literatura Oral-The Literary Journal, 10(1), 1594-1599.
  12. Lauguico, S., Concepcion II, R., & Dadios, E. (2019). A fuzzy logic-based stock market trading algorithm using bollinger bands. In 2019 IEEE 11th International Conference on Humanoid, Nanotechnology, Information Technology, Communication and Control, Environment, and Management (HNICEM) (pp. 1-6). IEEE.
  13. Li, Z., Deng, G., & Che, H. (2021). Patent-based predictive EPS on increasing investment performance of China Stock Market. In 2021 IEEE International Conference on Power Electronics, Computer Applications (ICPECA) (pp. 562-566). IEEE.
  14. M. Wu and X. Diao, (2015). "Technical analysis of three stock oscillators testing MACD, RSI, and KDJ rules in SH & SZ stock markets," 2015 4th International Conference on Computer Science and Network Technology (ICCSNT), Harbin, China, pp. 320-323. https://doi.org/10.1109/ICCSNT.2015.7490760  
  15. Pandow, B., & Butt, K. (2017). Risk and return analysis of mutual fund industry in India. Pandow, BA, & Butt, KA (2017). Risk and Return Analysis of Mutual Fund Industry in India. J. of Banking and Financial Dynamics, 1(1), 54-65.
  16. Rahmadi, Z. T. (2020). The Influence of Return on Investment, Current Ratio, Debt to Equity Ratio, Earning Per Share, and Firm Size to the Dividend Pay Out Ratio in Banking Industries Listed at Indonesia Stock Exchange Period 2013-2018. Dinasti Inter J. of Digital Business Management, 1(2), 260-276.
  17. Sami, H. M. (2021). Portfolio construction using financial ratio indicators and classification through machine learning. Int. J. Manag. Account, 3(4), 83-90.
  18. Sami, H. M., & Arifuzzaman, S. M. (2021). Comparing pure stock portfolio with stock and crypto-currency mixed portfolio through LSTM to compare & analyze investment opportunities for portfolio performance measurement. Aust. J. Eng. Innov. Technol, 3(3), 45-56.
  19. Sami, H. M., Ahshan, K. A., & Rozario, P. N. (2023). Determining the Best Activation Functions for Predicting Stock Prices in Different (Stock Exchanges) Through Multivariable Time Series Forecasting of LSTM. Aust. J. of Engineering and Innovative Technology, 7804, 63-71.
  20. Sami, H. M., Ahshan, K. A., & Ashrafi, N. (2022). Evaluating the Prediction Accuracy of MACD and RSI for Different Stocks in Terms of Standard Market Suggestions. Canadian Journal of Business and Information Studies, 7820, 137-143.
  21. Sami, H. M., Fardous, L., & Ruhit, D. S. (2021). Portfolio optimization in DSE using financial indicators, LSTM & PyportfolioOpt. Int. J. Mat. Math. Sci, 3(4), 74-84.
  22. Venkatesh, P., SUDHEER, K., & Paramasivan, S. (2021). A study on technical analysis using candlestick pattern of selected large cap stocks listed in National Stock Exchange (NSE), India with reference to steel sector. GSI Journals Serie B: Advancements in Business and Economics, 3(2), 62-71.
  23. Wang, J., & Kim, J. (2018). Predicting stock price trend using MACD optimized by historical volatility. Mathematical Problems in Engineering, 2018, 1-12.
  24. Widagdo, B., Jihadi, M., & Singh, S. K. (2020). Financial Ratio, Macro Economy, and Investment Risk on Sharia Stock Return. The J. of Asian Finance, Economics and Business, 7(12), 919-926.

Article Info:

Academic Editor

Dr. Doaa Wafik Nada, Associate Professor, School of Business and Economics, Badr University in Cairo (BUC), Cairo, Egypt.

Received

November 12, 2024

Accepted

December 14, 2024

Published

December 21, 2024

Article DOI: 10.34104/cjbis.024.02510260

Corresponding author

Monjurul Hoque Bhuiyan*

School of Business and Economics, Dept. of Finance, North South University, Dhaka, Bangladesh.

Cite this article

Bhuiyan MH, Moni AK, Halim MB, and Sami HM. (2024). Evaluating Portfolio performance using technical indicators and financial ratio for stocks in NSE by PyPortfolioOpt, Can. J. Bus. Inf. Stud., 6(6), 251-260. https://doi.org/10.34104/cjbis.024.02510260

Views
665
Download
35
Citations
Badge Img
Share