31:[{"id":"bf348519fc28c2d85204acc865fb4deaed6c1b33c5193502e207a04c028b1b6b8329c99ca4a51d0a24592e7ec17c8c506e45e2478e16fa9946261d904e1e3f91","href":"https://static.observableusercontent.com/files/bf348519fc28c2d85204acc865fb4deaed6c1b33c5193502e207a04c028b1b6b8329c99ca4a51d0a24592e7ec17c8c506e45e2478e16fa9946261d904e1e3f91","name":"CleanShot 2022-05-11 at 04.27.54-2x.png","type":"image/png","lastModified":1652271702000.326,"size":582144},{"id":"a9d5e6db2b69cb76221e47a35eea637c7328fe2ce5b5b36e7cd7644a557430af935b26744f74b97092cc8969991ddd65ce2b0cdecda646aca9e41406745a4a83","href":"https://static.observableusercontent.com/files/a9d5e6db2b69cb76221e47a35eea637c7328fe2ce5b5b36e7cd7644a557430af935b26744f74b97092cc8969991ddd65ce2b0cdecda646aca9e41406745a4a83","name":"CleanShot 2022-05-11 at 04.27.32-2x.png","type":"image/png","lastModified":1652271702000.326,"size":143901},{"id":"8e5d0b96a619f96eac2467353c6d10968e94ce6815aeb8402c17d520029fd98fde1d412c00252952541b9760567ed2afa47af1fd4ab884f0649bb98a2024c807","href":"https://static.observableusercontent.com/files/8e5d0b96a619f96eac2467353c6d10968e94ce6815aeb8402c17d520029fd98fde1d412c00252952541b9760567ed2afa47af1fd4ab884f0649bb98a2024c807","name":"CleanShot 2022-05-11 at 04.23.52-2x.png","type":"image/png","lastModified":1652271702000.326,"size":600115},{"id":"45192fe1379a0088a5e4e3fc3f944d64d6becc29d68bb4029d45eb281dabe7dbeec9dd16094ae7891ac7e3b794579fa4c0dbd2d8b606b93066d735c80b34a050","href":"https://static.observableusercontent.com/files/45192fe1379a0088a5e4e3fc3f944d64d6becc29d68bb4029d45eb281dabe7dbeec9dd16094ae7891ac7e3b794579fa4c0dbd2d8b606b93066d735c80b34a050","name":"CleanShot 2022-05-11 at 04.21.26-2x.png","type":"image/png","lastModified":1652271702000.326,"size":112470},{"id":"66ca502120f12d662419f581cfba582dd561d3d5cc39709f5b93af2287d6f9231739751011267513abb40bebe88211ed7c3d7cc9e76daa5f80093e9f3a0c04c1","href":"https://static.observableusercontent.com/files/66ca502120f12d662419f581cfba582dd561d3d5cc39709f5b93af2287d6f9231739751011267513abb40bebe88211ed7c3d7cc9e76daa5f80093e9f3a0c04c1","name":"CleanShot 2022-05-11 at 04@1.18.34-2x.png","type":"image/png","lastModified":1652271702000.326,"size":642750},{"id":"f45159f6b94899d997992065df74f7ed0f35a8abfea459f872bf4085cf2bc23c0ae8c010716eb12102901f80c37e588508a24c987da78d00b0fa2814747d8ffd","href":"https://static.observableusercontent.com/files/f45159f6b94899d997992065df74f7ed0f35a8abfea459f872bf4085cf2bc23c0ae8c010716eb12102901f80c37e588508a24c987da78d00b0fa2814747d8ffd","name":"CleanShot 2022-05-11 at 04.16.24-2x.png","type":"image/png","lastModified":1652271702000.326,"size":112539},{"id":"5422354cd7c99ec8535e5e40149761444e7a44c8582e3c93e214a99a130b5e8882d20acfa2794326f652a9ad04b59bbf33663b4dcc3825963db62e1911755a95","href":"https://static.observableusercontent.com/files/5422354cd7c99ec8535e5e40149761444e7a44c8582e3c93e214a99a130b5e8882d20acfa2794326f652a9ad04b59bbf33663b4dcc3825963db62e1911755a95","name":"CleanShot 2022-05-11 at 04.14.13-2x.png","type":"image/png","lastModified":1652271702000.326,"size":71088},{"id":"4e7dd9dbf29edbf9f3c9d11f2b24510fa4934af94214de4fc87a60519b4b6fdb2c5b6953d3b9e2b4284ac4431bcbfcc783de3fcc54bdd964b3bd663a0205a86e","href":"https://static.observableusercontent.com/files/4e7dd9dbf29edbf9f3c9d11f2b24510fa4934af94214de4fc87a60519b4b6fdb2c5b6953d3b9e2b4284ac4431bcbfcc783de3fcc54bdd964b3bd663a0205a86e","name":"CleanShot 2022-05-11 at 04.08.15-2x.png","type":"image/png","lastModified":1652271702000.326,"size":5395},{"id":"5f723b51a9cab769918991e5ff7268656a442ec65ecba6b64a797e9135bb47150e4d237106d3ecc1fe5dc40282d2c0639e13911973f334cc51a468f14d0e31a6","href":"https://static.observableusercontent.com/files/5f723b51a9cab769918991e5ff7268656a442ec65ecba6b64a797e9135bb47150e4d237106d3ecc1fe5dc40282d2c0639e13911973f334cc51a468f14d0e31a6","name":"CleanShot 2022-05-11 at 04.05.36-2x.png","type":"image/png","lastModified":1652271702000.326,"size":588173},{"id":"45cf29cdf5a5aa9c280a59caa3cc18e5a8c6ec21fb3fee5d5d029e2817d0aa80704cb575d617e8f7c2c3df353bad0aed801ef9161bdf4df21ecb2bcde653b8e4","href":"https://static.observableusercontent.com/files/45cf29cdf5a5aa9c280a59caa3cc18e5a8c6ec21fb3fee5d5d029e2817d0aa80704cb575d617e8f7c2c3df353bad0aed801ef9161bdf4df21ecb2bcde653b8e4","name":"CleanShot 2022-05-11 at 03.25.18-2x.png","type":"image/png","lastModified":1652271702000.326,"size":21355},{"id":"7722bda40fcfa269c867f15176d4a956d30175eee64b2a8c7d982b7ce03c9739c00ef998c8af1b56336e775574d1ab11dd58ae62cc56869d170ce753e2fd9d83","href":"https://static.observableusercontent.com/files/7722bda40fcfa269c867f15176d4a956d30175eee64b2a8c7d982b7ce03c9739c00ef998c8af1b56336e775574d1ab11dd58ae62cc56869d170ce753e2fd9d83","name":"CleanShot 2022-05-11 at 04.05.06-2x.png","type":"image/png","lastModified":1652271702000.326,"size":88588},{"id":"65109a2693ed6978f28471ffafb8f1c84f21a715bf2f9c8d3eebb259c915723f816861c15eb390ccb841262144f33d40331bdafa43ae4d54a8334695b5cbcf7c","href":"https://static.observableusercontent.com/files/65109a2693ed6978f28471ffafb8f1c84f21a715bf2f9c8d3eebb259c915723f816861c15eb390ccb841262144f33d40331bdafa43ae4d54a8334695b5cbcf7c","name":"CleanShot 2022-05-11 at 04.02.02-2x.png","type":"image/png","lastModified":1652271702000.326,"size":88345},{"id":"ca8aab589a6be1770da93f7143650e40e1fbf7fadb6f4c3a7a742501efb19a7d94a305bddd8385e3fba4cf1f57fb85397a0c775b29b837acfbf12b1646445236","href":"https://static.observableusercontent.com/files/ca8aab589a6be1770da93f7143650e40e1fbf7fadb6f4c3a7a742501efb19a7d94a305bddd8385e3fba4cf1f57fb85397a0c775b29b837acfbf12b1646445236","name":"CleanShot 2022-05-11 at 03@1.59.30-2x.png","type":"image/png","lastModified":1652271702000.326,"size":84095},{"id":"ca8aab589a6be1770da93f7143650e40e1fbf7fadb6f4c3a7a742501efb19a7d94a305bddd8385e3fba4cf1f57fb85397a0c775b29b837acfbf12b1646445236","href":"https://static.observableusercontent.com/files/ca8aab589a6be1770da93f7143650e40e1fbf7fadb6f4c3a7a742501efb19a7d94a305bddd8385e3fba4cf1f57fb85397a0c775b29b837acfbf12b1646445236","name":"CleanShot 2022-05-11 at 03.59.30-2x.png","type":"image/png","lastModified":1652271702000.326,"size":84095},{"id":"c1a1036d85f9ebfcb93c54e76df61c50ec4ddabb1563d569affb1e134ac74fc6950ad9c5439ab849a648c314a7cc573dfe8963e8b3f1ba90bda482d05c99f078","href":"https://static.observableusercontent.com/files/c1a1036d85f9ebfcb93c54e76df61c50ec4ddabb1563d569affb1e134ac74fc6950ad9c5439ab849a648c314a7cc573dfe8963e8b3f1ba90bda482d05c99f078","name":"CleanShot 2022-05-11 at 03.18.41-2x.png","type":"image/png","lastModified":1652271702000.326,"size":48564},{"id":"b72437add9b97ce36d0f854fa43897ceb5f3e42361e0f6f85db2f624554ff2e8a16492dd1be663ee5658f19f36d76060f7f1471e3ff5c4417e8575b3b663a283","href":"https://static.observableusercontent.com/files/b72437add9b97ce36d0f854fa43897ceb5f3e42361e0f6f85db2f624554ff2e8a16492dd1be663ee5658f19f36d76060f7f1471e3ff5c4417e8575b3b663a283","name":"CleanShot 2022-05-11 at 03.15.38-2x.png","type":"image/png","lastModified":1652271702000.326,"size":328427},{"id":"b3eeb3dae962248be47871e479c440f705d677fc459fff00be08855c3e19104af41d6f16a2606e1eff81db85b9424510bfc922285942d587db5d043c6c3ac02a","href":"https://static.observableusercontent.com/files/b3eeb3dae962248be47871e479c440f705d677fc459fff00be08855c3e19104af41d6f16a2606e1eff81db85b9424510bfc922285942d587db5d043c6c3ac02a","name":"CleanShot 2022-05-11 at 03.54.37-2x.png","type":"image/png","lastModified":1652271702000.326,"size":23218},{"id":"5476e244cbd8ee0224a3127d04556c3972c360031787d765471098be17290b57d4a2d3083ac8a8709b1093346e2f1bbd74f4285977d0f3ca9798902458ddce97","href":"https://static.observableusercontent.com/files/5476e244cbd8ee0224a3127d04556c3972c360031787d765471098be17290b57d4a2d3083ac8a8709b1093346e2f1bbd74f4285977d0f3ca9798902458ddce97","name":"CleanShot 2022-05-11 at 03.52.52-2x.png","type":"image/png","lastModified":1652271702000.326,"size":118442},{"id":"07b86b452382574415345b6377f7a8a28412f0e3980d1e216c4c8753e5c2818c9b68973cfafaeb477845c287dd44c472356a4f087c7d14c1a4329924712fe3bc","href":"https://static.observableusercontent.com/files/07b86b452382574415345b6377f7a8a28412f0e3980d1e216c4c8753e5c2818c9b68973cfafaeb477845c287dd44c472356a4f087c7d14c1a4329924712fe3bc","name":"CleanShot 2022-05-11 at 03.51.02-2x.png","type":"image/png","lastModified":1652271702000.326,"size":450069},{"id":"e4fbf7bbf2b42545e4e9ec2abec04c3f9e2578071ead829283f8be3c2a1b0e7ee85c2fc5572441d654165a887eb7d7ef738af6d35ddf86b4ebcba5bd5218b94f","href":"https://static.observableusercontent.com/files/e4fbf7bbf2b42545e4e9ec2abec04c3f9e2578071ead829283f8be3c2a1b0e7ee85c2fc5572441d654165a887eb7d7ef738af6d35ddf86b4ebcba5bd5218b94f","name":"CleanShot 2022-05-11 at 03.49.00-2x.png","type":"image/png","lastModified":1652271702000.326,"size":333612},{"id":"64e14d7871616447a510f30adf3ec9b9c23fbfa2f16092d91c7ff046d69ea987d5ac78e9040f81e9b7bd457c8d96994de187c823e227b4644af39216ea2dfb48","href":"https://static.observableusercontent.com/files/64e14d7871616447a510f30adf3ec9b9c23fbfa2f16092d91c7ff046d69ea987d5ac78e9040f81e9b7bd457c8d96994de187c823e227b4644af39216ea2dfb48","name":"CleanShot 2022-05-11 at 03.40.34-2x.png","type":"image/png","lastModified":1652271702000.326,"size":602083},{"id":"e4eae0696bc1c686162af9b962241ca5bf315f94a3d3c7b847ed49c0cdbca593214b4a9e037e827b9ae32803f22737b971bae1cbf84e0d3df40dffa320d1f188","href":"https://static.observableusercontent.com/files/e4eae0696bc1c686162af9b962241ca5bf315f94a3d3c7b847ed49c0cdbca593214b4a9e037e827b9ae32803f22737b971bae1cbf84e0d3df40dffa320d1f188","name":"CleanShot 2022-05-11 at 03.38.20-2x.png","type":"image/png","lastModified":1652271702000.326,"size":262250},{"id":"64712f86a595645f76aa5624866b6953616179fd5788d0d5026f04f34bfac31e6ae57a04ecd67bc32ffaed2691e324cd130c23835c5452d7f2aaef28e8ae5564","href":"https://static.observableusercontent.com/files/64712f86a595645f76aa5624866b6953616179fd5788d0d5026f04f34bfac31e6ae57a04ecd67bc32ffaed2691e324cd130c23835c5452d7f2aaef28e8ae5564","name":"CleanShot 2022-05-11 at 03.37.10-2x.png","type":"image/png","lastModified":1652271702000.326,"size":76167},{"id":"998def4ee04115848368d9da605a8160e7613a7f5685e1cc860b74217b00827f3b8e2bc77d5eac0b72d13c269f2b1ce0b929ae517ebc3a7ff049f9095dd0823a","href":"https://static.observableusercontent.com/files/998def4ee04115848368d9da605a8160e7613a7f5685e1cc860b74217b00827f3b8e2bc77d5eac0b72d13c269f2b1ce0b929ae517ebc3a7ff049f9095dd0823a","name":"CleanShot 2022-05-11 at 03.31.53-2x.png","type":"image/png","lastModified":1652271702000.326,"size":495459},{"id":"4755bb10f4efde0614a45b4108b56cdc47e61f5347945ea7aef7afd85acbe9916fa3d8119d2780467660df41f003add4763b58b7073f114e59ddf4141bd1c76f","href":"https://static.observableusercontent.com/files/4755bb10f4efde0614a45b4108b56cdc47e61f5347945ea7aef7afd85acbe9916fa3d8119d2780467660df41f003add4763b58b7073f114e59ddf4141bd1c76f","name":"CleanShot 2022-05-11 at 02.42.07-2x.png","type":"image/png","lastModified":1652271702000.326,"size":605568},{"id":"6c981ea2499020ef49ab313c1472d17f0720c03144c336904853769b1828075a81cf82bf17bdce08b26dcca826e6aa4223da5aa82a2ebe2b4d51b677e8066969","href":"https://static.observableusercontent.com/files/6c981ea2499020ef49ab313c1472d17f0720c03144c336904853769b1828075a81cf82bf17bdce08b26dcca826e6aa4223da5aa82a2ebe2b4d51b677e8066969","name":"CleanShot 2022-05-11 at 03.30.05-2x.png","type":"image/png","lastModified":1652271702000.326,"size":403032},{"id":"f92d2a0955947352ae7e9a25f836cf8eb6dfd32bddffe5511430bd55ce35eeea96d81b16865d7fc9836155a22aa455a6000181f310293fb44e45c675afb9c8b1","href":"https://static.observableusercontent.com/files/f92d2a0955947352ae7e9a25f836cf8eb6dfd32bddffe5511430bd55ce35eeea96d81b16865d7fc9836155a22aa455a6000181f310293fb44e45c675afb9c8b1","name":"CleanShot 2022-05-11 at 03.29.35-2x.png","type":"image/png","lastModified":1652271702000.326,"size":59382},{"id":"5aefbcfd827d9084d8826109ee88218e1e97c1571455992fcacae3b89cd455228c0738906d06a4c26726a7c98ee0269456683cd644740f2487e3968d66b106f1","href":"https://static.observableusercontent.com/files/5aefbcfd827d9084d8826109ee88218e1e97c1571455992fcacae3b89cd455228c0738906d06a4c26726a7c98ee0269456683cd644740f2487e3968d66b106f1","name":"CleanShot 2022-05-11 at 03.27.50-2x.png","type":"image/png","lastModified":1652271702000.326,"size":9514},{"id":"b55a0f3d1ecbc13c00db3cf35b2724be479f47d68c7ecb9af76027849ee36577c4f3e7f736d89ba719675e4bcf1d33ce0b22f5f179922f9a78d09c72fd2b9fb4","href":"https://static.observableusercontent.com/files/b55a0f3d1ecbc13c00db3cf35b2724be479f47d68c7ecb9af76027849ee36577c4f3e7f736d89ba719675e4bcf1d33ce0b22f5f179922f9a78d09c72fd2b9fb4","name":"ETH-USD.csv","type":"text/csv","lastModified":1652442243980.903,"size":130197}] 2f:{"title":"Candlestick Chart","cells":[{"id":0,"value":"# Candlestick Chart","pinned":false,"hidden":false,"mode":"md"},{"id":14,"value":"toc({\n headers: 'h2, h3, h4, h5, h6',\n skip: 'Candle Stick Chart'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":172,"value":"## Dataset Import and Preparation","pinned":false,"hidden":false,"mode":"md"},{"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"},{"id":85,"value":"Import dataset:","pinned":false,"hidden":false,"mode":"md"},{"id":1778,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.27.54-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1784,"value":"data_raw = FileAttachment(\"ETH-USD.csv\").csv({ typed: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":90,"value":"View the imported dataset:","pinned":false,"hidden":false,"mode":"md"},{"id":1774,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.27.32-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"Inputs.table(data_raw)","pinned":true,"hidden":false,"mode":"ojs"},{"id":94,"value":"Make column names lowercase:","pinned":false,"hidden":false,"mode":"md"},{"id":1390,"value":"FileAttachment(\"CleanShot 2022-05-11 at 02.42.07-2x.png\").image({width: 1000})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1794,"value":"// To use copied code replace \"data\" with your own variable\ndata_renamed = aq\n .from(data_raw)\n .rename({ Date: \"date\" })\n .rename({ Open: \"open\" })\n .rename({ High: \"high\" })\n .rename({ Low: \"low\" })\n .rename({ Close: \"close\" })\n .rename({ \"Adj Close\": \"adjustedClose\" })\n .rename({ Volume: \"volume\" })\n .objects() // Uncomment to return an array of objects","pinned":true,"hidden":false,"mode":"ojs"},{"id":99,"value":"Filter data by date, so that it shows one year:","pinned":false,"hidden":false,"mode":"md"},{"id":1764,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.23.52-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1769,"value":"// ... For this, you will need to filter the dataset using the Wrangler.\n// ... the filter command should specity `d[\"date\"].getFullYear() > 2021`\n// ... (.getFullYear gets the year as a number)\n// ... Because the statement is not simple, it will need to be wrapped in aq.escape()\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1804,"value":"// To use copied code replace \"data\" with your own variable\ndata_filtered = aq\n .from(data_renamed)\n .filter(aq.escape((d) => d[\"date\"].getFullYear() === 2022))\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1405,"value":"## Make a Simple Candlestick Chart","pinned":false,"hidden":false,"mode":"md"},{"id":1409,"value":"_See [Plot: Bar](https://observablehq.com/@observablehq/plot-bar) and [Plot: Rule](https://observablehq.com/@observablehq/plot-rule) on Observable._","pinned":false,"hidden":false,"mode":"md"},{"id":1816,"value":"Plot.plot({\n marks: [Plot.barY(data_filtered, { x: \"date\", y: \"close\" }), Plot.ruleY([0])]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1755,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.21.26-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1821,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.barY(data_filtered, { x: \"date\", y1: \"open\", y2: \"close\" }),\n Plot.ruleX(data_filtered, { x: \"date\", y1: \"high\", y2: \"low\" })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":187,"value":"## Color the Candles","pinned":false,"hidden":false,"mode":"md"},{"id":124,"value":"Color data by price change:","pinned":false,"hidden":false,"mode":"md"},{"id":1748,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04@1.18.34-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1836,"value":"// To use copied code replace \"data\" with your own variable\ndata_colored = aq\n .from(data_filtered)\n .derive({ color: (d) => (d.close < d.open ? \"crimson\" : \"oliveDrab\") })\n .objects() // Uncomment to return an array of objects","pinned":true,"hidden":false,"mode":"ojs"},{"id":107,"value":"// ... if close < open, then the color should be 'crimson', otherwise 'oliveDrab'\n// ... you will need to use Wrangler's derive method for this.","pinned":true,"hidden":false,"mode":"ojs"},{"id":1741,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.16.24-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":132,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.barY(data_colored, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n fill: \"color\",\n stroke: \"color\"\n }),\n Plot.ruleX(data_colored, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":352,"value":"## Fix the Tick Labels on the X Axis","pinned":false,"hidden":false,"mode":"md"},{"id":1423,"value":"_See [Plot: Rule](https://observablehq.com/@observablehq/plot-rule) on Observable._","pinned":false,"hidden":false,"mode":"md"},{"id":1204,"value":"There are too many. Also see the warning appearing on the right upper side of the chart.","pinned":false,"hidden":false,"mode":"md"},{"id":1727,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.14.13-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1730,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.ruleX(data_colored, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n stroke: \"color\",\n strokeWidth: 8\n }),\n Plot.ruleX(data_colored, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":166,"value":"## Parameterize the Date","pinned":false,"hidden":false,"mode":"md"},{"id":1209,"value":"Filter the date using `Wrangler()`. You will need to use a variable for the target year in a comparison instead of a value (e.g., instead of `d.year === 2000`, you should use d.year === `selectedYear`).","pinned":false,"hidden":false,"mode":"md"},{"id":1215,"value":"_See:_\n- _[Escape](https://uwdata.github.io/arquero/api/#escape) in Arquero API_\n- _[getFullYear](https://www.w3schools.com/jsref/jsrefgetfullyear.asp) at W3Schools_","pinned":false,"hidden":false,"mode":"md"},{"id":1704,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.08.15-2x.png\").image({height: 21})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1692,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.05.36-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1858,"value":"range","pinned":true,"hidden":false,"mode":"ojs"},{"id":46,"value":"// To use copied code replace \"data\" with your own variable\ndata_parameterized = aq\n .from(data_renamed)\n .derive({ color: (d) => (d.close < d.open ? \"crimson\" : \"oliveDrab\") })\n .filter(aq.escape((d) => d[\"date\"].getFullYear() === range))\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1688,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.05.06-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":201,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n stroke: \"color\",\n strokeWidth: 8\n }),\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":244,"value":"## Adjust Candle Sizes Dynamically","pinned":false,"hidden":false,"mode":"md"},{"id":254,"value":"When there are many candles, the candles overlap; they shouldn't. strokeWidth` parameter should return a value that can adapt to different number of candles in a chart.","pinned":false,"hidden":false,"mode":"md"},{"id":1230,"value":"_See [Array.length](https://www.w3schools.com/jsref/jsreflengtharray.asp) in W3 schools._","pinned":false,"hidden":false,"mode":"md"},{"id":1684,"value":"FileAttachment(\"CleanShot 2022-05-11 at 04.02.02-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1855,"value":"viewof range = Inputs.range([2017, 2022], { label: \"Year\", step: 1 })","pinned":true,"hidden":false,"mode":"ojs"},{"id":259,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n stroke: \"color\",\n strokeWidth: (d) =>\n (1200 - 300) /\n data_parameterized.filter((d) => d[\"date\"].getFullYear() === range)\n .length // <-- add formula to dynamically resize\n }),\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":371,"value":"## Add Tooltips","pinned":false,"hidden":false,"mode":"md"},{"id":429,"value":"See:\n- _[Get month name from date](https://stackoverflow.com/a/18648314/3102060) on Stack Overflow_\n- _[Plot Tooltip](https://observablehq.com/@mkfreeman/plot-tooltip) on Observable_","pinned":false,"hidden":false,"mode":"md"},{"id":1677,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.59.30-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1666,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n stroke: \"color\",\n strokeWidth: (d) =>\n (1200 - 300) /\n data_parameterized.filter((d) => d[\"date\"].getFullYear() === range)\n .length,\n title: (d) => `${d.date.toLocaleString(\"default\", {\n month: \"long\"\n })} ${d.date.getDate()}\nClose: ${d.close}\nOpen: ${d.open} \nHigh: ${d.high}\nLow: ${d.low}\n`\n }),\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":402,"value":"import { Plot } from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":491,"value":"Abstract the title template:","pinned":false,"hidden":false,"mode":"md"},{"id":1681,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03@1.59.30-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1659,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n stroke: \"color\",\n strokeWidth: (d) =>\n (1200 - 300) /\n data_parameterized.filter((d) => d[\"date\"].getFullYear() === range)\n .length,\n title: (d) => `${d.date.toLocaleString(\"default\", {\n month: \"long\"\n })} ${d.date.getDate()}\nClose: ${d3.format(\".3s\")(d.close)}\nHigh: ${d3.format(\".3s\")(d.high)}\nOpen: ${d3.format(\".3s\")(d.open)}\nLow: ${d3.format(\".3s\")(d.low)}\n`\n }),\n Plot.ruleX(data_parameterized, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":462,"value":"## Add Indicators","pinned":false,"hidden":false,"mode":"md"},{"id":1244,"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"},{"id":1239,"value":"Require the `d3fc` library:","pinned":false,"hidden":false,"mode":"md"},{"id":1648,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.54.37-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1671,"value":"fc = require(\"d3fc\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":549,"value":"### Exponential Moving Average (EMA)","pinned":false,"hidden":false,"mode":"md"},{"id":1256,"value":"Create a 9-period EMA column of `close` values:","pinned":false,"hidden":false,"mode":"md"},{"id":1636,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.52.52-2x.png\").image({height:460})","pinned":false,"hidden":false,"mode":"ojs"},{"id":547,"value":"emaColumn = fc\n .indicatorExponentialMovingAverage()\n .period(emaPeriod)\n .value((d) => d.close)(data_parameterized)","pinned":true,"hidden":false,"mode":"ojs"},{"id":512,"value":"### Bollinger Band","pinned":false,"hidden":false,"mode":"md"},{"id":1262,"value":"Create a 7-period Bollinger band column of `close` values; let it have 2 standard deviations (set using the `multiplier` method):","pinned":false,"hidden":false,"mode":"md"},{"id":1623,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.51.02-2x.png\").image({width: 800})","pinned":false,"hidden":false,"mode":"ojs"},{"id":539,"value":"bollingerColumn = fc\n .indicatorBollingerBands()\n .period(7)\n .multiplier(2)\n .value((d) => d.close)(data_parameterized)","pinned":true,"hidden":false,"mode":"ojs"},{"id":563,"value":"### Moving Average Convergence Divergence (MACD)","pinned":false,"hidden":false,"mode":"md"},{"id":1266,"value":"Create a MACD column with a signal period of 9, fast period of 12, and a slow period of 26:","pinned":false,"hidden":false,"mode":"md"},{"id":1614,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.49.00-2x.png\").image({width: 625})","pinned":false,"hidden":false,"mode":"ojs"},{"id":555,"value":"macdColumn = fc\n .indicatorMacd()\n .signalPeriod(9)\n .fastPeriod(12)\n .slowPeriod(26)\n .value((d) => d.close)(data_parameterized)","pinned":true,"hidden":false,"mode":"ojs"},{"id":569,"value":"### Join the Indicator Data with the Main Dataset","pinned":false,"hidden":false,"mode":"md"},{"id":1284,"value":"_See: [JS spread syntax](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Spreadsyntax) at MDN._","pinned":false,"hidden":false,"mode":"md"},{"id":1273,"value":"Join the indicator columns you have created with the dataset:","pinned":false,"hidden":false,"mode":"md"},{"id":1583,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.40.34-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"//Please uncomment to merge the indicators with the data after they are calculated\ndata_withIndicators = data_parameterized.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"},{"id":575,"value":"### Add the Indicators to the Visualization","pinned":false,"hidden":false,"mode":"md"},{"id":1293,"value":"To add the incdicators:\n- Create the Bollinger bands, using `Plot.areaY` (for the band) and `Plot.line` (for the average line).\n- Create the EMA using a Plot.line\n- Use a separate cell to create MACD and MACD signal lines using Plot.line, and a diveregence plot using `Plot.ruleX`\n\nAlso:\n- Move the y axes to right\n- Add grid","pinned":false,"hidden":false,"mode":"md"},{"id":591,"value":"\n","pinned":true,"hidden":false,"mode":"html"},{"id":1577,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.38.20-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1927,"value":"viewof emaPeriod = Inputs.range([0, 100], { label: \"EMA\", step: 1 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":308,"value":"\n${viewof range}","pinned":false,"hidden":false,"mode":"html"},{"id":1599,"value":"Plot.plot({\n width: 1200,\n marks: [\n Plot.ruleX(data_withIndicators, {\n x: \"date\",\n y1: \"open\",\n y2: \"close\",\n stroke: \"color\",\n strokeWidth: (d) =>\n (1200 - 300) /\n data_withIndicators.filter((d) => d[\"date\"].getFullYear() === range)\n .length,\n title: (d) => `${d.date.toLocaleString(\"default\", {\n month: \"long\"\n })} ${d.date.getDate()}\nClose: ${d3.format(\".3s\")(d.close)}\nHigh: ${d3.format(\".3s\")(d.high)}\nOpen: ${d3.format(\".3s\")(d.open)}\nLow: ${d3.format(\".3s\")(d.low)}\n`\n }),\n\n Plot.ruleX(data_withIndicators, {\n x: \"date\",\n y1: \"high\",\n y2: \"low\",\n stroke: \"color\"\n }),\n Plot.lineY(data_withIndicators, {\n x: \"date\",\n y: \"ema\",\n stroke: \"goldenrod\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1603,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1180,"value":"## Add External Indicators","pinned":false,"hidden":false,"mode":"md"},{"id":930,"value":"### Add Fear & Greed Index","pinned":false,"hidden":false,"mode":"md"},{"id":1307,"value":"_See: [Fear and Greed Index](https://alternative.me/crypto/fear-and-greed-index/) on Alternative.me._","pinned":false,"hidden":false,"mode":"md"},{"id":1312,"value":"Show the current index:","pinned":false,"hidden":false,"mode":"md"},{"id":1569,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.37.10-2x.png\").image({width: 250})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1591,"value":"// ... this should be an HTML cell. You can find the embed code at the Alternative.me's Fear and Greed index website","pinned":true,"hidden":false,"mode":"ojs"},{"id":1316,"value":"Get historical data using the API call: \"https://api.alternative.me/fng/?limit=0&format=json\":","pinned":false,"hidden":false,"mode":"md"},{"id":1527,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.31.53-2x.png\").image({width: 950})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1534,"value":"// ... d3.json can be used for this","pinned":true,"hidden":false,"mode":"ojs"},{"id":1321,"value":"Convert timestamp strings to date objects and make `values` numeric:","pinned":false,"hidden":false,"mode":"md"},{"id":1519,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.30.05-2x.png\").image({width: 680})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1536,"value":"// ... You can use Wrangler to generate the code","pinned":true,"hidden":false,"mode":"ojs"},{"id":1509,"value":"Plot the data:","pinned":false,"hidden":false,"mode":"md"},{"id":1514,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.29.35-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1538,"value":"// ... Plot.line is for the main line, Plot.ruleY is for the dotted one","pinned":true,"hidden":false,"mode":"ojs"},{"id":1102,"value":"### Add Current Price Line","pinned":false,"hidden":false,"mode":"md"},{"id":1332,"value":"You can get the current price information from Binance API using the query, \"https://www.binance.com/api/v3/ticker/price?symbol=ETHUSDT\".","pinned":false,"hidden":false,"mode":"md"},{"id":1344,"value":"Get the latest Ethereum price data:","pinned":false,"hidden":false,"mode":"md"},{"id":1485,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.25.18-2x.png\").image({height: 15})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1540,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1497,"value":"Extract the price and turn it into a number:","pinned":false,"hidden":false,"mode":"md"},{"id":1503,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.27.50-2x.png\").image({height: 15})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1542,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":723,"value":"## Parameterize the Indicators","pinned":false,"hidden":false,"mode":"md"},{"id":1350,"value":"You have used static values for the parameters (e.g., `period(9)` for EMA). Instead, you can use variables (e.g., period(myEmaPeriod)). If you bind the variables to sliders, you can also control these parameters interactively, by changing slider values.","pinned":false,"hidden":false,"mode":"md"},{"id":1437,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.18.41-2x.png\").image({width: 440})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1544,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1552,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1553,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1555,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1557,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1559,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1465,"value":"\n\n\n

\n \n
\n {viewof control_bollingerPeriod} {viewof control_bollingerSD}\n
\n {viewof control_emaPeriod}\n
\n {viewof control_macdSignalPeriod}, {viewof control_macdFastPeriod}, {viewof control_macdSlowPeriod}\n
\n {viewof control_year}\n \n

","pinned":true,"hidden":false,"mode":"md"},{"id":1356,"value":"Make sliders appear side by side:","pinned":false,"hidden":false,"mode":"md"},{"id":1429,"value":"FileAttachment(\"CleanShot 2022-05-11 at 03.15.38-2x.png\").image({width: 1100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1546,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1548,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":1549,"value":"// ...","pinned":true,"hidden":false,"mode":"ojs"},{"id":19,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":21,"value":"**Notebook Style**","pinned":false,"hidden":false,"mode":"md"},{"id":16,"value":"import {toc} from \"@nebrius/indented-toc\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":781,"value":"import {Wrangler, op} from \"@observablehq/data-wrangler\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1377,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":1381,"value":"Notebook style:","pinned":false,"hidden":false,"mode":"md"},{"id":1385,"value":"import {imageToDo} from \"@clokman/student-blocks\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1386,"value":"imageToDo","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}