I need an excel guru to improve an existing excel sheet.
I need to paste a Forex trading report into one tab and for selected data to be automatically extracted and populated into main Closed Trades report. Presumably a macro would be required.
Existing Closed Trades report needs various improvements to formulae to automate functions currently done manually.
A report by Forex pair needs to be automatically built from Closed Trades report in another tab. Peak to Valley drawdown needs to be calculated automatically for each instrument and graphs that dynamically update created. ... Show more