25:["$","title",null,{"children":"🏁 Assignment: Upgrade Your Dashboard | Juan Arriaga | Observable"}] 49:T58d,Plot.plot({ grid: true, tooltip: { stroke: (d) => (d["Open"] < d["Close"] ? "green" : "red") }, x:{ axis: "top" }, y:{ title: "Fear-GredValue", axis: "right" }, width: 1100, marks: [ // Bollinger cloud Plot.areaY(data_filtered_withIndicators, { x: "Date", y1: "bollingerUpper", y2: "bollingerLower", fill: "dodgerblue", fillOpacity: 0.20, stroke: "dodgerblue", strokeOpacity: 1 }), Plot.ruleY([+ current_price["price"]], {strokeDasharray: [4, 4], stroke: "lightslategrey"}),, Plot.lineY(data_filtered_withIndicators, { x: "Date", y: "bollingerAverage", stroke: "dodgerblue", strokeWidth: 1.5 }), Plot.lineY(data_filtered_withIndicators, { x: "Date", y: "ema", stroke: "goldenrod", strokeWidth: 1.5 }), // Wicks Plot.ruleX(data_filtered_withIndicators, { x: "Date", y1: "High", y2: "Low", stroke: (d) => (d["Open"] < d["Close"] ? "oliveDrab" : "crimson"), title: (d) => createTooltipContent(d) }), // Candle Body Plot.ruleX(data_filtered_withIndicators, { x: "Date", y1: "Close", y2: "Open", strokeWidth: 1000 / numberOfDaysInFilteredData, stroke: (d) => (d["Open"] < d["Close"] ? "oliveDrab" : "crimson"), title: (d) => createTooltipContent(d) }) ] })4a:[{"id":"3dc6552954ec295d4beddbf96f6016ce93fdfa40fa33bb5e72dab23ec8b8dac403dd6421bc305881840dba2a5bf115a4f26bcd0e7b9950e9b782b988dc43eff3","href":"https://static.observableusercontent.com/files/3dc6552954ec295d4beddbf96f6016ce93fdfa40fa33bb5e72dab23ec8b8dac403dd6421bc305881840dba2a5bf115a4f26bcd0e7b9950e9b782b988dc43eff3","name":"CleanShot 2023-04-28 at 16.16.09-2x.png","type":"image/png","lastModified":1683583170313.6,"size":97582},{"id":"a2f8d5a2bff113cbd381dfd5e04ddd28529b02230cd26ef989aa8a366cd6a878ee449452c7c1918e6e4f59c98d762ae2ce9bc95a2e9384ded88f88b0cc8ba7b7","href":"https://static.observableusercontent.com/files/a2f8d5a2bff113cbd381dfd5e04ddd28529b02230cd26ef989aa8a366cd6a878ee449452c7c1918e6e4f59c98d762ae2ce9bc95a2e9384ded88f88b0cc8ba7b7","name":"CleanShot 2023-04-28 at 22.10.42-2x.png","type":"image/png","lastModified":1683583170313.6,"size":15047},{"id":"f92545d96fe96853e1e98b0c6ad67f7bcabc873f4fc6ac352a3ab724fd6b739dff22a677d1e03e7f30299257bb76207963c29d437811003892cafa2a9f04e923","href":"https://static.observableusercontent.com/files/f92545d96fe96853e1e98b0c6ad67f7bcabc873f4fc6ac352a3ab724fd6b739dff22a677d1e03e7f30299257bb76207963c29d437811003892cafa2a9f04e923","name":"F76CF941-6A2C-4154-B704-9288963ECC15_1_102_o.jpeg","type":"image/jpeg","lastModified":1683583170313.6,"size":746036},{"id":"2d4a1ee8f7cc3cbdda333dd4a3c3f31de08f050a13b74089d87646fd9012d824532150850c0f7c76884dd8f99e8b0598646da331d579e104a0d2f02f6d83efda","href":"https://static.observableusercontent.com/files/2d4a1ee8f7cc3cbdda333dd4a3c3f31de08f050a13b74089d87646fd9012d824532150850c0f7c76884dd8f99e8b0598646da331d579e104a0d2f02f6d83efda","name":"ETH-USD@3.csv","type":"text/csv","lastModified":1683583170313.6,"size":159091}] 29:{"id":"a78319452e10ed1a","slug":null,"title":"🏁 Assignment: Upgrade Your Dashboard","thumbnail":"47f02361ca3bbbd3ca7debb9a110dd9903ee88f910fc292d34789c6fa76fab9e","access_level":"public","create_time":"$D2023-05-08T21:59:30.313Z","update_time":"$D2023-05-10T16:48:39.946Z","view_time":null,"first_public_time":"$D2023-05-08T21:59:30.313Z","has_unpublished_edits":null,"fork":{"id":"981628491ccf544c","slug":null,"title":"Candlestick Chart","owner":{"id":"c9e750b35fa1af7e","login":"juanarriaga-ws","name":"Juan Arriaga"}},"stars":0,"starred":false,"owner":{"type":"team","id":"c9e750b35fa1af7e","login":"juanarriaga-ws","name":"Juan Arriaga","avatar_url":"https://avatars-next.observableusercontent.com/bcf178f5838afd889f0dc36cf0890a4a8a942c8044f713cb2ddf4a42b9552295","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":3628,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"29b0b9d481e0b66d","login":"juanarriaga","name":"Juan Arriaga","avatar_url":"https://avatars-next.observableusercontent.com/f960da7f76aee6c193efac8eac985eb8996e03665b2b0d780a8826c0d31a73e6","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"29b0b9d481e0b66d","login":"juanarriaga","name":"Juan Arriaga","avatar_url":"https://avatars-next.observableusercontent.com/f960da7f76aee6c193efac8eac985eb8996e03665b2b0d780a8826c0d31a73e6","tier":null,"role":"editor"},{"type":"team","id":"c9e750b35fa1af7e","login":"juanarriaga-ws","name":"Juan Arriaga","avatar_url":"https://avatars-next.observableusercontent.com/bcf178f5838afd889f0dc36cf0890a4a8a942c8044f713cb2ddf4a42b9552295","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"64105d1336f920f4","slug":"worksheets-learn-plot","title":"Worksheets: Learn Plot","owner":{"id":"c9e750b35fa1af7e","login":"juanarriaga-ws","name":"Juan Arriaga"}},"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":3511,"value":"\n

\n\n
\n ${viewof bollingerPeriod_slider} ${viewof bollingerSD_slider}\n
\n ${viewof emaPeriod_slider}\n
\n ${viewof year_slider}\n\n

\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3286,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2922,"value":"Plot.plot({\n height: 150,\n width: 1100,\n grid: true, \n y:{\n title: \"FearGreedValue\",\n axis: \"right\"\n },\n marks: [\n\n Plot.lineY(data_filtered_withIndicators_withFearGreedIndex, {\n x: \"Date\",\n y: \"FearGreedValue\",\n stroke: \"forestgreen\",\n strokeWidth: 1.5\n \n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":21,"value":"**Notebook Style**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"import {toc} from \"@nebrius/indented-toc\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":781,"value":"import {Wrangler, op} from \"@observablehq/data-wrangler\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2106,"value":"import {howTo} from \"@clokman/howto\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2342,"value":"import {imageToDo} from \"@clokman/student-blocks\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2344,"value":"imageToDo","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"## Dataset Import and Preparation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1197,"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":1594,"value":"data_initial = await FileAttachment(\"ETH-USD@3.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":49,"value":"data_forAroundOneYear = aq.from(data_initial)\n .filter( aq.escape(d => d[\"Date\"].getFullYear() > 2022 ) )\n\t.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2713,"value":"viewof year_slider = Inputs.range([2017, 2023], {label: \"Amount\", step: 1, value: 2023})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3016,"value":"year_slider","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"// Uncomment to enable\ndata_filtered = aq.from(data_initial)\n .filter(aq.escape((d) => d[\"Date\"].getFullYear() === year_slider))\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2683,"value":"$${viewof year_slider}","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2674,"value":"numberOfDaysInFilteredData = data_filtered.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":402,"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":478,"value":"createTooltipContent = (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\"]) }`\n\n\n// The same function created with classic fuction syntax:\n\n// createTooltipContent = function (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\"]) }`\n// }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"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":547,"value":"// Uncoment to enable\n\nemaColumn = fc.indicatorExponentialMovingAverage()\n .period( emaPeriod_slider )\n .value(d => d[\"Close\"])\n ( data_filtered )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3474,"value":"viewof emaPeriod_slider = Inputs.range([0, 100], {\n label: \"EMA 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":539,"value":"// Uncoment to enable\n\nbollingerColumn = fc.indicatorBollingerBands()\n .value( d => d[\"Close\"] )\n .period( bollingerPeriod_slider )\n .multiplier( bollingerSD_slider )\n ( data_filtered )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3492,"value":"viewof bollingerPeriod_slider = Inputs.range([0, 100], {\n label: \"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":3485,"value":"viewof bollingerSD_slider = Inputs.range([0,5],{\n label: \"Bollinger Standard Devision\",\n step: 0.1,\n value: 1\n \n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"// Uncoment to enable\n\nmacdColumn = fc.indicatorMacd()\n .value( d => d[\"Close\"] )\n .signalPeriod( 9 )\n .fastPeriod( 12 )\n .slowPeriod( 26 )\n ( data_filtered )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3579,"value":"current_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":2509,"value":"// Uncoment to enable\n\ndata_filtered_withIndicators = data_filtered.map( (d, i) => ({ \n ema: emaColumn[i],\n macd: macdColumn[i].macd,\n macdSignal: macdColumn[i].signal,\n macdDivergence: macdColumn[i].divergence,\n bollingerUpper: bollingerColumn[i].upper, \n bollingerAverage: bollingerColumn[i].average,\n bollingerLower: bollingerColumn[i].lower,\n ...d\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"data_fearGreedIndex_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":1321,"value":"Convert '`timestamp`' strings to date objects and make '`values`' numeric:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":794,"value":"data_fearGreedIndex = aq.from(data_fearGreedIndex_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\t.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2249,"value":"data_filtered_withIndicators_withFearGreedIndex = aq.from(data_filtered_withIndicators)\n\t.join(aq.from(data_fearGreedIndex), [\"Date\", \"FearGreedDate\"])\n\t.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3301,"value":"

${viewof year_slider}

${viewof bollingerPeriod_slider}

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null