2c:null 2d:["$","title",null,{"children":"Dividend Income | Steve Pegg | Observable"}] 32:T454,chart = { const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); const color = d3 .scaleLinear() .domain([3, 0, -1]) .range(d3.schemeRdYlBu[3]), gradient = DOM.uid(); svg .append("linearGradient") .attr("id", gradient.id) .attr("gradientUnits", "userSpaceOnUse") .attr("x1", 0) .attr("y1", y(color.domain()[0])) .attr("x2", 0) .attr("y2", y(color.domain()[2])) .selectAll("stop") .data(d3.range(5)) .join("stop") .attr("offset", i => i / 4) .attr("stop-color", i => color(3 - i)); svg .append("path") .attr("fill", gradient) .attr("d", area(values)); svg.append("g").call(xAxis); svg.append("g").call(yAxis); // if (compareWithMM) svg .append("path") .attr("fill", "none") .attr("stroke", "navy") .attr("stroke-width", 1) .attr("d", yieldline(ROI_data)); // if (!compareWithMM) svg .append("path") .attr("fill", "none") .attr("stroke", "yellow") .attr("stroke-width", 1) .attr("d", line(norm)); return svg.node(); }33:[{"id":"0593ce6e01a367ef2ea1a53e8505bddf81f9bf2e089c24d69e70efa3ae4bd5034f0515e4343ad4d4547154c79250180a3fb5e2d14bf21d8b0657b5ab066210a4","href":"https://static.observableusercontent.com/files/0593ce6e01a367ef2ea1a53e8505bddf81f9bf2e089c24d69e70efa3ae4bd5034f0515e4343ad4d4547154c79250180a3fb5e2d14bf21d8b0657b5ab066210a4","name":"div data4.csv","type":"text/csv","lastModified":1609945077807.892,"size":8785}] 30:{"id":"24e555a9c4e84d4a","slug":"dividend-income","title":"Dividend Income","thumbnail":"7c0e2cf7d9e3c0f41c0fc0801f2be0366c47b26241484c00fc05f81084d15a9d","access_level":"public","create_time":"$D2021-01-06T13:34:44.249Z","update_time":"$D2021-02-19T09:54:04.418Z","view_time":null,"first_public_time":"$D2021-01-22T10:01:02.297Z","has_unpublished_edits":null,"fork":{"id":"49cee47a73a1a9f0","slug":"gaussian-smoothing","title":"Gaussian Smoothing","owner":{"id":"da2a32154638c457","login":"fil","name":"Fil"}},"stars":0,"starred":false,"owner":{"type":"team","id":"ea29cfe69c48ffa5","login":"steve-pegg","name":"Steve Pegg","avatar_url":"https://avatars-next.observableusercontent.com/91fcbf278fe93654a1747f10b741f5a8784201a827ba9ee211f90deccfffe490","tier":"starter_2024","bio":"Mainly coding for fun these days!"},"version":663,"publish_version":663,"role":null,"authored":false,"authors":[{"type":"individual","id":"1281bb8ce5440734","login":"steve-pegg","name":"Steve Pegg","avatar_url":"https://avatars-next.observableusercontent.com/91fcbf278fe93654a1747f10b741f5a8784201a827ba9ee211f90deccfffe490","tier":null,"bio":"Mainly coding for fun these days!"}],"members":[{"type":"individual","id":"1281bb8ce5440734","login":"steve-pegg","name":"Steve Pegg","avatar_url":"https://avatars-next.observableusercontent.com/91fcbf278fe93654a1747f10b741f5a8784201a827ba9ee211f90deccfffe490","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"6ff40e8e4a2133a9","slug":"ric","title":"RIC","owner":{"id":"ea29cfe69c48ffa5","login":"steve-pegg","name":"Steve Pegg"}},"type":"notebook","body":{"titling":"auto","title":"Dividend Income","cells":[{"id":0,"value":"md`# Dividend Income \n\n${N}-months Gaussian smoothing of dividend income. Yellow line is actual income £. Navy line is 5% yield on cost (YOC)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"viewof N = {\n const form = html``;\n form.i.oninput = () => (form.value = form.i.valueAsNumber);\n form.i.oninput();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"precision = 1e-6","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"function applyKernel(points, w) {\n const values = new Float64Array(points.length).fill(0),\n total = new Float64Array(points.length).fill(0);\n let p = 1;\n for (let d = 0; p > precision; d++) {\n p = w(d);\n for (let i = 0; i < points.length; i++) {\n if (i + d < points.length) {\n values[i + d] += p * points[i];\n total[i + d] += p;\n }\n if (d != 0 && i - d >= 0) {\n values[i - d] += p * points[i];\n total[i - d] += p;\n }\n }\n }\n for (let i = 0; i < values.length; i++) {\n values[i] /= total[i];\n }\n return values;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"function gaussianSmoothing(values, N) {\n const r = 2 / N;\n return applyKernel(values, d => Math.exp(-((r * d) ** 2)));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"function movingAverage(values, N) {\n console.log(values.length)\n let i = 0;\n let sum = 0;\n const means = new Float64Array(values.length).fill(NaN);\n for (let n = Math.min(N - 1, values.length); i < n; ++i) {\n sum += values[i];\n }\n for (let n = values.length; i < n; ++i) {\n sum += values[i];\n means[i] = sum / N;\n sum -= values[i - N + 1];\n }\n return means;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"values = gaussianSmoothing(final.map(d => d.usage), N)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"norm = final.map(d => d.usage)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"mm = movingAverage(final.map(d => d.usage), N)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"parseTime = d3.timeParse(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":499,"value":"parseDate = d3.timeParse(\"%d/%m/%Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":389,"value":"dataOLD = convertdata(datarOLD)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"function convertdata(d) {\n for (var t = 0; t < d.length; t++) {\n d[t].date = parseTime(d[t].date)\n d[t].usage = +d[t].usage\n }\n return d\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"columnsToSum = dataOLD.columns.slice(1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"byDay = d3.rollup(data, \n v => Object.fromEntries(columnsToSum.map(col => [col, d3.sum(v, d => +d[col])])),\n d => (d3.timeMonth(d.date)).getTime())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"final = Array.from(byDay, ([timestamp, counts]) => {\n const result = {...counts};\n result.date = new Date(timestamp);\n return result;\n}).sort((a, b) => d3.ascending(a.date, b.date))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"datarOLD = d3.csvParse(await FileAttachment(\"div data4.csv\").text())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"area = d3\n .area()\n .defined(d => !isNaN(d))\n .x((d, i) => x(final[i].date))\n .y0(y(0))\n .y1(y)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"line = d3\n .line()\n .defined(d => !isNaN(d))\n .x((d, i) => x(final[i].date - (N / 2) * (3600 * 1000)))\n .y(y)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"yieldline = d3\n .line()\n .defined(d => !isNaN(d.date))\n .x(d => x(d.date)) \n .y(d => y(d.ROI));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"x = d3\n .scaleTime()\n .domain(d3.extent(final, d => d.date))\n .range([margin.left, width - margin.right])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"y = d3\n .scaleLinear()\n .domain([0,300]) //(d3.extent(mm))\n .nice()\n .rangeRound([height - margin.bottom, margin.top])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x).tickSizeOuter(0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y))\n .call(g => g.select(\".domain\").remove())\n .call(g => g.selectAll(\".tick line\").clone()\n .attr(\"x2\", width)\n .attr(\"stroke-opacity\", 0.1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"height = 500","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":613,"value":"yieldate = [\n{\"date\": parseDate(\"01/01/2016\"),\"value\": 156.11},\n{\"date\": parseDate(\"01/01/2017\"),\"value\": 200.60},\n{\"date\": parseDate(\"01/01/2018\"),\"value\": 221.36},\n{\"date\": parseDate(\"01/01/2019\"),\"value\": 257.34},\n{\"date\": parseDate(\"01/01/2020\"),\"value\": 234.57},\n{\"date\": parseDate(\"01/01/2021\"),\"value\": 234}]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"margin = ({top: 20, right: 12, bottom: 30, left: 30})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":494,"value":"data = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let names =[];\n let total = 0;\n const spreadsheet = await d3.tsv(url).then(data => data.forEach(function (d) { \n d.Date = parseDate(d.Date)\n d.Credit = +d.Credit;\n // d.Credit = Math.round(d.Credit);\n // d.Credit = d.Credit.toFixed(2);\n d.Credit = +d.Credit;\n \n return names.push({ \"date\": d.Date, \"usage\": d.Credit})\n \n })) \n \n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"url = `https://sjp7001.herokuapp.com/${google_sheet_url}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"value":"google_sheet_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vT5RhRCWsgIkl3yY-eWpPc-jLuw-MVJ78ugxHUsCY5cwGurUCEUOXAsLHf4tprXoa0Mbpcqku5gxRZt/pub?output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":647,"value":"google_sheet_url_ROI = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vTKD-ZVPGGl2IBPnY8cE3I8R2KeBTSCsGxu71emxtapf6wlmbvs8G_e2ETOEPI_27IXijKHMGGq57xT/pub?output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"url_ROI = `https://sjp7001.herokuapp.com/${google_sheet_url_ROI}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"ROI_data = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let names =[];\n let total = 0;\n const spreadsheet = await d3.tsv(url_ROI).then(data => data.forEach(function (d) { \n d.date = parseDate(d.date)\n d.ROI = +d.ROI;\n \n return names.push({\"date\": d.date, \"ROI\": d.ROI})\n \n })) \n \n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"