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
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
Attached File(s)
martingale spreadsheet.xls
10 KB
|
9,523 downloads