Create an excel formula for selling and buying the same forex over and over
Budget: $10 – $30 USD
I need to create an excel formula that has a constant buying and selling of the same currency pair.. Example
I start with 100 USD and sell for 10,000 x coin.... at a price of 1 USD for 100 X coin
then i would like to buy back to USD lets say 30 USD at a price of 1 USD for 95 X coin
at this time it will calculate the earnings when i exchange back to 30 usd cause i exchange cheaper..
then i would like to sell back the 30USD but this time i got the X coin at 109 for each USD..
each time always calculating how much i had before of the x coin and it has a constant change in buy and selling price always calculating the profit or loss
etc
I start with 100 USD and sell for 10,000 x coin.... at a price of 1 USD for 100 X coin
then i would like to buy back to USD lets say 30 USD at a price of 1 USD for 95 X coin
at this time it will calculate the earnings when i exchange back to 30 usd cause i exchange cheaper..
then i would like to sell back the 30USD but this time i got the X coin at 109 for each USD..
each time always calculating how much i had before of the x coin and it has a constant change in buy and selling price always calculating the profit or loss
etc