martingale spreadsheet

i know this is simple to do but i am unable to make a basic spreadsheet to calculate risk and return.

i will be gratefull if you can help with any part

i am attaching a example of what i want but that it is wrong. I could do is divide the total risk (in units because i use Marketiva)

but what i want is it calculates how many units i should use in each level, the profit each level gives, the acumaled profit after closing each level, etc.

my maths and excell skills are a disgrace.


thanks in advance

very useful xls sheet for such calculation is available in nanningbob's thread.
It should serve your purpose.
I will attach here but I will not be able alter it to suit your requirements...

many thanks. Yes, i was suspecting there was something in his thread. I will post there to see if someon is able to make the changes i need.

thanks again.