Specifiche
a.) My current Script can do the Followings, 1.a) Create an index; 1.b) Create a custom configuration chart.
b.) What I want is use Custom Formula and make an average index
1.0) Index Initial Value=30.66723251(Use Common initial value)
Coefficients= Index1(0.159);Index2(0.155);Index3(0.143); Index4(0.148);Index5(0.135); Index6(0.132); Index7(0.128)[we will use Common coefficients]
Avg Index = 30.66723251 × [EURx^0.159 × GBPx^0.155 × JPYx^0.143 × USDx^0.148 × CADx^0.135 × NZDx^0.132 × CHFx^0.128] / 7
Notes: Index1=EURx; Index2=GBPx; Index3=JPYx; Index4=USDx; Index5=CADx; Index6=NZDx; Index7=CHFx
c.) Then we will configure another custom charts whereby we will say
1.) APXEUR=Avg Index/EUR Index; 2.) APXGBP=Avg Index/GBP Index; 3.) APXJPY=Avg Index/JPY Index;
4.) APXUSD=Avg Index/USD Index; 5.) APXCAD=Avg Index/CAD Index; 6.) APXNZD=Avg Index/NZD Index; 7.) APXCHF=Avg Index/CHF Index
d.) Then we will try to create custom Avg of APX say
"APX Avg"=APXCAD+APXCHF+APXEUR+APXGBP+APXNZD+APXJPY+APXUSD/7
e.) Then we will try to find the value of LNC per Fait of currencies in our index pairs.
1.a)LNCEUR=Avg Index-EUR Index]/2, 1.b) LNCGBP=Avg Index-GBP Index]/2, 1.c) LNCJPY=Avg Index-JPY Index]/2, 1.d) LNCUSD=Avg Index-USD Index]/2,
1.e)LNCCAD=Avg Index-CAD Index]/2, 1.f)LNCNZD=Avg Index-NZD Index]/2, 1.g)LNCCHF=Avg Index-CHF Index]/2
f.)Then we find LNC Avg and say
"LNC Avg"=LNCEUR+LNCGBP+LNCJPY+LNCUSD+LNCCAD+LNCNZD+LNCCHF/7
Then we make our Structured Currency by Arithmetic means
APXLNC=[APX Avg + LNC Avg]/2
----------------------------------------------------------------------------------------------------------------------------------------------------------------
2.0) So we will also make APXXAU
Index Initial Value=30.66723251( common initial value)
XAUEUR(-0.159), XAUGBP(-0.155), XAUJPY(0.143), XAUCAD(0.135), XAUCHF(0.128), XAUNZD(0.132), XAUUSD(0.148)
Avg Index(XAU)=30.66723251 × [XAUEUR^0.159 × XAUGBP^0.155 × XAUJPYx^0.143 × XAUUSD^0.148 × XAUCAD^0.135 × XAUNZD^0.132 × XAUCHF^0.128] / 7
ZAP Gold Index Pairs:
ZAPUSD=Avg Price(XAU)/XAUUSD; ZAPEUR=Avg Price(XAU)/XAUEUR; ZAPGBP=Avg Price(XAU)/XAUGBP; ZAPJPY=Avg Price(XAU)/XAUJPY; ZAPCAD=Avg Price(XAU)/XAUCAD;
ZAPCHF=Avg Price(XAU)/XAUCHF; ZAPNZD=Avg Price(XAU)/XAUNZD;
Structured Avg Index:
ZAP Avg Price=ZAPUSD+ZAPEUR+ZAPGBP+ZAPJPY+ZAPCAD+ZAPCHF+ZAPNZD/7
Structured LPO Index:
LPOUSD=[Avg Index(XAU)-USD Index]/2 ; LPOEUR= [Avg Index(XAU)-EUR Index]/2 ; LPOGBP= [Avg Index(XAU)-GBP Index]/2 ; LPOJPY= [Avg Index(XAU)-JPY Index]/2 ;
LPOCAD= [Avg Index(XAU)-CAD Index]/2 ; LPOCHF= [Avg Index(XAU)-CHF Index]/2 ; LPONZD= [Avg Index(XAU)-NZD Index]/2
Structed LPO Avg Index
LPO Avg Index= LPOUSD+LPOEUR+LPOGBP+LPOJPY+LPOCAD=+LPOCHF+LPONZD/7
Then we make our Structured Gold by Arithmetic means
APX/XAU= [ZAP Avg Price + LPO Avg Index]/2
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3.0)So we will also make APXXAG(Silver)
Index Initial Value=30.66723251
XAGEUR(0.159), XAGGBP(0.155), XAGJPY(0.143), XAGCAD(0.135), XAGCHF(0.128), XAGNZD(0.132), XAGUSD(0.148)
Avg Index(XAG)=30.66723251 × [XAGEUR^0.159 × XAGGBP^0.155 × XAGJPYx^0.143 × XAUGSD^0.148 × XAGCAD^0.135 × XAGNZD^0.132 × XAGCHF^0.128] / 7
GAP Silver Index Pairs:
GAPUSD=Avg Index(XAG)/XAGUSD; GAPEUR= Avg Index(XAG) /XAGEUR; GAPGBP= Avg Index(XAG)/XAGGBP; GAPJPY= Avg Index(XAG)/XAGJPY;
GAPCAD= Avg Index(XAG)/XAGCAD; GAPCHF= Avg Index(XAG)/XAGCHF; GAPNZD= Avg Index(XAG)/XAGNZD
Structured Silver Avg Index:
GAP Avg =GAPUSD+GAPEUR+GAPGBP+GAPJPY+GAPCAD+GAPCHF+GAPNZD/7
Structured LNP Index:
LNPUSD= Avg Index(XAG)-USD Index]/2 ; LNPEUR= Avg Index(XAG)-EUR Index]/2 ; LNPGBP= Avg Index(XAG)-GBP Index]/2 ;LNPJPY= Avg Index(XAG)-JPY Index]/2 ;
LNPCAD= Avg Index(XAG)-CAD Index]/2; LNPCHF= Avg Index(XAG)-CHF Index]/2 ; LNPNZD= Avg Index(XAG)-NZD Index]/2
Structed LPN Index(Silver)
LPN Avg = LNPUSD+LNPEUR+LNPGBP+LNPJPY+LNPCAD=+LNPCHF+LNPNZD/7
Then we make our Structured Silver by Arithmetic means
APX/XAG=[GAP Avg + LNP Avg]/2
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4.0) APXBTC Configuration
Index Initial Value=30.66723251
BTCEUR(0.159);BTCGBP(0.155);BTCJPY(0.143); BTCUSD(0.148);BTCCAD(0.135); BTCNZD(0.132); BTCCHF(0.128)
Avg Index(BTC) = 30.66723251 × [ BTCEUR^0.159 × BTCGBP^0.155 × BTCJPY^0.143 × BTCUSD^0.148 × BTCCAD^0.135 × BTCNZD^0.132 × BTCCHF^0.128] / 7
APXCAX=Avg Index(BTC)/BTCCAD; APXCHX= Avg Index(BTC)/BTCCHF; APXEUX= Avg Index(BTC)/BTCEUR; APXGBX= Avg Index(BTC)/BTCGBP;
APXJPX= Avg Index(BTC)/BTCJPY; APXNZX= Avg Index(BTC)/BTCNZD; APXUSX= Avg Index(BTC)/BTCUSD
APX Avg(BTC)=APXCAX+APXCHX+APXEUX+APXGBX+APXJPX+APXNZX+APXUSX/7
LNCCAX=Avg Index(BTC)-CAD Index]/2 ; LNCCHX= Avg Index(BTC)-CHF Index]/2 ; LNCUEX= Avg Index(BTC)-EUR Index]/2 ; LNCGBX= Avg Index(BTC)-GBP Index]/2 ;
LNCJPX= Avg Index(BTC)-JPY Index]/2 ; LNCNZX= Avg Index(BTC)-NZD Index]/2 ; LNCUSX= Avg Index(BTC)-USD Index]/2
Structed LNC Index(BTC)
LNC Avg(BTC) =LNCCAX+LNCCHX+LNCEUX+LNCGBX+LNCJPX+LNCNZX+LNCUSX/7
Then we make our Structured BTC by Arithmetic means
APXBTC=[APX Avg(BTC) + LNC Avg(BTC)]/2
----------------------------------------------------------------------------------------------
The end ...................