JAVA Have to calculate Simple moving average of existing stock data

Cerrado Publicado hace 2 años Pagado a la entrega
Cerrado Pagado a la entrega

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

Java Arquitectura de software JavaScript MySQL

Nº del proyecto: #32254576

Sobre el proyecto

2 propuestas Proyecto remoto Activo hace 2 años

2 freelancers están ofertando un promedio de ₹3025 por este trabajo

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 Más

₹1050 INR en 7 días
(2 comentarios)
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 en 7 días
(0 comentarios)
0.0