StockWeb

Stock Market: Indonesia

Program Description

StockWeb allows users to insert and export a CSV file containing the information of stock ownership data for the last six months, show stacked bar chart and tables of stock ownership, displays IPO stock sample data, and list of of website related capital market websites.

System Requirements

Software used in developing this program:

• Go 1.22
• GORM as Object Relational Mapping
• Gin Web Framework
• MySQL 8.3.0
• MySQL Workbench
• Text Editor: Visual Studio Code

Program Preparation

• Install all the required software to run the program

Data Source

• Stock Ownership Data Source: KSEI (Kustodian Sentral Efek Indonesia)
  URL: https://ksei.co.id/archive_download/holding_composition
• IPO Sample Data Source: E-IPO Stock Prospectus
  URL: https://e-ipo.co.id/en

Database Setup

1. Open MySQL Workbench

2. Open SQL folder

3. Create and use database using the commands in Database.sql.
   

4. Open Back End folder

5. Open terminal or cmd to run the back end by using command go run . and click Allow access.
   

6. The table will be automatically migrated.
   

7. Run all the insert SQL in SQL folder with following step to avoid foreign key error

   • Insert_Broker.sql

   • Insert_Stock_IPO.sql

   • Insert_Detail.sql

   • Insert_Category.sql

   • Insert_Link.sql

   • Insert_Stock.sql

8. Run the front end using Live Server extensions in Visual Studio Code.
   

9. Check the .env file in Back End folder and set the DB_SOURCE based on user setting with format user:password@tcp(host:port)/databaseName?parseTime=true.
   

Pages

1. Home Page
   The home page contains an introduction and services provided.
   

2. Link Page
   The link page displays a list of websites related to capital markets and filters based on category ID.
   

3. IPO Page
   The IPO page displays table of IPO sample data with Underwriter and Value filter.

4. Balance Page
   The balance page displays stock ownership data in table and chart format. User can insert data to database by uploading the correct txt data from KSEI (Kustodian Sentral Efek Indonesia).
   Notes: User must have internet connection to show the chart because the chart is generated using chart.js from the internet

   • The inserted data when using Insert_Stock.sql only insert 3 months of data so the table and chart only shows 3 months data.

   • Check data from KSEI data folder or download it from https://ksei.co.id/archive_download/holding_composition

   • Click Choose File button then choose 2024_01_January.txt from KSEI data folder then click Upload File button.

   • Upload 2023_11_November.txt and 2023_12_December.txt too.

   • Check ANTM stock and see the Change 1 Month row

     • If there are no changes, the background will be yellow.
     • If the shares are increasing compared to last month, the background will be green.
     • If the shares are decreasing compared to last month, the background will be red.

   • User can export data to CSV by clicking Export Data button and open it in Excel.