The pip value of the crosses changes along with the price. This is inconvenient to me to make the risk management, i.e.: lot size decision.

Is there a way to use excel to calculate the pip value at any given time?

Or a link to check it out?

This link seems not good enough. http://www.mataf.net/en/analysis-pipvalue.htm

Appreciate your help.

Is there a way to use excel to calculate the pip value at any given time?

Or a link to check it out?

This link seems not good enough. http://www.mataf.net/en/analysis-pipvalue.htm

Appreciate your help.

凹凸 only