Comprehensive Excel Performance Report Creation
₹1500-12500 INR
Paid on delivery
I'm looking for an Excel expert who can create a detailed report based on my specified input criteria: strategy, date, P/L, day, and margin. The report should have two sheets, with Sheet 1 containing detailed results and metrics, and Sheet 2 containing combined metrics. The report should also trigger a 'drawdown' alert.
Specific metrics to be tracked:
- Drawdown
- Margin
- Average P/L per day
- Number of strategies executed
- Overall profit
- Max profit
- Max loss
- Win%, Loss%
- Avg profit on win days
- Avg loss on loss days
- Return to MDD ratio
- Expectancy ratio
- Max win streak
- Max loss streak
- A month-wise breakup list with Time frame (day/month/year)
- Bar chart: profit/loss
- A list of all values added from input sheet.
I will require separate login access for this project.
Ideal skills and experience for the job include:
- Advanced knowledge of Excel, including data analysis, chart creation, and formula application.
- Experience in creating detailed performance reports.
- Ability to track and measure complex metrics.
- Proficiency in setting up alerts for specific conditions within the data.
- Understanding of financial metrics and performance indicators.
Project ID: #38667727
About the project
Awarded to:
15 freelancers are bidding on average ₹6333 for this job
As an experienced data analyst with a strong grip on Excel and Visual Basic, I can assure you of precise, accurate and well-structured report generation according to your requirements. Having worked extensively in the More
As a seasoned Excel professional, I am confident that I possess the expertise to proficiently complete your comprehensive performance report. Having spent years navigating the depths of Excel's functionality, I'm well- More
I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want job !!!I want j More
Hello, I am a Chartered Accountant based in India, specializing in maintaining accounts for US-based companies using various accounting software including MS Excel. With a decade of experience, I am well-equipped to p More
I worked on excel and make presentations Data analysis and research for definite topics and summarize reports in simple way
For your project, I propose creating a dynamic Excel report that tracks and analyzes the specified performance metrics in real-time. The report will include two detailed sheets: - Sheet 1: Detailed Results and Metrics More
I will do this with in 7 days with fare amount (₹6000). I'm a data entry specialist. And also i will try my best.
Namaste I read your proposal and I think I can meet your requirements How much data you want me to add in 1 sheet? Best regards Sakdhi
Hello, I am eager to assist with your Excel performance report project. Despite being new to freelancing, I have solid experience in Excel and financial data analysis. To demonstrate my skills, I am offering a free sa More
