Does anyone know how these sites do their calculations?

{links removed, see rule #3} True north Excel calculator

Some use

EUR)/CHF

Euro pip value 10 CHF 8.13 10/8.13 = 1.23 x .86 correlation

100- 86= 14 1.23 x 114 = 140

Buy 1.40 lots CHF

Buy 1 lot Euro

HowTo -pip value of each pair, swap value of each pair ,daily range of each pair Calculate

All these to factor how many lots to buy,sell

Does anyone know these calculation are done ? can you share any Excel sheets you have

{links removed, see rule #3} True north Excel calculator

Some use

EUR)/CHF

Euro pip value 10 CHF 8.13 10/8.13 = 1.23 x .86 correlation

100- 86= 14 1.23 x 114 = 140

Buy 1.40 lots CHF

Buy 1 lot Euro

HowTo -pip value of each pair, swap value of each pair ,daily range of each pair Calculate

All these to factor how many lots to buy,sell

Does anyone know these calculation are done ? can you share any Excel sheets you have