INDCOMP: A Shiny App for Open Data Repository of the Performance of an Indonesian Company Listed at the Indonesia Stock Exchange
Received: 13 June 2024 | Revised: 3 July 2024 | Accepted: 5 July 2024 | Online: 9 July 2024
Corresponding author: Prana Ugiana Gio
Abstract
Investors, practitioners, and stock researchers highly need data related to financial performance to predict a company's financial health condition, which is used as a basis to consider investing in it. The Indonesia Stock Exchange (IDX) website provides reports on the company's financial performance. Unfortunately, the company’s financial data found on the IDX website are in PDF format, and researchers must download them one by one, which takes a long time. This study presents a website-based application, named Indonesia Company Performance (INDCOMP), built using the R programming language and involving various R packages and frameworks to assist investors, practitioners, and stock researchers in studying the financial performance of companies. This application can help users quickly access the financial performance data of various companies, present financial performance data in data tables, and perform data visualizations as well as statistical analyses.
Keywords:
Financial, R Shiny, INDCOMP, Computational, StatisticsDownloads
References
"Indonesia Central Securities Depository (KSEI)." https://www.ksei.co.id/?setLocale=en-US.
"Statistik Pasar Modal Semester II-2022," Financial Services Authority (OJK), Jakarta, Indonesia, 2022. [Online]. Available: https://www.ojk.go.id/id/kanal/pasar-modal/data-dan-statistik/statistik-pasar-modal/Documents/Statistik%20Pasar%20Modal%20Semester%20II-2022.pdf.
N. Yalcin, A. Bayrakdaroglu, and C. Kahraman, "Application of fuzzy multi-criteria decision making methods for financial performance evaluation of Turkish manufacturing industries," Expert Systems with Applications, vol. 39, no. 1, pp. 350–364, Jan. 2012. DOI: https://doi.org/10.1016/j.eswa.2011.07.024
K. Kara, G. C. Yalçın, A. Çetinkaya, V. Simic, and D. Pamucar, "A single-valued neutrosophic CIMAS-CRITIC-RBNAR decision support model for the financial performance analysis: A study of technology companies," Socio-Economic Planning Sciences, vol. 92, Apr. 2024, Art. no. 101851. DOI: https://doi.org/10.1016/j.seps.2024.101851
"Indonesia Stock Exchange (IDX)." https://www.idx.co.id/.
M. Jimichi and S. Maeda, "Visualization and Statistical Modeling of Financial Data with R," presented at the R User Conference, 2014.
M. Jimichi, "Building of Financial Database Servers," Technical Report, 2010.
M. Jimichi, D. Miyamoto, C. Saka, and S. Nagata, "Visualization and statistical modeling of financial big data: double-log modeling with skew-symmetric error distributions," Japanese Journal of Statistics and Data Science, vol. 1, no. 2, pp. 347–371, Dec. 2018. DOI: https://doi.org/10.1007/s42081-018-0019-1
M. Jimichi, Y. Kawasaki, D. Miyamoto, C. Saka, and S. Nagata, "Statistical Modeling of Financial Data with Skew-Symmetric Error Distributions," Symmetry, vol. 15, no. 9, Sep. 2023, Art. no. 1772. DOI: https://doi.org/10.3390/sym15091772
W. Chang et al., "shiny: Web Application Framework for R." [Online]. Available: https://cran.r-project.org/web/packages/shiny/index.html.
P. Martinková and A. Drabinová, "ShinyItemAnalysis for Teaching Psychometrics and to Enforce Routine Analysis of Educational Tests," The R Journal, vol. 10, no. 2, 2019, Art. no. 503. DOI: https://doi.org/10.32614/RJ-2018-074
L. Savini, L. Candeloro, S. Perticara, and A. Conte, "EpiExploreR: A Shiny Web Application for the Analysis of Animal Disease Data," Microorganisms, vol. 7, no. 12, Dec. 2019, Art. no. 680. DOI: https://doi.org/10.3390/microorganisms7120680
B. Sivaprakasam and P. Sadagopan, "Development of an Interactive Web Application ‘Shiny App for Frequency Analysis on Homo sapiens Genome (SAFA-HsG),’" Interdisciplinary Sciences: Computational Life Sciences, vol. 11, no. 4, pp. 723–729, Dec. 2019. DOI: https://doi.org/10.1007/s12539-019-00340-z
L. de F. Ramalho and W. R. de C. Segundo, "R-Shiny as an Interface for Data Visualization and Data Analysis on the Brazilian Digital Library of Theses and Dissertations (BDTD)," Publications, vol. 8, no. 2, Jun. 2020, Art. no. 24. DOI: https://doi.org/10.3390/publications8020024
H. A. Ekiz, C. J. Conley, W. Z. Stephens, and R. M. O’Connell, "CIPR: a web-based R/shiny app and R package to annotate cell clusters in single cell RNA sequencing experiments," BMC Bioinformatics, vol. 21, no. 1, May 2020, Art. no. 191. DOI: https://doi.org/10.1186/s12859-020-3538-2
Y. Zhou, S. Leung, S. Mizutani, T. Takagi, and Y. S. Tian, "MEPHAS: an interactive graphical user interface for medical and pharmaceutical statistical analysis with R and Shiny," BMC Bioinformatics, vol. 21, no. 1, May 2020, Art. no. 183. DOI: https://doi.org/10.1186/s12859-020-3494-x
T. N. Moore, R. Q. Thomas, W. M. Woelmer, and C. C. Carey, "Integrating Ecological Forecasting into Undergraduate Ecology Curricula with an R Shiny Application-Based Teaching Module," Forecasting, vol. 4, no. 3, pp. 604–633, Sep. 2022. DOI: https://doi.org/10.3390/forecast4030033
S. Iddi and M. C Donohue, "Power and Sample Size for Longitudinal Models in R - The longpower Package and Shiny App," The R Journal, vol. 14, no. 1, pp. 264–282, Jul. 2022. DOI: https://doi.org/10.32614/RJ-2022-022
H. Wang et al., "VisProDom: an interactive Shiny/R application for displaying protein domains with transcriptional features," BMC Genomics, vol. 23, no. 1, Jun. 2022, Art. no. 472. DOI: https://doi.org/10.1186/s12864-022-08713-3
"R: The R Project for Statistical Computing." https://www.r-project.org/.
"RStudio IDE." [Online]. Available: https://www.posit.co/.
V. Nijs, F. Fang, Trestle Technology, Llc, and J. Allen, "shinyAce: Ace Editor Bindings for Shiny." [Online]. Available: https://cran.R-project.org/package=shinyAce.
J. B. Arnoid, "ggthemes: Extra Themes, Scales and Geoms for ggplot2." [Online]. Available: https://cran.r-project.org/web/packages/ggthemes/.
H. Wickham, "plyr: Tools for Splitting, Applying and Combining Data." [Online]. Available: https://cran.r-project.org/web/packages/plyr/.
Y. Xie et al., "DT: A Wrapper of the JavaScript Library ‘DataTables.’" [Online]. Available: https://cran.r-project.org/web/packages/DT/.
J. Owen et al., "rhandsontable: Interface to the ‘Handsontable.js’ Library." [Online]. Available: https://cran.r-project.org/web/packages/rhandsontable/.
H. Wickham et al., "ggplot2: Create Elegant Data Visualisations Using the Grammar of Graphics." [Online]. Available: https://cran.r-project.org/web/packages/ggplot2/.
C. Sievert et al., "plotly: Create Interactive Web Graphics via 'plotly.js.'" [Online]. Available: https://cran.r-project.org/web/packages/plotly/.
S. Su et al., "GLDEX: Fitting Single and Mixture of Generalised Lambda Distributions." [Online]. Available: https://cran.r-project.org/web/packages/GLDEX/.
P. Schauberger, A. Walker, L. Braglia, J. Sturm, J. M. Garbuszus, and J. M. Barbone, "openxlsx: Read, Write and Edit xlsx Files." [Online]. Available: https://cran.r-project.org/web/packages/openxlsx/.
B. Fournier, N. Rupin, M. Bigerelle, D. Najjar, A. Iost, and R. Wilcox, "Estimating the parameters of a generalized lambda distribution," Computational Statistics & Data Analysis, vol. 51, no. 6, pp. 2813–2835, Mar. 2007. DOI: https://doi.org/10.1016/j.csda.2006.09.043
S. Su, "A Discretized Approach to Flexibly Fit Generalized Lambda Distributions to Data," Journal of Modern Applied Statistical Methods, vol. 4, no. 2, Nov. 2005. DOI: https://doi.org/10.22237/jmasm/1130803560
Z. A. Karian and E. J. Dudewicz, Handbook of Fitting Statistical Distributions With R, 1st edition. Boca Raton, FL, USA: Chapman & Hall, 2010. DOI: https://doi.org/10.1201/b10159-3
A. H. Syafrina, A. Norzaida, and O. N. Shazwani, "Stochastic Modeling of Rainfall Series in Kelantan Using an Advanced Weather Generator," Engineering, Technology & Applied Science Research, vol. 8, no. 1, pp. 2537–2541, Feb. 2018. DOI: https://doi.org/10.48084/etasr.1709
P. Balamurugan, T. Yuvaraj, and P. Muthukannan, "Optimal Allocation of DSTATCOM in Distribution Network Using Whale Optimization Algorithm," Engineering, Technology & Applied Science Research, vol. 8, no. 5, pp. 3445–3449, Oct. 2018. DOI: https://doi.org/10.48084/etasr.2302
R. E. Caraka, M. Noh, R. C. Chen, Y. Lee, P. U. Gio, and B. Pardamean, "Connecting Climate and Communicable Disease to Penta Helix Using Hierarchical Likelihood Structural Equation Modelling," Symmetry, vol. 13, no. 4, Apr. 2021, Art. no. 657. DOI: https://doi.org/10.3390/sym13040657
R. E. Caraka et al., "Cluster Around Latent Variable for Vulnerability Towards Natural Hazards, Non-Natural Hazards, Social Hazards in West Papua," IEEE Access, vol. 9, pp. 1972–1986, 2021. DOI: https://doi.org/10.1109/ACCESS.2020.3038883
R. E. Caraka et al., "Micro, Small, and Medium Enterprises’ Business Vulnerability Cluster in Indonesia: An Analysis Using Optimized Fuzzy Geodemographic Clustering," Sustainability, vol. 13, no. 14, Jan. 2021, Art. no. 7807. DOI: https://doi.org/10.3390/su13147807
R. E. Caraka, R. C. Chen, S. W. Huang, S. Y. Chiou, P. U. Gio, and B. Pardamean, "Big data ordination towards intensive care event count cases using fast computing GLLVMS," BMC Medical Research Methodology, vol. 22, no. 1, Mar. 2022, Art. no. 77. DOI: https://doi.org/10.1186/s12874-022-01538-4
R. E. Caraka et al., "Connectivity, sport events, and tourism development of Mandalika’s special economic zone: A perspective from big data cognitive analytics," Cogent Business & Management, vol. 10, no. 1, Dec. 2023, Art. no. 2183565. DOI: https://doi.org/10.1080/23311975.2023.2183565
R. E. Caraka et al., "Albatross analytics a hands-on into practice: statistical and data science application," Journal of Big Data, vol. 9, no. 1, May 2022, Art. no. 70. DOI: https://doi.org/10.1186/s40537-022-00626-y
F. H. Putra and R. Kurniawan, "Clustering for Disaster Areas Endemic Dengue Hemorrhagic Fever Based on Factors Had Caused in East Java Using Fuzzy Geographically Weighted Clustering - Particle Swarm Optimization," Jurnal Aplikasi Statistika & Komputasi Statistik, vol. 8, no. 1, pp. 27–27, Jun. 2016.
B. I. Nasution, R. Kurniawan, T. H. Siagian, and A. Fudholi, "Revisiting social vulnerability analysis in Indonesia: An optimized spatial fuzzy clustering approach," International Journal of Disaster Risk Reduction, vol. 51, Dec. 2020, Art. no. 101801. DOI: https://doi.org/10.1016/j.ijdrr.2020.101801
P. A. Kaban, R. Kurniawan, R. E. Caraka, B. Pardamean, B. Yuniarto, and Sukim, "Biclustering Method to Capture the Spatial Pattern and to Identify the Causes of Social Vulnerability in Indonesia: A New Recommendation for Disaster Mitigation Policy," Procedia Computer Science, vol. 157, pp. 31–37, Jan. 2019. DOI: https://doi.org/10.1016/j.procs.2019.08.138
N. Masseran, "Markov Chain model for the stochastic behaviors of wind-direction data," Energy Conversion and Management, vol. 92, pp. 266–274, Mar. 2015. DOI: https://doi.org/10.1016/j.enconman.2014.12.045
N. Masseran and M. A. M. Safari, "Modeling the transition behaviors of PM10 pollution index," Environmental Monitoring and Assessment, vol. 192, no. 7, Jul. 2020, Art. no. 441. DOI: https://doi.org/10.1007/s10661-020-08376-1
M. M. Hamasha, "A Mathematical Approximation of the Left-sided Truncated Normal Distribution Using the Cadwell Approximation Model," Engineering, Technology & Applied Science Research, vol. 7, no. 1, pp. 1382–1386, Feb. 2017. DOI: https://doi.org/10.48084/etasr.988
Y. Chalabi, D. J. Scott, and D. Wuertz, "Flexible distribution modeling with the generalized lambda distribution," MPRA Paper, Nov. 2012. [Online]. Available: https://mpra.ub.uni-muenchen.de/43333/.
Y. Chalabi, D. J. Scott, and D. Wurtz, "The Generalized Lambda Distribution as an Alternative to Model Financial Returns," ETH Econohysics Working and White Papers Series.
D. S. Dedduwakumara, L. A. Prendergast, and R. G. Staudte, "A simple and efficient method for finding the closest generalized lambda distribution to a specific model," Cogent Mathematics & Statistics, vol. 6, no. 1, Jan. 2019, Art. no. 1602929. DOI: https://doi.org/10.1080/25742558.2019.1602929
J. S. Ramberg and B. W. Schmeiser, "An approximate method for generating asymmetric random variables," Communications of the ACM, vol. 17, no. 2, pp. 78–82, Oct. 1974. DOI: https://doi.org/10.1145/360827.360840
A. Tarsitano, "Fitting The Generalized Lambda Distribution to Income Data," in COMPSTAT 2004 Symposium, 2004, pp. 1861–1867.
P. Owusu Junior and C. H. Korkpoe, "Generalised Lambda Distributions by Method of Moments and Maximum Likelihood using the JSE-ASI Returns," Asian Journal of Finance & Accounting, vol. 9, no. 1, Apr. 2017, Art. no. 224. DOI: https://doi.org/10.5296/ajfa.v9i1.10913
S. Su, "Numerical maximum log likelihood estimation for generalized lambda distributions," Computational Statistics & Data Analysis, vol. 51, no. 8, pp. 3983–3998, May 2007. DOI: https://doi.org/10.1016/j.csda.2006.06.008
M. A. Tracy, Ratio Analysis Fundamentals: How 17 Financial Ratios Can Allow You to Analyse Any Business on the Planet, 1st ed. CreateSpace Independent Publishing Platform, 2012.
M. Krantz, Fundamental Analysis For Dummies, 2nd ed. Wiley, 2016.
P. Walton and W. Aerts, Global Financial Accounting and Reporting: Principles and Analysis. London, UK: CENGAGE Learning, 2006.
R. Palat, Fundamental Analysis for Investors, 4th ed. Vision Books, 2016.
S. Kurniati, "Stock returns and financial performance as mediation variables in the influence of good corporate governance on corporate value," Corporate Governance: The International Journal of Business in Society, vol. 19, no. 6, pp. 1289–1309, Dec. 2019. DOI: https://doi.org/10.1108/CG-10-2018-0308
Downloads
How to Cite
License
Copyright (c) 2024 Prana Ugiana Gio, Herman Mawengkang, Muhammad Zarlis, Saib Suwilo
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain the copyright and grant the journal the right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) after its publication in ETASR with an acknowledgement of its initial publication in this journal.
