Excel Automation & data analysis of Foreign Exchange currencies
₹600-1500 INR
Paid on delivery
I need someone to develop a VBA/Macro code to automate certain activities on an excel sheet so that I can get the excel sheet in the proper format without manually entering formulas.
The functions to be automated are:
1. Deleting all rows other than RIC, Period, Release / Effective Date, Country, Prior, Median, Highest
Lowest, No. of Forecasts.
2. Adding formulas in Median (=Median), Highest (=Max), Lowest (=Min), No. of Forecasts (=count) for ranges in each column.
4. Detecting outliers based on historical variance across each column and highlighting them yellow.
5. Deleting contributors with no forecasts for any RIC.
6. Formatting Row 23 & 24 so that Organization/Question is on the same level as Sentix Index*, Employment Final QQ, Employment Final YY...
7. Median row should be font 12, bold & in orange.
8. Formatting comments section
9. Additionally, coming up with an advanced analysis of Foreign Exchange currency dataset so that it can be automated and used in practise.
Project ID: #33304851
About the project
10 freelancers are bidding on average ₹1935 for this job
Hello! My name is Aldo. I am an actuarial student. I have many experience with R, Python, SQL, VBA, finances and statistics. I always deliver high quality work within accepted time limit and budget. Please start the More
Being a Financial engineer and avid programmer, I completed a lot of projects in Data analytics, Statistics, ML & Data Extraction in (R, Python, SAS, VBA-Excel); Finance; Reports and homeworks using LaTeX. That being More
|| DATA ANALYST || ADVANCE EXCEL Expert || GRAPHICAL CHART PREPARATION || Hello Sir, ✅I have read your requirement and I am very excited to start this work. I will complete this project in your time slot. I am well exp More
As I am also interested in stocks market, I will finish your work in a very short period of time Could you please contact me?