25:["$","title",null,{"children":"Fetch Stock Monthly Returns | Deepak Shenoy | Observable"}] 49:T1362,// Download the JSON data using the fetch API test = { const url = "http://localhost:8080/proxy?url=https://space.capitalmind.in/v2/api/prices/tv/history?symbol=NIFTY&resolution=1D&from=713409600&to=1679983712&countback=2"; let headers = new Headers(); headers.append('Access-Control-Allow-Origin', '*'); let response = await fetch(url, { mode: 'cors', headers: headers }); const jsonData = await response.json(); // Define the table headers const months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; const tableHeaders = ["Year", ...months, "Total"]; // Initialize an empty array to store the monthly returns const monthlyReturns = []; // Loop through the data to extract the daily stock prices let startYear = null; let endYear = null; for (let i = 0; i < jsonData.c.length; i++) { // Extract the date and price from the data const date = new Date(jsonData.t[i] * 1000); const price = jsonData.c[i]; // Calculate the year and month for the current price const year = date.getFullYear(); const month = date.getMonth(); // Find or create the entry for the current year let yearEntry = monthlyReturns.find(entry => entry.year === year); if (!yearEntry) { yearEntry = { year, months: [] }; monthlyReturns.push(yearEntry); if (startYear === null || year < startYear) { startYear = year; } if (endYear === null || year > endYear) { endYear = year; } } // Find or create the entry for the current month and year let monthEntry = yearEntry.months[month]; if (!monthEntry) { monthEntry = { month, prices: [] }; yearEntry.months[month] = monthEntry; } // Add the current price to the prices array for the current month and year monthEntry.prices.push(price); } let runningFirst=jsonData.c[0]; // Calculate the monthly returns and total returns for (const yearEntry of monthlyReturns) { let totalReturn = 1; for (let i = 0; i < 12; i++) { const monthEntry = yearEntry.months[i]; if (!monthEntry) continue; const prices = monthEntry.prices; if (prices.length > 1) { const firstPrice = runningFirst; // prices[0]; const lastPrice = prices[prices.length - 1]; const returnPercentage = (lastPrice - firstPrice) / firstPrice * 100; monthEntry.returnPercentage = returnPercentage; totalReturn *= (lastPrice / firstPrice); runningFirst = lastPrice; } } yearEntry.totalReturnPercentage = (totalReturn - 1) * 100; } // Sort the monthly returns by year and month monthlyReturns.sort((a, b) => a.year - b.year); // console.log( // monthlyReturns.map( (year) => { // year.months.map( (month) => { // this.push( month.returnPercentage ); // }, this); // }, []); // ); // Generate the table HTML const tableHtml = ` ${tableHeaders.map(header => ``).join("")} ${Array(endYear - startYear + 1).fill().map((_, i) => { const year = startYear + i; const yearEntry = monthlyReturns.find(entry => entry.year === year); if (!yearEntry) { return ""; } const monthEntries = yearEntry.months; let totalReturnPercentage = 1; const monthHtml = months.map((month, index) => { const monthEntry = monthEntries[index]; if (!monthEntry) { return ``; } const returnPercentage = monthEntry.returnPercentage || 0; totalReturnPercentage *= (1 + returnPercentage / 100); const color = returnPercentage >= 0 ? `rgba(0, 128, 0, ${returnPercentage / 100})` : `rgba(128, 0, 0, ${-returnPercentage / 100})`; return ``; }).join(""); const totalReturnColor = totalReturnPercentage >= 1 ? `rgba(0, 128, 0, ${totalReturnPercentage - 1})` : `rgba(128, 0, 0, ${1 - totalReturnPercentage})`; const totalReturnHtml = ``; return `${monthHtml}${totalReturnHtml}`; }).join("")}

${header}
	${returnPercentage.toFixed(1)}%	${((totalReturnPercentage - 1)*100).toFixed(1)}%
${year}

`; // Define the CSS for the table const tableCss = ` .returns-table { border-collapse: collapse; font-size: 12px; width: 100%; } .returns-table th, .returns-table td { border: 1px solid #ddd; padding: 5px; text-align: center; vertical-align: middle; } `; // Display the table and CSS in the notebook using the html template tag return { tableHtml, tableCss }; }4a:[] 29:{"id":"ff0028126a60bfa5","slug":null,"title":"Fetch Stock Monthly Returns","thumbnail":"d0c2878bf764d4450709115b71f447a879e121ad5f5a1c36ed98ca1f1defc089","access_level":"public","create_time":"$D2023-03-28T05:55:20.365Z","update_time":"$D2023-03-30T13:21:07.531Z","view_time":null,"first_public_time":"$D2023-03-28T05:55:20.365Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"f9594bfaa216953c","login":"deepakshenoycm","name":"Deepak Shenoy","avatar_url":"https://avatars-next.observableusercontent.com/8d7f7c4c98b4df3e53d8827dff4d5cb0d177bd77030ee5d8d090aa2dff515ebc","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":176,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b14da7f9ad39a821","login":"deepakshenoycm","name":"Deepak Shenoy","avatar_url":"https://avatars-next.observableusercontent.com/8d7f7c4c98b4df3e53d8827dff4d5cb0d177bd77030ee5d8d090aa2dff515ebc","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"b14da7f9ad39a821","login":"deepakshenoycm","name":"Deepak Shenoy","avatar_url":"https://avatars-next.observableusercontent.com/8d7f7c4c98b4df3e53d8827dff4d5cb0d177bd77030ee5d8d090aa2dff515ebc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Fetch Stock Monthly Returns","cells":[{"id":0,"value":"# Fetch Stock Monthly Returns","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":38,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":36,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":104,"value":"data = {\n const url = \"http://localhost:8080/proxy?url=https://space.capitalmind.in/v2/api/prices/tv/history?symbol=NIFTY&resolution=1D&from=713409600&to=1679983712&countback=2\";\n \n let headers = new Headers();\n headers.append('Access-Control-Allow-Origin', '*');\n \n let response = await fetch(url, {\n mode: 'cors',\n headers: headers\n });\n \n const jsonData = await response.json();\n\n return jsonData\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"ohlc = {\n return _.zipWith(data.t, data.c, (ts, close) => ({\n ts: new Date(ts * 1000),\n close\n }))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"return_monthly = {\n return _.chain(ohlc)\n .map(cur => ({...cur, ym: cur.ts.getFullYear() * 100 + cur.ts.getMonth() + 1}))\n .groupBy('ym')\n .mapValues(arr => _.last(arr))\n .values()\n .map((cur, idx, arr) => {\n if (idx === 0) return {...cur, pct_change: null }\n const prev = arr[idx - 1].close\n const pct_change = _.round(cur.close / prev - 1, 4)\n return {\n ...cur,\n pct_change,\n }\n })\n .value()\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"Plot.plot({\n marks: [\n Plot.auto(return_monthly, {x: \"ts\", y: \"pct_change\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"$49","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"html `\n \n ${test.tableHtml}\n `","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"function getQuantiles( arr ) {\n const quantiles = [];\n for( const i=10;i>=0;i--) \n quantiles.push(d3.quantile(arr, i/10));\n return quantiles;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null