To determine the 3W and 3M trend for every day for the duration of the data.
Possible Calculation Function: This function will examine the data in the stock price tab and let the user know for which date to which data is possible to run the calculations for. To calculate the 3W and 3M for 1 day 253 data points (including the data point for that day) are required. For example to calculate the 3W and 3M for 22/03/2016 we will need data for up to and until 23/03/2015 (which is 253 data points). So the first step will be to display from which date to which data the calculation is possible.
Transferring the Data: For example to calculate the 3W and 3M for 20/03/2020 we will require the data from 21/03/2019. The program will copy all the data (Date, Open, High, Low & Close) from the stock market tab and paste it in the raw data tab. The calculations to determine 3W and 3M is done automatically we just need to pick the right values.
Picking the Right Values: In the 3W and 3M tab the software needs to look at the values in the length column and highest number will correspond to a price in the price column.
• If there are two values which are the same in the length column then the value with the most recent occurrence will be chosen hence the price.
• If there is are two values which are the same and have occurred in the same time period the value which corresponds to the lower price will be chosen.
Recording the results: After the value have been determined for a certain date the date and the 3w and 3m value will need to be recorded.
This process will repeat until all possible days are calculated and the results recorded.
Sample results for 5 days are given and more can be provided upon request.
이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 28명, 평균 입찰가: $161
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can discuss more & start the project. Thanks
hello, I had more than 8 years working with VBA and can help You with your project, please send me a message with the file attached as example and I can start working on it immediately