I'm looking for somebody that could program/design an excel file that would consist out of the following:
1 tab: enter data serie of a particular stock (several years (monthly or daily data))
2 tab: should then be able to analyse key statistics over the entire period (as well as selected periods) like: - annualized return, volatility, draw down...
3 tab: what would happen to an initial investment (let's say 1000) that we then would multiply with a certain number x should a certain minus percentage y be reached. This tab should the show how over time the initial investment would evolve. It should also add the opportunity to put away money everytime the investment generated a certain percantae of gain. In essence this tab should give an overview of how an investment behaved over time if (just like in casino) the investment is doubled or multiplied with a certain number x every time the minus percantage y is reached. This tab should allow to autmoatically optimzie the x and y to generate the highest return over time....
If you're interested in doing something - please get in touch with me!
Many thx, Lukas