Enhance Trade Compounding Excel Sheet
Publicada el 2026-08-01
Descripción de la oferta
I use a custom spreadsheet to track how a series of trades compound over time, and I’d like it taken to the next level. The immediate priorities are two-fold: • New formulas for profit and loss projections – I need clean, reliable calculations that show projected equity curves, percentage returns, and cumulative gains based on variable position sizes and target/stop parameters. • Improvements to what is already there – the layout should feel more intuitive, and, above all, the figures must reconcile perfectly with the raw trade data I input. A sharper interface (clear labels, colour-coded highlights, sensible protections) plus stronger data validation rules will help eliminate the small accuracy issues I occasionally spot. If you are comfortable with advanced Excel functions—and, where it makes sense, some light VBA to automate repetitive steps—this should be a straightforward upgrade. I will provide the current workbook and a short video walkthrough so you can see the existing flow before starting. Once you finish, I’ll test the sheet against several historical trade logs to confirm that the projected P&L matches the real outcomes. Deliverables 1. Updated workbook containing the new dates, 2. Refreshed interface with clearer navigation, locked cells where edits shouldn’t happen, and conditional formatting for quick insights. 3. Validation checks that flag or block inputs likely to break the compounding math. 4. if a trade is lost, put a cell to put new number I’m happy to answer any clarifying questions and can turn feedback around quickly so we keep momentum. customize this and make it very simple
Skills
Fuente original: freelancer