Automated Crypto Trade Recon Tool in Excel/Sheets
Budget: €750 – €1,500 EUR
I'm looking for an expert in Excel or Google Sheets to create an automated solution for the daily reconciliation of my crypto trades.
Key Requirements:
- The tool should automatically track trades, calculate PnL, update portfolio balances, and reconcile transactions based on exchange data from Bybit and Zapper.
- Integration with APIs from Bybit and Zapper is crucial to fetch real-time trade data.
- It should provide detailed analytics, with clear summaries of open positions, realized profits, and transaction history.
- User-friendliness is important, but the main focus should be on providing in-depth, detailed analytics.
- If possible, automation with macros or scripts would be great to minimize manual input.
Ideal Skills and Experience:
- Expertise in Excel or Google Sheets
- Experience with API integration, particularly with crypto exchanges
- Ability to create user-friendly yet detailed analytical tools
- Proficiency in creating and implementing macros or scripts for automation.
Key Requirements:
- The tool should automatically track trades, calculate PnL, update portfolio balances, and reconcile transactions based on exchange data from Bybit and Zapper.
- Integration with APIs from Bybit and Zapper is crucial to fetch real-time trade data.
- It should provide detailed analytics, with clear summaries of open positions, realized profits, and transaction history.
- User-friendliness is important, but the main focus should be on providing in-depth, detailed analytics.
- If possible, automation with macros or scripts would be great to minimize manual input.
Ideal Skills and Experience:
- Expertise in Excel or Google Sheets
- Experience with API integration, particularly with crypto exchanges
- Ability to create user-friendly yet detailed analytical tools
- Proficiency in creating and implementing macros or scripts for automation.