I need to explain myself in details in order to make some sense. Please read this carefully as I desperately need some help.

I am an option trader. On the trading platform, let's suppose I want to invest 1$ as my initial trade, with 90% profit in case if the trade is a winning trade, I will make 1.9$.

In case if I lose this trade, then I'll go with the 2nd trade of 2.22$. Why? Because 2.22$ will help me recover the previously lost 1$ and also help me make another 1$.

I do this up to 6 times unless I win a trade. In case if I win, I go back to the 1$ value and start trading again with one dollar. This strategy is called martingale.

Now, I do all this calculation manually by visiting a website called

*percentage calculator*and also using a calculator on my PC.

I would like to know if I can automate all this.

I want to use a formula in excel that'll require me to change the percentage and my initial investment values only.

Why I want to use excel? Calculating all that manually requires time, and especially during those one minute trades, you don’t have enough time to calculate all that.

Please be informed that I am a newbie when it comes to excel. The only formula I have learned so far is the SUM formula. So please be specific if you're going to help me with this.

Thanks in advance.