| A | B | |
|---|---|---|
1 | 4x Risk Calculator | |
2 | Version | 1.5 [2021.03.01] |
3 | Sheet | Purpose / Instructions |
4 | XChngRates | Imports the current forex rates from google used by the rest of the calculations. It's not up to the second, but it doesn't matter for our purposes |
5 | Pairs | Various selected Forex Pair definitions. Check your lot size for each forex pair to see if it matches your brokers - most likely AU/AG/OIL will need adjusting |
6 | Calculator | Fill in the green cells only. Yellow cells are calculations, Orange are lookups used in calculations. Blue shows the recommended lot sizes based on the trade and your risk preference and what the potential upsides/downsides of a potential trade are. The yellow cells beside it will show the potential results for the actual lots you did add in |
7 | ||
8 | TODO: | - calculate the proper signs on buy/sells |
9 | - check the pairs page, figure out what I was doing with the pip scale columns - do I need both? | |
10 | ||
11 | ChangeLog | |
12 | v1.2 | - improved visual display of numbers on calculator sheet |
13 | v1.3 | - trades show actual profit/loss as +/- |
14 | v1.4 | - added risk/reward ratio calculations |
15 | v1.5 | - added HKD calculations - can override buy/sell calculation for to override when SL moves to the positive side of the trade |
16 | v1.6 | (in progress) - support 2 accounts |
17 | ||
18 | ||
19 | ||
20 | ||
21 | ||
22 | ||
23 | ||
24 | ||
25 | ||
26 | ||
27 | ||
28 | ||
29 | ||
30 | ||
31 |