viewof file = Inputs.file()
csv = {
const txt = await file.text();
return d3
.csvParse(txt.split("\n").slice(2).join("\n"), d3.autoType)
.map((row) => {
return {
...row,
date: new Date(row["Acquired date"])
};
});
}
database = DuckDBClient.of({
costbasis: csv
})
database
query = database.query(
`SELECT * from costbasis where "Symbol/CUSIP" = '${ticker}'`
)
database
viewof ticker = Inputs.select(tickers.map((t) => t.ticker))
Plot.plot({
caption: "Cost per share",
width,
x: {
label: "Date"
},
marks: [
Plot.ruleY([0]),
Plot.dot(query, { y: "Cost per share", x: "date", r: "Total cost" })
]
})
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
