
Excel VBA project - (financial) data classification
- or -
Post a project like this5607
£100(approx. $134)
- Posted:
- Proposals: 10
- Remote
- #50769
- Awarded
Excel, Access, VBA Developer Expert. Specializing in Excel and Access VBA automation.

Mobile App Development, Python, Power BI, Flutter, Angular, Android, IOS, Developer, Django, Ionic Framework, React JS, PHP, Web, Startup


98984678181265346363411009012221012797212729113104384610
Description
Experience Level: Intermediate
Description:
Our company is a hedge fund service provider, advisor and hedge fund consultancy company with a focus on innovative and scalable investment solutions. We are seeking for a person which should have very advanced excel VBA programming skills and should be young (18-40), trustworthy, skillful, ambitious and eager to learn and improve.We are planning to extend this single project into a long-term cooperation with the programmer. As we have also further projects in the pipeline within C# / .NET / quantitative trading (using Ninjatrader.com) / Collective2 integration (http://www.collective2.com/content/automationEncloser.htm), advanced skills in other areas would be welcomed.
Initial project:
We have a large file with data prints (.i.e. daily prints with the date, (our proprietary) trend score, Close Price and some indicator values) in separate columns. Our trend score is normed between -8 and +8. I would now like to have a an excel macro (VBA) programmed that would:
1) Assign classes to the trend score (i.e. between 1-1.5), which is an easy task
2) Run through the trend score column, for each occurrence that the trend score is within a certain class (input field) print the X day performance (input field) into a column (in a new sheet) (i.e. print the 1 day performance if trend score is 1.3 and is therefore in the 1-1.5 class)
3) The macro should continue until Y days is reached (input field, i.e. 30 days)
4) A variation would be that the macro continues to print the values until a certain trend score is reached, (i.e. print the performance figures until the trend score is below 0/or is above 6)
Thereafter, I will have a follow-on project which should automatically create plot charts for the outputs, which is not part of this initial project. Once the project is started, we should have an initial phone/skype discussion or screen demo.
The fixed price is subject to discuss and progress, and will be at the high end or above if the project is completed as desired
We are looking forward to working with you.
Our company is a hedge fund service provider, advisor and hedge fund consultancy company with a focus on innovative and scalable investment solutions. We are seeking for a person which should have very advanced excel VBA programming skills and should be young (18-40), trustworthy, skillful, ambitious and eager to learn and improve.We are planning to extend this single project into a long-term cooperation with the programmer. As we have also further projects in the pipeline within C# / .NET / quantitative trading (using Ninjatrader.com) / Collective2 integration (http://www.collective2.com/content/automationEncloser.htm), advanced skills in other areas would be welcomed.
Initial project:
We have a large file with data prints (.i.e. daily prints with the date, (our proprietary) trend score, Close Price and some indicator values) in separate columns. Our trend score is normed between -8 and +8. I would now like to have a an excel macro (VBA) programmed that would:
1) Assign classes to the trend score (i.e. between 1-1.5), which is an easy task
2) Run through the trend score column, for each occurrence that the trend score is within a certain class (input field) print the X day performance (input field) into a column (in a new sheet) (i.e. print the 1 day performance if trend score is 1.3 and is therefore in the 1-1.5 class)
3) The macro should continue until Y days is reached (input field, i.e. 30 days)
4) A variation would be that the macro continues to print the values until a certain trend score is reached, (i.e. print the performance figures until the trend score is below 0/or is above 6)
Thereafter, I will have a follow-on project which should automatically create plot charts for the outputs, which is not part of this initial project. Once the project is started, we should have an initial phone/skype discussion or screen demo.
The fixed price is subject to discuss and progress, and will be at the high end or above if the project is completed as desired
We are looking forward to working with you.
Andreas B.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
33%
Last project
17 May 2026
Switzerland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies