2c:null 2d:["$","title",null,{"children":"Dividend Yield | Steve Pegg | Observable"}] 32:T462,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", "steelblue") .attr("stroke-width", 2) .attr("d", yieldline(data)); // if (!compareWithMM) // svg // .append("path") // .attr("fill", "none") // .attr("stroke", "yellow") // .attr("stroke-width", 1) // .attr("d", line(norm)); return svg.node(); }33:[] 30:{"id":"957721ccb9da31aa","slug":"dividend-yield","title":"Dividend Yield","thumbnail":"5c4d75636a9bf1cbed7c8d7c567e9ba28e42e106aae4976da9643609a99deb2e","access_level":"public","create_time":"$D2021-01-10T13:59:30.871Z","update_time":"$D2021-01-10T18:16:56.062Z","view_time":null,"first_public_time":"$D2021-01-22T10:00:51.314Z","has_unpublished_edits":null,"fork":{"id":"24e555a9c4e84d4a","slug":"dividend-income","title":"Dividend Income","owner":{"id":"ea29cfe69c48ffa5","login":"steve-pegg","name":"Steve Pegg"}},"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":553,"publish_version":553,"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":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Dividend Yield","cells":[{"id":0,"value":"md`# Dividend Yield \n\n${N}-months Gaussian smoothing of dividend yield (monthly income/total suscriptions)`","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":203,"value":"viewof compareWithMM = {\n const form = html``;\n form.i.oninput = () => (form.value = form.i.checked);\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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"precision = 1e-6","pinned":true,"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":true,"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":true,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"values = gaussianSmoothing(data.map(d => d.yield), N)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"mm = movingAverage(data.map(d => d.yield), N)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"parseDate = d3.timeParse(\"%d/%m/%Y\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"google_sheet_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vTKD-ZVPGGl2IBPnY8cE3I8R2KeBTSCsGxu71emxtapf6wlmbvs8G_e2ETOEPI_27IXijKHMGGq57xT/pub?output=tsv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"url = `https://sjp7001.herokuapp.com/${google_sheet_url}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":503,"value":"formatMonth = d3.timeFormat('%m-%y');","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"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.yield = +d.yield\n d.subs = +d.subs\n \n return names.push({\"date\": d.date, \"credit\": d.credit, \"yield\": d.yield, \"subs\": d.subs})\n \n })) \n \n return names;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"area = d3\n .area()\n .defined(d => !isNaN(d))\n .x((d, i) => x(data[i].date))\n .y0(y(0))\n .y1(y)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":536,"value":"yieldline =d3.line()\n .defined(d => !isNaN(d.yield))\n .x(d => x(d.date))\n .y(d => y(d.yield))\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"line2 = d3.line()\n .defined(d => !isNaN(d))\n .x((d, i) => x(data[i].date))\n .y(y)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"line1 = d3.line()\n .defined(d => !isNaN(d))\n .x((d, i) => x(data[i].date - (N / 2) * (3600 * 1000)))\n .y(y)","pinned":true,"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(data, d => d.date))\n .range([margin.left, width - margin.right])","pinned":true,"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,10]) //(d3.extent(mm))\n .nice()\n .rangeRound([height - margin.bottom, margin.top])","pinned":true,"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":true,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"height = 500","pinned":true,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"