{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Start","LONG","SHORT","Disclaimer & Credits","ThankYou"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Start","index":0,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,21,6,30],[15,23,17,29],[20,23,22,29],[58,1,59,30],[54,1,55,30],[56,1,57,30],[10,23,12,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Follow Me On Twitter"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subscribe To My YouTube Channel"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visit DayTradingLife.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"“ALWAYS Calculate Your Downside! ‘Calculated risk’ Opens The Window To Opportunity Defined By Your Expectancy,"]
[]
[null,"Whilst Simultaneously Closing The Window Of Fear & Adversity.”"]
[]
[null,"Remember:- “Calculate Risk To ALWAYS Offer A Calculated Potential Reward.” - DowBoy"]

{"sheet":"LONG","index":1,"n_rows":41,"n_cols":48,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,45,1,49],[39,23,40,50],[4,25,5,31],[4,33,5,38],[4,40,5,46],[36,41,36,44],[37,47,37,48],[37,45,37,46],[37,41,37,44],[37,39,37,40],[37,37,37,38],[37,33,37,35],[37,31,37,32],[37,28,37,30],[37,26,37,27],[17,24,19,35],[21,47,22,47],[21,45,22,45],[21,42,22,43],[21,40,22,40],[21,38,22,38],[21,44,22,44],[21,25,22,25],[21,34,22,34],[21,31,22,31],[21,29,22,29],[21,27,22,27],[21,32,22,32],[34,9,34,13],[33,18,38,19],[39,18,39,19],[34,3,35,5],[36,1,36,15],[37,1,37,9],[39,1,39,15],[38,1,38,3],[23,42,23,43],[26,10,27,12],[32,3,33,3],[32,5,33,5],[24,24,26,35],[24,37,26,48],[33,9,33,13],[29,3,29,5],[4,3,4,5],[13,3,13,5],[5,18,5,19],[6,18,6,19],[26,3,26,5],[20,30,20,32],[20,28,20,29],[20,26,20,27],[20,41,20,43],[18,3,18,5],[17,37,19,48],[6,33,6,35],[6,30,6,32],[6,28,6,29],[6,26,6,27],[6,47,6,48],[6,45,6,46],[6,41,6,44],[6,39,6,40],[6,37,6,38]]}
[]
[null,null,null,"Current Date / Time:",{"$f":"TEXT(NOW(),\"dd/mm/yyyy   hh:mm AM/PM\")","v":"23/12/2018   03:43 PM"},null,null,null,null,null,null,null,"\"LONG ENTRY\"",null,null,null,null,"   SPREAD BETTING 'LONG' CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP & TARGET SCENARIOS",null,null,null,null,null,null,null,null,null,"v1.10 SE²",null,null,null,"DayTradingLife.com"]
[]
[]
[null,null,null,"LONG TRADES ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALTERED STOPS ONLY!",null,null,null,null,null,null,null,"What IF? Scenarios",null,null,null,null,null,null,"ALTERED (T) TARGETS ONLY!"]
[null,null,1,"INSERT YOUR ACCOUNT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LONG:- Trade Summary"]
[null,null,null,"NAME: Epic Code -> 'Optional'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(NOW(),\"dd/mm/yyyy   hh:mm AM/PM\")","v":"23/12/2018   03:43 PM"},null,null,null,null,null,null,"STOP Price","STOP PTs",null,"RISK In £'s",null,"R/R",null,null,"Acc % RISK",null,null,null,"(T) PRICE",null,"(T) PROFIT £'s",null,"(T) R/R",null,null,null,"PRICE % Gain",null,"ACC % Gain"]
[null,null,null,"SPREAD: BID/OFFER -> 'Optional'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",{"$f":"IF(COUNTA($F$7)=1,$F$7,\"N/A\")","v":"N/A"},null,null,null,null,10,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-$F$16)/10)+Z9,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"STOP\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"SAME\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"AS\",\"\")","v":""},null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"ENTRY\",\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$18-$F$17)/10)+AM9,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,((AM8-$F$17)*$F$33),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO8/$F$22),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM8-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO8/$F$10),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spread",{"$f":"IF(COUNTA($F$7)=1,$F$8,\"N/A\")","v":"N/A"},null,null,null,null,9,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z9),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z9)*$F$33,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD9),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD9/$F$10),\"\")","v":""},null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Account Size (£'s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account Size",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$10),\"\")","v":""},null,null,null,null,8,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Max Allowed Risk % Per Trade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Trade Risk %",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$11),\"\")","v":""},null,null,null,null,7,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Your Max Allowable Loss (£'s)",null,{"$f":"IF(COUNTA($F$10:$F$11)=2,($F$10*$F$11),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Max Allowable Loss (£)",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$12),\"\")","v":""},null,null,null,null,6,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,2,"INSERT TRADE INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk (£)",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$22),\"\")","v":""},null,null,null,null,4,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Price Data",null,null,null,null,null,3,"MARGIN",null,null,null,null,null,null,null,"Reward (£)",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21),\"\")","v":""},null,null,null,null,3,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,"S","STOP LOSS Price",null,null,null,null,null,null,"Enter Your Brokers","£",null,null,null,null,null,null,"R/R Ratio",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$26),\"\")","v":""},":1",null,null,null,2,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,"E","ENTRY Price",null,null,null,null,null,null,"IMR",null,"OR",null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-$F$16)/10)+$F$16,\"\")","v":""},null,"",null,"",null,"","",null,"",null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18-($F$17-$F$18)/10),\"\")","v":""},null,"",null,"","",null,"",null,""]
[null,null,"T","TARGET  Price",null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$18=$M$31,\"**\",\" \"),\"\")","v":""},null,null,null,"Requirement","%",null,null,null,null,null,null,"Entry Price",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"TIGHTER STOP orders but the LIMIT Order @\"&TEXT($F$18,\"0.00\")&\" & it's £\"&TEXT($F$21,\"0.00\")&\" Potential Profit value still remains unchanged!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"INCREASED TARGET but the STOP Order @ \"&TEXT($F$16,\"0.00\")&\" & it's £\"&TEXT($F$22,\"0.00\")&\" STOP Value, IE 'YOUR RISK' still remains unchanged!\",\"\")","v":""}]
[null,null,null,{"$f":"IF(COUNTA($F$10:$F$18,$M$29)=7,IF($F$18<$M$31,\"WARNING: TARGET Price < DESIRED PRICE\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stop Level",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16),\"\")","v":""}]
[null,null,null,"Point's & £'s Values",null,null,null,null,null,null,"Margin Required",null,{"$f":"IF(ISNUMBER($M$16),$M$16*$F$33,IF(ISNUMBER($M$18),$M$21*$M$18,\"\"))","v":""},null,null,null,null,null,"Exit Price",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18),\"\")","v":""}]
[null,null,null,"EST PROFIT: Target Value In £'s",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$23*$F$33),\"\")","v":""},null,null,null,null,"Position Size",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17*$F$33),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT","CURRENT",null,"CURRENT",null,"CURRENT",null,null,null,"CURRENT",null,null,null,"CURRENT",null,"CURRENT","CURRENT",null,null,null,"CURRENT %",null,"CURRENT %"]
[null,null,null,"EST RISK: STOP LOSS Value In £'s",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$24*$F$33),\"\")","v":""},null,null,null,null,"Leverage",null,{"$f":"IF(COUNTA($M$16,$M$18)=1,($M$21/$M$20),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,null,null,null,"Trade Increase %",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$28),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$24),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$22),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$26),\"\")","v":""},":1",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$11),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$26),\"\")","v":""},null,":1",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$28),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(F21/F10),\"\")","v":""}]
[null,null,null,"Target Amount In Pts",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18-$F$17),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Acc Increase %",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$29),\"\")","v":""}]
[null,null,null,"STOP LOSS Amount In Pts",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-$F$16),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP PRICE",null,"STOP PTS",null,"RISK In £'s",null,"R/R",null,null,"Acc RISK %",null,null,null,"(T) PRICE",null,"(T) IN £'s",null,"R/R",null,null,"PRICE GAIN",null,"ACC GAIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Margin IMR (£) OR (%)",{"$f":"TEXT($M$16&$M$18,IF($M$16=\"\",\"0.00%\",\"£0.00\"))","v":""},null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"WIDER STOP orders but the LIMIT Order @ \"&TEXT($F$18,\"0.00\")&\" & it's £\"&TEXT($F$21,\"0.00\")&\" Potential Profit value still remains unchanged!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"REDUCED TARGET but the STOP Order @ \"&TEXT($F$16,\"0.00\")&\" & it's £\"&TEXT($F$22,\"0.00\")&\" STOP Value, IE 'YOUR RISK' still remains unchanged!\",\"\")","v":""}]
[null,null,null,"Est (R/R) Risk /Reward Ratio:",{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"**\",\"\"),\"\"))","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/$F$22),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Margin Required",{"$f":"IF(COUNTA($F$10:$F$18)=6,($M$20),\"\")","v":""}]
[null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$26<$M$29,\"WARNING: Note Est:Risk Reward Is < DESIRED R/R\",\" \"),\"\")","v":""},null,null,null,null,null,4,"DESIRED Risk Reward?",null,null,null,null,null,null,null,"Position Size",{"$f":"IF(COUNTA($F$10:$F$18)=6,($M$21),\"\")","v":""}]
[null,null,null,"Est TRADE Price % Increase:",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18-$F$17)/$F$17,\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$29=$M$32,\"**\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Leverage",{"$f":"IF(COUNTA($F$10:$F$18)=6,($M$22),\"\")","v":""},null,null,null,null,1,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z28),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-$Z28)*$F$33,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD28),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD28/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18+($F$17-$F$18)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,((AM28-$F$17)*$F$33),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO28/$F$22),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM28-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO28/$F$10),\"\")","v":""}]
[null,null,null,"Est Account Equity % Increase:",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/$F$10),\"\")","v":""},null,null,null,null,"DESIRED Risk / Reward",{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"**\",\"\"),\"\"))","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z28-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z29),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD29),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD29/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM28+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO29/$F$22),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM29-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO29/$F$10),\"\")","v":""}]
[null,null,null,{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"WARNING: Desired R/R Is Less Than EST R/R!\",\"\"),\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$26<$M$29,\"WARNING: ***\",\" \"),\"\")","v":""},null,null,null,null,null,"MAX STAKE  £/Pt",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$33),\"\")","v":""},null,null,null,null,3,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z29-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z30),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD30),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD30/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM29+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO30/$F$22),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM30-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO30/$F$10),\"\")","v":""}]
[null,null,null,"SPREAD: Cost of Spread:",null,{"$f":"IF(COUNT($F$8,$F$33)=2,($F$8*$F$33),IF(N($F33),\"N/A\",\"\"))","v":""},null,null,null,null,"Price Must Reach?",null,{"$f":"IF(COUNTA($M$29)=1,($M$29*$F$24)+$F$17,\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$18=$M$31,\"**\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z30-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z31),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD31),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD31/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM30+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO31/$F$22),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM31-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO31/$F$10),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Gain %",null,{"$f":"IF(COUNTA($M$29)=1,($M$31-$F$17)/$F$17,\"\")","v":""},null,null,null,null,null,"Spread Cost",{"$f":"IF(COUNTA($F$8,$F$33)=2,($F$8*$F$33),\"N/A\")","v":"N/A"},null,null,null,null,5,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z31-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z32),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD32),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD32/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM31+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO32/$F$22),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM32-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO32/$F$10),\"\")","v":""}]
[null,null,null,"Max STAKE:  £'s per Pt Allowed",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(F12/F24),\"\")","v":""},null,null,null,null,"Gain £'s",null,{"$f":"IF(COUNTA($M$29)=1,($M$31-$F$17)*$F$33,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z32-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-Z33),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD33),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD33/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM32+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO33/$F$22),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM33-$F$17)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO33/$F$10),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"WARNING: Desired R/R Is Less Than EST R/R!\",\"\"),\"\"))","v":""},null,null,null,null,null,null,null,null,"“Why Risk Everything On 1 Trade? Why Not Make Your Life A Pursuit Of Happiness Rather Than Pain? I Decided That I Had To Learn Discipline & Money Management.”",null,null,null,null,null,7,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z33-($F$17-$F$16)/10),\"\")","v":""},null,"",null,"",null,"","",null,"",null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM33+($F$17-$F$18)/10),\"\")","v":""},null,"",null,"","",null,"",null,""]
[null,null,null,"Taking Into Account MAX Allowable Loss (£'s) & STOP LOSS Amount In Pts.",null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$26=$M$29,\"WARNING: Note Both R/R Ratios The Same!\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[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,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,"Copyright © 2013-2018  --- Distribution & Reprint Policy--- All Rights Reserved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"",null,"",null,"",null,"","",null,"",null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"TARGET\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"SAME\",\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\"AS\",\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"ENTRY\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"PRICE\",\"\")","v":""}]
[null,"For futher info please email me at: ",null,null,null,null,null,null,null,null,"TraderDowBoy@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP Price","STOP PTs",null,"RISK In £'s",null,null,"R/R",null,"Acc % RISK",null,null,null,"(T) PRICE",null,"(T) PROFIT £'s",null,"(T) R/R",null,null,null,"PRICE % GAIN",null,"ACC % GAIN"]
[null,"Also PLEASE Link back to this page:",null,null,"https://www.daytradinglife.com/trading-spreadsheets/spread-betting-calculator/"]
[null," This document maybe be republished & distributed under the proviso that it cannot be altered or amended.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paul Tudor Jones",null,null,null,null,"\"I Wish You Well In Your Journey & In Your Trading.\" - Dow-Boy"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Thank You!"]

{"sheet":"SHORT","index":2,"n_rows":41,"n_cols":48,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,1,38,3],[1,45,1,49],[37,45,37,46],[37,47,37,48],[21,47,22,47],[23,42,23,43],[24,37,26,48],[21,34,22,34],[21,38,22,38],[21,40,22,40],[21,42,22,43],[21,44,22,44],[21,25,22,25],[21,27,22,27],[21,29,22,29],[39,1,39,15],[39,18,39,19],[39,23,40,50],[40,2,40,4],[26,3,26,5],[26,10,27,12],[32,3,33,3],[32,5,33,5],[33,18,38,19],[34,3,35,5],[34,9,34,13],[37,1,37,9],[36,1,36,15],[33,9,33,13],[29,2,29,6],[24,24,26,35],[4,3,4,5],[5,18,5,19],[6,18,6,19],[21,45,22,45],[4,33,5,38],[4,40,5,46],[13,3,13,5],[17,24,19,35],[17,37,19,48],[18,3,18,5],[4,25,5,31],[20,30,20,32],[20,28,20,29],[20,26,20,27],[20,41,20,44],[6,33,6,35],[36,41,36,44],[37,26,37,27],[37,28,37,30],[37,31,37,32],[37,33,37,35],[37,37,37,38],[37,39,37,40],[37,41,37,44],[6,30,6,32],[6,28,6,29],[6,26,6,27],[21,32,22,32],[21,31,22,31],[6,47,6,48],[6,45,6,46],[6,41,6,44],[6,39,6,40],[6,37,6,38]]}
[]
[null,null,null,"Current Date / Time:",{"$f":"TEXT(NOW(),\"dd/mm/yyyy   hh:mm AM/PM\")","v":"23/12/2018   03:43 PM"},null,null,null,null,null,null,null,"\"SHORT ENTRY\"",null,null,null,null,"  SPREAD BETTING 'SHORT' CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP & TARGET SCENARIOS",null,null,null,null,null,null,null,null,null,"v1.10 SE²",null,null,null,"DayTradingLife.com"]
[]
[]
[null,null,null,"SHORT TRADES ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALTERED STOPS ONLY!",null,null,null,null,null,null,null,"What IF? Scenarios",null,null,null,null,null,null,"ALTERED (T) TARGETS ONLY!"]
[null,null,1,"INSERT YOUR ACCOUNT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHORT:- Trade Summary"]
[null,null,null,"NAME: Epic Code -> 'Optional'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(NOW(),\"dd/mm/yyyy   hh:mm AM/PM\")","v":"23/12/2018   03:43 PM"},null,null,null,null,null,null,"STOP Price","STOP PTs",null,"RISK In £'s",null,"R/R",null,null,"Acc % RISK",null,null,null,"(T) PRICE",null,"(T) PROFIT £'s",null,"(T) R/R",null,null,null,"PRICE % Gain",null,"ACC % Gain"]
[null,null,null,"SPREAD: BID/OFFER -> 'Optional'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",{"$f":"IF(COUNTA($F$7)=1,$F$7,\"N/A\")","v":"N/A"},null,null,null,null,10,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-$F$16)/10)+Z9,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"STOP\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"SAME\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"AS\",\"\")","v":""},null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"ENTRY\",\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$18-$F$17)/10)+AM9,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-AM8)*$F$33),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO8/$F$22),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-AM8)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO8/$F$10),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spread",{"$f":"IF(COUNTA($F$7)=1,$F$8,\"N/A\")","v":"N/A"},null,null,null,null,9,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z9-$F$17),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z9-$F$17)*$F$33,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD9),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD9/$F$10),\"\")","v":""},null,null,null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-AM9)*$F$33),\"\")","v":""},null,"","",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-AM9)/$F$17,\"\")","v":""},null,""]
[null,null,null,"Account Size (£'s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account Size",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$10),\"\")","v":""},null,null,null,null,8,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z10-$F$17),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z10-$F$17)*$F$33,\"\")","v":""},null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Max Allowed Risk % Per Trade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Trade Risk %",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$11),\"\")","v":""},null,null,null,null,7,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Your Max Allowable Loss (£'s)",null,{"$f":"IF(COUNTA($F$10:$F$11)=2,($F$10*$F$11),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Max Allowable Loss (£)",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$12),\"\")","v":""},null,null,null,null,6,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,2,"INSERT TRADE INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk (£)",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$22),\"\")","v":""},null,null,null,null,4,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,null,"Price Data",null,null,null,null,null,3,"MARGIN",null,null,null,null,null,null,null,"Reward (£)",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21),\"\")","v":""},null,null,null,null,3,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,"S","STOP LOSS Price",null,null,null,null,null,null,"Enter Your Brokers","£",null,null,null,null,null,null,"R/R Ratio",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$26),\"\")","v":""},":1",null,null,null,2,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,null,"E","ENTRY Price",null,null,null,null,null,null,"IMR",null,"OR",null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-$F$16)/10)+$F$16,\"\")","v":""},null,"",null,"",null,"","",null,"",null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18-($F$17-$F$18)/10),\"\")","v":""},null,"",null,"","",null,"",null,""]
[null,null,"T","TARGET  Price",null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$18=$M$31,\"**\",\" \"),\"\")","v":""},null,null,null,"Requirement","%",null,null,null,null,null,null,"Entry Price",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"TIGHTER STOP orders but the LIMIT Order @\"&TEXT($F$18,\"0.00\")&\" & it's £\"&TEXT($F$21,\"0.00\")&\" Potential Profit value still remains unchanged!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"INCREASED TARGET but the STOP Order @ \"&TEXT($F$16,\"0.00\")&\" & it's £\"&TEXT($F$22,\"0.00\")&\" STOP Value, IE 'YOUR RISK' still remains unchanged!\",\"\")","v":""}]
[null,null,null,{"$f":"IF(COUNTA($F$10:$F$18,$M$29)=7,IF($F$18<$M$31,\"WARNING: TARGET Price < DESIRED PRICE\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stop Level",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16),\"\")","v":""}]
[null,null,null,"Point's & £'s Values",null,null,null,null,null,null,"Margin Required",null,{"$f":"IF(ISNUMBER($M$16),$M$16*$F$33,IF(ISNUMBER($M$18),$M$21*$M$18,\"\"))","v":""},null,null,null,null,null,"Exit Price",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18),\"\")","v":""}]
[null,null,null,"EST PROFIT: Target Value In £'s",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$23*$F$33),\"\")","v":""},null,null,null,null,"Position Size",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17*$F$33),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT","CURRENT",null,"CURRENT",null,"CURRENT",null,null,null,"CURRENT",null,null,null,"CURRENT",null,"CURRENT","CURRENT",null,null,null,"CURRENT %",null,"CURRENT %"]
[null,null,null,"EST RISK: STOP LOSS Value In £'s",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$24*$F$33),\"\")","v":""},null,null,null,null,"Leverage",null,{"$f":"IF(COUNTA($M$16,$M$18)=1,($M$21/$M$20),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,null,null,null,"Trade Increase %",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$28),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$24),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$22),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$26),\"\")","v":""},":1",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$11),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$26),\"\")","v":""},null,":1",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$28),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(F21/F10),\"\")","v":""}]
[null,null,null,"Target Amount In Pts",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-$F$18),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Acc Increase %",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$29),\"\")","v":""}]
[null,null,null,"STOP LOSS Amount In Pts",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16-$F$17),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP PRICE",null,"STOP PTS",null,"RISK In £'s",null,"R/R",null,null,"Acc RISK %",null,null,null,"(T) PRICE",null,"(T) IN £'s",null,"R/R",null,null,"PRICE GAIN",null,"ACC GAIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Margin IMR (£) OR (%)",{"$f":"TEXT($M$16&$M$18,IF($M$16=\"\",\"0.00%\",\"£0.00\"))","v":""},null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"WIDER STOP orders but the LIMIT Order @ \"&TEXT($F$18,\"0.00\")&\" & it's £\"&TEXT($F$21,\"0.00\")&\" Potential Profit value still remains unchanged!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"REDUCED TARGET but the STOP Order @ \"&TEXT($F$16,\"0.00\")&\" & it's £\"&TEXT($F$22,\"0.00\")&\" STOP Value, IE 'YOUR RISK' still remains unchanged!\",\"\")","v":""}]
[null,null,null,"Est (R/R) Risk /Reward Ratio:",{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"**\",\"\"),\"\"))","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,(F21/F22),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Margin Required",{"$f":"IF(COUNTA($F$10:$F$18)=6,($M$20),\"\")","v":""}]
[null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$26<$M$29,\"WARNING: Note Est:Risk Reward Is < DESIRED R/R\",\" \"),\"\")","v":""},null,null,null,null,null,4,"DESIRED Risk Reward?",null,null,null,null,null,null,null,"Position Size",{"$f":"IF(COUNTA($F$10:$F$18)=6,($M$21),\"\")","v":""}]
[null,null,null,"Est TRADE Price % Increase:",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-$F$18)/$F$17,\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$29=$M$32,\"**\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Leverage",{"$f":"IF(COUNTA($F$10:$F$18)=6,($M$22),\"\")","v":""},null,null,null,null,1,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$16-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z28-$F$17),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z28-$F$17)*$F$33,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD28),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD28/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$18+($F$17-$F$18)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-AM28)*$F$33),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO28/$F$22),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-AM28)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO28/$F$10),\"\")","v":""}]
[null,null,null,"Est Account Equity % Increase:",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/$F$10),\"\")","v":""},null,null,null,null,"DESIRED Risk / Reward",{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"**\",\"\"),\"\"))","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\":1\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z28-($F$17-$F$16)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z29-$F$17),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z29-$F$17)*$F$33,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD29),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD29/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM28+($F$17-$F$18)/10),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(($F$17-AM29)*$F$33),\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO29/$F$22),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$17-AM29)/$F$17,\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO29/$F$10),\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"WARNING: Desired R/R Is Less Than EST R/R!\",\"\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$26<$M$29,\"WARNING: ***\",\" \"),\"\")","v":""},null,null,null,null,null,"MAX STAKE  £/Pt",{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$33),\"\")","v":""},null,null,null,null,3,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z29-($F$17-$F$16)/10),\"\")","v":""},null,"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD30),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD30/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM29+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO30/$F$22),\"\")","v":""},"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO30/$F$10),\"\")","v":""}]
[null,null,null,"SPREAD: Cost of Spread:",null,{"$f":"IF(COUNT($F$8,$F$33)=2,($F$8*$F$33),IF(N($F33),\"N/A\",\"\"))","v":""},null,null,null,null,"Price Must Reach?",null,{"$f":"IF(COUNTA($M$29)=1,$F$17-($M$29*$F$24),\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$18=$M$31,\"**\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z30-($F$17-$F$16)/10),\"\")","v":""},null,"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD31),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD31/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM30+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO31/$F$22),\"\")","v":""},"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO31/$F$10),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Gain %",null,{"$f":"IF(COUNTA($M$29)=1,($F$17-$M$31)/$F$17,\"\")","v":""},null,null,null,null,null,"Spread Cost",{"$f":"IF(COUNTA($F$8,$F$33)=2,($F$8*$F$33),\"N/A\")","v":"N/A"},null,null,null,null,5,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z31-($F$17-$F$16)/10),\"\")","v":""},null,"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD32),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD32/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM31+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO32/$F$22),\"\")","v":""},"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO32/$F$10),\"\")","v":""}]
[null,null,null,"Max STAKE:  £'s per Pt Allowed",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(F12/F24),\"\")","v":""},null,null,null,null,"Gain £'s",null,{"$f":"IF(COUNTA($M$29)=1,($F$17-$M$31)*$F$33,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z32-($F$17-$F$16)/10),\"\")","v":""},null,"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,($F$21/AD33),\"\")","v":""},"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AD33/$F$10),\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM32+($F$17-$F$18)/10),\"\")","v":""},null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO33/$F$22),\"\")","v":""},"",null,"",null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AO33/$F$10),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M$29),\"\",IF(COUNTA($F$10:$F$18)=6,IF($M$29<$F$26,\"WARNING: Desired R/R Is Less Than EST R/R!\",\"\"),\"\"))","v":""},null,null,null,null,null,null,null,null,"“Why Risk Everything On 1 Trade? Why Not Make Your Life A Pursuit Of Happiness Rather Than Pain? I Decided That I Had To Learn Discipline & Money Management.”",null,null,null,null,null,7,{"$f":"IF(COUNTA($F$10:$F$18)=6,(Z33-($F$17-$F$16)/10),\"\")","v":""},null,"",null,"",null,"","",null,"",null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,(AM33+($F$17-$F$18)/10),\"\")","v":""},null,"",null,"","",null,"",null,""]
[null,null,null,"Taking Into Account MAX Allowable Loss (£'s) & STOP LOSS Amount In Pts.  ",null,null,null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,IF($F$26=$M$29,\"WARNING: Note Both R/R Ratios The Same!\",\" \"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[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,"",null,"",null,"",null,"","",null,"",null,null,null,"",null,"",null,"","",null,"",null,""]
[null,"Copyright © 2013-2018  --- Distribution & Reprint Policy--- All Rights Reserved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"",null,"",null,"",null,"","",null,"",null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"TARGET\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"SAME\",\"\")","v":""},{"$f":"IF(COUNTA($F$10:$F$18)=6,\"AS\",\"\")","v":""},null,null,null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"ENTRY\",\"\")","v":""},null,{"$f":"IF(COUNTA($F$10:$F$18)=6,\"PRICE\",\"\")","v":""}]
[null,"For futher info please email me at: ",null,null,null,null,null,null,null,null,"TraderDowBoy@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP Price","STOP PTs",null,"RISK In £'s",null,null,"R/R",null,"Acc % RISK",null,null,null,"(T) PRICE",null,"(T) PROFIT £'s",null,"(T) R/R",null,null,null,"PRICE % GAIN",null,"ACC % GAIN"]
[null,"Also PLEASE Link back to this page:",null,null,"https://www.daytradinglife.com/trading-spreadsheets/spread-betting-calculator/"]
[null," This document maybe be republished & distributed under the proviso that it cannot be altered or amended.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paul Tudor Jones",null,null,null,null,"\"I Wish You Well In Your Journey & In Your Trading.\" - Dow-Boy"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Thank You!"]

{"sheet":"Disclaimer & Credits","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ThankYou","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}