2c:null 2d:["$","title",null,{"children":"Kite Basket Order | Vashistha Iyer | Observable"}] 32:T667,async function validate(upload) { const csv = await Files.text(upload); const parsed = d3.csvParse(csv.toUpperCase(), d3.autoType); const cols = parsed.columns; if (cols.length !== 3) { throw new Error("Invalid number of columns. There should be exactly 3."); } if (cols[0] !== "SYMBOL" || cols[1] !== "QUANTITY" || cols[2] !== "PRICE") { throw new Error( "Invalid columns, they should be Symbol, Quantity and Price." ); } const validSymbols = nseSymbols.map(row => row.SYMBOL); const symbols = parsed.map(row => row.SYMBOL); const quantities = parsed.map(row => row.QUANTITY); const prices = parsed.map(row => row.PRICE); if ( !symbols.every(val => typeof val === "string" && validSymbols.includes(val)) ) { throw new Error( "Error! Please make sure all symbols are valid NSE symbols." ); } if (new Set(symbols).size !== symbols.length) { throw new Error( "Error! Each symbol can have only one row. Please remove duplicates." ); } if ( !quantities.every( val => typeof val === "number" && Number.isInteger(val) && val !== 0 ) ) { throw new Error( "Error! All quantities must be valid integers (positive or negative)." ); } if (!prices.every(val => typeof val === "number" || val === null)) { throw new Error("Error! Prices must be numbers or left empty."); } return parsed.map(({ SYMBOL, QUANTITY, PRICE }) => ({ SYMBOL, NAME: nseSymbols.find(el => el.SYMBOL === SYMBOL).NAME, TRANSACTION: QUANTITY > 0 ? "BUY" : "SELL", ORDER: PRICE ? "LIMIT" : "MARKET", QUANTITY, PRICE })); }33:[{"id":"838dfee5bd96ade412d9b8f8f4b9b90e437388fb7f1035d328ab3e044b6bb800d6b3cd8d337ac4d2195ca3ef2ad6a7ca3acc3cb2f774ad077e04fb5ecef33711","href":"https://static.observableusercontent.com/files/838dfee5bd96ade412d9b8f8f4b9b90e437388fb7f1035d328ab3e044b6bb800d6b3cd8d337ac4d2195ca3ef2ad6a7ca3acc3cb2f774ad077e04fb5ecef33711","name":"symbols@4.csv","type":"text/csv","lastModified":1611740021563.374,"size":60477}] 30:{"id":"fd5a775422e998f5","slug":"kite-basket-order","title":"Kite Basket Order","thumbnail":"f85ba054fd6403e76ad912a1305b38431f1b9f9530a071b52d234880ed604a44","access_level":"public","create_time":"$D2020-07-28T05:00:38.310Z","update_time":"$D2021-01-27T09:33:54.487Z","view_time":null,"first_public_time":"$D2020-07-28T16:07:34.716Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"8e6c3b35efe3f2e7","login":"uptickr","name":"Vashistha Iyer","avatar_url":"https://avatars-next.observableusercontent.com/21bef411f9be2d217e539bb69bfb1824a4d70ad3fafba220acec625d8b6139e4","tier":"starter_2024"},"version":594,"publish_version":594,"role":null,"authored":false,"authors":[{"type":"individual","id":"423873860ad1fea6","login":"uptickr","name":"Vashistha Iyer","avatar_url":"https://avatars-next.observableusercontent.com/21bef411f9be2d217e539bb69bfb1824a4d70ad3fafba220acec625d8b6139e4","tier":null}],"members":[{"type":"individual","id":"423873860ad1fea6","login":"uptickr","name":"Vashistha Iyer","avatar_url":"https://avatars-next.observableusercontent.com/21bef411f9be2d217e539bb69bfb1824a4d70ad3fafba220acec625d8b6139e4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":9,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Kite Basket Order","cells":[{"id":0,"value":"md`\n# Kite Basket Order\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":579,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"md`### 1. Upload CSV`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"viewof upload = file({\n accept: \".csv\",\n description:\n \"Upload your desired transactions as a csv file in the format shown below:\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"html`\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Symbol	Quantity	Price
HDFCBANK	5	1000
RELIANCE	10
TCS	-3	2500

Leave the Price field empty if you want to place a market order
Positive quantity indicates BUY, negative quantity indicates SELL

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"md`\n---\n### 2. Review\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"{\n const basket = await validate(upload);\n const review = html`\n \n \n \n \n \n \n \n \n \n \n \n \n

Symbol	Name	Transaction	Order Type	Quantity	Price

\n `;\n\n const tbody = review.querySelector('tbody');\n let tr, td;\n basket.forEach(row => {\n tr = tbody.insertRow(tbody.rows.length);\n td = tr.insertCell(tr.cells.length);\n td.innerHTML = row.SYMBOL;\n td = tr.insertCell(tr.cells.length);\n td.innerHTML = row.NAME;\n td = tr.insertCell(tr.cells.length);\n td.innerHTML = row.TRANSACTION;\n td = tr.insertCell(tr.cells.length);\n td.innerHTML = row.ORDER;\n td = tr.insertCell(tr.cells.length);\n td.innerHTML = row.QUANTITY;\n td = tr.insertCell(tr.cells.length);\n td.innerHTML = row.PRICE;\n });\n\n return review;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"md`\n---\n### 3. Place Order\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":468,"value":"md`Click the button below to trigger your basket order on Zerodha Kite.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":513,"value":"{\n const order = await buildOrder();\n\n const button = html`\n \n `;\n\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"md`---\n#### Utils`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"nseSymbols = {\n const csv = await FileAttachment(\"symbols@4.csv\").text();\n return d3.csvParse(csv, d3.autoType);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"async function buildOrder() {\n const basket = await validate(upload);\n return basket.map(row => ({\n variety: \"regular\",\n exchange: \"NSE\",\n tradingsymbol: row.SYMBOL,\n quantity: Math.abs(row.QUANTITY),\n transaction_type: row.TRANSACTION,\n order_type: row.ORDER,\n ...(row.ORDER === \"LIMIT\" ? { price: row.PRICE } : {})\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"md`---\n#### Dependencies\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"import { file, radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"import { html } from \"@observablehq/htl\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"d3 = require(\"d3-dsv@1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"