Math Logic Question (Finding the right equation for live data percentages)

[mike4777]

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:

=(Target - Entry)/100

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%

 

[steve the fish]

This?

=(Live-Start)/(Target-Live)

Format to percentage.