Created on Spreadboard

bollinger_bands.sbd

{
  "tablenames": {
    "0": "table_0",
    "1": "table_0_format",
    "2": "table_1",
    "3": "table_1_format"
  },
  "tableformats": {
    "0": 1,
    "2": 3
  },
  "calctree": {
    "0": [
      ["ticker", "GOOGL"],
      ["start date", "=date.addMonths(B3, -12)"],
      ["end date", "=date.today()"],
      ["query", ">getStock(B1, B2, B3)"],
      ["dates", "=B4.quote.extract('Date')"],
      ["=B1", "=B4.quote.extract('Adj_Close')"],
      ["mavg", "=B6.mavg(20)"],
      ["bolup", "=B7.add(B6.mstddev(20), 2)"],
      ["boldn", "=B7.add(B6.mstddev(20), -2)"]
    ],
    "1": [
      ["", ""],
      ["", ""],
      ["", ""],
      ["", ""],
      ["", ""],
      ["", ""],
      ["", ""],
      ["", ""],
      ["", ""]
    ],
    "2": [
      ["=Chart.line(table_0.B5, table_0.B6_9, 'date', '', table_0.A6_9)"]
    ],
    "3": [
      [""]
    ]
  },
  "view": {
    "TableDetails": {
      "0": {
        "left": 32,
        "top": 32,
        "nrows": 9,
        "ncols": 2,
        "colwidths": [63, 63],
        "rowheights": [15, 15, 15, 15, 15, 15, 15, 15, 15]
      },
      "2": {
        "left": 184,
        "top": 32,
        "nrows": 1,
        "ncols": 1,
        "colwidths": [447],
        "rowheights": [279]
      }
    }
  }
}