You must have Matlab 2018a version to be able to run the whole code !
Budget is 45 USD !!!!
Delivery as soon as possible
ACC_DE is the line/time series we are working on
You can see that code is combining tickers( stocks) and getting /storage its ACC_De which is calculated the way ( you can see it in the code)
I need you to grab each stored ACC_De and include Regression/trendline with its Error bands ( 5th and 95th percentiles)
In the excel file print under the name "task2" include this results..
Add column R^2 Adj. and add columns Above Band , Bellow Band ( idea behind this is to check if last value od ACC_DE is bellow or above error bands)
You can use TRUE and FALSE for that
Another thing is that I want to see how many times ACC_DE form the start to end date touched and/or crossed above / bellow error bands (95th, 5th)
Those could be columns in the excel named Count Above Band, Count Bellow Band
So you have to add in total 5 columns in task2 existing excel file print
You can see that there is additional Excel file print under the name Results
It pools out filtered pairs from task2 excel into Results excel
Our filter will be just ( you can erase all others) :
Above Band , Below Band, Count Above Band, Count Bellow Band
I want to be able to change ( regarding 2 first filters if that is going to be 95th and 5th or 75th and 25th ) so make those in percentiles so I can input values
Regarding Count Above Band and Count Bellow Band you can use default value of 4 ( for both) and I will change accordingly
You will see also third Excel output
It prints DATE and Time Series if ACC_DE and Tickers making those ACC_DE...just make it to print ( same way it was done so far) to print what passed filter for Results
That is all
as professional team work is important for 100% satisfaction , we have team of 15 members for your work with skilled experience. feel free to contact us. Regards MATHCREATER