{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["JOURNAL DE TRADING","PLAN DE TRADING"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"JOURNAL DE TRADING","index":0,"n_rows":38,"n_cols":37,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,2,27,12],[23,14,25,17],[23,18,25,18],[1,1,1,22],[3,2,3,11],[3,14,3,18]]}
[]
[null,"  JOURNAL DE TRADING (ACTIONS) : 2024"]
[]
[null,null,"ENTRÉE EN POSITION",null,null,null,null,null,null,null,null,null,null,null,"SORTIE DE POSITION",null,null,null,null,null,null,"COMMENTAIRES",null,null,null,null,null,null,null,null,null,null,"MENSUEL",null,"Vente partielle"]
[null,null,"Titre","Date","Niveau d'entrée","Stop","Stop en %","Nombre","ORDRE","DEVISE","PUBLICATION","Montant",null,null,"Date","Durée","Résultat","Frais","Gains/pertes",null,null,null,null,null,null,null,null,null,null,null,null,null,"HEBDO",null,"Vente totale"]
[null,1,"ACCOR","2019-03-26",36.81,38.35,{"$f":"IF(ISBLANK(F6),\"\",(F6/E6)-1)","v":4.1836457484379252E-2},81,"VENTE","€","2019-04-18",{"$f":"IF(J6=\"€\",E6*H6,E6*H6*$D$31)","v":2981.61},{"$f":"S6","v":-77.509999999999991},null,"2019-04-03",{"$f":"O6-D6","v":8},-57.51,-20,{"$f":"R6+Q6","v":-77.509999999999991},{"$f":"S6","v":-77.509999999999991},null,"Vente prise trop tard, aurait du prendre le 22 (absent) ou ne rien prendre compte tenu du CAC en remonté.",null,null,null,null,null,null,null,null,null,null,"DAILY",null,"Renfort"]
[null,4,"ALPHABET","2019-04-01",1191.1400000000001,1159,-2.6982554527595459E-2,4,"ACHAT","$","2019-04-29",{"$f":"IF(J7=\"€\",E7*H7,E7*H7*$D$31)","v":4192.8128000000006},{"$f":"S7","v":32.050000000000004},null,"2019-04-08",{"$f":"O7-D7","v":7},35.950000000000003,-3.9,32.050000000000004,{"$f":"S7+#REF!","v":{"$error":"#REF!"}},null,"Taux de change important le dernier jour",null,null,null,null,null,null,null,null,null,null,"M1",null,"ACHAT","CONTRE TENDANCE","NON"]
[null,5,"NEUROCRINE BIOSCIENCE","2019-04-02",90,84.34,-6.2888888888888883E-2,23,"ACHAT","$","2019-05-02",{"$f":"IF(J8=\"€\",E8*H8,E8*H8*$D$31)","v":1821.6},-29.81,null,"2019-04-04",{"$f":"O8-D8","v":2},-25.91,-3.9,-29.81,null,null,"Doit suivre et tracer niveaux en M15 sur position courte.",null,null,null,null,null,null,null,null,null,null,"FIGURE / SUPPORT",null,null,null,"OUI"]
[null,6,"DISCOVERY INC","2019-04-10",27.36,26.5,-3.1432748538011701E-2,151,"ACHAT","$","2019-05-02",3635.5967999999998,145.4,null,"2019-04-10",1,149.30000000000001,-3.9,145.4,{"$f":"S14+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,7,"APPLE","2019-04-16",199.73,198.28,-7.259800730986754E-3,35,"ACHAT","$","2019-04-30",6151.6839999999993,282.90000000000003,null,"2019-04-23",{"$f":"O10-D10","v":7},286.8,-3.9,282.90000000000003,{"$f":"S15+T9","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$"]
[null,8,"AIRBUS","2019-04-17",118.72,117.28,-1.212938005390829E-2,44,"ACHAT","€","2019-04-30",5223.68,-25.759999999999998,null,"2019-04-18",{"$f":"O11-D11","v":1},-15.84,{"$f":"-4.96*2","v":-9.92},-25.759999999999998,{"$f":"S11+T10","v":{"$error":"#REF!"}},null,"Ne pas anticiper le marché, tenir sa ligne de progression.",null,null,null,null,null,null,null,null,null,null,null,null,null,"SORTI"]
[null,9,"LIBERTY GLOBAL","2019-04-22",27.68,26.61,-3.8656069364161882E-2,123,"ACHAT","$","2019-05-06",2996.0832,-41.41,null,"2019-04-23",{"$f":"O12-D12","v":1},-37.51,-3.9,-41.41,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON SORTI"]
[null,10,"VMWARE","2019-04-22",190.32,183,-3.8461538461538436E-2,18,"ACHAT","$","2019-05-30",3014.6687999999999,159.72,null,"2019-04-24",{"$f":"O13-D13","v":2},163.62,-3.9,159.72,{"$error":"#REF!"}]
[null,11,"TAKEAWAY","2019-04-23",76.400000000000006,73.099999999999994,-4.3193717277487109E-2,35,"ACHAT","€","2019-05-15",2674,38.1,null,"2019-04-26",{"$f":"O14-D14","v":3},42,-3.9,38.1,{"$f":"#REF!+T13","v":{"$error":"#REF!"}}]
[null,12,null,null,null,null,null,null,null,null,null,0,{"$f":"S15","v":0},null,null,null,null,null,null,{"$f":"#REF!+T14","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,"WIN",{"$f":"COUNTIF(S6:S25,\">5\")","v":6}]
[null,13,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,"LOST",{"$f":"COUNTIF(S6:S25,\"<-5\")","v":4}]
[null,14,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,"NEUTRAL",{"$f":"COUNTIF(S6:S25,\"<5\")-AH16","v":0}]
[null,15,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,16,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,17,null,null,null,null,null,null,null,null,null,0,{"$f":"S20","v":0}]
[null,18,null,null,null,null,null,null,null,null,null,0,0]
[null,19,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEBDO"]
[null,20,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performance mensuelle",null,null,null,{"$f":"SUM(S6:S23)","v":483.68000000000018}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S25+T19","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"INDICATEURS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BILAN :\n"]
[]
[]
[null,null,"Taux change $/€",0.88,null,null,null,"Gain moyen trade gagnant",null,{"$f":"AVERAGEIF(S6:S23,\">5\")","v":131.63400000000001}]
[null,null,null,null,null,null,null,"Gain moyen trade perdant",null,{"$f":"AVERAGEIF(S6:S25,\"<5\")","v":-43.622499999999995}]
[]
[null,null,"Capital précédent",15000,null,null,null,"Gain par trade",null,{"$f":"AVERAGE(S6:S16)","v":53.742222222222239}]
[null,null,"Capital actuel",{"$f":"D34+S24","v":15483.68}]
[null,null,"Evolution",{"$f":"D35-D34","v":483.68000000000029},null,null,null,"Durée moyenne du trade",null,{"$f":"AVERAGE(P6:P25)","v":3.5555555555555554}]
[]
[null,null,"Rentabilité mensuelle",{"$f":"D36/D34","v":3.2245333333333355E-2}]

{"sheet":"PLAN DE TRADING","index":1,"n_rows":46,"n_cols":29,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,14,1,17],[20,15,20,18],[7,13,7,15],[9,13,9,15],[11,13,11,15],[5,13,5,14]]}
[]
[null,null,"PLAN DE  TRADING (H1 / H4 / DAILY)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-04-12"}]
[]
[]
[]
[null,"1.","EVALUER LES PERTURBATIONS ECONOMIQUES (NEWS / 3 - 4 SORCIERES)",null,null,null,"NON REALISÉ",null,{"$f":"IF(G6=\"NON REALISÉ\",0,1)","v":0},null,{"$f":"I8*I12*I10*I14","v":1},"SENS DE TRADING :",null,{"$f":"VLOOKUP(K6,Y15:AE35,2,FALSE)","v":"ACHAT"},null,{"$f":"IF(N6=\"ACHAT\",1,IF(N6=\"VENTE\",3,2))","v":1},null,null,null,null,null,null,null,"NON REALISÉ","HAUSSIÈRE","EXISTANT","RANG / CANAL","EN TENDANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAS DE NEWS","BAISSIÈRE","QUASI INEXISTANT","PROGRESSION / FLUX","EN CONTRE TENDANCE"]
[null,"2.","TENDANCE EN COURS (H1, H4)",null,null,null,"HAUSSIÈRE",null,{"$f":"IF(G8=\"HAUSSIÈRE\",1,2)","v":1},null,null,"OBJECTIF :",null,{"$f":"VLOOKUP(K6,Y15:AE35,3,FALSE)","v":"Dans le sens de la tendance"},null,null,null,null,null,null,null,null,null,"NEWS TRACÉES",null,null,"CONSOLIDATION"]
[]
[null,"3.","CARACTÉRISTIQUES TECHNIQUES",null,null,null,"PROGRESSION / FLUX",null,{"$f":"IF(G10=\"PROGRESSION / FLUX\",1,IF(G10=\"CONSOLIDATION\",7,5))","v":1},null,null,"METHODOLOGIE : ",null,{"$f":"VLOOKUP(K6,Y15:AE35,4,FALSE)","v":"Retracement 50% / Canaux / Open"}]
[]
[null,"4.","POTENTIEL DE CONTINUATION (BB / OBJECTIF)",null,null,null,"EXISTANT",null,{"$f":"IF(G12=\"EXISTANT\",1,3)","v":1},null,null,"POINTS DE VIGILANCE :",null,{"$f":"VLOOKUP(K6,Y15:AE35,5,FALSE)","v":"Invalidation de la progression"}]
[]
[null,"5.","INVALIDATION BRUTALE / DOUBLE TOP - BOTTOM / THEORIE DE DOW",null,null,null,"EN TENDANCE",null,{"$f":"IF(G14=\"EN TENDANCE\",1,10)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS DE TRADING ","OBJECTIF","METHODE","POINTS DE VIGILANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"ACHAT","Dans le sens de la tendance","Retracement 50% / Canaux / Open","Invalidation de la progression"]
[null,null,{"$f":"IF($AB$38=2,Z37,IF($AB$38=1,AA37,\"\"))","v":""},null,null,null,null,null,{"$f":"IF(C16=\"\",3,1)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"VENTE","Dans le sens de la tendance","Retracement 50% / Canaux / Open","Cycle / Invalidation / OPEN / NEWS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"ATTENTE","Repérer les invalidations pour chercher le reverse","Retracement 50% / Théorie de Dow","Cycle / Invalidation / OPEN / NEWS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"ATTENTE","Repérer les invalidations pour chercher le reverse","Retracement 50% / Théorie de Dow","Cycle / Invalidation / OPEN / NEWS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"NEUTRE","ACHAT jusqu'au haut de range / VENTE  jusqu'au bas de range","Retracement 50% / Théorie de Dow après confirmation du reverse","Bornage / Zone d'invalidation / Reprise de la tendance initiale."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"VENTE","Exploiter les consolidations ","Retracement 50% / Théorie de Dow","Potentiel de retracement / Zone d'invalidation. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"ACHAT","Reprise de tendance initiale","Retracement 50% / Canaux / Open","Invalidation de la consolidation (reprise baissière)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"VENTE","Reprise de tendance initiale","Retracement 50% / Canaux / Open","Invalidation de la consolidation (reprise haussière)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"NEUTRE","VENTE jusqu'au bas de range / ACHAT jusqu'au haut de range","Retracement 50% / Théorie de Dow après confirmation du reverse","Bornage / Zone d'invalidation / Reprise de la tendance initiale."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"NEUTRE"]
[null,null,"Cadrage global = Plan de trading pour support résistance / canaux / retracement en vue d'évaluer ou non un flux et une direction. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"ACHAT","Exploiter les consolidations ","Retracement 50% / Théorie de Dow","Potentiel de retracement / Zone d'invalidation. "]
[null,null,"Pendant la journée suivre le flux, repérer les changements (invalidation brutale / DT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"ATTENTE","Réévaluer la situation de marché","Vision H1 / H4","News / Ouverture / Zone de reprise"]
[null,null,"Evaluer le flux (fort : suivre / faible BB)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"ATTENTE","Réévaluer la situation de marché","Vision H1 / H4","News / Ouverture / Zone de reprise"]
[null,null,"Suivre les invalidations ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"VENTE","Exploiter la baisse après Open","Invalidation / OPEN sur retracement ","Bornage / Reprise tendance initiale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"ACHAT","Exploiter la hausse après Open","Invalidation / OPEN sur retracement ","Bornage / Reprise tendance initiale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"VENTE ","Jouer le reverse s'il se présente","Invalidation / OPEN sur retracement ","Bornage / Reprise tendance initiale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"ACHAT","Jouer le reverse s'il se présente","Invalidation / OPEN sur retracement ","Bornage / Reprise tendance initiale"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 4 sorcières ","Jour des 3 sorcières "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB39:AB46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 4 sorcières ","2019-06-21",{"$f":"IF(AA39=$O$2,2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 3 sorcières ","2019-07-19",{"$f":"IF(AA40=$O$2,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 3 sorcières ","2019-08-16",{"$f":"IF(AA41=$O$2,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 4 sorcières ","2019-09-20",{"$f":"IF(AA42=$O$2,2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 3 sorcières ","2019-10-18",{"$f":"IF(AA43=$O$2,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 3 sorcières ","2019-11-15",{"$f":"IF(AA44=$O$2,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 4 sorcières ","2019-12-20",{"$f":"IF(AA45=$O$2,2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour des 3 sorcières ","2020-01-17",{"$f":"IF(AA46=$O$2,1,0)","v":0}]