Development of a macro in Excel for automatic calculation of financial strategies.
The full details are specified in the attached technical specification. The file language is Russian.
Job Description:
It is necessary to create a macro that automatically loads data from .txt file, processes it according to the specified parameters, and generates tables for analyzing the results.
Calculations are performed for three financial strategies:
- Simple
- Complex without profit withdrawal
- Complex with profit withdrawal and reinvestment
Macro Functionality:
- Loading input data from .txt file.
- Automatic calculation of deposit, profit/loss, commission, reinvestment points.
- Ability to select testing parameters (deposit, risk, number of trades, entry interval).
- Generation of reports for the selected strategy or for two strategies simultaneously.
- Use of the "tail trimming" algorithm – considering only relevant trades for the accuracy of the final data.
- Setting iterations for optimizing parameters.
Additionally:
🔹 All parameters are set in a separate Excel sheet.
🔹 Results are displayed in formatted tables on separate tabs.
🔹 Mandatory verification of calculation accuracy after implementation.
Requirements for the Performer:
✅ Experience in developing VBA macros for Excel.
✅ Understanding of financial calculations and working with deposits.
✅ Ability to optimize code for fast processing of large data arrays (up to 400,000 rows).
⏳ Deadline: to be discussed.
💰 Budget: please propose your cost.
Applications 1
-
10 days277 USD
492 1 0 10 days277 USD
Hello! I have experience in developing financial reports in Excel and automating calculations through the creation of macros (VBA). I can help you with creating automatic calculations. The technical specifications are generally clear, but there may be some additional questions that arise during the execution, particularly regarding the logic of the calculations. Feel free to reach out, I would be happy to collaborate.
-
28 days601 USD
361 1 0 28 days601 USD
Good health! I have a financial education, developed analytical reporting in Excel for the International Bank for Reconstruction and Development on energy programs (investments, contracts, currencies, exchange rate differences).
Deadline - 4 weeks
Budget - 40K
-
14 days134 USD
1574 37 0 14 days134 USD
Good day.
Experience in writing macros is available.
Your help may be needed in understanding financial calculations.
-
7 days22 USD
631 5 0 7 days22 USD
Good afternoon
I offer my services in implementing your task. Considering the large volume of lines, I think it would be better to perform the calculations not with a macro, but with an application.
I have experience in developing credit/deposit accounting systems
(price is conditional)
-
5 days111 USD
2854 72 0 5 days111 USD
Hello!
I have been working with formulas since 2008, and with VBA-Excel (macros) since 2011.
My priorities are optimizing calculations and user convenience.
I have worked on several projects related to finance: loan calculators; a payback model for an animal farm; a model for a credit organization (more than 70 variable input parameters), material and financial planning (for a year) for a sewing factory...
Despite all this, I have no knowledge in economics or finance. I can count money :), but that is far from specialized knowledge. The logic of calculations in these projects was explained by specialists; my part was data placement, coding, and optimization.
Budget and timeline - who knows... We need to discuss the task itself.
-
3 days27 USD
5852 345 0 3 days27 USD
Experience in developing macros for Excel - available
Understanding of how to write macros for processing hundreds of thousands of rows - available
Knowledge of finance and deposits - close to zero
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 days 14 hours back ∙ 10 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 4 days 18 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 5 days 20 hours back ∙ 112 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 8 days 3 hours back ∙ 44 proposals |
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 13 days 19 hours back ∙ 10 proposals |
Kyiv