Hello,
I would like to create eight offline charts in mt4 or custom charts in mt5. Unfortunately, I do not possess the necessary skills to create such charts. So, I beseech a gentlecoder to spare a few minutes for this cause. If you are interested please read the following instructions and do not hesitate to ask about any ambiguities in the text.
Each chart would represent one of the main currencies (USD, EUR, GBP, AUD, NZD, CAD, CHF, JPY). The result charts would be something similar to the DXY chart but with two main difference: 1- There are no weighting for any currency. For example the weight of EUR and JPY will be the same. 2- It is consisted of only the eight aforementioned currencies. In order to create the chart one candle in a specific date and time will become the base candle and its open will set to 0. After that all the changes will be determined according to this base point. Below, I will provide an example to how to calculate the aggregated chart for USD. The same procedure will be conducted for the other seven currencies. Note: in order for the calculation to be correct, the currency that we are trying to create an aggregated chart will always be on the left side. For example, when we are creating the USD chart, all the calculations of EURUSD, GBPUSD, AUDUSD, and NZDUSD will be multiplied by -1.
Formula:
1. Open USD(Ot)= -((Ot-Ot-1 )EU) -((Ot-Ot-1 )GU) -((Ot-Ot-1 )AU)- ((Ot-Ot-1 )NU)+ ((Ot-Ot-1 )UC)+ ((Ot-Ot-1 )UF)+ ((Ot-Ot-1 )UJ)
2. High USD(Ht)= -((Ht-Ht-1 )EU)- ((Ht-Ht-1 )GU)- ((Ht-Ht-1 )AU)- ((Ht-Ht-1 )NU)+ ((Ht-Ht-1 )UC)+ ((Ht-Ht-1 )UF)+ ((Ht-Ht-1 )UJ)
3. Low USD(Lt)= -((Lt-Lt-1 )EU)- ((Lt-Lt-1 )GU)- ((Lt-Lt-1 )AU)- ((Lt-Lt-1 )NU)+ ((Lt-Lt-1 )UC)+ ((Lt-Lt-1 )UF)+ ((Lt-Lt-1 )UJ)
4. Close USD(Ct)= -((Ct-Ct-1 )EU)- ((Ct-Ct-1 )GU)- ((Ct-Ct-1 )AU)- ((Ct-Ct-1 )NU)+ ((Ct-Ct-1 )UC)+ ((Ct-Ct-1 )UF)+ ((Ct-Ct-1 )UJ)
5. Volume USD(Vt)= ((Vt)EU)+ ((Vt)GU)+ ((Vt)AU)+ ((Vt)NU)+ ((Vt)UC)+ ((Vt)UF)+ ((Vt)UJ)
Example:
1. Open USD(3.12.29 20:01)= -((O 3.12.29 20:01 – O 3.12.29 20:00 )EU)-((O 3.12.29 20:01 – O 3.12.29 20:00)GU)- ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)- ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
= -(1.10577-1.10641)-( 1.27526-1.27622)-( 0.68300-0.68349)-( 0.63376-0.63431)+( 1.32102-1.32068)+(0.83985-83914)+(140.924-140.842)
=-(-64)-(-96)-(-49)-(-55)+34+71+82
=451
2. High USD(O 3.12.29 20:01)= ((O 3.12.29 20:01 – O 3.12.29 20:00)EU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)GU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
=-(1.10579-1.10641)-(1.27553-1.27622)-(0.68306-0.68349)-(0.63380-0.63431)+(1.32122-1.32121)+(0.84036-0.83993)+(140.990-140.939)
=-(-62)-(-69)-(-43)-(-51)+1+43+51
=320
3. Low USD(O 3.12.29 20:01)= ((O 3.12.29 20:01 – O 3.12.29 20:00)EU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)GU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
=-(1.10513-1.10571)-(1.27469-1.27507)-(0.68273-0.68288)-(0.63342-0.63364)+(1.32101-1.32062)+(0.83985-0.83914)+(140.920-140.839)
=-(-58)-(-38)-(-15)-(-22)+39+71+81
=324
4. Close USD(O 3.12.29 20:01)= ((O 3.12.29 20:01 – O 3.12.29 20:00)EU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)GU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
=-(1.10521-1.10579)-(1.27499-1.27527)-(0.68280-0.68301)-(0.63349-0.63375)+(1.32112-1.32100)+(0.84020-0.83986)+(140.990-140.923)
=-(-58)-(-28)-(-21)-(-26)+12+34+67
=246
5. Volume USD(O 3.12.29 20:01)= ((O 3.12.29 20:01)EU)+ ((O 3.12.29 20:01)GU)+ ((O 3.12.29 20:01)AU)+ ((O 3.12.29 20:01)NU)+ ((O 3.12.29 20:01)UC)+ ((O 3.12.29 20:01)UF)+ ((O 3.12.29 20:01)UJ)
=196+166+119+151+82+77+161
=952
Screenshots of the example:
I would like to create eight offline charts in mt4 or custom charts in mt5. Unfortunately, I do not possess the necessary skills to create such charts. So, I beseech a gentlecoder to spare a few minutes for this cause. If you are interested please read the following instructions and do not hesitate to ask about any ambiguities in the text.
Each chart would represent one of the main currencies (USD, EUR, GBP, AUD, NZD, CAD, CHF, JPY). The result charts would be something similar to the DXY chart but with two main difference: 1- There are no weighting for any currency. For example the weight of EUR and JPY will be the same. 2- It is consisted of only the eight aforementioned currencies. In order to create the chart one candle in a specific date and time will become the base candle and its open will set to 0. After that all the changes will be determined according to this base point. Below, I will provide an example to how to calculate the aggregated chart for USD. The same procedure will be conducted for the other seven currencies. Note: in order for the calculation to be correct, the currency that we are trying to create an aggregated chart will always be on the left side. For example, when we are creating the USD chart, all the calculations of EURUSD, GBPUSD, AUDUSD, and NZDUSD will be multiplied by -1.
Formula:
1. Open USD(Ot)= -((Ot-Ot-1 )EU) -((Ot-Ot-1 )GU) -((Ot-Ot-1 )AU)- ((Ot-Ot-1 )NU)+ ((Ot-Ot-1 )UC)+ ((Ot-Ot-1 )UF)+ ((Ot-Ot-1 )UJ)
2. High USD(Ht)= -((Ht-Ht-1 )EU)- ((Ht-Ht-1 )GU)- ((Ht-Ht-1 )AU)- ((Ht-Ht-1 )NU)+ ((Ht-Ht-1 )UC)+ ((Ht-Ht-1 )UF)+ ((Ht-Ht-1 )UJ)
3. Low USD(Lt)= -((Lt-Lt-1 )EU)- ((Lt-Lt-1 )GU)- ((Lt-Lt-1 )AU)- ((Lt-Lt-1 )NU)+ ((Lt-Lt-1 )UC)+ ((Lt-Lt-1 )UF)+ ((Lt-Lt-1 )UJ)
4. Close USD(Ct)= -((Ct-Ct-1 )EU)- ((Ct-Ct-1 )GU)- ((Ct-Ct-1 )AU)- ((Ct-Ct-1 )NU)+ ((Ct-Ct-1 )UC)+ ((Ct-Ct-1 )UF)+ ((Ct-Ct-1 )UJ)
5. Volume USD(Vt)= ((Vt)EU)+ ((Vt)GU)+ ((Vt)AU)+ ((Vt)NU)+ ((Vt)UC)+ ((Vt)UF)+ ((Vt)UJ)
Example:
1. Open USD(3.12.29 20:01)= -((O 3.12.29 20:01 – O 3.12.29 20:00 )EU)-((O 3.12.29 20:01 – O 3.12.29 20:00)GU)- ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)- ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
= -(1.10577-1.10641)-( 1.27526-1.27622)-( 0.68300-0.68349)-( 0.63376-0.63431)+( 1.32102-1.32068)+(0.83985-83914)+(140.924-140.842)
=-(-64)-(-96)-(-49)-(-55)+34+71+82
=451
2. High USD(O 3.12.29 20:01)= ((O 3.12.29 20:01 – O 3.12.29 20:00)EU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)GU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
=-(1.10579-1.10641)-(1.27553-1.27622)-(0.68306-0.68349)-(0.63380-0.63431)+(1.32122-1.32121)+(0.84036-0.83993)+(140.990-140.939)
=-(-62)-(-69)-(-43)-(-51)+1+43+51
=320
3. Low USD(O 3.12.29 20:01)= ((O 3.12.29 20:01 – O 3.12.29 20:00)EU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)GU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
=-(1.10513-1.10571)-(1.27469-1.27507)-(0.68273-0.68288)-(0.63342-0.63364)+(1.32101-1.32062)+(0.83985-0.83914)+(140.920-140.839)
=-(-58)-(-38)-(-15)-(-22)+39+71+81
=324
4. Close USD(O 3.12.29 20:01)= ((O 3.12.29 20:01 – O 3.12.29 20:00)EU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)GU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)AU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)NU)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UC)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UF)+ ((O 3.12.29 20:01 – O 3.12.29 20:00)UJ)
=-(1.10521-1.10579)-(1.27499-1.27527)-(0.68280-0.68301)-(0.63349-0.63375)+(1.32112-1.32100)+(0.84020-0.83986)+(140.990-140.923)
=-(-58)-(-28)-(-21)-(-26)+12+34+67
=246
5. Volume USD(O 3.12.29 20:01)= ((O 3.12.29 20:01)EU)+ ((O 3.12.29 20:01)GU)+ ((O 3.12.29 20:01)AU)+ ((O 3.12.29 20:01)NU)+ ((O 3.12.29 20:01)UC)+ ((O 3.12.29 20:01)UF)+ ((O 3.12.29 20:01)UJ)
=196+166+119+151+82+77+161
=952
Screenshots of the example: