Bonjour à tous.
Voici un petit indicateur codé maison pour faire apparaitre les niveaux futur sur le cash.
//valeurs à modifier
hautmois=13311.5 //haut mois précedént futur
basmois=11797 // bas mois précédent futur
cloturemois=13308.2 // cloture mois précédent futur
hautsemaine=13298.5 // haut semaine porécédente futur
bassemaine=12982.8 // bas semaine précédente futur
cloturesemaine=13074 // cloture semaine précédente futur
hautjour=13330.9 // haut jour précédente futur
basjour=12952 // bas jour précédent futur
cloturejour=13201 // Cloture jour précédent futur
de=76.2 // Delta entre cours futur et cash ( futur - cash)
a= 12500 // nombre de départ calcul niveau psychologique (se fini obligatoirement par 250/500/750/1000)
//code (ne pas toucher)
aa=a-de
b = a + 50 -de
c = a + 100 -de
d = a + 150-de
e = a + 200-de
f = a + 250-de
g = a + 300-de
hh = a + 350-de
ii = a + 400-de
j = a + 450-de
k = a + 500-de
l = a + 550-de
m = a + 600-de
n = a + 650-de
o = a + 700-de
p = a + 750-de
q = a + 800-de
r = a + 850-de
s = a + 900-de
t = a + 950-de
u = a + 1000-de
v = a + 1050-de
w = a + 1100-de
x = a + 1150-de
y = a + 1200-de
z = a + 1250-de
hautmoiss=hautmois-de
basmoiss=basmois-de
cloturemoiss=cloturemois-de
hautsemaines=hautsemaine-de
bassemaines=bassemaine-de
cloturesemaines=cloturesemaine-de
hautjours=hautjour-de
basjours=basjour-de
cloturejours=cloturejour-de
//pivot mensuel
mPiv=(hautmoiss+basmoiss+cloturemoiss)/3
//support mensuel
mS1m=(mpiv+ms1)/2
mS1=(mpiv*2)-hautmoiss
ms2m=(ms1+ms2)/2
ms2=mpiv-(hautmoiss-basmoiss)
ms3m=(ms2+ms3)/2
ms3=basmoiss-2*(hautmoiss-mpiv)
//resistances mensuel
mr1m=(mpiv+mr1)/2
mr1=(mpiv*2)-basmoiss
mr2m=(mr1+mr2)/2
mr2=mpiv+(hautmoiss-basmoiss)
mr3m=(mr2+mr3)/2
mr3=hautmoiss+2*(mpiv-basmoiss)
//pivot semaines
sPiv=(hautsemaines+bassemaines+cloturesemaines)/3
//support mensuel
sS1m=(spiv+ss1)/2
sS1=(spiv*2)-hautsemaines
ss2m=(ss1+ss2)/2
ss2=spiv-(hautsemaines-bassemaines)
ss3m=(ss2+ss3)/2
ss3=bassemaines-2*(hautsemaines-spiv)
//resistances mensuel
sr1m=(spiv+sr1)/2
sr1=(spiv*2)-bassemaines
sr2m=(sr1+sr2)/2
sr2=spiv+(hautsemaines-bassemaines)
sr3m=(sr2+sr3)/2
sr3=hautsemaines+2*(spiv-bassemaines)
//pivot jour
jPiv=(hautjours+basjours+cloturejours)/3
//support mensuel
jS1m=(jpiv+js1)/2
jS1=(jpiv*2)-hautjours
js2m=(js1+js2)/2
js2=jpiv-(hautjours-basjours)
js3m=(js2+js3)/2
js3=basjours-2*(hautjours-jpiv)
//resistances mensuel
jr1m=(jpiv+jr1)/2
jr1=(jpiv*2)-basjours
jr2m=(jr1+jr2)/2
jr2=jpiv+(hautjours-basjours)
jr3m=(jr2+jr3)/2
jr3=hautjours+2*(jpiv-basjours)
return aa as "0",b as " 50 " ,c as " 100 " ,d as " 150 " ,e as " 200 " ,f as " 250 " ,g as " 300 " ,hh as " 350 " ,ii as " 400 " ,j as " 450 " ,k as " 500 " ,l as " 550 " ,m as " 600 " ,n as " 650 " ,o as " 700 " ,p as " 750 " ,q as " 800 " ,r as " 850 " ,s as " 900 " ,t as " 950 " ,u as " 1000 " ,v as " 1050 " ,w as " 1100 " ,x as " 1150 " ,y as " 1200 " ,z as " 1250 ", mpiv as"mpiv",ms1m as "ms1m", ms1 as "ms1", ms2m as "ms2m", ms2 as "ms2", ms3m as "ms3m", ms3 as "ms3", mr1m as "mr1m", mr1 as "mr1", mr2m as "mr2m", mr2 as "mr2", mr3m as "mr3m", mr3 as "mr3",spiv as"spiv",ss1m as "ss1m", ss1 as "ss1", ss2m as "ss2m", ss2 as "ss2", ss3m as "ss3m", ss3 as "ss3", sr1m as "sr1m", sr1 as "sr1", sr2m as "sr2m", sr2 as "sr2", sr3m as "sr3m", sr3 as "sr3",jpiv as"jpiv",js1m as "js1m", js1 as "js1", js2m as "js2m", js2 as "js2", js3m as "js3m", js3 as "js3", jr1m as "jr1m", jr1 as "jr1", jr2m as "jr2m", jr2 as "jr2", jr3m as "jr3m", jr3 as "jr3",hautmoiss as "hautmois", hautsemaines as "hautsemaine", hautjours as "hautjour", basmoiss as "basmois", bassemaines as "bassemaine", basjours as "basjour", cloturemoiss as "cloturemois", cloturesemaines as "cloturesemaine", cloturejours as "cloturejour"
Je vais vous expliquer comment l'installer si ça vous intéresse.
Bonne journée
Ronan
Voici un petit indicateur codé maison pour faire apparaitre les niveaux futur sur le cash.
//valeurs à modifier
hautmois=13311.5 //haut mois précedént futur
basmois=11797 // bas mois précédent futur
cloturemois=13308.2 // cloture mois précédent futur
hautsemaine=13298.5 // haut semaine porécédente futur
bassemaine=12982.8 // bas semaine précédente futur
cloturesemaine=13074 // cloture semaine précédente futur
hautjour=13330.9 // haut jour précédente futur
basjour=12952 // bas jour précédent futur
cloturejour=13201 // Cloture jour précédent futur
de=76.2 // Delta entre cours futur et cash ( futur - cash)
a= 12500 // nombre de départ calcul niveau psychologique (se fini obligatoirement par 250/500/750/1000)
//code (ne pas toucher)
aa=a-de
b = a + 50 -de
c = a + 100 -de
d = a + 150-de
e = a + 200-de
f = a + 250-de
g = a + 300-de
hh = a + 350-de
ii = a + 400-de
j = a + 450-de
k = a + 500-de
l = a + 550-de
m = a + 600-de
n = a + 650-de
o = a + 700-de
p = a + 750-de
q = a + 800-de
r = a + 850-de
s = a + 900-de
t = a + 950-de
u = a + 1000-de
v = a + 1050-de
w = a + 1100-de
x = a + 1150-de
y = a + 1200-de
z = a + 1250-de
hautmoiss=hautmois-de
basmoiss=basmois-de
cloturemoiss=cloturemois-de
hautsemaines=hautsemaine-de
bassemaines=bassemaine-de
cloturesemaines=cloturesemaine-de
hautjours=hautjour-de
basjours=basjour-de
cloturejours=cloturejour-de
//pivot mensuel
mPiv=(hautmoiss+basmoiss+cloturemoiss)/3
//support mensuel
mS1m=(mpiv+ms1)/2
mS1=(mpiv*2)-hautmoiss
ms2m=(ms1+ms2)/2
ms2=mpiv-(hautmoiss-basmoiss)
ms3m=(ms2+ms3)/2
ms3=basmoiss-2*(hautmoiss-mpiv)
//resistances mensuel
mr1m=(mpiv+mr1)/2
mr1=(mpiv*2)-basmoiss
mr2m=(mr1+mr2)/2
mr2=mpiv+(hautmoiss-basmoiss)
mr3m=(mr2+mr3)/2
mr3=hautmoiss+2*(mpiv-basmoiss)
//pivot semaines
sPiv=(hautsemaines+bassemaines+cloturesemaines)/3
//support mensuel
sS1m=(spiv+ss1)/2
sS1=(spiv*2)-hautsemaines
ss2m=(ss1+ss2)/2
ss2=spiv-(hautsemaines-bassemaines)
ss3m=(ss2+ss3)/2
ss3=bassemaines-2*(hautsemaines-spiv)
//resistances mensuel
sr1m=(spiv+sr1)/2
sr1=(spiv*2)-bassemaines
sr2m=(sr1+sr2)/2
sr2=spiv+(hautsemaines-bassemaines)
sr3m=(sr2+sr3)/2
sr3=hautsemaines+2*(spiv-bassemaines)
//pivot jour
jPiv=(hautjours+basjours+cloturejours)/3
//support mensuel
jS1m=(jpiv+js1)/2
jS1=(jpiv*2)-hautjours
js2m=(js1+js2)/2
js2=jpiv-(hautjours-basjours)
js3m=(js2+js3)/2
js3=basjours-2*(hautjours-jpiv)
//resistances mensuel
jr1m=(jpiv+jr1)/2
jr1=(jpiv*2)-basjours
jr2m=(jr1+jr2)/2
jr2=jpiv+(hautjours-basjours)
jr3m=(jr2+jr3)/2
jr3=hautjours+2*(jpiv-basjours)
return aa as "0",b as " 50 " ,c as " 100 " ,d as " 150 " ,e as " 200 " ,f as " 250 " ,g as " 300 " ,hh as " 350 " ,ii as " 400 " ,j as " 450 " ,k as " 500 " ,l as " 550 " ,m as " 600 " ,n as " 650 " ,o as " 700 " ,p as " 750 " ,q as " 800 " ,r as " 850 " ,s as " 900 " ,t as " 950 " ,u as " 1000 " ,v as " 1050 " ,w as " 1100 " ,x as " 1150 " ,y as " 1200 " ,z as " 1250 ", mpiv as"mpiv",ms1m as "ms1m", ms1 as "ms1", ms2m as "ms2m", ms2 as "ms2", ms3m as "ms3m", ms3 as "ms3", mr1m as "mr1m", mr1 as "mr1", mr2m as "mr2m", mr2 as "mr2", mr3m as "mr3m", mr3 as "mr3",spiv as"spiv",ss1m as "ss1m", ss1 as "ss1", ss2m as "ss2m", ss2 as "ss2", ss3m as "ss3m", ss3 as "ss3", sr1m as "sr1m", sr1 as "sr1", sr2m as "sr2m", sr2 as "sr2", sr3m as "sr3m", sr3 as "sr3",jpiv as"jpiv",js1m as "js1m", js1 as "js1", js2m as "js2m", js2 as "js2", js3m as "js3m", js3 as "js3", jr1m as "jr1m", jr1 as "jr1", jr2m as "jr2m", jr2 as "jr2", jr3m as "jr3m", jr3 as "jr3",hautmoiss as "hautmois", hautsemaines as "hautsemaine", hautjours as "hautjour", basmoiss as "basmois", bassemaines as "bassemaine", basjours as "basjour", cloturemoiss as "cloturemois", cloturesemaines as "cloturesemaine", cloturejours as "cloturejour"
Je vais vous expliquer comment l'installer si ça vous intéresse.
Bonne journée
Ronan
Fichiers joints
