2d:null 2e:["$","title",null,{"children":"IMC Prosperity 2 visualizer | Max Bo | Observable"}] 33:T45f,tidyPrices = prices.flatMap( ({ timestamp, product, bid_price_1, bid_volume_1, bid_price_2, bid_volume_2, bid_price_3, bid_volume_3, ask_price_1, ask_volume_1, ask_price_2, ask_volume_2, ask_price_3, ask_volume_3, mid_price }) => [ { type: "bid_3", timestamp, product, price: bid_price_3, volume: bid_volume_3, mid_price }, { type: "bid_2", timestamp, product, price: bid_price_2, volume: bid_volume_2, mid_price }, { type: "bid_1", timestamp, product, price: bid_price_1, volume: bid_volume_1, mid_price }, { type: "ask_1", timestamp, product, price: ask_price_1, volume: -ask_volume_1, mid_price }, { type: "ask_2", timestamp, product, price: ask_price_2, volume: -ask_volume_2, mid_price }, { type: "ask_3", timestamp, product, price: ask_price_3, volume: -ask_volume_3, mid_price } ] )34:Taab,plotPricesAndVolume = (product) => { const scopedPrices = prices.filter( (d) => d.product == product && isWithinTimestampRange(d) ); const scopedTrades = trades.filter( (d) => d.symbol == product && isWithinTimestampRange(d) ); const scopedTidyPrices = tidyPrices.filter( (d) => d.product == product && isWithinTimestampRange(d) ); return Plot.plot({ title: `${product} price and order depth`, width, height: 300, caption: "Hover for tooltip. Trades fill color indicates buyer, stroke color indicates seller.", y: { label: "price" }, color: { label: "volume", legend: true, scheme: "BuRd" }, symbol: { domain: ["volume", "SUBMISSION buy", "SUBMISSION sell", "Other trades"], legend: true }, marks: [ Plot.lineY(scopedPrices, { x: "timestamp", y: "bid_price_1", z: null, tip: true, stroke: "bid_volume_1" }), Plot.lineY(scopedPrices, { x: "timestamp", y: "ask_price_1", z: null, tip: true, stroke: (d) => -d.ask_volume_1 }), Plot.dot(scopedTidyPrices, { x: "timestamp", y: "price", fill: "volume", symbol: (d) => "volume" }), obviousTrades ? Plot.ruleX(scopedTrades, { x: "timestamp", stroke: (d) => traderColorScale.apply(d.seller), filter: (d) => d.buyer === "SUBMISSION" || d.seller === "SUBMISSION", tip: true, channels: { buyer: "buyer", seller: "seller", quantity: "quantity" } }) : undefined, showTrades != "None" ? Plot.dot(scopedTrades, { x: "timestamp", y: "price", stroke: (d) => traderColorScale.apply(d.seller), fill: (d) => traderColorScale.apply(d.buyer), symbol: (d) => d.buyer === "SUBMISSION" ? "SUBMISSION buy" : d.seller === "SUBMISSION" ? "SUBMISSION sell" : "Other trades", filter: (d) => showTrades === "Just SUBMISSION" ? d.buyer === "SUBMISSION" || d.seller === "SUBMISSION" : true, tip: true, channels: { buyer: "buyer", seller: "seller", quantity: "quantity" } }) : undefined, Plot.lineY( scopedPrices, Plot.windowY({ x: "timestamp", y: "mid_price", k: kMovingAverage, reduce: "mean" }) ) ] }); }35:T772,plotRootedMidVolume = (product, { scale } = { scale: true }) => { const scopedPrices = tidyPrices.filter( (d) => d.product == product && isWithinTimestampRange(d) ); const scopedTrades = tidyTraderTrades.filter( (d) => d.symbol === product && isWithinTimestampRange(d) ); return Plot.plot({ title: `${product} volume around mid price`, width: scale ? width : undefined, symbol: { domain: ["volume", "SUBMISSION buy", "SUBMISSION sell", "Other trades"], legend: true }, fx: { domain: ["ask_3", "ask_2", "ask_1", "bid_1", "bid_2", "bid_3", "trades"] }, y: { label: "price - mid_price" }, color: { label: "volume", legend: true, scheme: "BuRd" }, marks: [ Plot.ruleY([0]), Plot.dot( scopedPrices.filter((d) => d.price - d.mid_price > -100), { x: "timestamp", y: (d) => d.price - d.mid_price, tip: true, fill: "volume", fx: "type" } ), showTrades != "None" ? Plot.dot(scopedTrades, { x: "timestamp", y: (d) => d.price - d.mid_price, stroke: (d) => traderColorScale.apply(d.seller), fill: (d) => traderColorScale.apply(d.buyer), symbol: (d) => d.buyer === "SUBMISSION" ? "SUBMISSION buy" : d.seller === "SUBMISSION" ? "SUBMISSION sell" : "Other trades", filter: (d) => showTrades === "Just SUBMISSION" ? d.buyer === "SUBMISSION" || d.seller === "SUBMISSION" : true, tip: true, fx: (d) => "trades", channels: { buyer: "buyer", seller: "seller", quantity: "quantity" } }) : undefined ] }); }36:[{"id":"17d90497a6155cecb4a645a84e91c5643ad419e35634db5882fd71c22ba46e2798342a904c064669335b540226984863d430f7abc0fda7145f623c2772122d03","href":"https://static.observableusercontent.com/files/17d90497a6155cecb4a645a84e91c5643ad419e35634db5882fd71c22ba46e2798342a904c064669335b540226984863d430f7abc0fda7145f623c2772122d03","name":"0e80413d-45f6-4e33-b551-61eb8af55335.csv","type":"text/csv","lastModified":1712443115318.798,"size":264552},{"id":"bbfc728461d4e9688e555591a472857fc0d4d990ff0fe36bda1b4feceb626f64f2a29abf5f71f268b9716a96f8ddd05284b476cd0cc532e8258d60860be01b6f","href":"https://static.observableusercontent.com/files/bbfc728461d4e9688e555591a472857fc0d4d990ff0fe36bda1b4feceb626f64f2a29abf5f71f268b9716a96f8ddd05284b476cd0cc532e8258d60860be01b6f","name":"trades_round_1_day_-1_nn.csv","type":"text/csv","lastModified":1712618683064.588,"size":204939},{"id":"f2a1321b471e9a5bba978d01d94c6645ebb22e6a5122d5a52b47aa73e3fbed0ee3909aa31ca4b38d2c31e0ba22a565ec76fceb1d7f13cce01cdee82b51884c23","href":"https://static.observableusercontent.com/files/f2a1321b471e9a5bba978d01d94c6645ebb22e6a5122d5a52b47aa73e3fbed0ee3909aa31ca4b38d2c31e0ba22a565ec76fceb1d7f13cce01cdee82b51884c23","name":"trades_round_1_day_0_nn.csv","type":"text/csv","lastModified":1712618683269.389,"size":202884},{"id":"1457002f50a3ed14f57c23469df9ba622ac4e7c053fa609dcc66d2ed6a913f4ea19169b46e2b632ddee8a6924a57689d4a8a9e19f5a1f48086efa6e4707e3714","href":"https://static.observableusercontent.com/files/1457002f50a3ed14f57c23469df9ba622ac4e7c053fa609dcc66d2ed6a913f4ea19169b46e2b632ddee8a6924a57689d4a8a9e19f5a1f48086efa6e4707e3714","name":"trades_round_1_day_-2_nn.csv","type":"text/csv","lastModified":1712618683767.28,"size":208522},{"id":"50dfb0cd791019cfa585debc4ac5c86689d0313dec71e5e0ca497d87aedf55711c1e65820b199e73ce53fc87dd1ac7027bedefc66fab76acb115ac782f42cd74","href":"https://static.observableusercontent.com/files/50dfb0cd791019cfa585debc4ac5c86689d0313dec71e5e0ca497d87aedf55711c1e65820b199e73ce53fc87dd1ac7027bedefc66fab76acb115ac782f42cd74","name":"prices_round_1_day_-1.csv","type":"text/csv","lastModified":1712618684762.494,"size":1257340},{"id":"5b1bd702017ed06469c6110aecd9cafeb2b3def80c7a666bf2b8b480d6f9863936d32bb0bfa8b246ebd5f8bcc24942b10e2232c6f41342fd45fb27f37cc89d38","href":"https://static.observableusercontent.com/files/5b1bd702017ed06469c6110aecd9cafeb2b3def80c7a666bf2b8b480d6f9863936d32bb0bfa8b246ebd5f8bcc24942b10e2232c6f41342fd45fb27f37cc89d38","name":"prices_round_1_day_-2.csv","type":"text/csv","lastModified":1712618684730.483,"size":1258643},{"id":"57c0856312a599bf580da4c1c91a6461ece12372fef1b787c93909abe1ff6036fed6a6689f9df2aa1a1763d15344e2705a2b7f95ae5eb68ae16132766bbd9c24","href":"https://static.observableusercontent.com/files/57c0856312a599bf580da4c1c91a6461ece12372fef1b787c93909abe1ff6036fed6a6689f9df2aa1a1763d15344e2705a2b7f95ae5eb68ae16132766bbd9c24","name":"prices_round_1_day_0.csv","type":"text/csv","lastModified":1712618684753.517,"size":1237383},{"id":"8ba7958834f984e965ef2ad004bc0bb3b43bf8255b365d500e84c5a9dda988bcca92e112fe9392149fe329873de21e747eb58d623f0b596de28adad1f2b3300c","href":"https://static.observableusercontent.com/files/8ba7958834f984e965ef2ad004bc0bb3b43bf8255b365d500e84c5a9dda988bcca92e112fe9392149fe329873de21e747eb58d623f0b596de28adad1f2b3300c","name":"bd41b3de-908d-4f6e-b956-bbed578968ef.log","type":"text/plain","lastModified":1713317054025.645,"size":671298},{"id":"2d8e93931b558b2fbdbcd0c4e4e51b2a0628af655087cc721def2ce807f93d14ea6f9c538208ca1df1a3fa1d209f887b5ebe26893a5a53618a24c5598f421a6e","href":"https://static.observableusercontent.com/files/2d8e93931b558b2fbdbcd0c4e4e51b2a0628af655087cc721def2ce807f93d14ea6f9c538208ca1df1a3fa1d209f887b5ebe26893a5a53618a24c5598f421a6e","name":"9ae0ba53-a1cf-4954-8abe-97350d543f13.log","type":"text/plain","lastModified":1713343659056.486,"size":2532619},{"id":"a6ad02d79adb850b770bba18a71ee6528ad0dbc46c708d8c738405d1b14ac7a79342c9988e084a3e8b10864f9f8e89294b43dcb7d732549da354b52885ee072e","href":"https://static.observableusercontent.com/files/a6ad02d79adb850b770bba18a71ee6528ad0dbc46c708d8c738405d1b14ac7a79342c9988e084a3e8b10864f9f8e89294b43dcb7d732549da354b52885ee072e","name":"prices_round_1_day_0.txt","type":"text/plain","lastModified":1712287296895.263,"size":1253484},{"id":"8d5143f4b04191e7125e38879144eddc208a1c7a97d613371ba50aaef1a8aec15c54565407d4c123195fb4a096eb70c5daa11c0146614cac56a4e6154e3ad3e6","href":"https://static.observableusercontent.com/files/8d5143f4b04191e7125e38879144eddc208a1c7a97d613371ba50aaef1a8aec15c54565407d4c123195fb4a096eb70c5daa11c0146614cac56a4e6154e3ad3e6","name":"d5cd4bf4-2093-4146-bbf4-73ac47ae8f6e (2).log","type":"text/plain","lastModified":1713363122880.204,"size":2627976},{"id":"f3103f1bc4123e5f448888ce13a7a26650cb506ee6e68d625a25cbfc2c2ffa1be1aa08f9ad15c6fbddc51f72946412976e5be66bf374660e38c7dbf08b985b7c","href":"https://static.observableusercontent.com/files/f3103f1bc4123e5f448888ce13a7a26650cb506ee6e68d625a25cbfc2c2ffa1be1aa08f9ad15c6fbddc51f72946412976e5be66bf374660e38c7dbf08b985b7c","name":"image.png","type":"image/png","lastModified":1714622380484.723,"size":272975},{"id":"8a53a1d608496915e2d8222fe034ae825ee688d5e9e071be3d5daeda2e8b4da88a1ebe26cbc9b600be4acd32d33f9316644d2d999add80a1333d848cbca75596","href":"https://static.observableusercontent.com/files/8a53a1d608496915e2d8222fe034ae825ee688d5e9e071be3d5daeda2e8b4da88a1ebe26cbc9b600be4acd32d33f9316644d2d999add80a1333d848cbca75596","name":"b55cf225-bcf1-4d1b-915c-ffc0536ac22f.log","type":"text/plain","lastModified":1713407208686.882,"size":2046862},{"id":"69cee6a4e047c02199b9e530876472972519e1822b1d720ed57e6704775917a1b2df1abce9eee3a2a5ae970181f083bc325c9340e52d9367505c751a7087eddc","href":"https://static.observableusercontent.com/files/69cee6a4e047c02199b9e530876472972519e1822b1d720ed57e6704775917a1b2df1abce9eee3a2a5ae970181f083bc325c9340e52d9367505c751a7087eddc","name":"edcb5273-78d0-4ae1-b29e-4680c3c23b62.csv","type":"text/csv","lastModified":1714012622640.243,"size":591874},{"id":"cb1c51932d420539a972408246f6009abca28f95de6eeb45e9df50ca65abf247da5c68cc225d396a7c0203dec67b741110ce03e1e97f7e87e9999c8401595ea8","href":"https://static.observableusercontent.com/files/cb1c51932d420539a972408246f6009abca28f95de6eeb45e9df50ca65abf247da5c68cc225d396a7c0203dec67b741110ce03e1e97f7e87e9999c8401595ea8","name":"edcb5273-78d0-4ae1-b29e-4680c3c23b62.log","type":"text/plain","lastModified":1714012647368.223,"size":3366832},{"id":"b563dff56c877549211d189461d6541656f62b40a77e38f3ff64fcd7c96d6571791793490f41275a7a165e2bfcf2258e192c73a1d86f1e52dbbc13b76bf6d03b","href":"https://static.observableusercontent.com/files/b563dff56c877549211d189461d6541656f62b40a77e38f3ff64fcd7c96d6571791793490f41275a7a165e2bfcf2258e192c73a1d86f1e52dbbc13b76bf6d03b","name":"0ac72d26-ba7f-47e4-8699-c4bc11c2386f.log","type":"text/plain","lastModified":1714023236538.702,"size":2855484},{"id":"55755d04c4e8634b3b83c78d87196fcdb28d40e431b8cd7aae60b1f303f144f69118fa20f0e915c711ff4df64db549535d56de4a46dd7e7bb4faae129f3ad88e","href":"https://static.observableusercontent.com/files/55755d04c4e8634b3b83c78d87196fcdb28d40e431b8cd7aae60b1f303f144f69118fa20f0e915c711ff4df64db549535d56de4a46dd7e7bb4faae129f3ad88e","name":"c2300069-c869-4323-8a77-e7a1173411ad.log","type":"text/plain","lastModified":1714030556024.988,"size":5324132},{"id":"0f0d40ba9f44640cabc01f0b2ec85e05b6440a66969014d649428cd8a101c013bce263182479f74d9c9b9572a03df01c786f8f50a11d9b0511181dbda9069d06","href":"https://static.observableusercontent.com/files/0f0d40ba9f44640cabc01f0b2ec85e05b6440a66969014d649428cd8a101c013bce263182479f74d9c9b9572a03df01c786f8f50a11d9b0511181dbda9069d06","name":"6607000f-8e71-462b-b9ea-4fbb6479e32f.log","type":"text/plain","lastModified":1714034056524.142,"size":3536896},{"id":"38e5e4ac83316ea21b08097a482c1d56a55bd17958076e0c25038899aace33db4b01201e3cba6c96dacf3fd8b8ed708e3c66db5a60f8e27e8ee11dcc719f7f70","href":"https://static.observableusercontent.com/files/38e5e4ac83316ea21b08097a482c1d56a55bd17958076e0c25038899aace33db4b01201e3cba6c96dacf3fd8b8ed708e3c66db5a60f8e27e8ee11dcc719f7f70","name":"28eb68e2-818d-46e4-9a45-44f936224284.log","type":"text/plain","lastModified":1714034816823.231,"size":3310361}] 31:{"id":"374da9e4a64471a9","slug":"imc-prosperity-2-visualizer","title":"IMC Prosperity 2 visualizer","thumbnail":"4afa3d032233e4a18b30f7f5c36119c972dba342c4e85c7efb1f971f8f7e61fb","access_level":"public","create_time":"$D2024-04-04T11:43:47.907Z","update_time":"$D2024-05-30T07:27:30.579Z","view_time":null,"first_public_time":"$D2024-05-01T13:45:30.918Z","fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"cc48459e4293f942","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":"starter_2024"},"version":2452,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5bb83a6e9493ea1d","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":null}],"members":[{"type":"individual","id":"5bb83a6e9493ea1d","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":null,"role":"editor"},{"type":"team","id":"cc48459e4293f942","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":10,"collection":null,"type":"notebook","body":{"title":"IMC Prosperity 2 visualizer","cells":[{"id":0,"value":"# IMC Prosperity 2 visualizer","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2268,"value":"This is a visualizer for the [IMC Prosperity 2](https://prosperity.imc.com/) competition's sandbox logs.\n\nThis notebook evolved out of mess of hacked together visualizations I ended up developing for my team over the course of the competition. Once the competition concluded, I thought I'd go through, clean everything up, and release them in case next year's cohort find them useful.\n\nShoutout to [Jasper van Merle](https://github.com/jmerle) for paving the way with his own [IMC Prosperity 2 Visualizer](https://jmerle.github.io/imc-prosperity-2-visualizer/).\n\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1867,"value":"viewof chosenLogFile = Inputs.file({\n label: \"Upload sandbox .log file\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1999,"value":"chosenLogFile\n ? `File chosen, using ${chosenLogFile.name}`\n : `No file chosen, using demo data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2336,"value":"viewof showTrades = Inputs.radio([\"All\", \"Just SUBMISSION\", \"None\"], {\n label: \"Show trades\",\n value: \"Just SUBMISSION\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2426,"value":"viewof obviousTrades = Inputs.toggle({\n label: \"Make SUBMISSION trades very obvious\",\n value: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"viewof kMovingAverage = Inputs.range([1, 1000], {\n label: \"Moving average window (k)\",\n step: 10\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"viewof unsettledTimestampRange = interval(\n [0, d3.max(prices, (d) => d.timestamp)],\n {\n label: \"Timestamp range (debounced)\",\n step: 1\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2360,"value":"⬆️ I would seriously recommend using this option to zoom in on the plots.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1890,"value":"

${globalPnl}

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2098,"value":"## Round 1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1004,"value":"plotGrid(\"STARFRUIT\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":984,"value":"plotGrid(\"AMETHYSTS\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2100,"value":"## Round 2","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1000,"value":"plotGrid(\"ORCHIDS\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"plotGrid(\"CHOCOLATE\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2102,"value":"## Round 3","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":998,"value":"plotGrid(\"GIFT_BASKET\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1006,"value":"plotGrid(\"STRAWBERRIES\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"plotGrid(\"ROSES\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2105,"value":"## Round 4","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":996,"value":"plotGrid(\"COCONUT\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":994,"value":"plotGrid(\"COCONUT_COUPON\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1040,"value":"{\n const scopedTrades = tidyTraderTrades.filter((d) =>\n isWithinTimestampRange(d)\n );\n const plot = Plot.plot({\n title: \"Trader position per product\",\n color: {\n domain: [...traders],\n legend: true\n },\n width,\n marginRight: 100,\n marks: [\n Plot.frame(),\n Plot.ruleY([0]),\n Plot.lineY(\n scopedTrades,\n Plot.mapY(\"cumsum\", {\n stroke: \"trader\",\n fy: \"symbol\",\n fx: \"trader\",\n x: \"timestamp\",\n y: \"position\",\n // stroke: \"green\",\n tip: true,\n // fill: \"quantity\",\n symbol: (d) => \"trades\"\n })\n )\n ]\n });\n\n return htl.html`

${plot}

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":404,"value":"## Implementation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1907,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1914,"value":"If the user hasn't uploaded a file, we'll use a sample file as a fallback just so users have something pretty to look at.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1106,"value":"sampleLogFileText = FileAttachment(\"28eb68e2-818d-46e4-9a45-44f936224284.log\").text()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1912,"value":"logFileText = chosenLogFile?.text() || sampleLogFileText","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"### Data cleaning","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":693,"value":"chunks = {\n const chunks = logFileText.split(\"\\n\\n\\n\\n\");\n const sandbox = chunks[0].split(\"Sandbox logs:\\n\")[1];\n const activities = chunks[1].split(\"Activities log:\\n\")[1];\n const trades = JSON.parse(chunks[2].split(\"\\nTrade History:\\n\")[1]);\n\n return {\n sandbox,\n activities,\n trades\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":867,"value":"logger = JSON.parse(`[${chunks.sandbox.replaceAll(\"}\\n{\", \"},{\")}]`).map(\n (d) => ({\n ...d\n \n })\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"Prices are stored with `;` separators instead of `,`s (?), so we replace the `;` with `,`s and then pass that modified file to the **COMMA** separated value parser.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":119,"value":"prices = d3.csvParse(chunks.activities.replace(/;/g, \",\"), d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":636,"value":"trades = chunks.trades","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2438,"value":"tradesAndPrices = trades.map((trade) => {\n const price = prices.find(\n (price) =>\n trade.timestamp === price.timestamp && trade.symbol === price.product\n );\n\n return {\n ...trade,\n ...price\n };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"Now let's create some [\"tidy data\"](https://tidyr.tidyverse.org/) - a single row per observation. This will make it easy to visualize in some situations.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":192,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":955,"value":"tidyTraderTrades = tradesAndPrices.flatMap((d) => [\n {\n ...d,\n trader: d.buyer,\n position: d.quantity,\n delta: -(d.quantity * d.price)\n },\n {\n ...d,\n trader: d.seller,\n position: -d.quantity,\n delta: d.quantity * d.price\n }\n])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":978,"value":"traders = new Set([\"SUBMISSION\", ...tidyTraderTrades.map((d) => d.trader)])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"### Timestep filtering","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":305,"value":"import { interval } from \"@mootari/range-slider\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"import { settle } from \"@mjbo/settling-input\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":676,"value":"We need to \"settle\" the input because immediately filtering with the new input tanks the browser. This will delay plot recomputation by 1 second.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":673,"value":"timestampRange = settle(viewof unsettledTimestampRange)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2306,"value":"isWithinTimestampRange = (d) =>\n timestampRange[0] <= d.timestamp && d.timestamp <= timestampRange[1]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":512,"value":"### Plots","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":217,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":902,"value":"listTrades = (product) => {\n const scopedTrades = trades.filter(\n (d) => d.symbol == product && isWithinTimestampRange(d)\n );\n\n return Inputs.table(scopedTrades, {\n columns: [\"timestamp\", \"buyer\", \"seller\", \"price\", \"quantity\"],\n height: 200\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"plotGlobalPnl = () => {\n const scopedPrices = prices.filter((d) => isWithinTimestampRange(d));\n return Plot.plot({\n title: \"Product profit and loss\",\n color: {\n legend: true\n },\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(scopedPrices, {\n x: \"timestamp\",\n y: \"profit_and_loss\",\n stroke: \"product\",\n curve: \"step-after\",\n tip: true\n })\n ]\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1875,"value":"globalPnl = plotGlobalPnl()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1737,"value":"plotPnl = (product, { scale } = { scale: true }) => {\n const scopedPrices = prices.filter(\n (d) => d.product == product && isWithinTimestampRange(d)\n );\n return Plot.plot({\n title: `${product} profit and loss`,\n color: globalPnl.scale(\"color\"),\n width: scale ? width : undefined,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(scopedPrices, {\n x: \"timestamp\",\n y: \"profit_and_loss\",\n stroke: \"product\",\n curve: \"step-after\",\n tip: true,\n })\n ]\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":534,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2165,"value":"traderColorScale = Plot.scale({\n color: { domain: traders }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":935,"value":"plotPositionCumSum = (symbol, { scale } = { scale: true }) => {\n const scopedTrades = tidyTraderTrades.filter((d) =>\n isWithinTimestampRange(d)\n );\n return Plot.plot({\n title: `${symbol} position per trader`,\n width: scale ? width : undefined,\n color: {\n ...traderColorScale,\n legend: true\n },\n fx: {\n domain: [...traders]\n },\n marks: [\n Plot.frame(),\n Plot.ruleY([0]),\n Plot.lineY(\n scopedTrades.filter((d) => d.symbol === symbol),\n Plot.mapY(\"cumsum\", {\n stroke: \"trader\",\n x: \"timestamp\",\n y: \"position\",\n // stroke: \"green\",\n curve: \"step-after\",\n tip: true\n // fill: \"quantity\",\n })\n )\n ]\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2222,"value":"plotTrades = (product) => {\n const scopedTrades = tidyTraderTrades.filter(\n (d) => d.symbol === product && isWithinTimestampRange(d)\n );\n return Plot.plot({\n title: `${product} inter-trader trade matrix`,\n color: {\n scheme: \"Plasma\"\n },\n marginLeft: 100,\n marks: [\n Plot.frame(),\n Plot.cell(\n scopedTrades,\n Plot.group(\n { fill: \"sum\" },\n {\n y: \"buyer\",\n x: \"seller\",\n fill: \"quantity\",\n tip: true\n }\n )\n ),\n Plot.text(\n scopedTrades,\n Plot.group(\n { text: \"sum\" },\n {\n y: \"buyer\",\n x: \"seller\",\n text: \"quantity\",\n fill: \"black\"\n }\n )\n )\n ]\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2412,"value":"### Presentation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2377,"value":"We need to import some of the [CSS classes from Observable Framework](https://observablehq.com/framework/) (because they look cool). They give us access to the `grid` and `card` classes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1130,"value":"import { observableFrameworkThemeAirStyle } from \"@mjbo/observable-framework-theme-air-css-style\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1158,"value":"observableFrameworkThemeAirStyle // need to evaluate to apply the CSS rules","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1154,"value":"function plotGrid(product) {\n const prices = plotPricesAndVolume(product);\n const position = plotPositionCumSum(product, { scale: false });\n const rooted = plotRootedMidVolume(product, { scale: false });\n const pnl = plotPnl(product, { scale: false });\n const tradesList = listTrades(product);\n const tradesPlot = plotTrades(product);\n\n return htl.html`\n

${prices}

${rooted}

${position}

${tradesPlot}${tradesList}

${pnl}

`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 32:"$31:body"