# JAVA Have to calculate Simple moving average of existing stock data

I have stock data of wipro shares 2021.

I will share the .sql file and you have calculate the simple moving average using that

the code should be in JAVA.

1. execute below query to get the 5min data order by time and date.

SELECT *

FROM wipro where stocktimeInterval='5_min_stock_data'

ORDER BY name, stockTimeInterval, stockTime, date;

for 20SMA:

2. From all the entries of 9:15 you have to start from 21st entry and get the closing value of all previous 20 entries and update the average calculated to 21st row..this will be continued till we finish all the entries of 9:15.

3. repeat point #2 get all the entries of 9:20,9:25,9:30,9:35 and you have to start from 21st entry......

this is the second requirement where you have to calculate the points gained based on below strategy:

------- get the high and low of 9:15 to 10:15 and calculate how many points the the stock moved above the high and below the low

stoploss will be high of 9:15 to 10:15 for buy side

stoploss will be low of 9:15 to 10:15 for sell side

Kĩ năng: Java, Kiến trúc phần mềm, JavaScript, MySQL

Về Bên Thuê:
( 0 nhận xét ) Bengaluru, India

ID dự án: #32254576

## 2 freelancer chào giá trung bình₹3025 cho công việc này

cschemmer23

I have been programming in Java for over two years now! I have worked on similar projects that relate to the stockmarket. Additionally, I am very familiar with SQL, and I think I would be perfect for your job. My work Thêm

₹1050 INR trong 7 ngày
(2 Nhận xét)
0.5
ankit928

Hello, I can create a Project in Eclipse for you using Java and mySQL scripts. You can import same in your environment and modify/develop it further to include other stocks tables and time. Thanks,

₹5000 INR trong 7 ngày
(0 Nhận xét)
0.0