Hi,
First things first, I have never used a macro/VBA before, so i do not know what im doing.
I've searched for an answer to my problem (below), but don't know how to go about adding it to my worksheet, setting the correct range, putting it into a cell etc..- so i need help with the solution AND getting it into my sheet...
it's just a simple maximum drawdown problem which i could do 'manually', but because the sheet im producing is meant to be saving time, it'd like to have a single cell that will calculate maximum drawdown for its own row - as part of a table.
i've attached a sample sheet, but on my actuall worksheet the dates go back to Oct-86 and not every series goes back the same length of time
any help is appreciated
EDIT: Solved myself, just had to learn how to use VBA
Bookmarks