{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["How to Use","Bollinger Bands"],"not_rendered":{"charts":1,"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"How to Use","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[5,0,5,5],[16,0,16,9],[17,0,17,9],[18,0,18,9]]}
["How to use this template?"]
["1) This file contains macros. Enable macros to start using this template."]
["2) Read our blog on how to enable macros."]
["3) If you are using this template for the first time, please see instructions below."]
["4) In 'Bollinder Bands' tab, enter date, open, high, low and close values in row #6."]
["5) Afer entering the values press 'Update' button."]
[]
["Note:"]
["1) The chart shows data for the latest 45 days."]
["2) For a fully functional chart, there has to be 64 days of stock price data."]
[]
["When you use template for the first time:"]
["1) Directly populate historic stock data in the table for last 64 days."]
["2) Add data in assending order (latest date at the top of the table and oldest at the bottom)."]
[]
["Customisation:"]
["We can also customise this template as per your requirements. You can email us at excelexpert@excelforcommerce.com"]
["1) Customisation could include automatically downloading all the stock prices from websites like yahoo finance etc."]
["2) Provide a dropdown to select a ticker to see Bollinger Bands for a particular ticker etc."]

{"sheet":"Bollinger Bands","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"merged":[[24,10,31,14],[39,14,39,15]]}
[null,"Bollinger Bands: Historic Stock Data"]
[]
[null,"STDEV Multiplier",2,null,"<< Select Standard Deviation Multiplier",{"$nulls":7},"*Grey filled cells are not editable"]
[]
[null,"Date","Open","High","Low","Close"]
[]
[]
[null,"Date","Open","High","Low","Close","20 Day Moving Average","Upper Bollinger","Lower Bollinger"]
[{"$nulls":6},{"$f":"IF(COUNTA(F9:F28)=20,IFERROR(AVERAGE(F9:F28),0),0)","v":0},{"$f":"IFERROR(G9+$C$3*STDEV(F9:F28),0)","v":0},{"$f":"IFERROR(G9-$C$3*STDEV(F9:F28),0)","v":0}]
[{"$nulls":6},{"$f":"IF(COUNTA(F10:F29)=20,IFERROR(AVERAGE(F10:F29),0),0)","v":0},{"$f":"IFERROR(G10+$C$3*STDEV(F10:F29),0)","v":0},{"$f":"IFERROR(G10-$C$3*STDEV(F10:F29),0)","v":0}]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0,null,"Disclaimer:\n\n1) While we make every effort to deliver high quality templates, we do not guarantee that the template is free from defects. You would be using our templates at your own risk.\n2) We make no warranties as to performance, fitness for a particular purpose, or any other warranties whether expressed or implied.\n3) Under no circumstances shall we be liable for direct, indirect, special, incidental, or consequential damages resulting from the use, misuse, or inability to use our templates.\n"]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0,null,"Bollinger Bands® is trademark of John Bollinger"]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]