I was thinking those who are skilled in excel often have a mind for math logic as well. Perhaps you can help me finish this equation?
I am trying to calculate the live percentage difference between two targets in the cryptocurrency market in relation to realtime price changes.
Entry: .02
Target 1: .03
Stop Loss: .01
Live Price: Rotating/second
I need the percentage that the price is diverging from the entry point until it reaches its target point. Here is the math I have so far:
This breaks the range down into 1% slices. How do I incorporate the live data into the equation?
If Price was equal to entry: 0%
If Price was equal to Target 1: 100%
If price was equal to Stop: -100%
I am trying to calculate the live percentage difference between two targets in the cryptocurrency market in relation to realtime price changes.
Entry: .02
Target 1: .03
Stop Loss: .01
Live Price: Rotating/second
I need the percentage that the price is diverging from the entry point until it reaches its target point. Here is the math I have so far:
Code:
=(Target - Entry)/100This breaks the range down into 1% slices. How do I incorporate the live data into the equation?
If Price was equal to entry: 0%
If Price was equal to Target 1: 100%
If price was equal to Stop: -100%
Last edited:
