Advanced Excel Expert for Data Metrics
Budget: $10 – $30 USD
I am seeking a skilled individual who is highly proficient in Excel and has a solid understanding of basic math.
The project involves organizing a set of simple numerical data according to various metrics. I have provided a sample dataset along with a detailed list of requirements for this task. While the work is straightforward for someone experienced in Excel and able to follow directions, attention to detail is essential. If this initial project is completed successfully, I have several additional datasets that will require similar organization.
One of the key requirements is that the Excel file must be dynamically formulated. Any edits or additions to the data should automatically update the corresponding metrics and visualizations across various tabs.
I have already created the foundation for the Excel file. Please provide your email address so I can share the file and any additional resources necessary to get started. I am happy to provide training and support as needed throughout the process.
Please send me a chat if interested
Requirements:
Equity Curve by Day – Graph representation.
Equity Curve by Week – Graph representation.
Equity Curve by Month – Graph representation.
Data distribution by day of the week.
Data distribution by month.
Data distribution by time intervals.
Data distribution by direction.
Total number of trades and winning percentage.
Average loss size, average win size, and win-to-loss ratio.
Organize profit and loss sequences by day and week.
Sort days and weeks from lowest to highest profit.
The project involves organizing a set of simple numerical data according to various metrics. I have provided a sample dataset along with a detailed list of requirements for this task. While the work is straightforward for someone experienced in Excel and able to follow directions, attention to detail is essential. If this initial project is completed successfully, I have several additional datasets that will require similar organization.
One of the key requirements is that the Excel file must be dynamically formulated. Any edits or additions to the data should automatically update the corresponding metrics and visualizations across various tabs.
I have already created the foundation for the Excel file. Please provide your email address so I can share the file and any additional resources necessary to get started. I am happy to provide training and support as needed throughout the process.
Please send me a chat if interested
Requirements:
Equity Curve by Day – Graph representation.
Equity Curve by Week – Graph representation.
Equity Curve by Month – Graph representation.
Data distribution by day of the week.
Data distribution by month.
Data distribution by time intervals.
Data distribution by direction.
Total number of trades and winning percentage.
Average loss size, average win size, and win-to-loss ratio.
Organize profit and loss sequences by day and week.
Sort days and weeks from lowest to highest profit.