2c:null 2d:["$","title",null,{"children":"RIC Benchmarks | Steve Pegg | Observable"}] 32:T764,viewof date = { const svg = d3.select(DOM.svg(width, height)) .style("-webkit-tap-highlight-color", "transparent") .on("mousemove touchmove", moved); svg.append("g") .call(xAxis); svg.append("g") .call(yAxis); const rule = svg.append("g") .append("line") .attr("y1", height) .attr("y2", 0) .attr("stroke", "black"); const serie = svg.append("g") .style("font", "bold 10px sans-serif") .selectAll("g") .data(series) .join("g"); serie.append("path") .attr("fill", "none") .attr("stroke-width", 1.5) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("stroke", d => z(d.key)) .attr("d", d => line(d.values)); serie.append("text") .datum(d => ({key: d.key, value: d.values[d.values.length - 1].value})) .attr("fill", "none") .attr("stroke", "white") .attr("stroke-width", 3) .attr("x", x.range()[1] + 3) .attr("y", d => y(d.value)) .attr("dy", "0.35em") .text(d => d.key) .clone(true) .attr("fill", d => z(d.key)) .attr("stroke", null); d3.transition() .ease(d3.easeCubicOut) .duration(1500) .tween("date", () => { const i = d3.interpolateDate(x.domain()[1], x.domain()[0]); return t => update(i(t)); }); function update(date) { date = d3.utcDay.round(date); rule.attr("transform", `translate(${x(date) + 0.5},0)`); serie.attr("transform", ({values}) => { const i = bisect(values, date, 0, values.length - 1); return `translate(0,${y(1) - y(values[i].value / values[0].value)})`; }); svg.property("value", date).dispatch("input"); } function moved(event) { update(x.invert(d3.pointer(event, this)[0])); d3.event.preventDefault(); } update(x.domain()[0]); return svg.node(); }33:T663,function swatches({ color, columns = null, format = x => x, swatchSize = 15, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 }) { const id = DOM.uid().id; if (columns !== null) return html`

${color.domain().map(value => { const label = format(value); return html`

${document.createTextNode(label)}

`; })}

`; return html`

${color.domain().map(value => html`${document.createTextNode(format(value))}`)}

`; }34:[{"id":"a3a40558b8a2590e24ccfa34bd62710fbbbe31badd5ad593b7b897b043180a95ae018de2d4e8c92af37cb21395abde4462c3291223ea0652baccfd04db91a749","href":"https://static.observableusercontent.com/files/a3a40558b8a2590e24ccfa34bd62710fbbbe31badd5ad593b7b897b043180a95ae018de2d4e8c92af37cb21395abde4462c3291223ea0652baccfd04db91a749","name":"MSFT.csv","type":"text/csv","lastModified":1613306181577.519,"size":88250},{"id":"c56b9e232d72bf1df96ca3eeca37e29e811adb72f49d943659a0006c015e74d2c429186d9dca251060784f364eb2a16fd39584695d523588bdcb87e4d9eac650","href":"https://static.observableusercontent.com/files/c56b9e232d72bf1df96ca3eeca37e29e811adb72f49d943659a0006c015e74d2c429186d9dca251060784f364eb2a16fd39584695d523588bdcb87e4d9eac650","name":"IBM.csv","type":"text/csv","lastModified":1613306181577.519,"size":93315},{"id":"3ca44f93993f84575ab5461b4097d37b814438266e8cfe8774f70882f49bb289143c190963a158e8dc886989433af1161798ba76f2f4b36d17cc7150cba94477","href":"https://static.observableusercontent.com/files/3ca44f93993f84575ab5461b4097d37b814438266e8cfe8774f70882f49bb289143c190963a158e8dc886989433af1161798ba76f2f4b36d17cc7150cba94477","name":"GOOG.csv","type":"text/csv","lastModified":1613306181577.519,"size":93857},{"id":"51ef8c06edd5d139385ad9477c0a42cbf0152f5a4facf30a52d5eaa3ce4debecf1114c4a51199e734274e4411ec8149ffdd0d094cd334095cf8f2a004fc90d44","href":"https://static.observableusercontent.com/files/51ef8c06edd5d139385ad9477c0a42cbf0152f5a4facf30a52d5eaa3ce4debecf1114c4a51199e734274e4411ec8149ffdd0d094cd334095cf8f2a004fc90d44","name":"AMZN.csv","type":"text/csv","lastModified":1613306181577.519,"size":94124},{"id":"3ccff97fd2d93da734e76829b2b066eafdaac6a1fafdec0faf6ebc443271cfc109d29e80dd217468fcb2aff1e6bffdc73f356cc48feb657f35378e6abbbb63b9","href":"https://static.observableusercontent.com/files/3ccff97fd2d93da734e76829b2b066eafdaac6a1fafdec0faf6ebc443271cfc109d29e80dd217468fcb2aff1e6bffdc73f356cc48feb657f35378e6abbbb63b9","name":"AAPL.csv","type":"text/csv","lastModified":1613306181577.519,"size":92399}] 30:{"id":"3d4ec58e180af5c4","slug":"ric-benchmarks","title":"RIC Benchmarks","thumbnail":"7a559b74668738a54b0849c7de272226c26231bfa2be998c4d3fc1c0d970e8cc","access_level":"public","create_time":"$D2021-02-14T12:36:21.577Z","update_time":"$D2021-03-29T12:36:00.294Z","view_time":null,"first_public_time":"$D2021-02-14T15:00:44.459Z","has_unpublished_edits":null,"fork":{"id":"8e3610e5bc765622","slug":"ric-buy-proposals-chart","title":"RIC Buy Proposals Chart","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":684,"publish_version":684,"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":"RIC Benchmarks","cells":[{"id":1,"value":"md`# RIC Benchmarks`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"html`

\n ${date.toLocaleString(\"en\", {timeZone: \"UTC\", month: \"long\", day: \"numeric\", year: \"numeric\"})} data from Google Finance\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"value":"menu = swatches({\n color: z,\n columns: \"180px\"\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"height = 600","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"margin = ({top: 20, right: 60, bottom: 30, left: 40})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"options= [\"CWR\",\"CCC\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"x = d3.scaleUtc()\n .domain(d3.extent(data, d => d.date))\n .range([margin.left, width - margin.right])\n .clamp(true)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":61,"value":"y = d3.scaleLog()\n .domain([1 / k, k])\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":576,"value":"k = d3.max(d3.group(data, d => d.name), ([, group]) => d3.max(group, d => d.value) / d3.min(group, d => d.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"z = d3.scaleOrdinal([\"#ff4040\",\"#e78d0b\",\"#a7d503\",\"#ADFF2F\",\"#18f472\",\"#00bfbf\",\"#1872f4\",\"#582afc\",\"#a703d5\",\"#e70b8d\",\"#ff4040\",\"#000000\"]).domain(data.map(d => d.stock))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x).ticks(width / 80).tickSizeOuter(0))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y)\n .ticks(null, x => +x.toFixed(6) + \"×\"))\n .call(g => g.selectAll(\".tick line\").clone()\n .attr(\"stroke-opacity\", d => d === 1 ? null : 0.2)\n .attr(\"x2\", width - margin.left - margin.right))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"parseDateB = d3.utcParse(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"formatDate = d3.utcFormat(\"%B, %Y\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"line = d3.line()\n .defined(d => !isNaN(d.value))\n .x(d => x(d.date))\n .y(d => y(d.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"bisect = d3.bisector(d => d.date).left","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"series = d3.groups(data, d => d.name).map(([key, values]) => {\n const v = values[0].value;\n return {key, values: values.map(({date, value}) => ({date, value: value / v}))};\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"dataB = d3.merge(await Promise.all([FileAttachment(\"AAPL.csv\"), FileAttachment(\"AMZN.csv\"), FileAttachment(\"GOOG.csv\"), FileAttachment(\"IBM.csv\"), FileAttachment(\"MSFT.csv\")].map(async file => d3.csvParse(await file.text(), d => {\n const date = parseDateB(d[\"Date\"]);\n return {name: file.name.slice(0, -4), date, value: +d[\"Close\"]};\n}))))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"data = { \n var arr = []\n const data = await d3.tsv(url);\n const columns = data.columns.slice(3);\n var x = 0\n \n data.forEach(function (d) { \n \n for (x = 0; x < columns.length; x++) {\n\n //d[columns[x]] = +d[columns[x]] /+d[columns[0]]\n \n // console.log(d[columns[0]])\n ///+d[columns[0]]\n \n arr.push({\"name\": d.name, \"stock\": d.stock, \"date\": parseDate(columns[x]), \"value\": +d[columns[x]]})\n } \n \n })\n \n return arr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":604,"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":600,"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":598,"value":"google_sheet_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vT2Lcg-pCf48GJod9UxUFUbSNACd-OVQF_XpAPGWPhym0c719qWXQt7zgeQNLRyoSkXZpIKT6nxKkiw/pub?output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":626,"value":"function entity(character) {\n return `&#${character.charCodeAt(0).toString()};`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":624,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 31:"$30:body"