Trading journal
Budget: ₹12,500 – ₹37,500 INR
Hi! I’m looking for someone to build a custom trading journal in Google Sheets for me.
The journal should include:
• A main trading log with the following columns:
• Date
• Instrument name / symbol
• Profit / Loss
• Long / Short position
Additionally, I need:
• A separate table for deposits and withdrawals to track account balance changes.
• Automatic ROI calculation (return on investment).
• Total profit and loss summary.
• Monthly statistics (e.g., total trades, win rate, average profit, total P/L per month).
• A chart showing the percentage growth of my capital over time.
• A summary dashboard with key metrics and basic charts (e.g., equity curve, monthly results).
I’ve attached an HTML file containing my trading history.
Please extract only the trades that affect the financial results — specifically closed positions, stop losses, and take profits — and import them into the trading log.
Also, please extract deposits and withdrawals separately into their own table.
The journal should include:
• A main trading log with the following columns:
• Date
• Instrument name / symbol
• Profit / Loss
• Long / Short position
Additionally, I need:
• A separate table for deposits and withdrawals to track account balance changes.
• Automatic ROI calculation (return on investment).
• Total profit and loss summary.
• Monthly statistics (e.g., total trades, win rate, average profit, total P/L per month).
• A chart showing the percentage growth of my capital over time.
• A summary dashboard with key metrics and basic charts (e.g., equity curve, monthly results).
I’ve attached an HTML file containing my trading history.
Please extract only the trades that affect the financial results — specifically closed positions, stop losses, and take profits — and import them into the trading log.
Also, please extract deposits and withdrawals separately into their own table.