2c:null 2d:["$","title",null,{"children":"RIC Stock Weighting | Steve Pegg | Observable"}] 32:T165c,chart = { // Initialize svg const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]); const tooltip = d3.select('body') .append('div') .attr('id', 'barchart-tooltip') .style('position', 'absolute') .style('z-index', '1') .style('visibility', 'hidden') .style('padding', '10px') .style('background', 'rgba(0,0,0,0.6)') .style('border-radius', '4px') .style('color', '#fff'); // Append the grid lines on X axis svg.append("g") .attr("class", "grid") .attr("transform", `translate(${x.bandwidth()/2}, ${height - margin.bottom})`) .call(make_x_gridlines() .tickSize(-height) .tickFormat("") ) // Append the bars const bar = svg.append("g") .selectAll("g") .data(series2) .join('g') .attr("fill", function(d) {return color(d.key)}) .attr("class", function (d) { return d.key}) .selectAll("rect") .data(d => d) .join("rect") .attr("class", function (d) { return "temp " + d.data.code}) .attr("width", x.bandwidth) .attr("x", d => x(d.data.code)) .attr("y", d => y(d[1])) .attr("height", d => y(d[0]) - y(d[1])) .on("mouseover", function(event, d) { let tooltipWidth = tooltip.node().offsetWidth; let tooltipHeight = tooltip.node().offsetHeight; tooltip .style("left", event.pageX - tooltipWidth/10 +'px') .style("top", event.pageY-tooltipHeight - 10+'px') .style('visibility', 'visible') .html(`Stock: ${d.data.code}
Profit/Loss: ${d.data.PL}
Residual : ${(d.data.Residual)}
Total : ${(d.data.total)}`); }) .on('mousemove', function (event) { let tooltipWidth = tooltip.node().offsetWidth; let tooltipHeight = tooltip.node().offsetHeight; tooltip .style("left", event.pageX - tooltipWidth/10 +'px') .style("top", event.pageY-tooltipHeight - 10+'px') }) .on("mouseout", function(event, d) { tooltip .style('visibility', 'hidden'); }); // Append ust & lst lines svg.append("path") .datum(line_series) .attr("fill", "none") .attr("stroke", "darkgreen") .attr("stroke-width", 2.5) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("d", line); const gx = svg.append("g") .call(xAxis); // Append the Y-axis let y_axis = svg.append("g") .attr("transform", `translate(${margin.left},0)`) .attr("id", "y-axis") .attr("class", "y axis") .call(yAxis) // Replace 0 tick on y-axis with - y_axis.selectAll("g.tick") // Y label svg.append("g") .attr("transform", `translate(${margin.left/2}, ${(height - margin.top)/2})`) .attr("class", "y-axis-label") .append("text") .attr("transform", "rotate(-90)") .text("£ GBP"); // Bar chart legends const legend = svg.selectAll('.legend') .data(color.domain()) .enter() .append('g') .attr('class', 'legend') .attr('transform', (d, i) => { let legendHeight = legendRectSize + legendSpacing; let x = width - margin.right; let y = (i+1) * legendHeight + margin.top + 5; return `translate(${x}, ${y})`; }); legend.append('rect') .attr('width', legendRectSize) .attr('height', legendRectSize) .style('fill', color) .style('stroke', color); const altext = ["PL from base", "Total PL","today's PL"] legend.append('text') .attr("class", "legend-text") .attr('x', legendRectSize + legendSpacing) .attr('y', legendRectSize) .text(d => d); // svg.selectAll("rect." + owner) // .style("stroke", "Black") // .style("stroke-width", 1); return Object.assign(svg.node(), { update(order) { // svg.selectAll("rect") // .style("stroke", "Black") // .style("stroke-width", 0); // svg.selectAll("rect." + owner) // .style("stroke", "Black") // .style("stroke-width", 1); // x.domain(data2.sort(order).map(d => d.code)); const t = svg.transition() .duration(750); // d3.selectAll(".temp") // .data(series, d => d) // .order() // .transition(t) // .delay((d, i) => i * 10) ; // .attr("x", d => x(d.data2.code)); // d3.selectAll(".temp").filter(function(d) { // return d.data["PL from Base"] > 10 }) // .transition(t) // .delay((d, i) => i * 10) // .attr("fill", d => color("PL from Base")) //.raise(); // d3.select(this).moveToFront(); gx.transition(t) .call(xAxis) .selectAll("text") .attr("y", 0) .attr("x", 9) .attr("dy", ".55em") .style("font-size", 12) .style('fill', 'navy') .attr("transform", "rotate(90)") .style("text-anchor", "start"); } }); } 33:[] 30:{"id":"408f7d3fa4e51639","slug":"ric-stock-weighting","title":"RIC Stock Weighting","thumbnail":"32f2f5f096bd7404d34d78b2c5402207209f81098ceb21e9cb91e9f0f4773e26","access_level":"public","create_time":"$D2021-02-14T17:30:24.054Z","update_time":"$D2021-02-15T21:51:11.091Z","view_time":null,"first_public_time":"$D2021-02-15T21:51:45.672Z","has_unpublished_edits":null,"fork":{"id":"547fd75a6ebe6fd3","slug":"ric-dividend-in-stacked-bar-chart","title":"RIC Dividend in Stacked Bar 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":2189,"publish_version":2189,"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":{"id":"6ff40e8e4a2133a9","slug":"ric","title":"RIC","owner":{"id":"ea29cfe69c48ffa5","login":"steve-pegg","name":"Steve Pegg"}},"type":"notebook","body":{"titling":"auto","title":"RIC Stock Weighting","cells":[{"id":0,"value":"md`# RIC Stock Weighting`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":750,"value":"md` Hover over bars to see more detail. Residual = buy cost - loss \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1239,"value":"combo = []","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"legendSpacing = 5","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"legendRectSize = 10","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"legend_auto = d3Legend\n .legendColor()\n .scale(color)\n .labels(color.domain())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"color2 = d3.scaleOrdinal()\n .domain(series.map(d => d.key))\n .range(['#d73027', '#fee08b', '#1a9850', \"#FFFFFF\"]);\n // .range([\"green-bar\", \"blue-bar\", \"striped-bar green-bar\", \"striped-bar blue-bar\"])\n // .range([\"#7f0000\", \"#007f00\", \"#00007f\", \"#7f7f7f\"])\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2033,"value":"bar_colors = [\"#6a3d9a\",\"#cab2d6\",\"#ffff99\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"bar_colorsORIG = [\"#8dd3c7\",\"#ffffb3\",\"#bebada\",\"#fb8072\",\"#80b1d3\",\"#fdb462\",\"#ccebc5\",\"#ffed6f\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":794,"value":"OwnerKeycolor = d3.scaleOrdinal()\n .domain([...new Set(data.map(d => d.owner)),\"Clear\"])\n // .range([\"green-bar\", \"blue-bar\", \"striped-bar green-bar\", \"striped-bar blue-bar\"])\n // .range([\"#7f0000\", \"#007f00\", \"#00007f\", \"#7f7f7f\"])\n .range([\"#7fc97f\",\"#beaed4\",\"#fdc086\",\"#ffff99\",\"#386cb0\",\"#f0027f\",\"#bf5b17\",\"#666666\"])\n .unknown(\"#ccc\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"// color = d3.scaleOrdinal(d3.schemeCategory10);\ncolor = d3.scaleOrdinal()\n .domain(series2.map(d => d.key)) \n // .range([\"green-bar\", \"blue-bar\", \"striped-bar green-bar\", \"striped-bar blue-bar\"])\n // .range([\"#7f0000\", \"#007f00\", \"#00007f\", \"#7f7f7f\"])\n .range(bar_colors)\n .unknown(\"#ccc\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":607,"value":"lline = d3.line()\n // .defined(d => !isNaN(d.code))\n .x(d => x(d.code))\n .y(d => y(d.lst));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"plline = d3.line()\n // .defined(d => !isNaN(d.code))\n .x(d => x(d.code))\n .y(d => y(d.PL));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"line = d3.line()\n // .defined(d => !isNaN(d.code))\n .x(d => x(d.code))\n .y(d => y(2000));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"// Function to produce gridlines in y-axis\nmake_x_gridlines = () => d3.axisBottom(x);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"formatNumber = d3.format(\"(.0f\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2010,"value":"options = [\"Bryan\", \"Chris\", \"Mike\", \"Richard\", \"Steve\", \"Terry\", \"Tom\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"yAxis = d3.axisLeft(y).ticks(null, \"s\").tickFormat(formatNumber)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"y = d3.scaleLinear()\n .domain([0, d3.max([d3.max(series2, d => d3.max(d, d => d[1]))+100,50])])\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":47,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom + 10})`)\n .call(d3.axisBottom(x).tickSize(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":18,"value":"x = d3.scaleBand()\n .domain(data2.map(d => d.code))\n .rangeRound([margin.left, width - margin.right])\n .padding(0.2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"height = 500","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":363,"value":"google_sheet_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vRXGQJpGllqJcsOUE1S-x9w0LDhviZtGCho-92P_T9MUNgZmYDe8VaRsBd2xomynxllx5jQvd88_INm/pub?gid=0&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"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":359,"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 = parseTime(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({\"code\": d.Code, \"credit\": d.Credit, \"buyDate\": formatMonth(d.Date), \"stock\": d.Stock, \"owner\": d.Owner,\"y2021\": total, \"y2020\": total, \"y2019\": total, \"y2018\": total, \"y2017\": total, \"y2016\": total, \"y2015\": total, \"y2021\": total})\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":1883,"value":"final = groups (data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1882,"value":"function groups (data) {\n\nlet obj = {};\n data.forEach(function(d){\n if (!obj[d.code]) obj[d.code] = {code: d.code};\n if (!obj[d.code]['y' + d.buyDate]) {obj[d.code]['y' + d.buyDate] = 0;} // first time we see year initialize to 0;\n obj[d.code]['y' + d.buyDate] += d.credit; // retrieve the dictionary value for this code and year and add value\n if (!obj[d.code]['total']) {obj[d.code]['total'] = 0;}\n obj[d.code]['total'] += d.credit\n if (!obj[d.code]['y2021']) {obj[d.code]['y2021'] = 0;} \n // console.log(obj[d.code])\n // if (obj[d.code]['y' + d.buyDate] > 0) \n // {\n // obj[d.code]['y' + d.buyDate] = obj[d.code]['y' + d.buyDate] + d.credit;}\n // else \n // obj[d.code][d.buyDate] = d.buyDate;\n \n obj[d.code]['stock'] = d.stock;\n \n obj[d.code]['owner'] = d.owner;\n })\n console.log(Object.values(obj));\n return Object.values(obj)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2065,"value":"data2 = { \n let names =[];\n let lvl1 = 0;\n let lvl2 = 0;\n let ttl = 0\n const spreadsheet = await d3.tsv(url2).then(data => data.forEach(function (d) { \n d.Cost = +d.Cost; \n d.PL = + d.PL\n if (d.PL > 0) { ttl = d.PL + d.Cost} else { ttl = d.Cost - Math.abs(+d.PL)}; \n if(d.PL > 0) { lvl1 = Math.abs(+d.PL); lvl2 = d.Cost; } else { lvl1 = 0; lvl2 = d.Cost - Math.abs(+d.PL)};\n \n \n return names.push({\"code\": d.Code, \"Profit\": lvl1,\"Residual\": lvl2, \"total\": ttl ,\"PL\":d.PL})\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":2081,"value":"//final2 = groups2 (data2)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2063,"value":"function groups2 (data2) {\n\nlet obj = {};\n data.forEach(function(d){\n if (!obj[d.code]) obj[d.code] = {code: d.code};\n if (!obj[d.code]['y' + d.buyDate]) {obj[d.code]['y' + d.buyDate] = 0;} // first time we see year initialize to 0;\n obj[d.code]['y' + d.buyDate] += d.credit; // retrieve the dictionary value for this code and year and add value\n if (!obj[d.code]['total']) {obj[d.code]['total'] = 0;}\n obj[d.code]['total'] += d.credit\n if (!obj[d.code]['y2021']) {obj[d.code]['y2021'] = 0;} \n // console.log(obj[d.code])\n // if (obj[d.code]['y' + d.buyDate] > 0) \n // {\n // obj[d.code]['y' + d.buyDate] = obj[d.code]['y' + d.buyDate] + d.credit;}\n // else \n // obj[d.code][d.buyDate] = d.buyDate;\n \n obj[d.code]['stock'] = d.stock;\n \n obj[d.code]['owner'] = d.owner;\n })\n console.log(Object.values(obj));\n return Object.values(obj)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2061,"value":"url2 = `https://sjp7001.herokuapp.com/${google_sheet_url2}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2058,"value":"google_sheet_url2 = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vRoXVuUvF6D6iCd-CK31QERBtrS87n-l18qhqz1az6-SpvpYAbP42LAez9rdeylkMuFvozMpZCx51wL/pub?output=tsv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1596,"value":"formatMonth = d3.timeFormat('%Y');","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1354,"value":"parseTime = d3.timeParse(\"%d/%m/%Y\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2123,"value":"sorti = data2.sort((a, b) => d3.ascending(a.total, b.total)).map(d => d.code)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2084,"value":"series2 = d3.stack().keys([\"Profit\", \"Residual\"]).offset(d3.stackOffsetDiverging)(data2) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"series = d3.stack().keys([\"y2015\", \"y2016\", \"y2017\",\"y2018\", \"y2019\", \"y2020\",\"y2021\"]).offset(d3.stackOffsetDiverging)(final) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"line_series = data2.map( d => { return { code: d.code }; } );","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"margin = ({top: 5, right: 90, bottom: 90, left: 80})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2013,"value":"import {radio} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"import {legend} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"d3Legend = require('d3-svg-legend')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":909,"value":"viewof order = { const options = [\n {label: \"Total\", value: (a, b) => d3.ascending(a.Profit, b.Profit)},\n {label: \"Total 2021\", value: (a, b) => d3.ascending(a.y2021, b.y2021)},\n {label: \"Total Dividend\", value: (a, b) => d3.ascending(a.total,b.total)},\n // {label: \"PL from Base\", value: (a, b) => d3.ascending(a[\"PL from Base\"],b[\"PL from Base\"])},\n {label: \"A to Z\", value: (a, b) => d3.ascending(a.code, b.code)}\n ];\n const form = html`