Creation of an XL table with formulas for data calculation for statistics
34 USD It is necessary to create a trading journal based on selected criteria where data will be summarized, and in the cells, there will be options to input different types of data. A professional with expert knowledge of working in Excel spreadsheets is required to implement any technical idea within the capabilities of Excel.)
Applications 1
Work results
Client's review of cooperation with Kateryna Matsapura
Creation of an XL table with formulas for data calculation for statisticsExcellent work done by Katerina, ahead of schedule and very accurately, good ideas were proposed, the deal journal turned out just as I wanted. Thank you)
Freelancer's review of cooperation with Denys Dordiai
Creation of an XL table with formulas for data calculation for statisticsI was glad to collaborate with Denis. The client described the task very clearly and provided their layout, so I understood exactly what was needed, and the work went smoothly and quickly. The revisions were clear and to the point, Denis responded promptly and kindly; it was a pleasure to work with such a client. I would be happy to help again if there is a need to refine the magazine or if new ideas arise.
I recommend!
-
1 day34 USD1 day34 USD
Good day. The main thing here is that the table not only calculates totals but also does not break after new rows and provides clear statistics without manual recalculation.
I will create an Excel table with formulas for data calculation, automatic totals, percentages, filters, and a neat structure for further filling.
I will also check edge cases: empty cells, new entries, formula errors, and the correctness of overall statistics.
I can start today and deliver a working file in 1 day that can be used immediately.
Please let me know which format you prefer to work with — Excel or Google Sheets, and I will adjust the file accordingly.
-
5 days57 USD
378 5 days57 USDHello!
I have reviewed the task. Instead of a complex Excel spreadsheet, I would suggest implementing an internal CRM system using Django + Django REST Framework.
This approach will provide not just a file with formulas, but a convenient web tool for maintaining a trading journal, where data will be stored in a structured manner, automatically summed up, and analyzed.
What can be implemented:
1. A trading journal with the necessary criteria and data types.
… 2. Fields with value selections, dropdown lists, dates, numbers, text, and comments.
3. Automatic calculation of totals, sums, percentages, and other indicators.
4. Filters, sorting, and searching through records.
5. Reports and summary analytics.
6. Data export to Excel if needed.
7. A user-friendly admin panel for independently changing reference lists and parameters.
The advantage of this solution is that the system will not be limited by Excel's capabilities and will not break due to accidental changes to a formula or cell. At the same time, the familiar tabular logic can be preserved in the interface.
I would be happy to discuss the structure of the journal and propose a convenient solution for your processes.
-
3 days34 USD
1026 15 0 3 days34 USDGood day.
I work in Excel and Google Sheets.
I am ready to help implement your task. To create the necessary journal with automatic calculations using formulas.
I am ready to discuss the task in more detail.
-
1 day34 USD
4461 102 0 1 day34 USDGood day. I have the necessary skills and experience. I would be happy to help with the implementation of this project and discuss any points of interest you may have!
-
2 days34 USD
343 1 0 2 days34 USDHello, Denys! I have extensive experience in developing trading journals and analytical tables in Excel / Google Sheets. I fully understand your task: I will implement convenient dropdown lists for selecting types of data (strategies, tools, trade direction, etc.) and set up automatic summation and calculation of statistics.
-
1 day34 USD
232 1 day34 USDHello! I created trading journals in Excel — drop-down lists for types of trades, auto-calculation of win rate, RR, and P&L, highlighting WIN/LOSS with conditional formatting. I will look at your screenshot and tailor it to your criteria so that the numbers are calculated automatically and you won't have to enter them manually. I can do it in a day. Do you need overall statistics or also broken down by instruments/strategies?
-
1 day34 USD
452 1 day34 USDGood day! I have studied the task — I will create a trading journal with formulas, drop-down lists, conditional formatting (WIN/LOSS highlighting, color markers), and automatic calculation of statistics (% win rate, RR, Pips, P&L).
I see there is already a structure in the screenshot — I will adapt it to your criteria or create it from scratch.
Deadline: 1
Budget: 30 EUR (as stated)
I am ready to start immediately.
-
2 days57 USD
2937 73 4 2 2 days57 USDGood day! I have been working with Excel for over 20 years!!! I can implement any ideas, both with formulas and possibly with macros!!! Feel free to reach out!!!
-
2 days40 USD
1311 63 1 2 days40 USDDenis, good afternoon.
I have been working with Excel, Google Sheets, and various databases for over 10 years. Not only the standard functionality of Excel but also my own add-ins, applications, and automation for spreadsheets.
Feel free to reach out, we can discuss, I will suggest implementation options, and I will do it.
-
1 day34 USD
3615 113 7 1 1 day34 USDHello.
I have extensive experience working with Google Sheets and Excel.
I also create scripts for the aforementioned programs.
Check out my portfolio and reviews.
Freelancehunt
I have reviewed the project. I am ready to assist with the implementation.
Message me - we will discuss the details.
Current freelance projects in the category Technical Documentation
Translation, editing, and layout of brochures/instructions
223 USD
Looking for a performer for comprehensive work with brochures and instructions. Required services: translation; editing and proofreading; document layout; transfer of color images from the original; preparation of printed and electronic versions. Output file: PDF. Please… Text Translation, Technical Documentation ∙ 2 days back ∙ 26 proposals |
Czech Republic