{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Accueil","Bureau Direction","Comptabilité","Information","Portefeuille","   Presse    ","L"],"not_rendered":{"charts":4,"images":47,"macros":1,"external_links":0,"defined_names":38,"comments":1,"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":"Accueil","index":0,"n_rows":41,"n_cols":34,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,7,14,12],[1,7,2,12],[3,7,5,12],[6,7,9,12],[10,7,12,12],[26,0,26,2],[39,4,39,7],[28,1,28,3],[17,9,18,12],[34,2,34,4],[35,7,35,8],[19,11,19,12],[20,11,20,12],[31,8,31,11],[34,9,34,11],[35,9,35,11],[27,10,29,10]]}
[]
[null,1,false,0,null,1,null,"Jeu de bourse"]
[null,null,2]
[null,null,null,null,null,null,null,"Vous pouvez exercer vos talents de financier sur ce programme de simulation boursière."]
[]
[]
[null,null,null,null,null,null,null,"Vous devez créer un portefeuille de titres et le gérer pendant une année. Spéculation ou placement de père de famille ?",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,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,null,null,2]
[null,null,null,null,null,null,null,"Vous disposez de CHF 50'000.-.  La partie se déroule en 12 mois pendant lesquels vous donnez autant d'ordres de bourse que vous le souhaitez."]
[]
[]
[null,null,null,null,null,null,null,"De 1 à 2 joueurs peuvent participer : le plus riche en fin d'année a gagné, bien sûr !"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Ecivez ici le nom des investisseurs"]
["  Chaque mois le financier doit acheter et (ou) vendre des titres:"]
[null,"1) Choisir des titres parmi une offre de 4 actions, 1 obligation et 2 warrants.",null,null,null,null,null,null,null,"Joueur",1,"Julius"]
[null,"2) Déterminer la quantité de titres à traiter en fonction des cours du jour et des liquidités à disposition.",null,null,null,null,null,null,null,"Joueur",2,"Baer"]
[null,"3) Pour les baissiers, vendre à découvert dans les limitées de la garantie de CHF 50'000.-."]
[null,"4) Emprunter en cas de \"coup dur\" sur une opération à terme."]
[null,"5) Suivre l'évolution de son portefeuille sur les graphiques et définir des stratégies en fonction des tendances."]
[]
[]
["  Rôle des icônes dans le jeu :",null,null,null,"passer au mois suivant"]
[null,null,null,null,null,null,null,"Consulter la  comptabilité",null,null,"Nouvelle cote"]
[null,"                         obtenir des renseignements",null,null,null,null,null,"et voir le portefeuille"]
[]
[null,null,null,null,null,"Voir les graphiques"]
[null,null,null,"Valider ",null,null,null,null,"     Recommencer une nouvelle partie"]
[null,null,null,null,null,"Cacher les graphiques"]
[]
[null,null,"     Cliquer ici pour  jouer !",null,null,null,null,null,null,"Voir les commentaires"]
[null,null,null,null,null,null,null,"        Lire la presse",null,null,null,null,"Pour quitter le jeu"]
[]
[]
[]
[null,null,null,null,"Retour ici grâce à la fenêtre du bureau du patron !"]
[null,null,null,null,null,null,null,null,null,null,null,"Version","3  - 30.05.2015"]

{"sheet":"Bureau Direction","index":1,"n_rows":97,"n_cols":91,"rows_kept":97,"cut":false,"hidden":false,"merged":[[26,80,26,81],[38,80,38,81],[19,80,21,80],[19,79,21,79],[13,57,14,57],[13,21,13,22],[28,25,28,28],[7,23,7,24],[9,24,9,25],[8,23,8,25],[7,19,7,21],[0,4,0,21],[3,16,3,18],[4,8,4,9],[4,10,4,11],[4,12,4,13],[36,3,36,4],[15,0,15,1],[10,24,10,25],[10,22,10,23],[11,3,11,4],[10,9,10,11],[12,9,12,11],[19,4,20,6],[19,7,20,9],[12,21,12,22],[0,22,0,23],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[5,10,5,11],[5,12,5,13],[9,16,9,18],[7,10,7,11],[38,5,38,8],[36,5,36,8],[37,5,37,8],[15,17,15,18],[16,17,16,18],[17,17,17,18],[33,5,35,8],[17,7,17,9],[19,10,20,11],[15,13,15,16],[45,38,45,39],[14,21,14,22],[13,19,13,20],[14,19,14,20],[26,25,26,28],[15,21,15,22],[29,25,29,28],[17,21,17,22],[27,25,27,28],[27,33,27,34],[18,21,18,22],[17,19,17,20],[18,19,18,20],[1,8,1,9],[1,10,1,11],[1,12,1,13],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[7,8,7,9],[5,16,5,18],[6,16,6,18],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[7,12,7,13],[7,14,7,15],[2,16,2,18],[7,16,7,18],[4,14,4,15],[4,16,4,18],[6,8,6,9],[6,10,6,11],[5,8,5,9],[6,12,6,13],[1,19,1,21],[2,19,2,21],[3,19,3,21],[3,23,3,24],[1,14,1,15],[15,19,15,20],[1,16,1,18],[5,14,5,15],[9,19,9,21],[4,23,5,24],[4,19,4,21],[5,19,5,21],[6,19,6,21],[6,22,6,23],[3,22,5,22],[6,14,6,15],[8,19,8,21],[11,21,11,22],[9,22,9,23],[14,17,14,18],[12,13,12,16],[13,13,13,16],[18,13,18,16],[21,13,22,16],[20,14,20,16],[16,13,16,16],[17,13,17,16],[25,25,25,28],[18,17,18,18],[44,38,44,39],[8,16,8,18],[11,6,11,7],[12,3,12,8],[11,9,11,11],[18,8,18,9],[18,5,18,7],[13,9,13,11],[14,13,14,16],[11,13,11,16],[50,58,50,62],[24,13,24,16],[23,13,23,16],[12,17,12,18],[13,17,13,18],[16,21,16,22],[13,55,13,56],[10,31,13,31],[10,13,10,15],[26,31,26,34],[16,19,16,20],[11,19,11,20],[12,19,12,20],[11,17,11,18],[10,16,10,18],[43,40,43,53]]}
["SMI",{"$f":"VLOOKUP(8,Cote,AG2+2)","v":148.15},null,null,{"$f":"\"Portefeuille de  \"&VLOOKUP(AG3,Accueil!K20:M21,2)","v":"Portefeuille de  Julius"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"No \"&AG3","v":"No 1"},null,null,null,null,null,null,null,null,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,74,75,76,77,78,79,80,{"$f":"\"\"","v":""}]
[null,null,null,"min.",null,null,null,null,"Inventraire",null,"Acheté",null,"Vendu",null,"Prix moyen",null,"Valeur  ",null,null,"Situation",null,null,null,null,null,null,null,null,null,null,null,"Mois",1,null,null,null,"choix cote B/D",{"$f":"IF(AJ4=4,2,IF(AJ29=\"put\",2,1))","v":1},{"$f":"IF(AJ4=4,2,IF(AJ29=\"put\",2,1))","v":1},"Constantes mensuelles. Nom : Datamens",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,{"$f":"ROUNDUP((1000/R13),0)","v":63},{"$f":"AL11","v":"Abeco"},null,null,null,{"$f":"IF($AG$3=1,BB23,BB35)","v":0},null,{"$f":"IF($AG$3=1,BC23,BC35)","v":0},null,{"$f":"IF($AG$3=1,BD23,BD35)","v":0},null,{"$f":"IF($AG$3=1,IF(I3=0,\"\",BT23),IF(I3=0,\"\",BT35))","v":""},null,{"$f":"IF($AG$3=1,BU23,BU35)","v":0},null,null,{"$f":"IF($AG$3=1,CA23,CA35)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Joueur",1,{"$f":"IF(AG3=1,\"A actif\",\"B actif\")","v":"A actif"},"Voir com:",0,"Coef. Cote",{"$f":"IF(AG4<6,1,IF(AJ4=2,0.75,1))","v":1},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,null,null,null,null,"Pour le graphique : variation en %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tableau pour information. En vert le warrant serait exercé en mode américain",null,null,null,null,null,null,null,null,null,null,null,null,null,"31 déc.",null,"strick"]
[null,null,null,{"$f":"ROUNDUP((1000/R14),0)","v":1},"Bell & Cie",null,null,null,{"$f":"IF($AG$3=1,BB24,BB36)","v":0},null,{"$f":"IF($AG$3=1,BC24,BC36)","v":0},null,{"$f":"IF($AG$3=1,BD24,BD36)","v":0},null,{"$f":"IF($AG$3=1,IF(I4=0,\"\",BT24),IF(I4=0,\"\",BT36))","v":""},null,{"$f":"IF($AG$3=1,BU24,BU36)","v":0},null,null,{"$f":"IF($AG$3=1,CA24,CA36)","v":0},null,null,{"$f":"IF(AG2<13,\"Résultat virtuel des titres\",\"Résultat final des titres\")","v":"Résultat virtuel des titres"},{"$f":"HLOOKUP(AG2,Datamens,2)","v":"janvier"},null,null,{"$f":"IF(X5=31,\"Fin de partie\",\"\")","v":""},null,{"$f":"IF($AG$3=1,IF(AO$30=1,\"o\",\"\"),IF(AO$42=1,\"o\",\"\"))","v":""},null,null,"Titre choisi",{"$f":"AH4-1","v":0},1,null,{"$f":"IF(AG6=FALSE,AG5,AG5+2)","v":1},"légende :","achat",1,null,"janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre","décembre","FIN",null,null,null,null,null,"déc","jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc",null,null,"Bell","cours",{"$f":"AN$12","v":2330},2354,2401,2378,2615,2544,2568,2734,2758,2710,2568,2710,2829,null,"call"]
[null,null,null,{"$f":"ROUNDUP((1000/R15),0)","v":7},"Comon",null,null,null,0,null,0,null,0,null,"",null,{"$f":"IF($AG$3=1,BU25,BU37)","v":0},null,null,0,null,null,null,{"$f":"HLOOKUP(AG2,Datamens,3)","v":1},null,null,null,null,{"$f":"IF($AG$3=1,IF(AP$30=1,\"o\",\"\"),IF(AP$42=1,\"o\",\"\"))","v":""},null,null,"Achat/Vente",1,"Put:","Call :","Pr cote :","Ecran","vente",2,null,1,1,1,1,1,1,1,1,1,1,1,1,31,null,null,null,null,null,"Abeco",{"$f":"AN11*100/AN11","v":100},{"$f":"IF(BH$13=0,BH5,AO11*100/$AN11)","v":100},{"$f":"IF(BI$13=0,BI5,AP11*100/$AN11)","v":100},100,100,100,100,100,100,100,100,100,100,null,null,null,"équart",{"$f":"BY4-$CM$5","v":-270},{"$f":"BZ4-$CM$5","v":-246},-199,-222,15,-56,-32,134,158,110,-32,110,229,null,{"$f":"(ROUNDUP(BB12/100,0)*100)","v":2600}]
[null,null,null,{"$f":"ROUNDUP((1000/R16),0)","v":2},"Divogan",null,null,null,0,null,0,null,0,null,"",null,{"$f":"IF($AG$3=1,BU26,BU38)","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"IF($AG$3=1,IF(AQ$30=1,\"o\",\"\"),IF(AQ$42=1,\"o\",\"\"))","v":""},null,null,"Option",false,0,{"$f":"IF(AG6=FALSE,0,IF(AG5=1,1,0))","v":0},{"$f":"IF(AG4<6,AH6,IF(AJ4=4,1,AH6))","v":0},{"$f":"IF(AI6=1,\"call\",\"put\")","v":"put"},"Call",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bell & Cie",{"$f":"AN12*100/AN12","v":100},{"$f":"IF(BH$13=0,BH6,AO12*100/$AN12)","v":101.03004291845494},{"$f":"IF(BI$13=0,BI6,AP12*100/$AN12)","v":101.03004291845494},101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,101.03004291845494,null,null,"Divo","cours",{"$f":"AN$14","v":580},591,569,597,603,574,540,523,574,540,529,534,529,null,{"$f":"(ROUNDUP(BB14/100,0)*100)+20","v":620}]
[null,null,null,{"$f":"ROUNDUP((1000/R17),0)","v":1},"Oblig. Emotion",null,null,null,0,null,0,null,0,null,"",null,{"$f":"IF($AG$3=1,BU27,BU39)","v":0},null,null,0,null,null,{"$f":"SUM(T3:T7)","v":0},null,null,null,null,null,{"$f":"IF($AG$3=1,IF(AR$30=1,\"o\",\"\"),IF(AR$42=1,\"o\",\"\"))","v":""},null,null,"Graph1","0 ou 1",0,"Travaux",0,null,"Put",4,"COTE","Nom : Cote",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comon",{"$f":"AN13*100/AN13","v":100},{"$f":"IF(BH$13=0,BH7,AO13*100/$AN13)","v":98.75},98.75,98.75,98.75,98.75,98.75,98.75,98.75,98.75,98.75,98.75,98.75,null,null,null,"équart",{"$f":"BY6-$CM$6","v":-40},{"$f":"BZ6-$CM$6","v":-29},-51,-23,-17,-46,-80,-97,-46,-80,-91,-86,-91]
[null,null,null,{"$f":"IF(R18=0,\"\",ROUNDUP((1000/R18),0))","v":15},"Warrant BELL",null,null,null,0,null,0,null,0,null,"",null,{"$f":"IF(AG2=13,0,IF(I8=0,0,I8*O8))","v":0},null,null,0,null,null,{"$f":"IF(T8<0,\"- prime\",\"\")","v":""},{"$f":"INT(BB18/20)","v":41},null,null,null,null,{"$f":"IF($AG$3=1,IF(AS$30=1,\"o\",\"\"),IF(AS$42=1,\"o\",\"\"))","v":""},null,null,"Graph2",0,0,"Champagne",0,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,null,null,null,"Divogan",{"$f":"AN14*100/AN14","v":100},{"$f":"IF(BH$13=0,BH8,AO14*100/$AN14)","v":101.89655172413794},101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,101.89655172413794,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,{"$f":"IF(R19=0,\"\",ROUNDUP((1000/R19),0))","v":28},"Warrant DIVO",null,null,null,0,null,0,null,0,null,"",null,{"$f":"IF(AG2=13,0,IF(I9=0,0,I9*O9))","v":0},null,null,0,null,null,{"$f":"IF(T9<0,\"- prime\",\"\")","v":""},{"$f":"IF(Y10=0,\"Résultat de la partie :\",IF(Y10>0,\"Bénéfice\",\"Perte\"))","v":"Résultat de la partie :"},null,null,null,null,{"$f":"IF($AG$3=1,IF(AT$30=1,\"o\",\"\"),IF(AT$42=1,\"o\",\"\"))","v":""},null,null,"Emprunt","Jou. A",0,"Jou. B",0,null,"Titres",null,"déc","jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc","(nov+déc)/2","Moy.",null,null,null,null,"Oblig. Emotion",100,{"$f":"IF(BH$13=0,BH9,AO15*100/$AN15)","v":101},101,101,101,101,101,101,101,101,101,101,101,null,null,"Bell","cours",{"$f":"AN$12","v":2330},2354,2401,2378,2615,2544,2568,2734,2758,2710,2568,2710,2829,null,"put"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q3:S9)","v":0},null,null,{"$f":"SUM(T3:V9)","v":0},null,null,{"$f":"J13","v":0},null,{"$f":"SUM(T10:X10)","v":0},null,null,null,{"$f":"IF($AG$3=1,IF(AU$30=1,\"o\",\"\"),IF(AU$42=1,\"o\",\"\"))","v":""},null,null,"Futur",{"$f":"IF(AG3=1,IF(AG5=1,0,IF(H20>VLOOKUP(AG4,Achat_vente_A,15),1,0)),   IF(AG5=1,0,IF(H20>VLOOKUP(AG4,Achat_Vente_B,15),1,0)))","v":0},"Test/inv",{"$f":"SUMIF(I3:I7,\"<0\")","v":0},{"$f":"IF(AI10<0,1,0)","v":0},null,"             T i t r e s ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,null,"SMI",100,{"$f":"AVERAGE(BI5:BI9)","v":100.53531892851856},{"$f":"AVERAGE(BJ5:BJ9)","v":100.53531892851856},100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,100.53531892851856,null,null,null,"équart",{"$f":"$CM$10-BY9","v":70},{"$f":"$CM$10-BZ9","v":46},-1,22,-215,-144,-168,-334,-358,-310,-168,-310,-429,null,{"$f":"(ROUNDUP(BB12/100,0)*100)-200","v":2400}]
[null,null,null,null,null,null,null,null,"  Ancien solde  ",{"$f":"IF($AG$3=1,N22-BC48,N22-BC58)","v":50000},null,null,null,{"$f":"IF(Q11=0,\"\",\"En compte :\")","v":""},null,null,{"$f":"ABS(SUMIF(Q3:Q7,\"<0\"))","v":0},null,null,null,null,null,"Actifs :",null,{"$f":"Q10+N22-N25","v":50000},null,null,null,{"$f":"IF($AG$3=1,IF(AV$30=1,\"o\",\"\"),IF(AV$42=1,\"o\",\"\"))","v":""},null,null,"Cycle L(I)",4,{"$f":"IF(AG11=1,\" =\", IF(AG11=2,\" -\",IF(AG11=3,\" +\",\" +-\")))","v":" +-"},null,null,1,"Abeco",1,16,16,16,15,19,20,18,15,16,15,20,20,18,{"$f":"(AY11+AZ11)/2","v":19},{"$f":"SUM(AN11:AZ11)/13","v":17.23076923076923},-1,null,null,null,"Option ABEC",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Divo","cours",{"$f":"AN$14","v":580},591,569,597,603,574,540,523,574,540,529,534,529,null,{"$f":"(ROUNDUP(BB14/100,0)*100)-20","v":580}]
[null,null,null,{"$f":"INT(H20)","v":0},null," x ",{"$f":"VLOOKUP(AG4,Cote,AG2+2)*AL3","v":0},null," = ",{"$f":"D12*G12","v":0},null,null,null,"COTE",null,null,null,"Cours",null,"Précéd.",null,"dif. en %",null,null,null,null,null,null,{"$f":"IF($AG$3=1,IF(AW$30=1,\"o\",\"\"),IF(AW$42=1,\"o\",\"\"))","v":""},null,null,null,1,{"$f":"IF(AG12=1,\" =\", IF(AG12=2,\" -\",IF(AG12=3,\" +\",\" +-\")))","v":" ="},null,null,2,"Bell & Cie",2,2330,2354,2401,2378,2615,2544,2568,2734,2758,2710,2568,2710,2829,{"$f":"(AY12+AZ12)/2","v":2769.5},{"$f":"SUM(AN12:AZ12)/13","v":2576.8461538461538},0,null,null,null,"Option DIVO",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"équart",{"$f":"$CM$11-BY11","v":0},{"$f":"$CM$11-BZ11","v":-11},11,-17,-23,6,40,57,6,40,51,46,51]
[null,null,null,"Dividendes et int. cumulés  ",null,null,null,null,null,{"$f":"IF($AG$3=1,BC48,BC58)","v":0},null,null,1,{"$f":"AL11","v":"Abeco"},null,null,null,{"$f":"VLOOKUP(1,Cote,$AG$2+2)","v":16},null,{"$f":"VLOOKUP(1,Cote,$AG$2+1)","v":16},null,{"$f":"(R13-T13)*100/T13","v":0},null,{"$f":"AH11","v":" +-"},null,null,null,null,{"$f":"IF($AG$3=1,IF(AX$30=1,\"o\",\"\"),IF(AX$42=1,\"o\",\"\"))","v":""},null,null,null,1,{"$f":"IF(AG13=1,\" =\", IF(AG13=2,\" -\",IF(AG13=3,\" +\",\" +-\")))","v":" ="},"Be 1=put","Di 1=put",3,"Comon",3,160,158,164,163,179,172,172,156,153,195,184,156,172,{"$f":"(AY13+AZ13)/2","v":164},{"$f":"SUM(AN13:AZ13)/13","v":168},0,null,null,null,"Mois OK",1,{"$f":"AO30+AO42","v":0},{"$f":"AP30+AP42","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,"Prochain solde ",{"$f":"IF(AG5=2,J11+J12+J13,J11-J12+J13)","v":50000},null,null,2,"Bell & Cie",null,null,null,{"$f":"VLOOKUP(2,Cote,$AG$2+2)","v":2354},null,{"$f":"VLOOKUP(2,Cote,$AG$2+1)","v":2330},null,1.0300429184549356,null,{"$f":"AH12","v":" ="},null,null,null,null,{"$f":"IF($AG$3=1,IF(AY$30=1,\"o\",\"\"),IF(AY$42=1,\"o\",\"\"))","v":""},null,null,null,2,{"$f":"IF(AG14=1,\" =\", IF(AG14=2,\" -\",IF(AG14=3,\" +\",\" +-\")))","v":" -"},0,0,4,"Divogan",4,580,591,569,597,603,574,540,523,574,540,529,534,529,{"$f":"(AY14+AZ14)/2","v":531.5},{"$f":"SUM(AN14:AZ14)/13","v":560.23076923076928},0,"Strick pour joueur",null,"Vente de warrent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Comon",null,null,null,{"$f":"VLOOKUP(3,Cote,$AG$2+2)","v":158},null,{"$f":"VLOOKUP(3,Cote,$AG$2+1)","v":160},null,-1.25,null,{"$f":"AH13","v":" ="},null,null,null,null,{"$f":"IF($AG$3=1,IF(AZ$30=1,\"o\",\"\"),IF(AZ$42=1,\"o\",\"\"))","v":""},null,null,null,null,"A",0,0,null,"Oblig. Emotion",5,{"$f":"100*50","v":5000},{"$f":"101*50","v":5050},{"$f":"101*50","v":5050},{"$f":"102*50","v":5100},{"$f":"102*50","v":5100},{"$f":"103*50","v":5150},5150,5150,5150,5150,5150,{"$f":"102*50","v":5100},{"$f":"102*50","v":5100},{"$f":"(AY15+AZ15)/2","v":5100},{"$f":"SUM(AN15:AZ15)/13","v":5107.6923076923076},0,"A","B",null,"Call",null,12,1,2,3,4,5,6,7,8,9,10,11,12,null,null,"Put",12,1,2,3,4,5,6,7,8,9,10,11,12]
["Charges et produits du mois",null,null,null,null,null,null,null,null,null,null,null,4,"Divogan",null,null,null,{"$f":"VLOOKUP(4,Cote,$AG$2+2)","v":591},null,{"$f":"VLOOKUP(4,Cote,$AG$2+1)","v":580},null,1.896551724137931,null,{"$f":"AH14","v":" -"},null,null,null,null,null,null,null,null,null,"B","Bell","Divo",null,"Warrant BELL",6,{"$f":"IF($AL$2=2,BY16,BI16)","v":67.2},{"$f":"IF($AL$2=2,BZ16,BJ16)","v":71.400000000000006},80.2,75,16.200000000000003,107,111.2,140.70000000000002,164.32,113.3,108.80000000000001,111.1,229,null,"strike :",{"$f":"IF(AJ6=1,(ROUNDUP(BB12/100,0)*100)-200,(ROUNDUP(BB12/100,0)*100))","v":2600},{"$f":"IF(AI14=1,(ROUNDUP(BB12/100,0)*100)-200,(ROUNDUP(BB12/100,0)*100))","v":2600},{"$f":"IF(AI15=1,(ROUNDUP(BB12/100,0)*100)-200,(ROUNDUP(BB12/100,0)*100))","v":2600},{"$f":"IF(AG6=TRUE,BC16,IF(AG3=1,BD16,BE16))","v":2600},"Warrant BELL",6,{"$f":"IF(AN12-$BC$16<10,  IF( ( (60*AN19)+ ( (AN12-$AN$12  )/5  ) )<10,10, ( (60*AN19)+ ( (AN12-$AN$12  )/5  ) )),(AN12-$BC$16)*AN19)","v":67.2},{"$f":"IF(AO12-$BC$16<10,  IF( ( (60*AO19)+ ( (AO12-$AN$12  )/5  ) )<10,10, ( (60*AO19)+ ( (AO12-$AN$12  )/5  ) )),(AO12-$BC$16)*AO19)","v":71.400000000000006},80.2,75,16.200000000000003,107,111.2,140.70000000000002,164.32,113.3,108.80000000000001,111.1,229,null,"Warrant BELL",6,{"$f":"IF($BF$16-AN12<10,  IF( ( (60*AN19)+ ( ($AN$12-AN12  )/5  ) )<10,10, ( (60*AN19)+ ( ($AN$12-AN12  )/5  ) )),($BF$16-AN12)*AN19)","v":302.40000000000003},{"$f":"IF($BF$16-AO12<10,  IF( ( (60*AO19)+ ( ($AN$12-AO12  )/5  ) )<10,10, ( (60*AO19)+ ( ($AN$12-AO12  )/5  ) )),($BF$16-AO12)*AO19)","v":273.06},218.9,241.98000000000002,10,59.92,33.92,10,10,10,32.64,10,10]
[{"$f":"IF(B17=0,\"\",IF(AG2=13,\"Résultat  warrants\",\"Dividendes du mois\"))","v":""},{"$f":"IF($AG$3=1,HLOOKUP($AG$2,Dividende_1,7),HLOOKUP($AG$2,Dividende_2,7))","v":0},null,null,null,null,null,null,null,null,null,null,5,"Oblig. Emotion",null,null,null,{"$f":"VLOOKUP(5,Cote,$AG$2+2)","v":5050},null,{"$f":"VLOOKUP(5,Cote,$AG$2+1)","v":5000},null,1,null," =",null,null,null,null,null,null,null,"Affichage",null,"Conflit",{"$f":"IF(X18=\"\",0,IF(X18=AK6,0,1))","v":0},{"$f":"IF(X19=\"\",0,IF(X19=AK6,0,1))","v":0},null,"Warrant DIVO",7,{"$f":"IF($AM$2=2,BY17,BI17)","v":33.6},{"$f":"IF($AM$2=2,BZ17,BJ17)","v":36.966666666666669},29.333333333333332,38.366666666666667,40.06666666666667,30.1,18.466666666666669,12.5,29.200000000000003,17.56666666666667,13.600000000000001,14.966666666666667,13,0,"strike :",{"$f":"IF(AJ6=1,(ROUNDUP(BB14/100,0)*100)-20,(ROUNDUP(BB14/100,0)*100)+20)","v":620},{"$f":"IF(AJ14=1,(ROUNDUP(BB14/100,0)*100)-20,(ROUNDUP(BB14/100,0)*100)+20)","v":620},{"$f":"IF(AJ15=1,(ROUNDUP(BB14/100,0)*100)-20,(ROUNDUP(BB14/100,0)*100)+20)","v":620},{"$f":"IF(AG6=TRUE,BC17,IF(AG3=1,BD17,BE17))","v":620},"Warrant DIVO",7,{"$f":"IF(AN14-$BC$17<10,    IF( ( (30*AN19)+ ( (AN14-$AN$14  )/3  ) )<10,10,  ( (30*AN19)+ ( (AN14-$AN$14  )/3  ) )),(AN14-$BC$17)*AN19)","v":33.6},{"$f":"IF(AO14-$BC$17<10,    IF( ( (30*AO19)+ ( (AO14-$AN$14  )/3  ) )<10,10,  ( (30*AO19)+ ( (AO14-$AN$14  )/3  ) )),(AO14-$BC$17)*AO19)","v":36.966666666666669},29.333333333333332,38.366666666666667,40.06666666666667,30.1,18.466666666666669,12.5,29.200000000000003,17.56666666666667,13.600000000000001,14.966666666666667,13,null,"Warrant DIVO",7,{"$f":"IF($BF$17-AN14<10,  IF( ( (30*AN19)+ ( ($AN$14-AN14  )/2  ) )<10,10, ( (30*AN19)+ ( ($AN$14-AN14  )/2  ) )),($BF$17-AN14)*AN19)","v":44.800000000000004},{"$f":"IF($BF$17-AO14<10,  IF( ( (30*AO19)+ ( ($AN$14-AO14  )/2  ) )<10,10, ( (30*AO19)+ ( ($AN$14-AO14  )/2  ) )),($BF$17-AO14)*AO19)","v":32.190000000000005},56.1,25.07,18.36,49.220000000000006,84.800000000000011,101.85000000000001,47.84,82.4,92.820000000000007,86.86,91]
[{"$f":"IF(B18=0,\"\",IF(AG2=13,\"Int. des obligations\",\"Intérêts et int. cour.\"))","v":""},{"$f":"IF($AG$3=1,HLOOKUP($AG$2,Dividende,8),HLOOKUP($AG$2,Dividende_2,8))","v":0},null,null,null,null,null,{"$f":"IF(AG6=FALSE,\"\",VLOOKUP(3,AF30:AG32,2))","v":""},null,null,null,null,6,"Warrant BELL",null,null,null,{"$f":"VLOOKUP(6,Cote,$AG$2+2)*AL3","v":71.400000000000006},null,{"$f":"VLOOKUP(6,Cote,$AG$2+1)*AL3","v":67.2},null,6.2500000000000036,null,{"$f":"IF(AG3=1,IF(Q8=0,\"\",IF(AI14=1,\"put\",\"call\")),IF(Q8=0,\"\",IF(AI15=1,\"put\",\"call\")))","v":""},null,null,null,null,null,null,null,"Ligne 1",2,null,null,null,null,"Moy. pond",8,{"$f":"((AN11*10)+(AN12/10)+(AN13/2)+(AN14/5))/4","v":147.25},{"$f":"((AO11*10)+(AO12/10)+(AO13/2)+(AO14/5))/4","v":148.15},148.97499999999999,147.17500000000001,165.4,163.79999999999998,157.69999999999999,151.5,156.77499999999998,156.625,163.64999999999998,163.95,163.67499999999998,163.8125,{"$f":"AVERAGE(BB11:BB14)","v":830.57692307692309},{"$f":"BB18/20","v":41.528846153846153}]
[{"$f":"IF(B19=0,\"\",IF(AG2=13,\"Int. emprunt\",\"Frais bancaires\"))","v":""},{"$f":"IF($AG$3=1,HLOOKUP($AG$2,Dividende,9),HLOOKUP($AG$2,Dividende_2,9))","v":0},null,null,null,{"$f":"IF(AG6=FALSE,\"\",\"Strike\")","v":""},null,null,{"$f":"IF(AG6=TRUE,VLOOKUP(AG4,Cote,17),\"\")","v":""},null,null,"Enter",7,"Warrant DIVO",null,null,null,{"$f":"VLOOKUP(7,Cote,$AG$2+2)*AL3","v":36.966666666666669},null,{"$f":"VLOOKUP(7,Cote,$AG$2+1)*AL3","v":33.6},null,10.019841269841272,null,{"$f":"IF(AG3=1,IF(Q9=0,\"\",IF(AJ14=1,\"put\",\"call\")),IF(Q9=0,\"\",IF(AJ15=1,\"put\",\"call\")))","v":""},null,null,null,null,null,null,null,"Ligne 2",2,null,null,null,null,"prime temporelle",null,1.1200000000000001,1.1100000000000001,1.1000000000000001,1.0900000000000001,1.08,1.07,1.06,1.05,1.04,1.03,1.02,1.01,1,1]
["Total du mois",{"$f":"SUM(B17:B19)","v":0},null,null,"Quantité : ",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,"Ligne 3",2,null,null,null,null,"Achats/Ventes  joueur ","A",null,"Nombre de titres achetés ou vendus. Nom : Achat_vente_A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur_A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Résultat provisoire","OP. à terme en cours",{"$f":"\"\"","v":""}]
[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,null,null,null,null,"Ligne 4",2,null,"calcul tuyau",null,null,null,null,null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc",null,"Total",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,"Dép/tot","cours*tot",null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[100,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3=1,50000+N25+BS30+BC48-CB27-Q11,50000+N25+BS42+BC58-CB39-Q11)","v":50000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ligne 5",3,"A",{"$f":"VLOOKUP(AI25,Cote,$AG$2+2)","v":0},{"$f":"VLOOKUP(AI25,Cote,$AG$2+3)","v":0},null,"Titre",null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"achats","ventes",null,null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc","Dépense","Prix moy","Inv. Final","achats","ventes",null,"Ventes","PRAMV","BB",null,null,{"$f":"\"\"","v":""}]
["zoom",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,null,null,null,null,2,"B",{"$f":"VLOOKUP(AI26,Cote,$AG$2+2)","v":0},{"$f":"VLOOKUP(AI26,Cote,$AG$2+3)","v":0},null,"Abeco",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO23:AZ23)","v":0},{"$f":"SUMIF(AO23:AZ23,\">0\")","v":0},{"$f":"BC23-BB23","v":0},null,1,{"$f":"AO23*AO11*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BG23:BR23)","v":0},{"$f":"IF(BB23=0,0,BS23/BB23*-1)","v":0},{"$f":"VLOOKUP(BF23,Cote,$AG$2+2)*BB23","v":0},{"$f":"SUMIF(BG23:BR23,\"<0\")","v":0},{"$f":"BS23-BV23","v":0},null,{"$f":"BW23","v":0},{"$f":"(BV23*-1)-BU23","v":0},{"$f":"IF(BU23<0,0,BY23-BZ23)","v":0},{"$f":"IF(CC23=\"oui\",BY23-BZ23,0)","v":0},{"$f":"IF(BB23<0,\"oui\",\"non\")","v":"non"},{"$f":"\"\"","v":""}]
["Réglage",null,null,null,null,null,null,null,null,null,null,null,null,"Emprunt à 10 %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nb","titre","tuyau",null,"Bell & Cie",null,2,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(AO24:AZ24)","v":0},{"$f":"SUMIF(AO24:AZ24,\">0\")","v":0},{"$f":"BC24-BB24","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BG24:BR24)","v":0},{"$f":"IF(BB24=0,0,BS24/BB24*-1)","v":0},{"$f":"VLOOKUP(BF24,Cote,$AG$2+2)*BB24","v":0},{"$f":"SUMIF(BG24:BR24,\"<0\")","v":0},{"$f":"BS24-BV24","v":0},null,{"$f":"BW24","v":0},{"$f":"(BV24*-1)-BU24","v":0},{"$f":"IF(BU24<0,0,BY24-BZ24)","v":0},{"$f":"IF(CC24=\"oui\",BY24-BZ24,0)","v":0},{"$f":"IF(BB24<0,\"oui\",\"non\")","v":"non"},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3,IF(BC51=0,0,BC51),IF(BC61=0,0,BC61))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3=1,IF(AI25=0,\"\",VLOOKUP(AI25,AK11:AL14,2)),IF(AI26=0,\"\",VLOOKUP(AI26,AK11:AL14,2)))","v":""},{"$f":"IF(AG3=1,IF(AI25=0,\"\",AJ25),IF(AI26=0,\"\",AJ26))","v":""},null,null,null,null,"Tuyau","joueur A",0,0,{"$f":"IF(AJ22-AI22>0,\"+\",\"-\")","v":"-"},null,"Comon",null,3,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF25,Cote,$AG$2+2)*BB25","v":0},0,0,null,0,0,0,{"$f":"IF(CC25=\"oui\",BY25-BZ25,0)","v":0},{"$f":"IF(BB25<0,\"oui\",\"non\")","v":"non"},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Smak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG4>5,\"Opération sur dérivés\",IF(AG10=1,\" Achat à terme \"&VLOOKUP(AG33,AF30:AG32,2),\"\"))","v":""},null,null,null,null,null,null,"joueur B",0,0,{"$f":"IF(AJ23-AI23>0,\"+\",\"-\")","v":"-"},null,"Divogan",null,4,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF26,Cote,$AG$2+2)*BB26","v":0},0,0,null,0,0,0,{"$f":"IF(CC26=\"oui\",BY26-BZ26,0)","v":0},{"$f":"IF(BB26<0,\"oui\",\"non\")","v":"non"},{"$f":"\"\"","v":""}]
[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":"IF(AG2>12,\"\",IF(AH4=1,\"Choisissez un titre !\", IF(J14<0,IF(AG5=1,\"Pas possible !\",\"\"),\"\")))","v":"Choisissez un titre !"},null,null,null,null,null,"Le titre sélectionné est call ou put",null,null,null,{"$f":"IF(AG4=6,X18,X19)","v":""},null,"Oblig. Emotion",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF27,Cote,$AG$2+2)*BB27","v":0},0,0,null,0,0,0,{"$f":"SUM(CB23:CB26)","v":0},"Total à déduire du cash"]
[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":"VLOOKUP(3,Commentaire,AG20)","v":""},null,null,null,null,null,null,null,"idem figé",null,null,null,"Option BELL",null,6,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,6,{"$f":"AO28*AO88*-1","v":0},{"$f":"AP28*AP88*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF28,$AN$88:$BA$89,$AG$2+1)*BB28","v":0},0,0,null,0,0,0,null,null,{"$f":"\"\"","v":""}]
[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":"VLOOKUP(4,Commentaire,AG21)","v":""},null,null,null,null,null,"Texte pour futur :",null,null,null,{"$f":"IF(OR(AJ27=\"put\",AJ28=\"put\"),\"put\",0)","v":0},null,"Option DIVO",null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,7,{"$f":"AO29*AO89*-1","v":0},{"$f":"AP29*AP89*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF29,$AN$88:$BA$89,$AG$2+1)*BB29","v":0},0,0,null,0,0,0,null,null,{"$f":"\"\"","v":""}]
[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":"VLOOKUP(5,Commentaire,AG22)","v":"Prêt pour jouer"},null,null,null,null,null,1," fin avril",null,null,null,null,"VALIDATION DES MOIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"<-",null,null,null,{"$f":"SUMIF(BG23:BG29,\">0\")","v":0},{"$f":"SUMIF(BH23:BH29,\">0\")","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BS23:BS29)","v":0},0,{"$f":"SUM(BU23:BU29)","v":0},0,0,null,0,0,0,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,2," fin août",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":"SUMIF(BG23:BG30,\"<0\")","v":0},{"$f":"SUMIF(BH23:BH30,\"<0\")","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BS28:BS29)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,3," fin décembre",null,null,null,null,"Achats/Ventes  joueur ","A",null,"Nombre de titres achetés ou vendus. Nom : Achat_vente_A",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(BB25:BB28)","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,null,null,null,null,null,null,"rnd mois/4",{"$f":"IF(AG6=TRUE,3,ROUND((AG2+2)/4,0))","v":1},null,null,null,null,null,null,null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc",null,"Total",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,"Dép/tot","cours*tot"]
[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,null,null,null,null,null,null,null,null,null,null,"Titre",null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"achats","ventes",null,null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc","Dépense","Prix moy","Inv. Final","achats","ventes",null,"Ventes","PRAMV","BB"]
[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,null,null,null,null,null,null,null,null,null,null,"Abeco",null,1,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(AO35:AZ35)","v":0},{"$f":"SUMIF(AO35:AZ35,\">0\")","v":0},{"$f":"BC35-BB35","v":0},null,1,{"$f":"AO35*AO11*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BG35:BR35)","v":0},{"$f":"IF(BB35=0,0,BS35/BB35*-1)","v":0},{"$f":"VLOOKUP(BF35,Cote,$AG$2+2)*BB35","v":0},{"$f":"SUMIF(BG35:BR35,\"<0\")","v":0},{"$f":"BS35-BV35","v":0},null,{"$f":"BW35","v":0},{"$f":"(BV35*-1)-BU35","v":0},{"$f":"IF(BU35<0,0,BY35-BZ35)","v":0},{"$f":"IF(CC35=\"oui\",BY35-BZ35,0)","v":0},{"$f":"IF(BB35<0,\"oui\",\"non\")","v":"non"}]
[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,null,null,null,null,"Mac =1, PC = 2",null,{"$f":"Accueil!C3","v":2},null,null,null,"Bell & Cie",null,2,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(AO36:AZ36)","v":0},{"$f":"SUMIF(AO36:AZ36,\">0\")","v":0},{"$f":"BC36-BB36","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BG36:BR36)","v":0},{"$f":"IF(BB36=0,0,BS36/BB36*-1)","v":0},{"$f":"VLOOKUP(BF36,Cote,$AG$2+2)*BB36","v":0},{"$f":"SUMIF(BG36:BR36,\"<0\")","v":0},{"$f":"BS36-BV36","v":0},null,{"$f":"BW36","v":0},{"$f":"(BV36*-1)-BU36","v":0},{"$f":"IF(BU36<0,0,BY36-BZ36)","v":0},{"$f":"IF(CC36=\"oui\",BY36-BZ36,0)","v":0},{"$f":"IF(BB36<0,\"oui\",\"non\")","v":"non"}]
[null,null,null,"Pour :",null,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,null,null,null,null,null,null,"Comon",null,3,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF37,Cote,$AG$2+2)*BB37","v":0},0,0,null,0,0,0,{"$f":"IF(CC37=\"oui\",BY37-BZ37,0)","v":0},{"$f":"IF(BB37<0,\"oui\",\"non\")","v":"non"}]
[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,null,null,null,null,null,null,null,null,null,null,"Divogan",null,4,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF38,Cote,$AG$2+2)*BB38","v":0},0,0,null,0,0,0,{"$f":"IF(CC38=\"oui\",BY38-BZ38,0)","v":0},{"$f":"IF(BB38<0,\"oui\",\"non\")","v":"non"}]
[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":"IF(AG2=13,\"Nouvelle partie = New\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Oblig. Emotion",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF39,Cote,$AG$2+2)*BB39","v":0},0,0,null,0,0,0,{"$f":"SUM(CB35:CB38)","v":0},"Total à déduire du cash"]
[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":"IF(AG2=13,\"Pour quitter le jeu, cliquer\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Option BELL",null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,6,{"$f":"AO40*AO92*-1","v":0},{"$f":"AP40*AP92*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF40,$AN$92:$BA$93,$AG$2+1)*BB40","v":0},0,0,null,0,0,0]
["© Y. Péguiron - Infodidac - rév. mai 2015",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":"IF(AG2=13,\"la flèche Fermer de la page d'accueil.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Option DIVO",null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,7,{"$f":"AO41*AO93*-1","v":0},{"$f":"AP41*AP93*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(BF41,$AN$92:$BA$93,$AG$2+1)*BB41","v":0},0,0,null,0,0,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,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,null,"VALIDATION DES MOIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"<-",null,null,null,{"$f":"SUMIF(BG35:BG41,\">0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BS35:BS41)","v":0},0,{"$f":"SUM(BU35:BU41)","v":0},{"$f":"SUM(BV35:BV41)","v":0},{"$f":"SUM(BW35:BW41)","v":0},null,{"$f":"SUM(BY35:BY41)","v":0},{"$f":"SUM(BZ35:BZ41)","v":0},{"$f":"SUM(CA35:CA41)","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,null,null,null,null,{"$f":"\"\"","v":""},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,null,{"$f":"SUMIF(BG35:BG42,\"<0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BS40:BS41)","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,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,null,"Dividendes, intérêts courus et frais bancaires. Nom : Dividende",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cours_compta"]
[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,null,null,{"$f":"\"\"","v":""},null,"Texte pour remarques. Nom : Commentaire",null,null,null,null,null,null,null,null,null,null,"ABEC",null,null,"BELL",null,null,"COMO","DIVO",null,"Oblig.","Warrants","Cumul",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,"Z26 à Z30",2,3,4,5,6,null,"Dividende",null,null,null,{"$f":"IF(AQ69>AN69,0.9,0.6)","v":0.9},null,null,{"$f":"IF(AT70>AN70,90,60)","v":60},null,null,{"$f":"IF(AW71>AN71,15,11)","v":11},{"$f":"IF(AX72>AN72,51,42)","v":42},null,null,null,"mens.","Total int et frais",null,null,"Sommes validation",null,{"$f":"AO30+AO42","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"BS46","v":0},null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},"AG18",1,{"$f":"\"\"","v":""},"contrat d'achat à terme",null,null,{"$f":"\"\"","v":""},"A",null,1,1,2,3,4,5,6,7,8,9,10,11,12,13,null,null,"ch","Pr",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":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},"AG19",2,{"$f":"\"\"","v":""},"Pas possible",null,null,{"$f":"\"\"","v":""},"Cumul","Div.",2,null,null,{"$f":"AQ53","v":0},{"$f":"AQ48","v":0},{"$f":"AR48","v":0},{"$f":"AT53+AS48","v":0},{"$f":"AT48","v":0},{"$f":"AU48","v":0},{"$f":"AW53+AV48","v":0},{"$f":"AX53+AW48","v":0},{"$f":"AX48","v":0},{"$f":"AY48","v":0},{"$f":"AZ48+BA53","v":0},{"$f":"HLOOKUP(AG2,Dividende,2)","v":0},{"$f":"SUM(BB48:BB50)","v":0},{"$f":"BB50","v":0},{"$f":"SUM(BB48:BB49)","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,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},"AG20",3,{"$f":"\"\"","v":""},"Séance de liquidation","Partie terminée","Pas possible ce mois","Mois déjà saisi","Patientez !                Patientez !","Int. cour.",3,{"$f":"AO27*5000*AO74/100*-1","v":0},{"$f":"(AP27*5000*AP74/100*-1)+AO49","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"AZ49+BA54","v":0},{"$f":"HLOOKUP($AG$2,Dividende,3)","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,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},"AG21",4,{"$f":"\"\"","v":""},"Vous n'avez pas la couverture","Donnez vos ordres !","Manque de liquidités","Ordre minimum CHF 1000.-","Opération impossible","Frais ",4,{"$f":"AO55","v":0},{"$f":"AO50+AP55","v":0},{"$f":"AP50+AQ55","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AZ50+BA55","v":0},{"$f":"HLOOKUP($AG$2,Dividende,4)","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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},"AG22",5,{"$f":"\"\"","v":""},"Prêt pour jouer",{"$f":"\"Résultat = \"& ROUND(Y10,2)","v":"Résultat = 0"},"Cochez la case option !","Call ou Put; pas les deux !","OK, ordre enregistré","emprunt",5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG2=13,SUM(AO51:AZ51)*10*BA52/1200,0)","v":0},{"$f":"BA51","v":0},{"$f":"SUM(AO51:AZ51)","v":0},null,null,null,"Exercice des options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"nb mois",6,{"$f":"IF(AO51=0,0,13-AO75)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO52:AZ52)*-1","v":0},null,"Etat de la dette",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":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},"Mensuel","Div.",7,null,null,{"$f":"IF(AQ70<0,0,AQ70*AQ$46)","v":0},null,null,{"$f":"IF(AT71<0,0,AT71*AT46)","v":0},null,null,{"$f":"IF(AW72<0,0,AW72*AW46)","v":0},{"$f":"IF(AX73<0,0,AX73*AX46)","v":0},null,{"$f":"AZ70*AZ46","v":0},{"$f":"BM56","v":0},{"$f":"SUM(AO53:BA53)","v":0},null,null,null,null,"Options A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Int. Cour",8,{"$f":"(AO27*5000)*AO74/100*-1","v":0},{"$f":"(AP27*5000)*AP74/100*-1","v":0},{"$f":"(AQ27*5000)*AQ74/100*-1","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AG2=13,BB27*5000*4.25/100,0)","v":0},{"$f":"SUM(AO54:BA54)","v":0},"      somme pour contrôle",null,null,null,"Stike","prix 31.12","diff.","st.fin","Résultat","somme +",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Frais ",9,{"$f":"(((ABS(BG23)+ABS(BG24)+ABS(BG25)+ABS(BG26))*1.185/100)+(ABS(BG27)*0.885/100))*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"BA51","v":0},{"$f":"SUM(AO55:BA55)","v":0},null,null,null,null,{"$f":"BD16","v":2600},{"$f":"$AZ$12","v":2829},{"$f":"IF(AI14=1,BG55-BH55,BH55-BG55)","v":229},{"$f":"BB28","v":0},{"$f":"BI55*BJ55","v":0},{"$f":"IF(BK55>0,BK55,0)","v":0},"Toto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,10,{"$f":"SUM(AO53:AO55)","v":0},{"$f":"SUM(AP53:AP55)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"BD17","v":620},{"$f":"$AZ$14","v":529},{"$f":"IF(AJ14=1,BG56-BH56,BH56-BG56)","v":-91},{"$f":"BB29","v":0},{"$f":"BI56*BJ56","v":0},{"$f":"IF(BK56>0,BK56,0)","v":0},{"$f":"SUM(BL55:BL56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},"B",null,1,1,2,3,4,5,6,7,8,9,10,11,12,13,null,null,"Ch","Pr",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":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},"Cumul","Div.",2,null,null,{"$f":"AQ63","v":0},{"$f":"AQ58","v":0},{"$f":"AR58","v":0},{"$f":"AT63+AS58","v":0},{"$f":"AT58","v":0},{"$f":"AU58","v":0},{"$f":"AW63+AV58","v":0},{"$f":"AX63+AW58","v":0},{"$f":"AX58","v":0},{"$f":"AY58","v":0},{"$f":"AZ58+BA63","v":0},{"$f":"HLOOKUP($AG$2,Dividende,12)","v":0},{"$f":"SUM(BB58:BB60)","v":0},{"$f":"BB60","v":0},{"$f":"SUM(BB58:BB59)","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,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Int. cour.",3,{"$f":"AO39*5000*AO83/100*-1","v":0},{"$f":"(AP39*5000*AP83/100*-1)+AO59","v":0},{"$f":"(AQ39*5000*AQ83/100*-1)+AP59","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AZ59+BA64","v":0},{"$f":"HLOOKUP($AG$2,Dividende,13)","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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Frais ",4,{"$f":"AO65","v":0},{"$f":"AO60+AP65","v":0},{"$f":"AP60+AQ65","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AZ60+BA65","v":0},{"$f":"HLOOKUP($AG$2,Dividende,14)","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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"emprunt",5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG2=13,SUM(AO61:AZ61)*10*BA62/1200,0)","v":0},{"$f":"BA61","v":0},{"$f":"SUM(AO61:AZ61)","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,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"nb mois",6,{"$f":"IF(AO61=0,0,13-AO84)","v":0},{"$f":"IF(AP61=0,0,13-AP84)","v":0},{"$f":"IF(AQ61=0,0,13-AQ84)","v":0},{"$f":"IF(AR61=0,0,13-AR84)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(AO62:AZ62)*-1","v":0},null,"Etat de la dette",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":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},"Mensuel","Div.",7,null,null,{"$f":"IF(AQ79<0,0,AQ79*AQ$46)","v":0},null,null,{"$f":"IF(AT80<0,0,AT80*AT$46)","v":0},null,null,{"$f":"IF(AW81<0,0,AW81*AW$46)","v":0},{"$f":"IF(AX82<0,0,AX82*AX$46)","v":0},null,{"$f":"AZ79*AZ46","v":0},{"$f":"BM66","v":0},{"$f":"SUM(AO63:BA63)","v":0},null,null,null,null,"Options B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Int. Cour",8,{"$f":"(AO39*5000)*AO83/100*-1","v":0},{"$f":"(AP39*5000)*AP83/100*-1","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AG2=13,BB39*5000*4.25/100,0)","v":0},{"$f":"SUM(AO64:BA64)","v":0},"      somme pour contrôle",null,null,null,"Stike","prix 31.12","diff.","st.fin","Résultat","somme +",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Frais ",9,{"$f":"(((ABS(BG35)+ABS(BG36)+ABS(BG37)+ABS(BG38))*1.185/100)+(ABS(BG39)*0.885/100))*-1","v":0},{"$f":"(((ABS(BH35)+ABS(BH36)+ABS(BH37)+ABS(BH38))*1.185/100)+(ABS(BH39)*0.885/100))*-1","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"BA61","v":0},{"$f":"SUM(AO65:BA65)","v":0},null,null,null,null,{"$f":"BE16","v":2600},{"$f":"$AZ$12","v":2829},{"$f":"IF(AI15=1,BG65-BH65,BH65-BG65)","v":229},{"$f":"BB40","v":0},{"$f":"BI65*BJ65","v":0},{"$f":"IF(BK65>0,BK65,0)","v":0},"Toto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,10,{"$f":"SUM(AO63:AO65)","v":0},{"$f":"SUM(AP63:AP65)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"BE17","v":620},{"$f":"$AZ$14","v":529},{"$f":"IF(AJ15=1,BG66-BH66,BH66-BG66)","v":-91},{"$f":"BB41","v":0},{"$f":"BI66*BJ66","v":0},{"$f":"IF(BK66>0,BK66,0)","v":0},{"$f":"SUM(BL65:BL66)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"Nombre de titres, cumulé pour le dividende",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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"A",null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc",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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,1,null,null,{"$f":"SUM($AO23:AQ23)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,2,null,null,null,null,null,{"$f":"SUM($AO24:AT24)","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,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,3,null,null,null,null,null,null,null,null,{"$f":"SUM($AO25:AW25)","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,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,4,null,null,null,null,null,null,null,null,null,{"$f":"SUM($AO26:AX26)","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,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Obligation",null,{"$f":"4.25*AO75/12","v":0.35416666666666669},0.70833333333333337,1.0625,1.4166666666666667,1.7708333333333333,2.125,2.4791666666666665,2.8333333333333335,3.1875,3.5416666666666665,3.8958333333333335,4.25,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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,"Cumul pour le mois donné",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":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"B",null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc",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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,1,null,null,{"$f":"SUM($AO35:AQ35)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,2,null,null,null,null,null,{"$f":"SUM($AO36:AT36)","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,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,3,null,null,null,null,null,null,null,null,{"$f":"SUM($AO37:AW37)","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,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,4,null,0,0,0,0,0,0,0,0,{"$f":"SUM($AO38:AX38)","v":0},0,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,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"Obligation",null,{"$f":"4.25*AO84/12","v":0.35416666666666669},0.70833333333333337,1.0625,1.4166666666666667,1.7708333333333333,2.125,2.4791666666666665,2.8333333333333335,3.1875,3.5416666666666665,3.8958333333333335,4.25,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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,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,null,null,{"$f":"\"\"","v":""}]
[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,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,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":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Retour du cours pratiqués pour les warrants",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Joueurs A",null,null,null,null,null,null,null,null,null,null,null,null,"prix moyen",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,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Warrant BELL",6,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Warrant DIVO",7,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Joueurs B",0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Warrant BELL",6,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Warrant DIVO",7,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"jan","fév","mars","avril","mai","juin","juillet","août","sep","oct","nov","déc",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,null,null,{"$f":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"cells",41,42,43,44,45,46,47,48,49,50,51,52,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,null,null,{"$f":"\"\"","v":""}]
[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,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,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":"\"\"","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"La partie warrant de la cote bleu est mobile, cette partie est fixée en fonction des achats et ventes",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]

{"sheet":"Comptabilité","index":2,"n_rows":64,"n_cols":37,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,34,1,35],[3,3,3,10],[3,11,3,15],[5,0,5,1],[7,0,7,1],[6,0,6,1],[58,11,59,14],[5,2,5,15],[50,11,50,14],[52,8,52,9],[53,8,53,9],[50,8,50,9],[51,8,51,9],[58,4,59,7],[58,8,59,9],[58,10,59,10],[51,11,51,14],[52,11,52,14],[53,11,53,14],[8,0,8,1],[9,0,9,1],[14,19,14,26],[16,15,17,15],[16,10,17,14],[10,2,10,15],[11,0,11,1],[10,0,10,1],[45,0,45,1],[45,11,45,14],[46,11,46,14],[49,11,49,14],[47,8,47,9],[48,8,48,9],[49,8,49,9],[45,8,45,9],[46,8,46,9],[55,8,55,9],[55,4,55,7],[47,4,47,7],[48,4,48,7],[49,4,49,7],[50,4,50,7],[51,4,51,7],[52,4,52,7],[44,11,44,14],[54,11,54,14],[43,4,43,7],[44,4,44,7],[45,4,45,7],[46,4,46,7],[54,8,54,9],[21,24,21,25],[22,24,22,25],[23,24,23,25],[22,21,22,23],[21,19,21,23],[23,19,23,23],[42,3,42,14],[47,11,47,14],[48,11,48,14],[57,4,57,7],[56,8,56,9],[55,11,55,14],[43,8,43,9],[44,8,44,9],[56,11,56,14],[56,4,56,7],[56,3,57,3],[57,8,57,9],[53,4,53,7],[54,4,54,7],[57,11,57,14],[43,11,43,14]]}
[{"$f":"'Bureau Direction'!AG2","v":1},{"$f":"'Bureau Direction'!AG3","v":1},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,null,null,32,33,34,35,36,37]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AJ4,Accueil!K20:M21,2)","v":"Julius"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zoom",88,null,null,null,"Mois pour le titre",null,null,"Variable GLOB"]
[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,null,null,null,null,1,"janvier",{"$f":"IF($AJ$3<AF3,\"\",AG3)","v":"janvier"},"Actif mois /firm",{"$f":"A1","v":1},{"$f":"B1","v":1}]
[null,null,null,"Les compte \"Titres\"  de   ",null,null,null,null,null,null,null,{"$f":"VLOOKUP(AJ5,AF3:AG15,2)","v":"janvier"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"février",{"$f":"IF($AJ$3<AF4,\"\",AG4)","v":""},"Firm compta",1]
[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,null,null,null,null,3,"mars",{"$f":"IF($AJ$3<AF5,\"\",AG5)","v":""},"Mois compta",1]
["Situation Titres",null,"TITRES",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,null,4,"avril","","Achats"]
[{"$f":"IF(AJ4=1,'Bureau Direction'!CA30,'Bureau Direction'!CA42)","v":0},null,null,{"$f":"IF(I7=0,\"\",\"Achats de titres\")","v":""},null,null,null,null,{"$f":"IF(AJ4=1,HLOOKUP(AJ5,Valeur_A,11)*-1,HLOOKUP(AJ5,Valeur_B,11)*-1)","v":0},null,{"$f":"IF(P7=0,\"\",\"Ventes de titres\")","v":""},null,null,null,null,{"$f":"IF(AJ4=1,HLOOKUP(AJ5,Valeur_A,10),HLOOKUP(AJ5,Valeur_B,10))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"mai","","Prix achat"]
[null,null,null,{"$f":"IF(I8=\"\",\"\",\"Diminution\")","v":""},null,null,null,null,{"$f":"IF(P7>I7,P7-I7,\"\")","v":""},null,{"$f":"IF(P8=\"\",\"\",\"Augmentation\")","v":""},null,null,null,null,{"$f":"IF(I7>P7,I7-P7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"juin","","Salaires"]
["Ch. & Prod.",null,null,null,null,null,null,null,{"$f":"SUM(I7:I8)","v":0},null,null,null,null,null,null,{"$f":"SUM(P7:P8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"juillet","","Prix salaire"]
[{"$f":"IF(AJ4=1,'Bureau Direction'!BC48,'Bureau Direction'!BC58)","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,null,null,null,null,null,8,"août","","Pub"]
["Résultat",null,"CHARGES & PRODUITS",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,null,9,"septembre",{"$f":"IF($AJ$3<AF11,\"\",AG11)","v":""},"Frais rech"]
[{"$f":"A7+A10","v":0},null,null,{"$f":"IF(I12=0,\"\",\"Courtage et frais\")","v":""},null,null,null,null,{"$f":"IF(AJ4=1,HLOOKUP(AJ5,Dividende_1,9)*-1,HLOOKUP(AJ5,Dividende_2,9)*-1)","v":0},null,{"$f":"IF(P12=0,\"\",\"Dividendes\")","v":""},null,null,null,null,{"$f":"IF(AJ4=1,HLOOKUP(AJ5,Dividende_1,7),HLOOKUP(AJ5,Dividende_2,7))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"octobre",{"$f":"IF($AJ$3<AF12,\"\",AG12)","v":""},"Ventes"]
[null,null,null,{"$f":"IF(I13=0,\"\",\"Intérêts débiteurs\")","v":""},null,null,null,null,{"$f":"IF(AJ4=1,IF(HLOOKUP(AJ5,Dividende_1,8)>0,0,HLOOKUP(AJ5,Dividende_1,8)*-1),IF(HLOOKUP(AJ5,Dividende_2,8)>0,0,HLOOKUP(AJ5,Dividende_2,8)*-1))","v":0},null,{"$f":"IF(P13=0,\"\",\"Intérêts créanciers\")","v":""},null,null,null,null,{"$f":"IF(AJ4=1,IF(HLOOKUP(AJ5,Dividende_1,8)>0,HLOOKUP(AJ5,Dividende_1,8),0),IF(HLOOKUP(AJ5,Dividende_2,8)>0,HLOOKUP(AJ5,Dividende_2,8),0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"novembre",{"$f":"IF($AJ$3<AF13,\"\",AG13)","v":""},"Prix vente"]
[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,null,null,null,null,12,"décembre",{"$f":"IF($AJ$3<AF14,\"\",AG14)","v":""},"Production"]
[null,null,null,{"$f":"IF(I15=\"\",\"\",\"Produit des titres\")","v":""},null,null,null,null,{"$f":"IF(SUM(P12:P14)-SUM(I12:I14)>0,SUM(P12:P14)-SUM(I12:I14),\"\")","v":""},null,{"$f":"IF(P15=\"\",\"\",\"Charge des titres\")","v":""},null,null,null,null,{"$f":"IF(SUM(I12:I14)-SUM(P12:P14)>0,SUM(I12:I14)-SUM(P12:P14),\"\")","v":""},null,null,null,{"$f":"IF(AJ5=13,\"Résultat options \"& L4,\"Etat des options en \"& L4)","v":"Etat des options en janvier"},null,null,null,null,null,null,null,null,null,null,null,13,"fin décembre",{"$f":"IF($AJ$3<AF15,\"\",AG15)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I11:I15)","v":0},null,null,null,null,null,null,{"$f":"SUM(P11:P15)","v":0},null,null,null,null,null,"Strike","Cours","Équart","Stock","Résultat","Exercice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," BELL",{"$f":"IF(AJ4=1,IF('Bureau Direction'!AI14=1,\"Put\",\"Call\"),IF('Bureau Direction'!AI15=1,\"Put\",\"Call\"))","v":"Call"},{"$f":"IF(AJ4=1,'Bureau Direction'!BG55,'Bureau Direction'!BG65)","v":2600},{"$f":"IF(HLOOKUP(AJ5,Cours_compta,2)=0,0,VLOOKUP(2,Cote,AJ5+1))","v":0},{"$f":"ABS(W17-V17)","v":2600},{"$f":"IF(AJ4=1,'Bureau Direction'!BJ55,'Bureau Direction'!BJ65)","v":0},{"$f":"IF(W17=0,0,IF(U17=\"Call\",(W17-V17)*Y17,(V17-W17)*Y17))","v":0},{"$f":"IF(Y17=0,\"\",IF(Z17>0,\"oui\",\"non\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," DIVO",{"$f":"IF(AJ4=1,IF('Bureau Direction'!AJ14=1,\"Put\",\"Call\"),IF('Bureau Direction'!AJ15=1,\"Put\",\"Call\"))","v":"Call"},{"$f":"IF(AJ4=1,'Bureau Direction'!BG56,'Bureau Direction'!BG66)","v":620},{"$f":"IF(HLOOKUP(AJ5,Cours_compta,2)=0,0,VLOOKUP(4,Cote,AJ5+1))","v":0},{"$f":"ABS(W18-V18)","v":620},{"$f":"IF(AJ4=1,'Bureau Direction'!BJ56,'Bureau Direction'!BJ66)","v":0},{"$f":"IF(W18=0,0,IF(U18=\"Call\",(W18-V18)*Y18,(V18-W18)*Y18))","v":0},{"$f":"IF(Y18=0,\"\",IF(Z18>0,\"oui\",\"non\"))","v":""}]
[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":"SUMIF(Z17:Z18,\">0\")","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ5<13,\"Situation brute provisoire des options\",\"Résultat brut des options\")","v":"Situation brute provisoire des options"},null,null,null,null,{"$f":"Z19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," -  primes",null,null,{"$f":"IF(AJ4=1,'Bureau Direction'!BS31,'Bureau Direction'!BS43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ5<13,\"Situation nette provisoire des options\",\"Résultat net des options\")","v":"Situation nette provisoire des options"},null,null,null,null,{"$f":"Y22+Y23","v":0}]
[null,75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Relevés des charges et produits"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Relevé des charges et produits par mois"]
[null,null,null,null,"Dividendes*",null,null,null,"Intérêts courus",null,"Courtage et frais","Total",null,null,null,"cumul"]
[null,null,1,"Janvier",{"$f":"IF($AJ$4=1,HLOOKUP($C45,Dividende_1,7),HLOOKUP($C45,Dividende_2,7))","v":0},null,null,null,{"$f":"IF($AJ$4=1,HLOOKUP($C45,Dividende_1,8),HLOOKUP($C45,Dividende_2,8))","v":0},null,{"$f":"IF($AJ$4=1,HLOOKUP($C45,Dividende_1,9),HLOOKUP($C45,Dividende_2,9))","v":0},{"$f":"SUM(E45:K45)","v":0},null,null,null,{"$f":"L45","v":0}]
["retour  ",null,2,"Février",{"$f":"IF($AJ$4=1,HLOOKUP(C46,Dividende_1,7),HLOOKUP(C46,Dividende_2,7))","v":0},null,null,null,0,null,0,{"$f":"SUM(E46:K46)","v":0},null,null,null,{"$f":"P45+L46","v":0}]
[null,null,3,"Mars",0,null,null,null,0,null,0,0,null,null,null,{"$f":"P46+L47","v":0}]
[null,null,4,"Avril",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,5,"Mai",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,6,"Juin",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,7,"Juillet",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,8,"Août",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,9,"Septembre",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,10,"Octobre",0,null,null,null,0,null,0,0,null,null,null,0]
[null,null,11,"Novembre",0,null,null,null,0,null,0,0,null,null,null,{"$f":"P54+L55","v":0}]
[null,null,12,"Décembre",0,null,null,null,0,null,0,0,null,null,null,{"$f":"P55+L56","v":0}]
[null,null,null,"Fin Décembre",null,null,null,null,{"$f":"IF($AJ$4=1,HLOOKUP($C58,Dividende_1,8),HLOOKUP($C58,Dividende_2,8))","v":0},null,{"$f":"IF($AJ$4=1,HLOOKUP($C58,Dividende_1,9),HLOOKUP($C58,Dividende_2,9))","v":0},{"$f":"SUM(E57:K57)","v":0},null,null,null,{"$f":"P56+L57","v":0}]
[null,null,13,null,{"$f":"IF(AJ3=13,IF($AJ$4=1,HLOOKUP(C58,Dividende_1,7),HLOOKUP(C58,Dividende_2,7)),\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(E58:K58)","v":0},null,null,null,{"$f":"P57+L58","v":0}]
[null,null,null,null,{"$f":"SUM(E45:H58)","v":0},null,null,null,{"$f":"SUM(I45:J57)","v":0},null,{"$f":"SUM(K45:K57)","v":0},{"$f":"SUM(L45:O58)","v":0}]
[]
[]
[]
[]
[null,null,null,"* Dividendes reçus ou attendus"]

{"sheet":"Information","index":3,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,14,3,16],[4,14,9,16],[32,8,33,11],[34,8,34,11],[11,10,11,11],[5,0,5,1],[5,6,6,7],[11,6,11,7],[5,2,6,2],[5,3,6,4],[7,10,7,11],[8,10,8,11],[28,7,28,8],[37,8,37,11],[38,8,38,11],[13,6,13,7],[36,8,36,11],[35,8,35,11],[19,2,20,4],[9,10,9,11],[40,8,40,11],[41,8,41,11],[10,14,10,16],[39,8,39,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warrants"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les Calls (droit d'acheter) et les Puts (droit de vendre) peuvent être achetés en activant la case \"option\". Ils peuvent être vendus en bourse comme de simples actions pour le 75% de la prime."]
[null,null,"Titres","Nominal",null,null,"Dividendes distribués l'année précédente"]
[]
[null,null,"Abeco",null,10,null,0.8," en mars",null,null,"Ordres de bourse"]
[null,null,"Bell & Cie",null,1000,null,"80.- -"," en juin",null,null,"Montant minimun"]
[null,null,"Comon",null,100,null,12," en septembre",null,null,"CHF 1'000.-"]
[null,null,"Divogan",null,100,null,45," en octobre",null,null,null,null,null,null,"Calcul de la prime "]
[null,null,null,null,null,null,"intérêt",null,null,null,"Frais et courtage",null,null,null,"Valeur intrinsèque :",null,"Sous-jacent - strike"]
[null,null,"Oblig. Emotion",null,5000,null,4.25,"en décembre",null,null,"Actions",1.1849999999999999E-2,null,null,"Valeur temporelle :",null,"1% par mois restant"]
[null,null,null,null,null,null,"Intérêts courus à l'achat et à la vente",null,null,null,"Obligations",8.8500000000000002E-3,null,null,null,null," + coef. volatilité"]
[null,null,"Warrant BELL",null,"exercice fin",null,"Sous-jacent :","Action Bell & Cie",null,null,null,null,null,null,null,"Type de warrant"]
[null,null,"Warrant DIVO",null,"décembre",null,"Sous-jacent :","Action Divogan",null,null,null,null,null,null,"Européen, échéance 31 décembre."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ces warrants peuvent être achetés et"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vendus pendant l'année, mais pas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"exercés. ","En cas de bénéfice, le"]
[null,null,"VAD -  Vente à découvert ",null,null,null,null,null,null,null,null,null,null,null,"produit est versé cash comme un"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dividende le 31 décembre."]
[null,null,"Vente d'un nombre de titres plus"]
[null,null,"grand que ce que l'on possède."]
[]
["zoom",78,"Votre garantie vous permet jusqu'à"]
[null,null,"CHF 50'000.- de ventes non couvertes."]
[]
[null,null,"L'achat se fait automatiquement"]
[null,null,"aux échéances suivants :"]
[null,null,null,"avril"]
[null,null,null,"août"]
[null,null,null,"décembre"]
[null,null,null,null,null,null,null,null,"Inventaire final"]
[null,null,"Néanmoins, si à l'échéance vous n'êtes"]
[null,null,"pas en mesure de vous exécuter, le ",null,null,null,null,null,"Les titres sont évalués aux"]
[null,null,"bouton emprunt vous offre un prêt",null,null,null,null,null,"cours moyen nov.- déc."]
[null,null,"unique pour continuer la partie."]
[null,null,null,null,null,null,null,null,"Les warrants s'exercent"]
[null,null,"La deuxième fois, vous serez bloqué !",null,null,null,null,null,"automatiquement le 31.12 en cas"]
[null,null,null,null,null,null,null,null,"de profit. "]
[null,null,null,null,null,null,null,null,"La prime est perdue dans tous "]
[null,null,null,null,null,null,null,null,"les cas."]

{"sheet":"Portefeuille","index":4,"n_rows":37,"n_cols":36,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,23,36,26],[36,27,36,30],[1,33,1,34],[3,19,3,22],[3,23,3,26],[3,27,3,30],[2,28,2,30],[21,19,21,22],[21,23,21,26],[21,27,21,30],[17,32,17,33],[16,32,16,33],[34,32,34,33],[35,32,35,33],[18,23,18,26],[0,4,0,5],[0,25,0,29],[1,25,1,29],[0,7,1,23],[1,4,1,5],[18,27,18,30],[2,3,2,6],[20,3,20,6],[21,15,21,18],[3,15,3,18],[21,3,21,6],[21,7,21,10],[21,11,21,14],[3,3,3,6],[3,7,3,10],[3,11,3,14]]}
[null,null,null,null,"Légende :",null,null,"Portefeuille détaillé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D3","v":"Julius"},null,null,null,null,true]
[null,null,null,null,"Achats Ventes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21","v":"Baer"},null,75,null,null,false,null,null,"zoom",null,95]
[null,null,null,{"$f":"Accueil!L20","v":"Julius"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ajustement colonnes"]
[null,null,null,"Abeco",null,null,null,"Bell & Cie",null,null,null,"Comon",null,null,null,"Divogan",null,null,null,"Ob. Emotion",null,null,null,"Warrant BELL",null,null,null,"Warrant DIVO"]
[]
[null,null,"Janvier",{"$f":"'Bureau Direction'!$AO$23","v":0},{"$f":"IF(D6=0,\"\",\"x\")","v":""},{"$f":"IF(D6=0,0,'Bureau Direction'!$AO$11)","v":0},{"$f":"D6*F6*-1","v":0},{"$f":"'Bureau Direction'!$AO$24","v":0},{"$f":"IF(H6=0,\"\",\"x\")","v":""},{"$f":"IF(H6=0,0,'Bureau Direction'!$AO$12)","v":0},{"$f":"H6*J6*-1","v":0},{"$f":"'Bureau Direction'!$AO$25","v":0},{"$f":"IF(L6=0,\"\",\"x\")","v":""},{"$f":"IF(L6=0,0,'Bureau Direction'!$AO$13)","v":0},{"$f":"L6*N6*-1","v":0},{"$f":"'Bureau Direction'!$AO$26","v":0},{"$f":"IF(P6=0,\"\",\"x\")","v":""},{"$f":"IF(P6=0,0,'Bureau Direction'!$AO$14)","v":0},{"$f":"P6*R6*-1","v":0},{"$f":"'Bureau Direction'!$AO$27","v":0},{"$f":"IF(T6=0,\"\",\"x\")","v":""},{"$f":"IF(T6=0,0,'Bureau Direction'!$AO$15)","v":0},{"$f":"T6*V6*-1","v":0},{"$f":"'Bureau Direction'!$AO$28","v":0},{"$f":"IF(X6=0,\"\",\"x\")","v":""},{"$f":"IF(X6=0,0,'Bureau Direction'!$AO$88)","v":0},{"$f":"X6*Z6*-1","v":0},{"$f":"'Bureau Direction'!$AO$29","v":0},{"$f":"IF(AB6=0,\"\",\"x\")","v":""},{"$f":"IF(AB6=0,0,'Bureau Direction'!$AO$89)","v":0},{"$f":"AB6*AD6*-1","v":0},null,{"$f":"'Bureau Direction'!N13","v":"Abeco"},{"$f":"'Bureau Direction'!R13","v":16}]
[null,null,"Février",{"$f":"'Bureau Direction'!$AP$23","v":0},{"$f":"IF(D7=0,\"\",\"x\")","v":""},{"$f":"IF(D7=0,0,'Bureau Direction'!$AP$11)","v":0},{"$f":"D7*F7*-1","v":0},{"$f":"'Bureau Direction'!$AP$24","v":0},"",{"$f":"IF(H7=0,0,'Bureau Direction'!$AP$12)","v":0},{"$f":"H7*J7*-1","v":0},{"$f":"'Bureau Direction'!$AP$25","v":0},{"$f":"IF(L7=0,\"\",\"x\")","v":""},{"$f":"IF(L7=0,0,'Bureau Direction'!$AP$13)","v":0},{"$f":"L7*N7*-1","v":0},{"$f":"'Bureau Direction'!$AP$26","v":0},{"$f":"IF(P7=0,\"\",\"x\")","v":""},{"$f":"IF(P7=0,0,'Bureau Direction'!$AP$14)","v":0},{"$f":"P7*R7*-1","v":0},{"$f":"'Bureau Direction'!$AP$27","v":0},{"$f":"IF(T7=0,\"\",\"x\")","v":""},{"$f":"IF(T7=0,0,'Bureau Direction'!$AP$15)","v":0},{"$f":"T7*V7*-1","v":0},{"$f":"'Bureau Direction'!$AP$28","v":0},"",{"$f":"IF(X7=0,0,'Bureau Direction'!$AP$88)","v":0},{"$f":"X7*Z7*-1","v":0},{"$f":"'Bureau Direction'!$AP$29","v":0},{"$f":"IF(AB7=0,\"\",\"x\")","v":""},{"$f":"IF(AB7=0,0,'Bureau Direction'!$AP$89)","v":0},{"$f":"AB7*AD7*-1","v":0},null,{"$f":"'Bureau Direction'!N14","v":"Bell & Cie"},{"$f":"'Bureau Direction'!R14","v":2354}]
[null,null,"Mars",{"$f":"'Bureau Direction'!$AQ$23","v":0},"",{"$f":"IF(D8=0,0,'Bureau Direction'!$AQ$11)","v":0},0,{"$f":"'Bureau Direction'!$AQ$24","v":0},"",{"$f":"IF(H8=0,0,'Bureau Direction'!$AQ$12)","v":0},0,{"$f":"'Bureau Direction'!$AQ$25","v":0},"",{"$f":"IF(L8=0,0,'Bureau Direction'!$AQ$13)","v":0},0,{"$f":"'Bureau Direction'!$AQ$26","v":0},"",{"$f":"IF(P8=0,0,'Bureau Direction'!$AQ$14)","v":0},0,{"$f":"'Bureau Direction'!$AQ$27","v":0},"",{"$f":"IF(T8=0,0,'Bureau Direction'!$AQ$15)","v":0},0,{"$f":"'Bureau Direction'!$AQ$28","v":0},"",{"$f":"IF(X8=0,0,'Bureau Direction'!$AQ$88)","v":0},0,{"$f":"'Bureau Direction'!$AQ$29","v":0},"",{"$f":"IF(AB8=0,0,'Bureau Direction'!$AQ$89)","v":0},0,null,{"$f":"'Bureau Direction'!N15","v":"Comon"},{"$f":"'Bureau Direction'!R15","v":158}]
[null,null,"Avril",{"$f":"'Bureau Direction'!$AR$23","v":0},"",{"$f":"IF(D9=0,0,'Bureau Direction'!$AR$11)","v":0},0,{"$f":"'Bureau Direction'!$AR$24","v":0},"",{"$f":"IF(H9=0,0,'Bureau Direction'!$AR$12)","v":0},0,{"$f":"'Bureau Direction'!$AR$25","v":0},"",{"$f":"IF(L9=0,0,'Bureau Direction'!$AR$13)","v":0},0,{"$f":"'Bureau Direction'!$AR$26","v":0},"",{"$f":"IF(P9=0,0,'Bureau Direction'!$AR$14)","v":0},0,{"$f":"'Bureau Direction'!$AR$27","v":0},"",{"$f":"IF(T9=0,0,'Bureau Direction'!$AR$15)","v":0},0,{"$f":"'Bureau Direction'!$AR$28","v":0},"",{"$f":"IF(X9=0,0,'Bureau Direction'!$AR$88)","v":0},0,{"$f":"'Bureau Direction'!$AR$29","v":0},"",{"$f":"IF(AB9=0,0,'Bureau Direction'!$AR$89)","v":0},0,null,{"$f":"'Bureau Direction'!N16","v":"Divogan"},{"$f":"'Bureau Direction'!R16","v":591}]
[null,null,"Mai",{"$f":"'Bureau Direction'!$AS$23","v":0},"",{"$f":"IF(D10=0,0,'Bureau Direction'!$AS$11)","v":0},0,{"$f":"'Bureau Direction'!$AS$24","v":0},"",{"$f":"IF(H10=0,0,'Bureau Direction'!$AS$12)","v":0},0,{"$f":"'Bureau Direction'!$AS$25","v":0},"",{"$f":"IF(L10=0,0,'Bureau Direction'!$AS$13)","v":0},0,{"$f":"'Bureau Direction'!$AS$26","v":0},"",{"$f":"IF(P10=0,0,'Bureau Direction'!$AS$14)","v":0},0,{"$f":"'Bureau Direction'!$AS$27","v":0},"",{"$f":"IF(T10=0,0,'Bureau Direction'!$AS$15)","v":0},0,{"$f":"'Bureau Direction'!$AS$28","v":0},"",{"$f":"IF(X10=0,0,'Bureau Direction'!$AS$88)","v":0},0,{"$f":"'Bureau Direction'!$AS$29","v":0},"",{"$f":"IF(AB10=0,0,'Bureau Direction'!$AS$89)","v":0},0,null,{"$f":"'Bureau Direction'!N17","v":"Oblig. Emotion"},{"$f":"'Bureau Direction'!R17","v":5050}]
[null,null,"Juin",{"$f":"'Bureau Direction'!$AT$23","v":0},"",{"$f":"IF(D11=0,0,'Bureau Direction'!$AT$11)","v":0},0,{"$f":"'Bureau Direction'!$AT$24","v":0},"",{"$f":"IF(H11=0,0,'Bureau Direction'!$AT$12)","v":0},0,{"$f":"'Bureau Direction'!$AT$25","v":0},"",{"$f":"IF(L11=0,0,'Bureau Direction'!$AT$13)","v":0},0,{"$f":"'Bureau Direction'!$AT$26","v":0},"",{"$f":"IF(P11=0,0,'Bureau Direction'!$AT$14)","v":0},0,{"$f":"'Bureau Direction'!$AT$27","v":0},"",{"$f":"IF(T11=0,0,'Bureau Direction'!$AT$15)","v":0},0,{"$f":"'Bureau Direction'!$AT$28","v":0},"",{"$f":"IF(X11=0,0,'Bureau Direction'!$AT$88)","v":0},0,{"$f":"'Bureau Direction'!$AT$29","v":0},"",{"$f":"IF(AB11=0,0,'Bureau Direction'!$AT$89)","v":0},0,null,{"$f":"'Bureau Direction'!N18","v":"Warrant BELL"},{"$f":"'Bureau Direction'!R18","v":71.400000000000006}]
[null,null,"Juillet",{"$f":"'Bureau Direction'!$AU$23","v":0},"",{"$f":"IF(D12=0,0,'Bureau Direction'!$AU$11)","v":0},0,{"$f":"'Bureau Direction'!$AU$24","v":0},"",{"$f":"IF(H12=0,0,'Bureau Direction'!$AU$12)","v":0},0,{"$f":"'Bureau Direction'!$AU$25","v":0},"",{"$f":"IF(L12=0,0,'Bureau Direction'!$AU$13)","v":0},0,{"$f":"'Bureau Direction'!$AU$26","v":0},"",{"$f":"IF(P12=0,0,'Bureau Direction'!$AU$14)","v":0},0,{"$f":"'Bureau Direction'!$AU$27","v":0},"",{"$f":"IF(T12=0,0,'Bureau Direction'!$AU$15)","v":0},0,{"$f":"'Bureau Direction'!$AU$28","v":0},"",{"$f":"IF(X12=0,0,'Bureau Direction'!$AU$88)","v":0},0,{"$f":"'Bureau Direction'!$AU$29","v":0},"",{"$f":"IF(AB12=0,0,'Bureau Direction'!$AU$89)","v":0},0,null,{"$f":"'Bureau Direction'!N19","v":"Warrant DIVO"},{"$f":"'Bureau Direction'!R19","v":36.966666666666669}]
[null,null,"Août",{"$f":"'Bureau Direction'!$AV$23","v":0},"",{"$f":"IF(D13=0,0,'Bureau Direction'!$AV$11)","v":0},0,{"$f":"'Bureau Direction'!$AV$24","v":0},"",{"$f":"IF(H13=0,0,'Bureau Direction'!$AV$12)","v":0},0,{"$f":"'Bureau Direction'!$AV$25","v":0},"",{"$f":"IF(L13=0,0,'Bureau Direction'!$AV$13)","v":0},0,{"$f":"'Bureau Direction'!$AV$26","v":0},"",{"$f":"IF(P13=0,0,'Bureau Direction'!$AV$14)","v":0},0,{"$f":"'Bureau Direction'!$AV$27","v":0},"",{"$f":"IF(T13=0,0,'Bureau Direction'!$AV$15)","v":0},0,{"$f":"'Bureau Direction'!$AV$28","v":0},"",{"$f":"IF(X13=0,0,'Bureau Direction'!$AV$88)","v":0},0,{"$f":"'Bureau Direction'!$AV$29","v":0},"",{"$f":"IF(AB13=0,0,'Bureau Direction'!$AV$89)","v":0},0]
[null,null,"Septembre",{"$f":"'Bureau Direction'!$AW$23","v":0},"",{"$f":"IF(D14=0,0,'Bureau Direction'!$AW$11)","v":0},0,{"$f":"'Bureau Direction'!$AW$24","v":0},"",{"$f":"IF(H14=0,0,'Bureau Direction'!$AW$12)","v":0},0,{"$f":"'Bureau Direction'!$AW$25","v":0},"",{"$f":"IF(L14=0,0,'Bureau Direction'!$AW$13)","v":0},0,{"$f":"'Bureau Direction'!$AW$26","v":0},"",{"$f":"IF(P14=0,0,'Bureau Direction'!$AW$14)","v":0},0,{"$f":"'Bureau Direction'!$AW$27","v":0},"",{"$f":"IF(T14=0,0,'Bureau Direction'!$AW$15)","v":0},0,{"$f":"'Bureau Direction'!$AW$28","v":0},"",{"$f":"IF(X14=0,0,'Bureau Direction'!$AW$88)","v":0},0,{"$f":"'Bureau Direction'!$AW$29","v":0},"",{"$f":"IF(AB14=0,0,'Bureau Direction'!$AW$89)","v":0},0]
[null,null,"Octobre",{"$f":"'Bureau Direction'!$AX$23","v":0},"",{"$f":"IF(D15=0,0,'Bureau Direction'!$AX$11)","v":0},0,{"$f":"'Bureau Direction'!$AX$24","v":0},"",{"$f":"IF(H15=0,0,'Bureau Direction'!$AX$12)","v":0},0,{"$f":"'Bureau Direction'!$AX$25","v":0},"",{"$f":"IF(L15=0,0,'Bureau Direction'!$AX$13)","v":0},0,{"$f":"'Bureau Direction'!$AX$26","v":0},"",{"$f":"IF(P15=0,0,'Bureau Direction'!$AX$14)","v":0},0,{"$f":"'Bureau Direction'!$AX$27","v":0},"",{"$f":"IF(T15=0,0,'Bureau Direction'!$AX$15)","v":0},0,{"$f":"'Bureau Direction'!$AX$28","v":0},"",{"$f":"IF(X15=0,0,'Bureau Direction'!$AX$88)","v":0},0,{"$f":"'Bureau Direction'!$AX$29","v":0},"",{"$f":"IF(AB15=0,0,'Bureau Direction'!$AX$89)","v":0},0]
[null,null,"Novembre",{"$f":"'Bureau Direction'!$AY$23","v":0},"",{"$f":"IF(D16=0,0,'Bureau Direction'!$AY$11)","v":0},0,{"$f":"'Bureau Direction'!$AY$24","v":0},"",{"$f":"IF(H16=0,0,'Bureau Direction'!$AY$12)","v":0},0,{"$f":"'Bureau Direction'!$AY$25","v":0},"",{"$f":"IF(L16=0,0,'Bureau Direction'!$AY$13)","v":0},0,{"$f":"'Bureau Direction'!$AY$26","v":0},"",{"$f":"IF(P16=0,0,'Bureau Direction'!$AY$14)","v":0},0,{"$f":"'Bureau Direction'!$AY$27","v":0},"",{"$f":"IF(T16=0,0,'Bureau Direction'!$AY$15)","v":0},0,{"$f":"'Bureau Direction'!$AY$28","v":0},"",{"$f":"IF(X16=0,0,'Bureau Direction'!$AY$88)","v":0},0,{"$f":"'Bureau Direction'!$AY$29","v":0},"",{"$f":"IF(AB16=0,0,'Bureau Direction'!$AY$89)","v":0},0]
[null,null,"Décembre",{"$f":"'Bureau Direction'!$AZ$23","v":0},"",{"$f":"IF(D17=0,0,'Bureau Direction'!$AZ$11)","v":0},0,{"$f":"'Bureau Direction'!$AZ$24","v":0},"",{"$f":"IF(H17=0,0,'Bureau Direction'!$AZ$12)","v":0},0,{"$f":"'Bureau Direction'!$AZ$25","v":0},"",{"$f":"IF(L17=0,0,'Bureau Direction'!$AZ$13)","v":0},0,{"$f":"'Bureau Direction'!$AZ$26","v":0},"",{"$f":"IF(P17=0,0,'Bureau Direction'!$AZ$14)","v":0},0,{"$f":"'Bureau Direction'!$AZ$27","v":0},"",{"$f":"IF(T17=0,0,'Bureau Direction'!$AZ$15)","v":0},0,{"$f":"'Bureau Direction'!$AZ$28","v":0},"",{"$f":"IF(X17=0,0,'Bureau Direction'!$AZ$88)","v":0},0,{"$f":"'Bureau Direction'!$AZ$29","v":0},"",{"$f":"IF(AB17=0,0,'Bureau Direction'!$AZ$89)","v":0},0,null,"Ventes - achats"]
[null,null,"ventes-achats",null,null,null,{"$f":"SUM(G6:G17)","v":0},null,null,null,{"$f":"SUM(K6:K17)","v":0},null,null,null,{"$f":"SUM(O6:O17)","v":0},null,null,null,{"$f":"SUM(S6:S17)","v":0},null,null,null,{"$f":"SUM(W6:W17)","v":0},null,null,null,{"$f":"SUM(AA6:AA17)","v":0},null,null,null,{"$f":"SUM(AE6:AE17)","v":0},null,{"$f":"G18+K18+O18+S18+W18+AA18+AE18","v":0}]
[null,null,"Inventaire",{"$f":"SUM(D6:D17)","v":0},{"$f":"IF(D19=0,\"\",\"x\")","v":""},{"$f":"IF(D19=0,0,AH6)","v":0},{"$f":"D19*F19","v":0},{"$f":"SUM(H6:H17)","v":0},{"$f":"IF(H19=0,\"\",\"x\")","v":""},{"$f":"IF(H19=0,0,AH7)","v":0},{"$f":"H19*J19","v":0},{"$f":"SUM(L6:L17)","v":0},{"$f":"IF(L19=0,\"\",\"x\")","v":""},{"$f":"IF(L19=0,0,AH8)","v":0},{"$f":"L19*N19","v":0},{"$f":"SUM(P6:P17)","v":0},{"$f":"IF(P19=0,\"\",\"x\")","v":""},{"$f":"IF(P19=0,0,AH9)","v":0},{"$f":"P19*R19","v":0},{"$f":"SUM(T6:T17)","v":0},{"$f":"IF(T19=0,\"\",\"x\")","v":""},{"$f":"IF(T19=0,0,AH10)","v":0},{"$f":"T19*V19","v":0},"Total des primes :",null,null,null,{"$f":"AA18+AE18","v":0}]
[]
[null,null,null,{"$f":"Accueil!L21","v":"Baer"}]
[null,null,null,"Abeco",null,null,null,"Bell & Cie",null,null,null,"Comon",null,null,null,"Divogan",null,null,null,"Ob. Emotion",null,null,null,"Warrant BELL",null,null,null,"Warrant DIVO"]
[]
[null,null,"Janvier",{"$f":"'Bureau Direction'!$AO$35","v":0},{"$f":"IF(D24=0,\"\",\"x\")","v":""},{"$f":"IF(D24=0,0,'Bureau Direction'!$AO$11)","v":0},{"$f":"D24*F24*-1","v":0},{"$f":"'Bureau Direction'!$AO$36","v":0},{"$f":"IF(H24=0,\"\",\"x\")","v":""},{"$f":"IF(H24=0,0,'Bureau Direction'!$AO$12)","v":0},{"$f":"H24*J24*-1","v":0},{"$f":"'Bureau Direction'!$AO$37","v":0},{"$f":"IF(L24=0,\"\",\"x\")","v":""},{"$f":"IF(L24=0,0,'Bureau Direction'!$AO$13)","v":0},{"$f":"L24*N24*-1","v":0},{"$f":"'Bureau Direction'!$AO$38","v":0},{"$f":"IF(P24=0,\"\",\"x\")","v":""},{"$f":"IF(P24=0,0,'Bureau Direction'!$AO$14)","v":0},{"$f":"P24*R24*-1","v":0},{"$f":"'Bureau Direction'!$AO$39","v":0},{"$f":"IF(T24=0,\"\",\"x\")","v":""},{"$f":"IF(T24=0,0,'Bureau Direction'!$AO$15)","v":0},{"$f":"T24*V24*-1","v":0},{"$f":"'Bureau Direction'!$AO$40","v":0},{"$f":"IF(X24=0,\"\",\"x\")","v":""},{"$f":"IF(X24=0,0,'Bureau Direction'!$AO$92)","v":0},{"$f":"X24*Z24*-1","v":0},{"$f":"'Bureau Direction'!$AO$41","v":0},{"$f":"IF(AB24=0,\"\",\"x\")","v":""},{"$f":"IF(AB24=0,0,'Bureau Direction'!$AO$93)","v":0},{"$f":"AB24*AD24*-1","v":0}]
[null,null,"Février",{"$f":"'Bureau Direction'!$AP$35","v":0},{"$f":"IF(D25=0,\"\",\"x\")","v":""},{"$f":"IF(D25=0,0,'Bureau Direction'!$AP$11)","v":0},{"$f":"D25*F25*-1","v":0},{"$f":"'Bureau Direction'!$AP$36","v":0},"",{"$f":"IF(H25=0,0,'Bureau Direction'!$AP$12)","v":0},{"$f":"H25*J25*-1","v":0},{"$f":"'Bureau Direction'!$AP$37","v":0},{"$f":"IF(L25=0,\"\",\"x\")","v":""},{"$f":"IF(L25=0,0,'Bureau Direction'!$AP$13)","v":0},{"$f":"L25*N25*-1","v":0},{"$f":"'Bureau Direction'!$AP$38","v":0},{"$f":"IF(P25=0,\"\",\"x\")","v":""},{"$f":"IF(P25=0,0,'Bureau Direction'!$AP$14)","v":0},{"$f":"P25*R25*-1","v":0},{"$f":"'Bureau Direction'!$AP$39","v":0},{"$f":"IF(T25=0,\"\",\"x\")","v":""},{"$f":"IF(T25=0,0,'Bureau Direction'!$AP$15)","v":0},{"$f":"T25*V25*-1","v":0},{"$f":"'Bureau Direction'!$AP$40","v":0},"",{"$f":"IF(X25=0,0,'Bureau Direction'!$AP$92)","v":0},{"$f":"X25*Z25*-1","v":0},{"$f":"'Bureau Direction'!$AP$41","v":0},{"$f":"IF(AB25=0,\"\",\"x\")","v":""},{"$f":"IF(AB25=0,0,'Bureau Direction'!$AP$93)","v":0},{"$f":"AB25*AD25*-1","v":0}]
[null,null,"Mars",{"$f":"'Bureau Direction'!$AQ$35","v":0},"",{"$f":"IF(D26=0,0,'Bureau Direction'!$AQ$11)","v":0},0,{"$f":"'Bureau Direction'!$AQ$36","v":0},"",{"$f":"IF(H26=0,0,'Bureau Direction'!$AQ$12)","v":0},0,{"$f":"'Bureau Direction'!$AQ$37","v":0},"",{"$f":"IF(L26=0,0,'Bureau Direction'!$AQ$13)","v":0},0,{"$f":"'Bureau Direction'!$AQ$38","v":0},"",{"$f":"IF(P26=0,0,'Bureau Direction'!$AQ$14)","v":0},0,{"$f":"'Bureau Direction'!$AQ$39","v":0},"",{"$f":"IF(T26=0,0,'Bureau Direction'!$AQ$15)","v":0},0,{"$f":"'Bureau Direction'!$AQ$40","v":0},"",{"$f":"IF(X26=0,0,'Bureau Direction'!$AQ$92)","v":0},0,{"$f":"'Bureau Direction'!$AQ$41","v":0},"",{"$f":"IF(AB26=0,0,'Bureau Direction'!$AQ$93)","v":0},0]
[null,null,"Avril",{"$f":"'Bureau Direction'!$AR$35","v":0},"",{"$f":"IF(D27=0,0,'Bureau Direction'!$AR$11)","v":0},0,{"$f":"'Bureau Direction'!$AR$36","v":0},"",{"$f":"IF(H27=0,0,'Bureau Direction'!$AR$12)","v":0},0,{"$f":"'Bureau Direction'!$AR$37","v":0},"",{"$f":"IF(L27=0,0,'Bureau Direction'!$AR$13)","v":0},0,{"$f":"'Bureau Direction'!$AR$38","v":0},"",{"$f":"IF(P27=0,0,'Bureau Direction'!$AR$14)","v":0},0,{"$f":"'Bureau Direction'!$AR$39","v":0},"",{"$f":"IF(T27=0,0,'Bureau Direction'!$AR$15)","v":0},0,{"$f":"'Bureau Direction'!$AR$40","v":0},"",{"$f":"IF(X27=0,0,'Bureau Direction'!$AR$92)","v":0},0,{"$f":"'Bureau Direction'!$AR$41","v":0},"",{"$f":"IF(AB27=0,0,'Bureau Direction'!$AR$93)","v":0},0]
[null,null,"Mai",{"$f":"'Bureau Direction'!$AS$35","v":0},"",{"$f":"IF(D28=0,0,'Bureau Direction'!$AS$11)","v":0},0,{"$f":"'Bureau Direction'!$AS$36","v":0},"",{"$f":"IF(H28=0,0,'Bureau Direction'!$AS$12)","v":0},0,{"$f":"'Bureau Direction'!$AS$37","v":0},"",{"$f":"IF(L28=0,0,'Bureau Direction'!$AS$13)","v":0},0,{"$f":"'Bureau Direction'!$AS$38","v":0},"",{"$f":"IF(P28=0,0,'Bureau Direction'!$AS$14)","v":0},0,{"$f":"'Bureau Direction'!$AS$39","v":0},"",{"$f":"IF(T28=0,0,'Bureau Direction'!$AS$15)","v":0},0,{"$f":"'Bureau Direction'!$AS$40","v":0},"",{"$f":"IF(X28=0,0,'Bureau Direction'!$AS$92)","v":0},0,{"$f":"'Bureau Direction'!$AS$41","v":0},"",{"$f":"IF(AB28=0,0,'Bureau Direction'!$AS$93)","v":0},0]
[null,null,"Juin",{"$f":"'Bureau Direction'!$AT$35","v":0},"",{"$f":"IF(D29=0,0,'Bureau Direction'!$AT$11)","v":0},0,{"$f":"'Bureau Direction'!$AT$36","v":0},"",{"$f":"IF(H29=0,0,'Bureau Direction'!$AT$12)","v":0},0,{"$f":"'Bureau Direction'!$AT$37","v":0},"",{"$f":"IF(L29=0,0,'Bureau Direction'!$AT$13)","v":0},0,{"$f":"'Bureau Direction'!$AT$38","v":0},"",{"$f":"IF(P29=0,0,'Bureau Direction'!$AT$14)","v":0},0,{"$f":"'Bureau Direction'!$AT$39","v":0},"",{"$f":"IF(T29=0,0,'Bureau Direction'!$AT$15)","v":0},0,{"$f":"'Bureau Direction'!$AT$40","v":0},"",{"$f":"IF(X29=0,0,'Bureau Direction'!$AT$92)","v":0},0,{"$f":"'Bureau Direction'!$AT$41","v":0},"",{"$f":"IF(AB29=0,0,'Bureau Direction'!$AT$93)","v":0},0]
[null,null,"Juillet",{"$f":"'Bureau Direction'!$AU$35","v":0},"",{"$f":"IF(D30=0,0,'Bureau Direction'!$AU$11)","v":0},0,{"$f":"'Bureau Direction'!$AU$36","v":0},"",{"$f":"IF(H30=0,0,'Bureau Direction'!$AU$12)","v":0},0,{"$f":"'Bureau Direction'!$AU$37","v":0},"",{"$f":"IF(L30=0,0,'Bureau Direction'!$AU$13)","v":0},0,{"$f":"'Bureau Direction'!$AU$38","v":0},"",{"$f":"IF(P30=0,0,'Bureau Direction'!$AU$14)","v":0},0,{"$f":"'Bureau Direction'!$AU$39","v":0},"",{"$f":"IF(T30=0,0,'Bureau Direction'!$AU$15)","v":0},0,{"$f":"'Bureau Direction'!$AU$40","v":0},"",{"$f":"IF(X30=0,0,'Bureau Direction'!$AU$92)","v":0},0,{"$f":"'Bureau Direction'!$AU$41","v":0},"",{"$f":"IF(AB30=0,0,'Bureau Direction'!$AU$93)","v":0},0]
[null,null,"Août",{"$f":"'Bureau Direction'!$AV$35","v":0},"",{"$f":"IF(D31=0,0,'Bureau Direction'!$AV$11)","v":0},0,{"$f":"'Bureau Direction'!$AV$36","v":0},"",{"$f":"IF(H31=0,0,'Bureau Direction'!$AV$12)","v":0},0,{"$f":"'Bureau Direction'!$AV$37","v":0},"",{"$f":"IF(L31=0,0,'Bureau Direction'!$AV$13)","v":0},0,{"$f":"'Bureau Direction'!$AV$38","v":0},"",{"$f":"IF(P31=0,0,'Bureau Direction'!$AV$14)","v":0},0,{"$f":"'Bureau Direction'!$AV$39","v":0},"",{"$f":"IF(T31=0,0,'Bureau Direction'!$AV$15)","v":0},0,{"$f":"'Bureau Direction'!$AV$40","v":0},"",{"$f":"IF(X31=0,0,'Bureau Direction'!$AV$92)","v":0},0,{"$f":"'Bureau Direction'!$AV$41","v":0},"",{"$f":"IF(AB31=0,0,'Bureau Direction'!$AV$93)","v":0},0]
[null,null,"Septembre",{"$f":"'Bureau Direction'!$AW$35","v":0},"",{"$f":"IF(D32=0,0,'Bureau Direction'!$AW$11)","v":0},0,{"$f":"'Bureau Direction'!$AW$36","v":0},"",{"$f":"IF(H32=0,0,'Bureau Direction'!$AW$12)","v":0},0,{"$f":"'Bureau Direction'!$AW$37","v":0},"",{"$f":"IF(L32=0,0,'Bureau Direction'!$AW$13)","v":0},0,{"$f":"'Bureau Direction'!$AW$38","v":0},"",{"$f":"IF(P32=0,0,'Bureau Direction'!$AW$14)","v":0},0,{"$f":"'Bureau Direction'!$AW$39","v":0},"",{"$f":"IF(T32=0,0,'Bureau Direction'!$AW$15)","v":0},0,{"$f":"'Bureau Direction'!$AW$40","v":0},"",{"$f":"IF(X32=0,0,'Bureau Direction'!$AW$92)","v":0},0,{"$f":"'Bureau Direction'!$AW$41","v":0},"",{"$f":"IF(AB32=0,0,'Bureau Direction'!$AW$93)","v":0},0]
[null,null,"Octobre",{"$f":"'Bureau Direction'!$AX$35","v":0},"",{"$f":"IF(D33=0,0,'Bureau Direction'!$AX$11)","v":0},0,{"$f":"'Bureau Direction'!$AX$36","v":0},"",{"$f":"IF(H33=0,0,'Bureau Direction'!$AX$12)","v":0},0,{"$f":"'Bureau Direction'!$AX$37","v":0},"",{"$f":"IF(L33=0,0,'Bureau Direction'!$AX$13)","v":0},0,{"$f":"'Bureau Direction'!$AX$38","v":0},"",{"$f":"IF(P33=0,0,'Bureau Direction'!$AX$14)","v":0},0,{"$f":"'Bureau Direction'!$AX$39","v":0},"",{"$f":"IF(T33=0,0,'Bureau Direction'!$AX$15)","v":0},0,{"$f":"'Bureau Direction'!$AX$40","v":0},"",{"$f":"IF(X33=0,0,'Bureau Direction'!$AX$92)","v":0},0,{"$f":"'Bureau Direction'!$AX$41","v":0},"",{"$f":"IF(AB33=0,0,'Bureau Direction'!$AX$93)","v":0},0]
[null,null,"Novembre",{"$f":"'Bureau Direction'!$AY$35","v":0},"",{"$f":"IF(D34=0,0,'Bureau Direction'!$AY$11)","v":0},0,{"$f":"'Bureau Direction'!$AY$36","v":0},"",{"$f":"IF(H34=0,0,'Bureau Direction'!$AY$12)","v":0},0,{"$f":"'Bureau Direction'!$AY$37","v":0},"",{"$f":"IF(L34=0,0,'Bureau Direction'!$AY$13)","v":0},0,{"$f":"'Bureau Direction'!$AY$38","v":0},"",{"$f":"IF(P34=0,0,'Bureau Direction'!$AY$14)","v":0},0,{"$f":"'Bureau Direction'!$AY$39","v":0},"",{"$f":"IF(T34=0,0,'Bureau Direction'!$AY$15)","v":0},0,{"$f":"'Bureau Direction'!$AY$40","v":0},"",{"$f":"IF(X34=0,0,'Bureau Direction'!$AY$92)","v":0},0,{"$f":"'Bureau Direction'!$AY$41","v":0},"",{"$f":"IF(AB34=0,0,'Bureau Direction'!$AY$93)","v":0},0]
[null,null,"Décembre",{"$f":"'Bureau Direction'!$AZ$35","v":0},"",{"$f":"IF(D35=0,0,'Bureau Direction'!$AZ$11)","v":0},0,{"$f":"'Bureau Direction'!$AZ$36","v":0},"",{"$f":"IF(H35=0,0,'Bureau Direction'!$AZ$12)","v":0},0,{"$f":"'Bureau Direction'!$AZ$37","v":0},"",{"$f":"IF(L35=0,0,'Bureau Direction'!$AZ$13)","v":0},0,{"$f":"'Bureau Direction'!$AZ$38","v":0},"",{"$f":"IF(P35=0,0,'Bureau Direction'!$AZ$14)","v":0},{"$f":"P35*R35","v":0},{"$f":"'Bureau Direction'!$AZ$39","v":0},"",{"$f":"IF(T35=0,0,'Bureau Direction'!$AZ$15)","v":0},0,{"$f":"'Bureau Direction'!$AZ$40","v":0},"",{"$f":"IF(X35=0,0,'Bureau Direction'!$AZ$92)","v":0},0,{"$f":"'Bureau Direction'!$AZ$41","v":0},"",{"$f":"IF(AB35=0,0,'Bureau Direction'!$AZ$93)","v":0},0,null,"Ventes - achats"]
[null,null,"ventes-achats",null,null,null,{"$f":"SUM(G24:G35)","v":0},null,null,null,{"$f":"SUM(K24:K35)","v":0},null,null,null,{"$f":"SUM(O24:O35)","v":0},null,null,null,{"$f":"SUM(S24:S35)","v":0},null,null,null,{"$f":"SUM(W24:W35)","v":0},null,null,null,{"$f":"SUM(AA24:AA35)","v":0},null,null,null,{"$f":"SUM(AE24:AE35)","v":0},null,{"$f":"G36+K36+O36+S36+W36+AA36+AE36","v":0}]
[null,null,"Inventaire",{"$f":"SUM(D24:D35)","v":0},{"$f":"IF(D37=0,\"\",\"x\")","v":""},{"$f":"IF(D37=0,0,AH6)","v":0},{"$f":"D37*F37","v":0},{"$f":"SUM(H24:H35)","v":0},{"$f":"IF(H37=0,\"\",\"x\")","v":""},{"$f":"IF(H37=0,0,AH7)","v":0},{"$f":"H37*J37","v":0},{"$f":"SUM(L24:L35)","v":0},{"$f":"IF(L37=0,\"\",\"x\")","v":""},{"$f":"IF(L37=0,0,AH8)","v":0},{"$f":"L37*N37","v":0},{"$f":"SUM(P24:P35)","v":0},{"$f":"IF(P37=0,\"\",\"x\")","v":""},{"$f":"IF(P37=0,0,AH9)","v":0},{"$f":"P37*R37","v":0},{"$f":"SUM(T24:T35)","v":0},{"$f":"IF(T37=0,\"\",\"x\")","v":""},{"$f":"IF(T37=0,0,AH10)","v":0},{"$f":"T37*V37","v":0},"Total des primes :",null,null,null,{"$f":"AA36+AE36","v":0}]

{"sheet":"   Presse    ","index":5,"n_rows":58,"n_cols":37,"rows_kept":58,"cut":false,"hidden":false,"merged":[[29,9,29,10],[26,2,26,6],[7,2,8,4],[9,2,9,4],[7,6,16,6],[10,2,22,2],[10,4,22,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entreprise no",{"$f":"'Bureau Direction'!AF9","v":"Emprunt"},"Nom :",{"$f":"VLOOKUP(P1,'Bureau Direction'!AJ23:AN27,2)","v":0},"Nb Employés",{"$f":"'Bureau Direction'!L4","v":0},null,null,null,null,"Faillite :",{"$f":"VLOOKUP(P1,Datavar,16)","v":{"$error":"#NAME?"}}]
[null,null,"  ",null,null,null,null,null,"Sommaire",null,null,null,null,null,"Commentaire no",1,4,null,null,null,null,null,null,null,{"$f":"'Bureau Direction'!H16","v":0},null,null,null,null,null,null,null,null,null,"Journal, groupement des lignes"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,"Articles","1. Présentation","2. La bourse","3. Les actions","4. Les obligations","5. Les futures","6. Les options","7. Les warrant","8. Les ventes à découvert","9. La tendance","10. Stratégie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"largeur 21 svp",1,2,3,4,5,6,7,8,9,10]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,0,"SMAK-MARKET","LA BOURSE","Les actions","Les obligations","Les futures","Les options","Les warrants","VAD - Ventes à découvert","La tendance","Stratégie",1]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,1,"Un jeu de bourse","Confrontation entre l'offre et la demande","Des titres de propriété","Des titres de créance","Contrats d'achat ou de vente à terme","Achat ou vente d'un droit","Une forme d'option à succès.","Outils pour spéculer à la baisse","Des indices pour nous guider","Comment se protéger dans une VAD ?"," "]
[null,null,null,null,null,null,2,null,null,null,null,null,null,null,2,"S’initier à la bourse, sans risque de se ruiner, voici le but de ce jeu de simulation. Vous pouvez placer votre argent en « père de famille » sur des actions stables ou en obligations. Vous pouvez aussi « boursicoter » pour tenter des gains alléchants en multipliant les achats et les ventes des titres les plus volatils (dont l'amplitude des cours est importante).","Investir en bourse revient à acheter ou vendre des titres en fonction de ses objectifs (par exemple faire un profit rapide en prenant des risques ou avoir une épargne rentable sur le long terme). Au cours de chaque séance, une même valeur peut voir son cours fluctuer de façon importante. Tout dépend de la confrontation entre l'offre (les vendeurs) et la demande (les acheteurs) .","Une action est une part du capital de l’entreprise. Ainsi, en devenant actionnaire, vous devenez co-propriétaire de la société. En contrepartie de l'achat d'actions, l'investisseur a des droits patrimoniaux comme le droit à une part de bénéfice (dividende) ainsi que le droit de souscription lors de l'émission de nouvelles actions et des droits sociaux comme le droit de vote aux Assemblées et un droit de contrôle. ","Une obligation est un titre représentatif d'une créance émise par l'Etat ou par une société privée ou parapublique. En contrepartie de son prêt, le souscripteur reçoit chaque année des intérêts qui peuvent être fixes, variables ou indexés. Les obligations sont définies par le nom de l'emprunteur, le taux d'intérêt, la date d'émission et la date de remboursement.","Imaginons que vous êtes producteur de Blé. La récolte se fait en été, mais les ventes n'auront lieu qu'en automne. Le blé se traite aujourd'hui sur le marché au comptant à 1200 $ la tonne. Au prix actuel, vous savez combien vaut votre récolte; ce que vous ignorez, c'est le prix auquel vous pourrez vendre cette récolte dans 3 mois. Pour éviter de perdre de l'argent si les prix venaient à connaître une","Une option donne à son acquéreur, moyennant le paiement d'une prime (ou prix de l'option appelé premium), le droit, et non l'obligation, d'acheter (option d'achat ou Call) ou de vendre (option de vente ou put), à un prix fixé à l'avance (prix d'exercice), une quantité déterminée d'un actif financier appelé actif sous-jacent (actions, devises, indices, contrats sur emprunt, etc...), ","Un warrant se définit comme ","La vente à découvert consiste à emprunter un titre à un intermédiaire financier pour le vendre sur le marché et le racheter à terme afin de le rendre à son propriétaire. Vous vendez des titres que vous n'avez pas dans l'espoir de les racheter à un cours inférieur Cette opération n'est lucrative que si le titre en question baisse entre la date de sa vente et celle de son rachat. La vente à découvert permet de spéculer à la baisse.","Les lignes de tendances sont la loi de base de l'analyse technique. Quelque analyse que vous appliquiez, vous devrez d'abord positionner et étudier soigneusement vos lignes pour déceler le comportement d'un titre, savoir comment il évolue. ","L'investisseur qui a vendu des actions à découvert peut se protéger d'une hausse des cours en achetant une option (ou un warrant) sur ces mêmes actions. Si le cours monte, il exercera son call."," ",null,null,null,null,null,null,null," ",{"$f":"VLOOKUP(2,Articles,$P$2+1)","v":"S’initier à la bourse, sans risque de se ruiner, voici le but de ce jeu de simulation. Vous pouvez placer votre argent en « père de famille » sur des actions stables ou en obligations. Vous pouvez aussi « boursicoter » pour tenter des gains alléchants en multipliant les achats et les ventes des titres les plus volatils (dont l'amplitude des cours est importante)."},{"$f":"VLOOKUP(15,Articles,$P$2+1)","v":"Mais, si les frissons de la spéculation vous attirent, alors jouez gros sur les opérations à découvert ou exploitez l’effet de levier  des warrants."},{"$f":"VLOOKUP(28,Articles,$P$2+1)","v":"Des guides en ligne sont à votre disposition chez:"}]
[null,null,{"$f":"VLOOKUP(0,Articles,P2+1)","v":"SMAK-MARKET"},null,null,null,{"$f":"AK7&AK8&AK9&AK10&AK11&AK12&AK13&AK14&AK15&AK16&AK17&AK18&AK19","v":"Des guides en ligne sont à votre disposition chez:   www.edubourse.com           www.abcbourse.com           www.boursorama.com              www.oddowarrants.fr                             "},null,null,null,null,null,null,null,3,"  ","  "," "," "," "," ","le droit d'acheter ou de vendre un actif financier dans "," "," "," L'option d'achat constitue une protection efficace contre une fluctuation défavorable des cours puisqu'elle fixe le prix maximal que l'investisseur doit payer pour racheter ses actions."," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(3,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(16,Articles,$P$2+1)","v":"   Les \"futures\" et les \"options\" sont d'autres instruments financiers à disposition des spéculateurs, mais ils ne sont pas présents dans ce jeu."},{"$f":"VLOOKUP(29,Articles,$P$2+1)","v":"   www.edubourse.com           www.abcbourse.com           www.boursorama.com              www.oddowarrants.fr"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"  ","  "," "," "," "," ","des conditions de prix et de durée définies à l'avance. Ainsi, le call warrant donne le droit d'acheter un sous-jacent donné à un prix fixé (le prix d'exercice) jusqu'à une date donnée (l'échéance), et, le put warrant donne le droit de vendre à un prix fixé (le prix d'exercice) jusqu'à une date donnée (l'échéance) ce sous-jacent. "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(4,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(17,Articles,$P$2+1)","v":"   Put, call, sous-jacent, strike…, voici quelques notions  que vous devez maîtriser pour jouer les investisseurs ici  ou dans la vie."},{"$f":"VLOOKUP(30,Articles,$P$2+1)","v":"                    "}]
[null,null,{"$f":"VLOOKUP(1,Articles,P2+1)","v":"Un jeu de bourse"},null,null,null,null,null,null,null,null,null,null,null,5,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(5,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(18,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(31,Articles,$P$2+1)","v":" "}]
[null,null,{"$f":"AI7&AI8&AI9&AI10&AI11&AI12&AI13&AI14&AI15&AI16&AI17&AI18&AI19","v":"S’initier à la bourse, sans risque de se ruiner, voici le but de ce jeu de simulation. Vous pouvez placer votre argent en « père de famille » sur des actions stables ou en obligations. Vous pouvez aussi « boursicoter » pour tenter des gains alléchants en multipliant les achats et les ventes des titres les plus volatils (dont l'amplitude des cours est importante).                        "},null,{"$f":"AJ7&AJ8&AJ9&AJ10&AJ11&AJ12&AJ13&AJ14&AJ15&AJ16&AJ17&AJ18&AJ19","v":"Mais, si les frissons de la spéculation vous attirent, alors jouez gros sur les opérations à découvert ou exploitez l’effet de levier  des warrants.   Les \"futures\" et les \"options\" sont d'autres instruments financiers à disposition des spéculateurs, mais ils ne sont pas présents dans ce jeu.   Put, call, sous-jacent, strike…, voici quelques notions  que vous devez maîtriser pour jouer les investisseurs ici  ou dans la vie.                    "},null,null,null,null,null,null,null,null,null,6,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(6,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(19,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(32,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(7,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(20,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(33,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(8,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(21,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(34,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(9,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(22,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(35,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(10,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(23,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(36,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"  ","  "," "," "," "," ","   "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(11,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(24,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(37,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"  ","  "," "," "," "," ","  "," "," "," "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(12,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(25,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(38,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"  ","  "," "," "," "," ","  "," "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(13,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(26,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(39,Articles,$P$2+1)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"  "," "," "," "," "," ","  "," ","   ","  "," ",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(14,Articles,$P$2+1)","v":"  "},{"$f":"VLOOKUP(27,Articles,$P$2+1)","v":"  "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Mais, si les frissons de la spéculation vous attirent, alors jouez gros sur les opérations à découvert ou exploitez l’effet de levier  des warrants.",". Le cours d'une valeur monte lorsque les investisseurs voulant acheter les titres de cette valeur sont plus nombreux que les vendeurs. Pour savoir quand vendre ou quand acheter une valeur, plusieurs éléments sont à prendre en compte : la santé financière de l'entreprise, son marché, ses produits, le contexte économique, son actualité, ses prévisions et son environnement. ","Le marché action est scindé en deux : le marché primaire et le marché secondaire. Le marché primaire est le lieu où sont émis les titres, c'est-à-dire vendus par l'entreprise. C'est sur ce marché que l'entreprise trouve ses sources de financement. Une fois vendue sur le marché primaire, l'action peut alors être échangée sur le marché secondaire incarné par la bourse. ","Coupon :"," chute inattendue, vous pouvez vous entendre aujourd'hui avec un acheteur pour lui vendre votre blé dans trois mois à un prix que vous fixerez dès maintenant. ","pendant une période définie par une date d'échéance.","L'acheteur du warrant dispose donc d'un droit, qu'il a payé, sur le support. S'il décide d'exercer son droit, il peut acheter (call warrant) ou bien vendre (put warrant) le support au prix d'exercice, jusqu'à l'échéance.","La VAD, est une opération SRD (Service de réglement différé), permettant de vendre à crédit des titres que l'on ne détient pas.    ","Un indice permet d'évaluer l'état du marché grâce à un échantillon de valeurs représentatives. C'est ainsi un bon outil de comparaison pour évaluer les performances de son propre portefeuille.","La gourmandise est mauvaise conseillère en bourse. Mieux vaut souvent se contenter de prises de bénéfice modestes qu'attendre des produits fabuleux mais  hypothétiques !"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"   Les \"futures\" et les \"options\" sont d'autres instruments financiers à disposition des spéculateurs, mais ils ne sont pas présents dans ce jeu."," "," "," Intérêts servis par une obligation. Le coupon couru représente les intérêts d'une obligation qui  s'accumulent quotidiennement entre deux dates de versement. On parle de coupon échu ou de  tombée de coupon lorsque l'émetteur verse les intérêts d'une obligation."," Les \"futures\" sont des instruments financiers de la catégorie des contrats à terme.","                                                               "," Un warrant est un produit négociable : l'acheteur de warrant peut s'en séparer à tout moment en le revendant en bourse."," LES RISQUES : les ventes à découvert constituent une stratégie de placement très spéculative et très risquée car le montant de perte est illimité si le cours du titre s'envole. Cet outil doit donc être employé avec vigilance et ne pas représenter une part importante d'un portefeuille boursier.","      ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"   Put, call, sous-jacent, strike…, voici quelques notions  que vous devez maîtriser pour jouer les investisseurs ici  ou dans la vie."," "," "," ","  En résumé, les \"futures\" sont des contrats à terme qui incorporent une obligation d'achat ou de vente d'un sous-jacent dans le futur.","                            Comme les \"futures\", les options font partie de la famille des \"produits dérivés\".  Mais dans le cas de l'option, les acheteurs n'ont pas à se soucier de trouver un vendeur car c'est une chambre de compensation qui joue le rôle de la contrepartie. ","  "," ","                 Chaque place boursière a ses indices :                                        ","  "," ",null,null,null,null,null,null,null,null,"Titres"]
[null,null,null,{"$f":"P2","v":1},null,null,"reuter",null,null,null,null,null,null,null,18,"  "," "," "," "," "," ","  ","  ","SMI Swiss Market Index -  Dow Jones  New York - NASDAQ   New York -  Nikkei Tokyo  - CAC40 Paris - FTSE100 Londres  - DAX Francfort."," "," ",null,null,null,null,null,null,null,null,{"$f":"P3","v":"1. Présentation"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"  "," "," "," "," "," ","  ","  "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"Q3","v":"2. La bourse"}]
[null,75,null,null,null,null,null,null,null,null,null,null,null,null,20,"  "," "," "," "," "," ","  ","  "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"R3","v":"3. Les actions"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"  "," "," "," "," "," ","  ","  "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"S3","v":"4. Les obligations"}]
[null,null,"Consultez le lexique de Smak-Market !",null,null,null,null,null,null,null,null,null,null,null,22,"  "," "," "," "," "," ","  ","  "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"T3","v":"5. Les futures"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"  "," "," "," "," "," ","  ","  "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"U3","v":"6. Les options"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"  "," "," "," "," "," ","  ","  "," ","  "," ",null,null,null,null,null,null,null,null,{"$f":"V3","v":"7. Les warrant"}]
[null,null,null,null,null,null,null,null,"zoom",105,null,null,null,null,25,"  "," "," "," "," "," ","  ","  ","  ","  "," ",null,null,null,null,null,null,null,null,{"$f":"W3","v":"8. Les ventes à découvert"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"  "," "," "," "," "," ","  ","  ","  ","  "," ",null,null,null,null,null,null,null,null,{"$f":"X3","v":"9. La tendance"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"  "," "," ","  "," "," ","  ","  ","   "," "," ",null,null,null,null,null,null,null,null,{"$f":"Y3","v":"10. Stratégie"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Des guides en ligne sont à votre disposition chez:","Rôle de la Bourse :            ","D'une certaine manière on peut dire que le marché primaire est le marché du neuf et le marché secondaire celui de l'occasion.","Dans ce jeu, l'intérêt couru est calculé depuis le début de l'année, jusqu'à la fin du mois en cours (4 1/4% sur 5'000.-). Lors de l'achat d'une obligation EMOTION, l'intérêt couru est ajouté aux charges, à côté des frais de courtage. Lors de la vente, il est enregistré comme produit.","Il n'y a pas de \"futures\" à disposition dans Smak-Market. Pour spéculer dans le futur, utilisez la vente à découvert ou le warrant.","Américaine ou Européenne ?           Si l'option peut être exercée à tout moment et ce jusqu'à l'échéance, on parle d'option à l'américaine. Dans le cas ou elle ne peut être exercée qu'à l'échéance, on parle d'option Européenne.","Contrairement aux options normales, qui sont gérées par une caisse de compensation, les warrants sont des options standardisées fabriquées par des grandes Banques pour être vendues sur le marché comme de simples produits de consommation boursière.","Dans ce jeu, il suffit de vendre une action que l'on n'a pas pour faire une vente à découvet. Le produit de la vente est bloqué en compte. L'achat se fait automatiquement aux dates de liquidation. (ler avril, ler août, ler décembre)","Dans cette simulation, la tendance est donnée par un signe arithmétique à droite de la cote. Tendance à la hausse +, tendance à la baisse -, titre stable =, titre volatile + -.","Si les tendances exprimées  ne semblent pas intéressantes pour le jeu, il est possible, avant de commencer la partie, de choisir une autre période en cliquant sur le livre *Cote\" déposé dans la bibliothèque."," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"   www.edubourse.com           www.abcbourse.com           www.boursorama.com              www.oddowarrants.fr","Une société qui cherche des fonds a la possibilité d’augmenter son capital. La bourse, en trouvant des actionnaires est une chance unique pour les entreprises, et un formidable outil de placement pour les investisseurs."," "," "," "," "," ","  ","Le SMI (Smak Market Indice) donne la valeur moyenne des titres de ce jeu.","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"                    "," "," "," "," "," "," ","  ","  ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,31," "," "," "," "," "," "," ","  ","  ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,32," "," "," "," "," "," "," ","  ","  ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,33," "," "," "," "," "," "," ","  ","  ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,34," "," "," "," "," "," "," ","  ","  ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,35," "," "," "," "," "," "," ","  ","  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,36," "," "," "," "," "," "," ","  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,37," "," "," "," "," "," "," ","  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,38," "," "," "," "," "," "," ","  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,39," "," "," "," "," "," ","  ","  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,40," "," ",null," "," "," ",null,"  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"   "," ","   "," "," "," "," ","  ","  "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"  ","   ","   "," "," "," ","  ","  ","  ","  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"  ","   ","   ","   ","   "," ","   ","  ","  "," "]
[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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"L","index":6,"n_rows":369,"n_cols":4,"rows_kept":369,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,2,2,3]]}
["Vocabulaire économique et boursier"]
[]
[]
["A",null,"à vue","Immédiatement à la présentation d'un papier-valeur"]
[null,null,"acceptation","Signature du tiré sur un effet de change par laquelle il s'engage à payer le montant indiqué."]
[null,null,"accroche","Titre d'un texte publicitaire souvent mis en valeur graphiquement. (Headline)"]
[null,null,"acompte","Versement d'une partie d'une somme due, à valoir sur le paiement final."]
[null,null,"acte","Ecrit constatant légalement un fait."]
[null,null,"acte authentique","Ecrit constatant légalement un fait et établi par un notaire"]
[null,null,"acte de défaut de biens","Document établissant, après la faillite, le montant non couvert d'une créance."]
[null,null,"actif","Partie gauche du Bilan où sont énumérés tous les emplois non-consommés"]
[null,null,"action","Titre de copropriété qui donne à son détenteur (l'actionnaire) des droits patrimoniaux et sociaux sur une entreprise."]
[null,null,"adjudication","Acte par lequel on attribue quelque chose (un bien ou des travaux) à quelqu'un."]
[null,null,"agencement","Disposition, installation d'un magasin. (vitrines, mobilier, etc...)"]
[null,null,"aliéner","Fait de transmettre à une personne une propriété ou un droit."]
[null,null,"allouer","Attribuer une somme d'argent à quelqu'un"]
[null,null,"amortissement comptable","Réduction de la valeur d'un poste du Bilan."]
[null,null,"amortissement financier","Remboursement d'une dette."]
[null,null,"annuité","Somme dépensée annuellement pour les intérêts et l'amortissement d'une dette."]
[null,null,"appointements","Rétribution fixe pour un emploi régulier. (Ne s'emploie qu'au pluriel !)"]
[null,null,"arbitrage","Opération visant à tirer profit de la différence de cours du change existant à un moment donné entre plusieurs marchés"]
[null,null,"argus","Périodique publiant le prix moyen des voitures d'occasion"]
[null,null,"artisan","Celui qui exerce un métier manuel pour son propre compte"]
[null,null,"assignation","Versement postal par mandat de paiement."]
[null,null,"assolement","Alternance des cultures d'un champ pour obtenir le maximum de rendement, sans épuiser le sol."]
[null,null,"autarcie","Manière de vivre qui vise à se suffire à soi-même, sans faire appel à une aide extérieure."]
[null,null,"autochtone","Originaire du pays où il vit."]
[null,null,"autofinancement","Augmentation du capital de l'entreprise au moyen des bénéfices non distribués."]
[null,null,"aval","cautionnement d'un tiers en faveur du tiré."]
[null,null,"avenant","Acte additionnel modifiant un contrat."]
[]
["B",null,"bail","Contrat par lequel le propriétaire d'un bien en cède la jouissance à une autre, moyennant un prix convenu."]
[null,null,"baissier","Personne qui, à la Bourse, spécule sur la baisse."]
[null,null,"battre","Action de créer des pièces de monnaie et des billets pour un pays."]
[null,null,"bénéfice brut","Chiffre d'affaires net moins Prix de revient d'achat."]
[null,null,"bénéfice net","Bénéfice brut moins les frais généraux et les frais de vente."]
[null,null,"bénéficiaire","Celui qui pourra encaisser une lettre de change à l'échéance"]
[null,null,"besoin","Etat de privation qui se traduit par une sensation pénible d'insuffisance génératrice de désir."]
[null,null,"bien","Produit qui sert à satisfaire les besoins"]
[null,null,"bien-fonds","Terme cadastral pour définir un bien immobilier (terre, maison)."]
[null,null,"biennal","Qui a lieu tous les deux ans."]
[null,null,"bilan","Tableau résumant la situation de l'entreprise (ressources et emplois) à un moment donné."]
[null,null,"billet à ordre","Papier-valeur par lequel le souscripteur s'engage à payer une certaine somme au bénéficiaire."]
[null,null,"bon poids","Réduction accordée sur un poids brut pour tenir compte des pertes provenant de la vente au détail"]
[null,null,"bordereau","Relevé détaillé des éléments d'un décompte, d'un inventaire, d'une opération bancaire, etc."]
[null,null,"bourse","Marché où se négocient les titres."]
[null,null,"Bretton Woods","Ville américaine où furent signés des accords qui donnèrent naissance au FMI en 1944."]
[null,null,"brevet","Titre délivré à un inventeur et qui lui assure le droit exclusif d'exploiter sa découverte."]
[null,null,"brûlis","Portion de champs dont on a brûlé les herbes pour améliorer le sol."]
[null,null,"brut","Tout compris, c'est-à-dire avant déduction."]
[null,null,"budget","Evaluation prévisionnelle des recettes et des dépenses pour une période déterminée"]
[]
["C",null,"c.i.f.","L'assurance et les frais de transport sont compris dans le prix d'achat."]
[null,null,"cachet","Revenu d'un artiste"]
[null,null,"cambiste","Courtier en devises"]
[null,null,"call","Droit d'acheter un titre à un prix fixé d'avance par contrat. (Contraire de put)"]
[null,null,"cartel","Convention passée entre plusieurs entreprises de la même branche"]
[null,null,"cauris","Petits coquillages utilisés jadis comme argent en Asie et en Afrique"]
[null,null,"caution","Personne qui s'engage à payer à la place d'une autre si celle-ci ne peut pas s'exécuter."]
[null,null,"cédule","Papier-valeur établi par un notaire lors de la constitution d'une hypothèque."]
[null,null,"certain","Cotation qui indique la quantité de monnaie étrangère pour 1 unité nationale"]
[null,null,"change","Opération qui consiste à échanger une monnaie d'un pays contre une autre d'un autre pays."]
[null,null,"charges","Ce qui oblige à des dépenses. Frais que l'entreprise doit supporter pour exercer son activité."]
[null,null,"chèque","Papier-valeur donnant l'ordre à une banque de payer à vue, une somme déterminée à la personne désignée."]
[null,null,"chiffre d'affaires","Quantité vendue au prix de vente. Total des ventes."]
[null,null,"clientèle","Bien immatériel représentant la réputation d'une entreprise et pouvant être négocié"]
[null,null,"clôture","bouclement des comptes à une date donnée"]
[null,null,"clôturer","Tirer le solde d'un compte par différence entre débit et crédit."]
[null,null,"code","Ouvrages où sont regroupés les lois selon leur nature."]
[null,null,"commission","Somme due à un courtier ou à un vendeur en fonction de son chiffre d'affaires."]
[null,null,"comptant","avec paiement immédiat"]
[null,null,"compte courant","tableau dans lequel on inscrit les opérations financières entre deux personnes ou deux entreprises."]
[null,null,"compte d'exploitation","Compte de résultat intermédiaire centralisateur des charges et produits de l'activité principale de l'entreprise"]
[null,null,"concepteur","Celui qui propose des idées ou des projets pour la publicité"]
[null,null,"concurrence","Compétition entre plusieurs personnes ou plusieurs entreprises visant les mêmes avantages."]
[null,null,"concussion","Malversation dans l'exercice d'une fonction publique."]
[null,null,"connaissement","Lettre de transport maritime possédant le caractère d'un papier-valeur."]
[null,null,"consentir","Accepter qu'une chose se fasse, accorder un avantage à quelqu'un."]
[null,null,"consommation","Usure ou destruction d'un bien ou utilisation d'un service pour satisfaire des besoins."]
[null,null,"consomptible","Dont on ne peut se servir sans le détruire."]
[null,null,"contrat","acte juridique par lequel une ou plusieurs personnes s'obligent envers une ou plusieurs autres."]
[null,null,"contribuable","Personne assujettie au paiement d'un impôt."]
[null,null,"convertible","Adjectif qui qualifie une monnaie que l'on peut échanger contre de l'or."]
[null,null,"corporation","Ensemble des personnes exerçant la même profession"]
[null,null,"cote","Liste des monnaies étrangères et de leur valeur par rapport à une monnaie donnée."]
[null,null,"cote","Liste des cours des actions et obligations pour une bourse donnée."]
[null,null,"coulage","Réduction accordée sur un poids brut pour tenir compte des pertes éventuelles dues aux manipulation de la marchandise."]
[null,null,"coupon","Pièce donnant droit au dividende d'une action."]
[null,null,"couronne","Monnaie des pays scandinaves."]
[null,null,"cours","Prix d'une monnaie étrangère ou d'un titre à la bourse"]
[null,null,"courtage","Commission, rémunération du courtier."]
[null,null,"courtier","Commerçant dont l'activité consiste à mettre en présence un acheteur et un vendeur."]
[null,null,"coutume","Loi non écrite"]
[null,null,"créance","Droit que l'on a de demander à quelqu'un le paiement d'une somme due."]
[null,null,"créancier","Personne à qui l'on doit une somme d'argent."]
[null,null,"crédit","1) Confiance qu'inspire quelqu'un. Degré de solvabilité"]
[null,null,"crédit","2) Opération par laquelle une personne met une somme d'argent à disposition d'une autre."]
[null,null,"crédit","3) Partie droite d'un compte"]
[null,null,"cuniculiculture","Elevage des lapins"]
[null,null,"cybernétique","Science qui étudie les mécanismes de communication dans les machines"]
[]
["D",null,"débit","1) Quantité de fluide fournie. (pour une fontaine par ex.)"]
[null,null,"débit","2) Vente au détail"]
[null,null,"débit","3) Partie gauche d'un compte"]
[null,null,"débiteur","Celui ou celle qui doit une somme d'argent à un tiers."]
[null,null,"découler","Qui suit logiquement"]
[null,null,"découvert","Situation financière d'une entreprise caractérisée par des dettes supérieures aux biens et aux créances."]
[null,null,"déférer","Porter une affaire ou traduire un accusé devant un tribunal."]
[null,null,"délit","Acte illicite, infraction à la loi."]
[null,null,"demande","Prix auquel la banque achète des monnaies étrangères. Cours ..."]
[null,null,"demeure","Terme juridique indiquant un retard."]
[null,null,"déroger","Manquer à l'observation d'une loi."]
[null,null,"dette","Somme que l'on doit à quelqu'un."]
[null,null,"devise","Créances sur l'étranger libellées en monnaie étrangère"]
[null,null,"différend","Désaccord résultant d'une différence d'opinion."]
[null,null,"différer","Reporter à plus tard."]
[null,null,"diligence","Soin, zèle, faire ...."]
[null,null,"disponibilité","Fonds dont on peut user à tout moment."]
[null,null,"dividende","Part du bénéfice d'une société anonyme (SA) qui est versée pour chaque action."]
[null,null,"domanial","Qui est du domaine de l'Etat, du seigneur. (adj.)"]
[null,null,"domiciliation","Indication d'un lieu de paiement, autre que le domicile du tiré, sur un effet de change"]
[null,null,"droit d'auteur","Pourcentage reçu par l'auteur sur la production en série d'une de ses oeuvres"]
[]
["E",null,"échéance","Date à laquelle une dette doit être payée."]
[null,null,"échoir","Etre payable à une époque déterminée (dette échue)."]
[null,null,"Ecu","Nom (abrégé) de l'unité monétaire européenne."]
[null,null,"effet de levier","Le cours des options varie proportionnellement beaucoup plus que le cours du sous-jacent auquel l'option est liée."]
[null,null,null,"Action de quitter son pays pour s'établir dans un autre."]
[null,null,"émolument","Rétribution tarifée alloué à une administration ou à un notaire."]
[null,null,"enchère","Offre supérieure au prix proposé au cours d'une adjudication."]
[null,null,"endémie","Maladie qui sévit continuellement dans un pays"]
[null,null,"escompte","déduction d'un intérêt lors de l'exécution d'un engagement avant l'échéance."]
[null,null,"escompter","Action de remettre à la banque un effet avant l'échéance."]
[null,null,"espèces","Nom féminin pluriel désignant l'ensemble des billets de banque et des pièces de monnaie."]
[null,null,"ester","Poursuivre une action en justice, comme demandeur ou comme défendeur."]
[null,null,"excédent","Surplus"]
[null,null,"exhaustif","Complet"]
[null,null,"exploitation","Action de mettre en valeur"]
[]
["F",null,"f.o.b.","Transbordement compris dans le prix d'achat."]
[null,null,"faillite","Procédure judiciaire entraînant la liquidation d'une société qui ne peut plus honorer ses paiements."]
[null,null,"fallacieux","Qui trompe"]
[null,null,"fiduciaire","Adjectif qui qualifie la monnaie basée sur la confiance, comme les pièces ou les billets de banque."]
[null,null,"filiale","Succursale"]
[null,null,"fixing","Cours moyen d'un titre fixé entre le prix d'achat et le prix de vente"]
[null,null,"florin","Nom de la monnaie hollandaise"]
[null,null,"fonds","Sol d'un champ, d'un domaine, terrain (n.m. singulier)"]
[null,null,"fonds","Somme d'argent à disposition pour acquérir des biens (n. m. pluriel)"]
[null,null,"fonds propres","Apport du propriétaire"]
[null,null,"fongible","Qui se consomme par l'usage et qui peut être remplacé par une chose analogue."]
[null,null,"for","Lieu où une action judiciaire doit être intentée"]
[null,null,"fournisseur","Personne qui nous vend des marchandises à crédit"]
[null,null,"franco","Le fournisseur supporte les frais de transport jusqu'au point indiqué (domicile, douane, etc)."]
[null,null,"fret","Frais de transport par navire ou par avion"]
[null,null,"future","Contrat standardisé par lequel une des parties s'engage à acheter (ou vendre) des titres à une prix donné et à une date fixée d'avance. Achat ou vente à terme."]
[]
["G",null,"gage","Bien mobilier remis par un débiteur à son créancier en garantie du paiement d'une dette."]
[null,null,"giro","Système de virement entre banques permettant le règlement de sommes sans utilisation d'espèces."]
[null,null,"goodwill","Mot anglais désignant la valeur immatérielle de la clientèle et du fonds de commerce."]
[null,null,"grand magasin","Etablissement non alimentaire, non spécialisé proposant une grande variété de produits, sur un surface de plus de 2500 m2"]
[null,null,"grever","Frapper de charges financières, de servitudes, etc..."]
[]
["H",null,"haussier","Personne qui, en Bourse, joue à la hausse."]
[null,null,"hebdomadaire","Publication qui paraît chaque semaine"]
[null,null,"honoraire","Rétribution accordée à des personnes exerçant une profession libérale."]
[null,null,"house organ","Journal édité par une entreprise et destiné à ses collaborateurs ou à ses partenaires commerciaux"]
[null,null,"hypermarché","libre-service réalisant plus de 1/3 de son chiffre d'affaires en alimentation, sur une surface de plus de 2500 m2"]
[null,null,"hypothèque","Droit de gage inscrit au R.F., sur un bien immobilier en garantie d'un prêt."]
[]
["I",null,"illicite","Contraire à la loi"]
[null,null,"immigration","Action de venir d'établir dans un pays étranger."]
[null,null,"immobilisation","Capitaux engagés durablement dans l'entreprise et utilisables de nombreuses fois. (Machines, véhicules, immeubles,etc)"]
[null,null,"impôt anticipé","Impôt prélevé immédiatement sur des revenus provenant d'un capital et remboursé au contribuable lorsque ces revenus sont"]
[null,null,"imputer","Mettre sur le compte de quelqu'un. Inscrire un montant dans un compte"]
[null,null,"inaltérable","Dont l'état général ou les propriétés ne se modifient pas avec le temps."]
[null,null,"incertain","Manière de coter où l'on indique en FS le prix de 100 unités étrangères"]
[null,null,"indice","Valeur moyenne des prix d'une série de produits ou d'un panier de titres. "]
[null,null,"inflation","Hausse du niveau général des prix"]
[null,null,"infrastructure","Ensemble des constructions de base (routes, ponts, etc...)"]
[null,null,"initié","Personne profitant d'informations confidentielles pour spéculer en Bourse."]
[null,null,"inhérent","Attaché à, inséparable."]
[null,null,"insolvable","Qui n'a pas de quoi payer"]
[null,null,"intenter","Entreprendre contre quelqu'un une action en justice."]
[null,null,"intérêt","Revenu du capital - Loyer perçu pour une somme placée."]
[null,null,"intrinsèque","Qui qualifie la valeur d'une chose pour elle-même, en dehors de toute convention"]
[null,null,"inventaire","Recensement de tous les biens d'une entreprise, compte par compte."]
[null,null,"investir","Consacrer de l'argent à étendre, remplacer, moderniser les moyens de production. Placer une somme d'argent à long terme."]
[null,null,"ipso facto","D'office, automatiquement"]
[]
["J",null,"jachère","Terre labourée, mais non ensemencée, pour la laisser reposer temporairement"]
[null,null,"jingle","Publicité mélodique ou chantée"]
[null,null,"journal","Liste chronologique des opérations comptables"]
[null,null,"jurisprudence","Interprétation de la loi donnée par les tribunaux lors de procès et restant valable pour tous les jugements à venir."]
[]
["L",null,"latent","qui demeure caché et qui ne c'est pas encore déclaré"]
[null,null,"leasing","Forme d'acquisition de biens entre la vente et la location."]
[null,null,"léser","Blesser quelqu'un dans ses intérêts, ses droits; lui causer du tort."]
[null,null,"libellé","Courte description d'un fait comptable."]
[null,null,"libérale","Adjectif qui qualifie une profession qui n'appartient ni à l'industrie, ni au commerce, ni à la fonction publique."]
[null,null,"Libor","(London Interbank Offered Rate). Taux appliqué aux prêts interbancaires à court terme"]
[null,null,"lingot","Barre de métal fondu et non ouvragé."]
[null,null,"liquidation","Fin du mois boursier. C'est avant la date de liquidation (5ème jour ouvré avant la fin du mois civil) que l'acheteur doit décider du report, du débouclage ou de la livraison de ses titres."]
[null,null,"liquidité","Montant des moyens de paiement dont l'entreprise peut disposer immédiatement."]
[null,null,"litige","Conflit, contestation donnant matière à procès."]
[null,null,"litispendance","Situation lorsque deux demandes portant sur le même objet sont présentées devant une juridiction."]
[null,null,"logistique","Département qui s'occupe de la distribution des biens"]
[null,null,"logo","Nom, initiales ou image qui représente symboliquement une marque ou une entreprise"]
[null,null,"loi","Ensemble des règles imposées au citoyen."]
[null,null,"lucratif","Qui procure un gain, des profits, des bénéfices."]
[null,null,"lucre","Amour du gain, du profit."]
[]
["M",null,"magistrat","Fonctionnaire investi d'une autorité juridique ou politique"]
[null,null,"main d'oeuvre","Charge salariale de production"]
[null,null,"majorer","Augmenter la valeur attribuée à un objet."]
[null,null,"mandat","Convention par laquelle une personne donne pouvoir à une autre d'effectuer un acte en son nom."]
[null,null,"mandat","Titre postal qui permet d'adresser une somme d'argent à une personne qui n'a pas de CCP."]
[null,null,"manteau","Partie principale d'un papier-valeur sans la feuille de coupon"]
[null,null,"manufacture","Grande fabrique où certains produits se font à la main"]
[null,null,"manutention","Transport avec les mains"]
[null,null,"marge","différence entre le prix de revient et le prix de vente. (Bénéfice)"]
[null,null,"marketing","Science visant à distribuer rationnellement sur un marché des biens et des services adaptés au besoins des consommateurs."]
[null,null,"mécène","Protecteur des arts, des sciences ou du sport, généreux et désintéressé"]
[null,null,"médias","Moyens de communication tels que la presse, la radio, la TV, le cinéma, les affiches"]
[null,null,"mensualité","Somme payée mensuellement"]
[null,null,"mensuel","publication qui paraît chaque mois"]
[null,null,"mercenaire","Soldat qui loue ses services."]
[null,null,"migration","Action de passer d'un pays dans un autre pour s'y établir"]
[null,null,"minimum vital","Revenu au-dessous duquel la survie de l'homme devient difficile."]
[null,null,"moratoire","Qui pénalise un débiteur en retard. Intérêt ..."]
[]
["N",null,"nantissement","Mise en gage de biens mobiliers en garantie d'un crédit."]
[null,null,"net","Prix ou poids après déduction d'une bonification. Contraire de brut"]
[null,null,"nomade","Qui n'a pas d'habitation fixe"]
[null,null,"nominatif","Se dit d'un titre sur lequel le nom du propriétaire figure."]
[null,null,"note de crédit","Document établi par le vendeur, confirmant une diminution d'un prix de vente à faire valoir sur un prochain achat."]
[]
["O",null,"obligation","Papier-valeur incorporant un droit de créance et émis en représentation d'un capital souscrit."]
[null,null,"obsolescence","Diminution de la valeur d'un bien due à un vieillissement technologique."]
[null,null,"obvier","Prendre les précautions nécessaires pour prévenir un mal."]
[null,null,"offre","Prix auquel la banque vend les monnaies étrangères. Cours ..."]
[null,null,"OFIAMT","Office Fédéral de l'Industrie, des Arts et Métiers, du travail"]
[null,null,"once","Unité de poids utilisée pour les métaux précieux et valant 31.1035 grammes."]
[null,null,"onéreux","Contraire de gratuit."]
[null,null,"option","Instrument financier donnant le droit d'acheter (call) ou de vendre (put) un actif dit sous-jacent (action, indice, etc) à un cours déterminé à l'avance (strike ou prix d'exercice). "]
[null,null,"ordalie","Epreuve judiciaire pour établir la culpabilité ou l'innocence d'un accusé. (duel, épreuve du fer rouge ou de l'eau bouillante)"]
[null,null,"ostracisme","Loi condamnant au bannissement temporaire des citoyens jugés dangereux."]
[null,null,"ostréiculture","Elevage des huîtres"]
[]
["P",null,"papier-valeur","Titre dans lequel un droit est incorporé d'une manière telle qu'il est impossible de le faire valoir ou de le transmettre"]
[null,null,"parité","Egalité de la valeur d'échange."]
[null,null,"pas de porte","Indemnité versée au propriétaire d'un fonds de commerce par son successeur."]
[null,null,"passif","Partie droite du Bilan où sont énumérées toutes les ressources financières de l'entreprise."]
[null,null,"patrimoine","Ensemble des biens d'une famille ou d'une entreprise, appréciable en argent."]
[null,null,"péage","Droit perçu sur les personnes, les véhicules pour leur passage sur certains chemins, ponts, tunnels, etc..."]
[null,null,"pécule","Somme d'argent économisée lentement."]
[null,null,"pécuniaire","Relatif à l'argent. (Du mot bétail en latin)"]
[null,null,"péremptoire","Contre quoi on ne peut rien répliquer."]
[null,null,"périphérie","Région de banlieue entourant une ville"]
[null,null,"physiologique","Synonyme de vital pour définir un besoin."]
[null,null,"pilori","Poteau où l'on attachait les condamnés pour les exposer au public"]
[null,null,"pisciculture","Elevage des poissons"]
[null,null,"porteur","Personne détenant légalement un titre non nominatif"]
[null,null,"potentiel","adjectif : qui existe en puissance"]
[null,null,"potentiel","nom : Ensemble des ressources d'un pays"]
[null,null,"préemption","Droit d'acheter avant tout autre"]
[null,null,"prescription","Extinction d'un droit par l'écoulement du temps."]
[null,null,"presse","Terme englobant tous les médias imprimés, tels quotidiens, hebdomadaires, revues, etc..."]
[null,null,"prestation","Ce qu'une partie s'engage par contrat à faire ou à ne pas faire."]
[null,null,"prêt non gagé","prêt sans garanties données au créancier (crédit en blanc)"]
[null,null,"procédure","Ensemble des actions qui doivent être mises en oeuvre pour parvenir à une solution judiciaire"]
[null,null,"procuration","Titre donnant à une personne la capacité d'agir pour une autre."]
[null,null,"prodigue","qui fait des dépenses excessives"]
[null,null,"productivité","Amélioration quantitative et qualitative de la production"]
[null,null,"produit","Ce qui rapporte un capital"]
[null,null,"produits dérivés","Instrument financier très spéculatif. Les options ou les futures figurent dans cette catégorie."]
[null,null,"prohibition","Interdiction légale."]
[null,null,"prorata","Mot latin qui signifie proportionnellement."]
[null,null,"proroger","Prolonger un délai, différer l'échéance."]
[null,null,"publicité","Ensemble des moyens destinés à informer le public et à le convaincre d'acheter un produit ou un service"]
[null,null,"puîné","Terme juridique indiquant le cadet."]
[null,null,"put","Droit de vendre un titre à un prix fixé d'avance par contrat. (Contraire de call)"]
[]
["Q",null,"quinquennal","Qui dure 5 ans ou qui se produit tous les 5 ans."]
[null,null,"quintal","100 kg"]
[null,null,"quittance","Déclaration écrite que l'on donne à celui qui acquitte une dette"]
[null,null,"quotidien","Publication qui paraît chaque jour"]
[]
["R",null,"rabais","Bonification accordée sur un prix en fonction de la qualité du produit."]
[null,null,"rang","Degré dans une hiérarchie"]
[null,null,"recensement","Dénombrement d'une population."]
[null,null,"récépissé","Document par lequel on reconnaît avoir reçu des documents, des objets ou de l'argent."]
[null,null,"récépissé PTT","Partie gauche d'un bulletin de versement vert."]
[null,null,"redevance","Taxe"]
[null,null,"rédhibition","Action d'un acheteur pour faire annuler une vente dans le cas où l'objet se révèle défectueux."]
[null,null,"réfaction","Réduction accordée sur un poids brut pour tenir compte des impuretés et des déchets éventuels."]
[null,null,"réméré","Droit du vendeur de racheter dans un certain délai et à certaines conditions la chose vendue."]
[null,null,"remise","Bonification accordée sur un prix en fonction de la quantité achetée."]
[null,null,"rémunération","Argent reçu contre un travail ou un service."]
[null,null,"réquisition","Action de demander en justice."]
[null,null,"résiliation","Annulation d'un contrat."]
[null,null,"retrait","Action de retirer de l'argent liquide d'un compte bancaire ou postal."]
[null,null,"ristourne","Bonification accordée en fin d'année en fonction du volume des commandes."]
[null,null,"royalty","Frais de licence pour l'exploitation de brevets et de procédés de fabrication. (mot anglais)"]
[null,null,"rural","Qui concerne la campagne. (adj)"]
[]
["S",null,"scripturale","Adjectif qui qualifie une monnaie écrite comme les chèques par exemple."]
[null,null,"sédentaire","Qui a une habitation fixe."]
[null,null,"seing privé","Signature d'un acte non enregistré devant notaire."]
[null,null,"sériciculture","Elevage du ver à soie"]
[null,null,"servitude","Charge imposée sur une propriété pour l'usage d'un fonds qui appartient à un autre propriétaire"]
[null,null,"slogan","Phrase courte facile à retenir, qui est étroitement associée à un produit."]
[null,null,"solvable","Qui a les moyens de payer."]
[null,null,"souche","Talon d'un chèque ou d'une quittance qui reste en main de celui qui l'établit."]
[null,null,"soulte","Somme d'argent qui, dans un partage ou un échange, compense l'inégalité des lots."]
[null,null,"souscription","Action de s'engager pour un certain montant."]
[null,null,"sous-jacent","Actif financier (action ou autres) qui sert de base à une option ou un warrent."]
[null,null,"spéculation","Recherche d'un profit résultant des variations des cours ou des prix."]
[null,null,"sponsor","Souteneur financier d'une manifestation, d'une équipe, d'un sportif, en échange de publicité indirecte"]
[null,null,"spot","Publicité radio ou TV de courte durée"]
[null,null,"stipendier","Payer pour une besogne ignoble. Corrompre."]
[null,null,"stipuler","Enoncer comme condition dans un contrat ou dans un acte."]
[null,null,"stock","Quantité de marchandise en réserve."]
[null,null,"storyboard","Esquisse d'un projet de film, avec croquis et légendes"]
[null,null,"strike","Prix d'exercice d'une option ou d'un warrant par exemple."]
[null,null,"subside","Secours d'argent d'un Etat à un autre Etat ami."]
[null,null,"subvention","Aide que l'Etat accorde à un groupement, une association, voire à un privé."]
[null,null,"succursale","Entreprise dépendante de la maison mère"]
[null,null,"supérette","Libre-service vendant principalement des produits alimentaires, sur une surface de 120 à 400 m2"]
[null,null,"supermarché","Libre-service réalisant plus des 2/3 de son chiffre d'affaires en alimentation, sur une surface de 400 à 2500 m2"]
[null,null,"supplémentaire","En plus, en sus..."]
[null,null,"surplus","Part de la production qui excède la quantité nécessaire à sa propre consommation."]
[null,null,"sylviculture","Culture des arbres"]
[null,null,"synallagmatique","Qui comporte des obligations réciproques entre deux parties.(Bilatéral)"]
[]
["T",null,"tacite","Qui découle du comportement, sans qu'il y ait une acceptation écrite ou orale."]
[null,null,"talon","bon de renouvellement attaché à la feuille de coupons d'un titre"]
[null,null,"tare","Poids de l'emballage."]
[null,null,"tempérament","Acheter en payant par acomptes successifs réguliers. Acheter à ..."]
[null,null,"terme","Expiration d'un délai pour l'accomplissement d'une obligation."]
[null,null,"thésauriser","Action de retirer de l'argent du circuit économique en le conservant dans un \"bas de laine\"."]
[null,null,"tiers","Personne étrangère à l'action."]
[null,null,"tirage","Nombre d'exemplaires imprimés et mis en vente"]
[null,null,"tiré","Celui qui devra payer une lettre de change"]
[null,null,"tireur","Personne qui établit un effet de change."]
[null,null,"titre","Acte écrit, pièce authentique qui sert a établir un droit ou une qualité."]
[null,null,"traite","Synonyme de lettre de change"]
[null,null,"traitement","Somme d'argent versée à quelqu'un en échange d'un travail fixe pour lequel elle a été nommée."]
[null,null,"transitaire","Commissionnaire qui se charge du passage des marchandises"]
[null,null,"trésorerie","Fonds liquides dont dispose une entreprise."]
[null,null,"triennal","Qui a lieu tous les trois ans."]
[null,null,"troc","Echange d'un objet contre un autre, sans usage de monnaie."]
[null,null,"trust","Intégration par une entreprise de toutes les étapes allant de la production à la distribution"]
[]
["U",null,"ubiquité","Possibilité d'être présent en plusieurs lieux à la fois"]
[null,null,"usufruit","Droit d'utiliser un bien sans en avoir la propriété"]
[]
["V",null,"vacation","Montant de la rémunération due pour une séance de travail."]
[null,null,"valeur nominale","Valeur inscrite sur un titre"]
[null,null,"valeur résiduelle","valeur d'un bien après une certaine durée d'utilisation"]
[null,null,"vannier","Celui qui confectionne des paniers, corbeilles, sièges en rotin, paille ou osier."]
[null,null,"vente à découvert","Vente de titres que le vendeur ne possède pas."]
[null,null,"virement","Transfère d'argent d'un compte sur un autre, sans mouvement d'espèce."]
[null,null,"virement comptable","Opération qui consiste à reporter un montant d'un compte dans un autre."]
[null,null,"volatilité","Caractère d'un titre dont la valeur est très instable, très fluctuante."]
[null,null,"vrac","Livraison de marchandise pêle-mêle, sans emballage."]
[null,null,"vue","Se dit des effets de commerce payables sur simple présentation. A ..."]
[]
["W",null,"warrant","Certificat d'entrepôt servant au nantissement de marchandises."]
[null,null,"warrant ","Sorte d'option standardisée émise par des sociétés financières."]