by speakinmymind » Mon May 14, 2018 8:40 pm
Could you automate this process for me?
The Simple Arithmetic Mean is used four times:
1. Selected Pair (EUR/USD in this example)
2. (GBP is base in this example) Put GBP on left of quote and use both currencies in the selected pair. (Here it would be GBP/USD and GBP/EUR).
3. Recipricol of step 2. (Here it would be USD/GBP and EUR/GBP.
4. Add step 2 and 3 to create a midpoint. (Here it would be GBP/USD, GBP/EUR, USD/GBP, and EUR/GBP
The only thing the user should be able to change is the base currency. All JPY related quotes should have a 0.01 weight.
Thanks!
- Attachments
-