1 of 13

Analyzing stock market movements based on sentiment analysis

2 of 13

Utilizing NLP for sentiment analysis of stock comments, providing scores to determine whether the comments are positive or negative. Analyzing the sentiment of comments enables the assessment of whether the stock is viewed favorably (bullish) or unfavorably (bearish). By establishing a predictive relationship between stock trends and sentiment expressed in comments, it provides insights for stock trading decisions.

The comment data is stored in TiDB Serverless, and the system utilizes JDBC for database connectivity. The crud function and statistics are based on TiDB Serverless. In this hackathon, we are amazed by the high performance of the HTAP, which is based on the MMP architecture.

3 of 13

Meerkat Movers

4 of 13

Our team is Meerkat Movers. There are two developer in the team, one is me, named Jacky, and the other one is Jim. We are from Shenzhen, China. Our team’s slogan is “Happy programming”. We enjoyed this hackathon.

5 of 13

  • Project Introduction

6 of 13

The following is the project introduction

  • This app is for stock investors
  • Through sentiment analysis, stock investors are provided with information about whether the stock is bullish or bearish.

7 of 13

  • Application Demo

8 of 13

Application demo:

  • We integrate TiDB Cloud serverless By JDBC. Storing the data and implements crud functions by TiDB Serverless.
  • The technology stacks are TiDB Serverless, Python, ML, Java, NodeJS, Vue, Echarts.

Demo address:

http://43.132.176.253:3000/

Github url:

Frontend: https://github.com/opkcloud/meerkat-tidb-app-h5

Python: https://github.com/yuan2006/sentimentanalysisweb

Java: https://github.com/opkcloud/meerkat-tidb-app-source

9 of 13

TiDB Cloud is a powerful and user-friendly cloud-based database platform.

It provides almost all SQL functions directly online, and integrates traditional OLTP and OLAP into one, that is, HTAP, which can realize high-performance data transaction services and real-time data analysis services.TiDB is a type of MPP database.TiDB performs better than traditional database in HTAP.

The guides and the HTAP test results are in the following website:

https://github.com/yuan2006/meerkat-tidb-app-source/blob/main/HTAP_en.md

10 of 13

  • Future Plan

11 of 13

To train a more intelligent model by a lot of comments from media platform to help the investors to make an investment decision.

12 of 13

The development plan for the remaining part of the hackathon:

  • Increase data supply through crawler media platform.
  • Improve the performance of the apps.

13 of 13

Thank you