Kasliwal Portfolio Tracker

🇮🇳 India Price Sources — Equities & ETFs

Status

1

Your Render.com proxy (tried first)
Endpoint: — / price?symbol=…&exchange=…
Key required: none — it's your own hosted proxy, set the base URL below.

2

Groww public chart API (fallback if proxy fails)
Endpoint: groww.in/v1/api/stocks_fo/.../charting/v2/chart/exchange/NSE/...
Key required: none — public endpoint, no signup.

3

Stooq.com CSV (last resort, via allorigins.win CORS proxy)
Endpoint: stooq.com/q/l/?s={symbol}.in
Key required: none.

🇺🇸 US Price Sources — Equities & ETFs

Status

1 → Finnhub (key required) · 2 → Stooq CSV (free fallback)

📊 Other Asset Types

🌀 Mutual Funds — mfapi.in

₿ Crypto — CoinGecko + Binance

🪙 Commodities — Gold API + Yahoo

💱 Currency — exchangerate-api

🔒 Unlisted — manual entry only

📄 Bonds/Property — manual only

🗄 Database Connection

Supabase URL

Supabase Anon Key

👨‍👩‍👧‍👦 Family Members

📁 File Import Formats

Every format the importer recognises — what it takes out of each file and where that ends up.

Group by

	File	Family	Market	Destination	Status

Nothing is written until you press Import.

General

🎨 Appearance

The same switch as the one in the header — every panel, table, chart and modal in the app follows it.

👨‍👩‍👧‍👦 Family Members

Everyone the portfolio is tracked for. Each one has their own holdings, realized P&L, MTF book and Positions ledger.

📊 At a Glance

📋 API Status & Fetch Methods

Asset Type	Fetch Methods (in order)	Key Needed	Live Status
🇮🇳 Equities	1. Render Proxy (NSE) · 2. Stooq	None (free)	—
🇺🇸 Equities	1. Finnhub · 2. Stooq · 3. Twelve Data*	Finnhub key	—
📦 ETFs	1. Render Proxy · 2. Finnhub · 3. Stooq	None	—
🌀 Mutual Funds	1. mfapi.in — /search · /{code}/latest · /{code}	None (free)	—
₿ Crypto	1. CoinGecko · 2. Binance	None	—
💱 Currency (FX)	1. exchangerate-api · 2. Frankfurter	None	—
🪙 Commodities	1. Metals.Dev (gold/silver/MCX/LME) · 2. Gold-API	Metals.Dev key*	—
📰 News & Search	1. Marketaux · 2. Finnhub news	Marketaux key	—
📄 Bonds & FDs	Manual entry only	—	Manual
🏠 Property	Manual entry only	—	Manual
📈 Unlisted Equity	Manual entry only	—	Manual
* = planned / add key when ready to use. Groww removed (unofficial, unreliable). FinStack removed (not a usable public API).

🩺 Market Data Diagnostics

Self-serve checks you can run any time — including against your own deployed Render proxy — without anyone else needing to run them for you.

🇮🇳 Render Proxy — isolated deep test

Calls your configured proxy directly — no Groww/Stooq fallback — and shows latency plus the raw response, the same request the app makes for every Indian equity/ETF.

🖼️ Logo Sources

LogoKit stays the primary source for every equity/ETF/MF logo. These two free, static GitHub-hosted sets are only tried next, when LogoKit has none — never live APIs, so they can't rate-limit or go down mid-session.

📐 Normalized Market Data — live sample

The shared MarketData record shape any part of the app can read, built from one of your actual holdings and its cached price. Fields no wired source supplies stay null rather than guessed.

📚 Reference-only / not wired

• imanojkumar/NSE-India-All-Stocks-Tickers-Data — stale historical CSVs (last updated ~Jan 2021); its Ticker_List_NSE_India.csv is a genuine NSE↔Yahoo ticker map, kept as documentation only, never as a live price source.

• nse-rs (Rust) / jugaad-data (Python) — real libraries, but neither is callable from a browser tab without a server to run them on; catalogued as future backend candidates, not wired here.

• Twelve Data / Metals.Dev — free-tier APIs catalogued in API Keys below; add a key there to switch one on — nothing is silently active without one.

🔑 API Keys & Endpoints

🔑 Configure Keys

🇺🇸 Finnhub API Key (required for US equities)

Current:

Get free key: finnhub.io → Sign up → Dashboard

🇮🇳 NSE Proxy URL (required for India equities)

Current: https://nse-price-proxy-hngn.onrender.com

Self-hosted on Render.com free tier. Community maintained.

📰 Marketaux API Key (news + company search)

Current:

Free 100 req/day: marketaux.com → Sign up → API token

▶️ YouTube Data API Key (channel uploads)

Current:

Free 10,000 units/day: console.cloud.google.com → enable YouTube Data API v3

🆓 Free APIs (no key needed)

🌀 mfapi.in — Mutual Funds NAV

₿ CoinGecko — Crypto (primary)

₿ Binance — Crypto (fallback)

📈 Stooq — Equity fallback (all)

💱 exchangerate-api — Currency (primary)

💱 Frankfurter — Currency (fallback)

🪙 Gold-API.com — Commodities (current)

🔎 Local list — Equity search (instant)

Groww removed (unofficial). FinStack removed (not a public API).
Metals.Dev (100 req/month free) will replace Gold-API when you add the key above.

🗄️ Supabase Database

Active Connection

URL

—

Publishable Key

—

Change Connection (optional — only if you want your own project)

New Supabase URL

New Publishable Key

Get both from: supabase.com → Your Project → Settings → API

Checks the tables, columns and keys this app writes to. It never changes data.

📁 File Import Formats

Every format the importer recognises, including the ones you confirmed yourself.

📁 Master file data

The latest file of each format, per family member — not a history. One row per format: re-import it and the row updates instead of stacking, and a file whose entries you deleted drops off by itself. Undo removes exactly what that import wrote and puts back anything it replaced.

🏷️ Sector mapping

Every equity and ETF you hold, and which sector it is counted under on the Dashboard. Set one yourself and it wins over everything — the built-in table, the name match, all of it — and it stays set, on every device. Unknown ones are listed first, because those are the ones worth ten seconds.

▶️ YouTube

The YouTube page lists the newest uploads from the channels you follow. Nothing here calls a paid service.

Videos shown per channel Auto-refresh every (min, 0 = off) Skip videos shorter than (min) — Shorts filter

Prompts

Copy and Gemini both send prompt + link, never a bare URL. Pick which prompt is the default with the radio; that is the one both buttons use.

🔍 Market Data Audit — Read-Only System Overview

A complete, honest snapshot of the market-data engine as it actually runs — not as documented elsewhere. Everything below is read from live application state and code configuration; nothing here can be edited, reset, or cleared from this screen, and opening this tab never makes a network request, spends a quota, or touches your holdings, cache, or database. Where the app genuinely does not track something, it says so instead of guessing.

Advanced Real-Time Chart ↗ 1Y · daily candles · drawing tools on