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.
FROM wipro where stocktimeInterval='5_min_stock_data'
ORDER BY name, stockTimeInterval, stockTime, date;
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
2 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹3025
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,