Do some Excel Work

IMPORTANT: PLEASE READ THE .DOCX AND CHECK THE .XLSX IF YOU HAVE ANY INQUIRIES ABOUT THE PROJECT, DO NOT HESITATE TO ASK Suggested improvements (and on budget) will be highly considered to select the right freelancer VBA Project – Automatic calculations and charts Colum A = List of Currencies Column B = List of Currencies Column C = Random number from 0 to 12 D8 = IF C8 > 8, then select the currency shown in A8 and B8 and the whole data of those 2 values from the list in “Tab 5”, 5 15 30 USDJPY GBPJPY 12 GBPJPY EURJPY 12 USDJPY EURJPY 11 EURJPY CHFJPY 10 A8 = USDJPY -> in Tab 5 is Column AC, take values of the whole Column to calculate in VBA B8 = GBPJPY -> in Tab 5 is Column U, take values of the whole Column to calculate in VBA IN VBA = Take the higher value currency and subtract the lower value currency (Example, USDJPY= 1.0385, GBPJPY = 1.72623, then calculate the result of GBPJPY – USDJPY (GBPJPY “minus” USDJPY) for the whole data, that is the GBPJPY Column minus USDJPY column to create Difference Colum with the results.) For the whole data of Difference Column, calculate the moving mean for all the elements in the Column. Calculate a double standard deviation of the mean which will be added to the mean value and also subtracted from the mean value. 100 Moving 2+ 2- GBPJPY60 USDJPY60 Difference Average Std. Dev Std. Dev 1.72623 1.03850 0.68773 0.684222 0.69992 0.66852 1.72463 1.03738 0.68725 0.684094 0.69979 0.66840 1.72616 1.03765 0.68851 0.684001 0.69969 0.66831 1.72588 1.03755 0.68833 0.683889 0.69957 0.66821 1.72656 1.03806 0.68850 0.683779 0.69945 0.66811 1.72501 1.03707 0.68794 0.683683 0.69935 0.66802 1.72538 1.03695 0.68843 0.68357 0.69923 0.66791 1.72465 1.03630 0.68835 0.68346 0.69911 0.66781 1.72654 1.03674 0.68980 0.683276 0.69893 0.66763 1.72554 1.03698 0.68856 0.683091 0.69874 0.66745 1.72710 1.03786 0.68924 0.682914 0.69855 0.66727 1.72835 1.03789 0.69046 0.682742 0.69838 0.66711 1.72808 1.03798 0.69010 0.682557 0.69819 0.66692 Where the formula for the average is = =AVERAGE(OFFSET(L9;0;0;$L$7)) (where L7 is the 100 on the top of the “Difference” Column; and will be located on C4 at the Excel file in yellow and bold border, for calculation). Formula for 2+ Standard Deviation is = =M9+(2*(STDEV.P(M9:M509))) *For reference, M Column is the Moving Average Formula for 2- Standard Deviation is = =M9-(2*(STDEV.P(M9:M509))) *For reference, M Column is the Moving Average RETURN VALUE in D8 IF C8 > 8, then Calculate in VBA the whole thing explained above AND return value “OVER” if the most recent value in Difference is OVER 2+ Standard Deviation, “UNDER” if the most recent value in Difference is UNDER 2- Standard Deviation, or “ “ if Difference is not OVER nor Under. In Tab 5 and others, the Top values are the most recent values. APPLY THE SAME CRITERIA TO COLUMNS E:I for currencies in A and B ; AND O:T for currencies in L and M CHARTS Create 2 ComboBoxes, to select relevant currencies in A and B. Create “Button 5” which will show a chart when clicked of the selected currencies in ComboBoxes and the whole calculation made above. APPLY THE SAME CRITERIA TO 15 – 30 – 60 – 240 AND 1440 Series 1 = Difference Series 2 = Moving Average Series 3 = 2+ Standard Deviation Series 4 = 2- Standard Deviation IMPORTANT NOTE! ALL CALCULATIONS HAVE TO BE DONE IN VBA, DO NOT USE THE EXCEL GRID.