JAVA Have to calculate Simple moving average of existing stock data
₹600-1500 INR
Fechado
Publicado há mais de 2 anos
₹600-1500 INR
Pago na 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
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 is of great quality and is always on time. I hope you select me for the job, because I hope to earn enough money to fix my computer. I look forward to working with you!
Have a great day,
Case Schemmer
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,