31: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 })); }32:[{"id":"838dfee5bd96ade412d9b8f8f4b9b90e437388fb7f1035d328ab3e044b6bb800d6b3cd8d337ac4d2195ca3ef2ad6a7ca3acc3cb2f774ad077e04fb5ecef33711","href":"https://static.observableusercontent.com/files/838dfee5bd96ade412d9b8f8f4b9b90e437388fb7f1035d328ab3e044b6bb800d6b3cd8d337ac4d2195ca3ef2ad6a7ca3acc3cb2f774ad077e04fb5ecef33711","name":"symbols@4.csv","type":"text/csv","lastModified":1611740021563.374,"size":60477}] 2f:{"title":"Kite Basket Order","cells":[{"id":0,"value":"md`\n# Kite Basket Order\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":579,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":115,"value":"md`### 1. Upload CSV`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":110,"value":"md`\n---\n### 2. Review\n`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":129,"value":"md`\n---\n### 3. Place Order\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":468,"value":"md`Click the button below to trigger your basket order on Zerodha Kite.`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":22,"value":"md`---\n#### Utils`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":172,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":7,"value":"md`---\n#### Dependencies\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"import { file, radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":544,"value":"import { html } from \"@observablehq/htl\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"d3 = require(\"d3-dsv@1\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}