Excel VBA Macro - Cleaning-up financial time series
€30-250 EUR
Completed
Posted over 7 years ago
€30-250 EUR
Paid on delivery
Spreadsheet (provided for example) contains time series of stock prices.
The VBAMacro should do the following 4 steps:
Example: we look at a 5 years period 01JAN2010 to 31DEC2015
Step 1
Identify the period where some data is available
Example: there is data available from 01JAN2011 to 31DEC2014 (i.e. no data available for 2010 and 2015)
Step 2
Where some data is available, clean it up by replacing the missing prices by the n-th last available price
Step 3
Transform the cleaned-up series of available prices into returns (Price [t]/Price[t-1] - 1)
Step 4
Where data is unavalaible, replace the returns of an Index. The Index and returns of the index to be used to replace is provided.
Example: for 2010 and 2015, returns are those of the index
Specials:
- The macro should perform the transformations on multiple columns in order to clean up a relatively large set of data in one operation;
- Clean coding with comments in the code
- Code viewable in the developer tab
An example spreadsheet with an example of raw data to be treated will be provided
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews. They speak for themselves.
Best regards
Deasr Sir/Madam,
I have 4 years experience in Excel VBA programming.
I used to work for a company called InvestorForce (part of MSCI) where I created automated Excel tools to calculate benchmark index returns.
Please contact me if you think my experience can be useful in this project.
Regards,
Balint Kolosi
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). Deliver spreadsheet
Hi,
I have more than 14 years of Excel/VBA exp and I am expert in this kind of work.
Please send me more details so that I can estimate cost and time better.
I have completed more than 290 projects.
Please look at the feedback left by my employers to know more about my work. Waiting for your positive response.
Thanks.
Hello Dear. I am an stock analyst. I have made similar program for stock analysis. You may find the video of that program in my portfolio as well. I am interested to take your project. Kindly hire me to develop top class program for your requirements.
Dear Client
I am an experienced VBA developer and have done many projects like this. I have reviewed your projects in detail and ready to go for it right away. I will provide you the code in developers tab for your review and be flexible for any changes in future.
Will be waiting for your response to proceed.
Warm Regards
Zulfiqar
Dear Contact Person,
I have read your job description thoroughly and I think you can rely on me.
I have vast experience in web search, web research, collecting information, data entry and formatting.
I am a full time available freelancer and the quality of my work is a reflection of my sincerity.
Best Regards,
Farhana Bilkis
Hi,
I am interested to your job. I am expert web research, data mining, Google Spreadsheet, Adwords, Analytics, Webmaster, SEO, SMM, EM, SEM, PR, B2B Marketing, Lead Generation, Directory and other related programs.
I have already completed so many projects. Please have a look on my portfolio and profile. I have listed many successful projects in my work history area.
I am waiting to be hired in this project to show my skills.
I do your job very lowest cost.
Regards,
MD:Mithun Ali
mesg for details ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,