25:["$","title",null,{"children":"🏁 Assignment: Upgrade Your Dashboard | MyWorkspace | Observable"}] 49:T574,Plot.plot({ tooltip : { // tooltip fix stroke: d => d["Close"] < d["Open"] ? "red" : "lawngreen", strokeWidth: innerWidth/data_filtered.length }, width: 1200, grid: true, y: { label: "Price ↑", axis: "right" }, x: {axis: "top"}, marks: [ Plot.line(data_filtered_with_indicators, { // AVERAGE LINE x: "Date", y: "bollingerAverage", stroke: "dodgerblue", strokeWidth: 2 }), Plot.line(data_filtered_with_indicators, { // EMA PERIOD x: "Date", y: "ema", stroke: "goldenrod", strokeWidth: 2 }), Plot.ruleY([price_today], { strokeOpacity: 0.5, strokeDasharray: 10 }), Plot.areaY(data_filtered_with_indicators, { // BOLLINGER BAND x: "Date", y1: "bollingerLower", y2: "bollingerUpper", fill: "dodgerblue", fillOpacity: 0.25, stroke: "dodgerblue", strokeOpacity: 0.5 }), Plot.ruleX(data_filtered_with_indicators, { // CANDLE BODY x: "Date", y1: "Open", y2: "Close", stroke: d => d["Close"] < d["Open"] ? "red" : "green", strokeWidth: innerWidth/data_filtered.length, title: d => create_tooltip_content(d) }), Plot.ruleX(data_filtered_with_indicators, { // WICKS x: "Date", y1: "High", y2: "Low", stroke: d => d["Close"] < d["Open"] ? "red" : "green" }) ] })4a:[{"id":"2d4a1ee8f7cc3cbdda333dd4a3c3f31de08f050a13b74089d87646fd9012d824532150850c0f7c76884dd8f99e8b0598646da331d579e104a0d2f02f6d83efda","href":"https://static.observableusercontent.com/files/2d4a1ee8f7cc3cbdda333dd4a3c3f31de08f050a13b74089d87646fd9012d824532150850c0f7c76884dd8f99e8b0598646da331d579e104a0d2f02f6d83efda","name":"ETH-USD-3@1.csv","type":"text/csv","lastModified":1683186601828.164,"size":159091}] 29:{"id":"9f153d256892d278","slug":null,"title":"🏁 Assignment: Upgrade Your Dashboard","thumbnail":"1a8107eba8d43e4dfaacaad8e3fa354c310598bfe708a2dd76dfb5abdc82d848","access_level":"public","create_time":"$D2023-05-04T07:42:39.452Z","update_time":"$D2023-05-06T13:45:35.981Z","view_time":null,"first_public_time":"$D2023-05-04T07:42:39.452Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"a052f5d21e4cd617","login":"lucas2109","name":"MyWorkspace","avatar_url":"https://avatars-next.observableusercontent.com/9595d69f6ad4ae370a3600036829e9f1dfdf40dba028a6b52580a3bf1f66e564","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":589,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7301395826986d06","login":"lmw2109","name":"Lucas","avatar_url":"https://avatars-next.observableusercontent.com/83e3a52e223b285c9a3362d06cbd2780f46d782c1f77812e5e2f629473307b55","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"7301395826986d06","login":"lmw2109","name":"Lucas","avatar_url":"https://avatars-next.observableusercontent.com/83e3a52e223b285c9a3362d06cbd2780f46d782c1f77812e5e2f629473307b55","tier":null,"role":"editor"},{"type":"team","id":"a052f5d21e4cd617","login":"lucas2109","name":"MyWorkspace","avatar_url":"https://avatars-next.observableusercontent.com/9595d69f6ad4ae370a3600036829e9f1dfdf40dba028a6b52580a3bf1f66e564","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"afd3b8f9c656b08c","slug":"worksheets-plot","title":"Worksheets: Learn Plot - Lucas Wagner","owner":{"id":"a052f5d21e4cd617","login":"lucas2109","name":"MyWorkspace"}},"type":"notebook","body":{"titling":"auto","title":"🏁 Assignment: Upgrade Your Dashboard","cells":[{"id":0,"value":"# 🏁 Assignment: Upgrade Your Dashboard","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":90,"value":"## Financial Dashboard","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"\n

\n
\n ${viewof year_slider}\n
\n ${viewof ema_period_slider} ${viewof bollinger_period_slider} ${viewof bollinger_std_slider}\n

\n
\n ${viewof macd_signal_period_slider} ${viewof macd_fast_period_slider} ${viewof macd_slow_period_slider}\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":215,"value":"macd_plot = Plot.plot({\n width: 1200,\n height: 200,\n grid: true,\n y: {\n label: \"MACD ↑\",\n axis: \"right\"\n },\n marks: [\n Plot.ruleY([0]), // ZERO LINE\n Plot.lineY(data_filtered_with_indicators, { // MACD SIGNAL\n x: \"Date\",\n y: \"macdSignal\",\n stroke: \"LightSalmon\",\n strokeWidth: 2.5,\n }),\n Plot.lineY(data_filtered_with_indicators, { // MACD\n x: \"Date\",\n y: \"macdDivergence\",\n stroke: \"LightSeaGreen\",\n strokeWidth: 2.5,\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"## Data Import","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":135,"value":"### Import Financial Data (via CSV)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"Source: [ETH-USD](https://finance.yahoo.com/quote/ETH-USD/history?period1=1438905600&period2=1652227200&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true) at Yahoo Finance","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"data_initial = await FileAttachment(\"ETH-USD-3@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"data_initial","database":"$undefined"},{"id":137,"value":"### Import Fear and Greed Indicator Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":116,"value":"data_FGI_raw = d3.json(\"https://api.alternative.me/fng/?limit=0&format=json\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":169,"value":"### Import Todays Price Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":175,"value":"data_eth_price = d3.json(\"https://www.binance.com/api/v3/ticker/price?symbol=ETHUSDT\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"## Data Preprocessing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":131,"value":"### Financial Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"Initial data filtered by a year slider:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":15,"value":"// Uncomment to enable\ndata_filtered = aq.from(data_initial)\n .filter(aq.escape((d) => d[\"Date\"].getFullYear() === year_slider))\n // .filter(aq.escape(d => (d[\"Date\"] >= earliest_year) && (d[\"Date\"] <= latest_year))) // opt. interval slider\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"Filtered data extended by financial indicator data:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":72,"value":"data_filtered_with_indicators = data_filtered.map( (d, i) => ({ \n ema: ema_column[i],\n macd: macd_column[i].macd,\n macdSignal: macd_column[i].signal,\n macdDivergence: macd_column[i].divergence,\n bollingerUpper: bollinger_column[i].upper, \n bollingerAverage: bollinger_column[i].average,\n bollingerLower: bollinger_column[i].lower,\n ...d\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":133,"value":"### Fear and Greed Indicator Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":140,"value":"Processed FGI data:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":118,"value":"data_FGI = aq.from(data_FGI_raw.data)\n\t.derive({ date: aq.escape(d => new Date(+d[\"timestamp\"] * 1000)) })\n\t.derive({ valueAsNumber: d => +d[\"value\"] })\n .select('value_classification','date','valueAsNumber')\n\t.rename({valueAsNumber: \"FearGreedValue\"})\n .rename({value_classification: \"FearGreedClass\"})\n .rename({date: \"FearGreedDate\"})\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"Join financial data & FGI data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":121,"value":"data_filtered_with_indicators_with_FGI = aq.from(data_filtered_with_indicators)\n .join(aq.from(data_FGI), [\"Date\", \"FearGreedDate\"])\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"### Todays Price Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":179,"value":"price_today = +data_eth_price.price","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"## Sliders","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"viewof year_slider = Inputs.range([2017, 2023], {\n step: 1,\n value: [2023],\n label: html`

Year

`\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"viewof year_interval_slider = interval([2017, 2023], {step: 1, value: [2019, 2021], label: \"Years\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":489,"value":"earliest_year = new Date(year_interval_slider[0], 1).getTime()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":491,"value":"latest_year = new Date(year_interval_slider[1], 1).getTime()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"viewof bollinger_period_slider = Inputs.range([2, 100], {\n label: html`

Bollinger Period

`,\n step: 1,\n value: 7\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"viewof bollinger_std_slider = Inputs.range([0, 5], {\n label: html`

Bollinger Standard Deviation

`,\n step: 1,\n value: 2\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"viewof ema_period_slider = Inputs.range([0,100], {\n label: html`

EMA Period

`,\n step: 1,\n value: 9\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"viewof macd_signal_period_slider = Inputs.range([0,100], {\n label: html`

MACD Signal Period

`,\n step: 1,\n value: 9\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"viewof macd_fast_period_slider = Inputs.range([0,100], {\n label: html`

MACD Fast Period

`,\n step: 1,\n value: 12\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"viewof macd_slow_period_slider = Inputs.range([0,100], {\n label: html`

MACD Slow Period

`,\n step: 1,\n value: 24\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"## Tooltip Content Wrapper","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":102,"value":"create_tooltip_content = (d) => \n `${ d[\"Date\"].toLocaleString('default', { month: 'long' }) } ${d[\"Date\"].getDate()}\n Close: ${ d3.format('.3s')(d[\"Close\"]) }\n High: ${ d3.format('.3s')(d[\"High\"]) }\n Open: ${ d3.format('.3s')(d[\"Open\"]) }\n Low: ${ d3.format('.3s')(d[\"Low\"]) }`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"## Financial Indicators","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"_See: [d3fc-technical-indicator](https://github.com/d3fc/d3fc/blob/master/packages/d3fc-technical-indicator/README.md)_ in D3FC API.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":45,"value":"fc = require('d3fc')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"### Generare Indicator Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":50,"value":"#### Exponential Moving Average (EMA)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":52,"value":"ema_column = fc.indicatorExponentialMovingAverage()\n .period(ema_period_slider)\n .value(d => d[\"Close\"])\n (data_filtered)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"#### Bollinger Band","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":57,"value":"bollinger_column = fc.indicatorBollingerBands()\n .value(d => d[\"Close\"])\n .period(bollinger_period_slider)\n .multiplier(bollinger_std_slider)\n (data_filtered)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":61,"value":"#### Moving Average Convergence Divergence (MACD)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":59,"value":"macd_column = fc.indicatorMacd()\n .value(d => d[\"Close\"])\n .signalPeriod(macd_signal_period_slider)\n .fastPeriod(macd_fast_period_slider)\n .slowPeriod(macd_slow_period_slider)\n (data_filtered)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":24,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":479,"value":"import {interval} from '@mootari/range-slider@1786'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null