Status
Instruments
| Ticker | Sheet token | Resolved token | Subscribed? | Latest tick | LTP shown | Source |
|---|---|---|---|---|---|---|
| yes no — |
|
kite yahoo — |
Google Sheets
Paste the entire contents of the .json file. Share the Sheet with this account's email (Editor permission).
✓ A service account is already saved. Leave blank to keep it; paste new JSON to replace.
Sheet tab
All holdings and live prices live in this one tab. Backend writes live prices back into the columns you map below.
Read columns (holdings)
Map each app field to a column in your sheet. Optional fields use defaults if you leave them as — none —: exchange=NSE, qty=1, alertPct=5%.
Write columns (live prices written back)
Backend updates these cells per row, only for rows whose ticker it can find. Throttled to once every 5 minutes (Sheets rate-limit safe).
Zerodha Kite
Daily access token
Kite tokens expire daily ~6 AM IST. Two ways to refresh:
Option A — login flow:
- Click the link below, log in to Kite, you'll be redirected to a URL containing
request_token=... - Copy that
request_tokenvalue (just the token, not the whole URL) and paste below - We'll exchange it for an access token and save it
Option B — paste access token directly (if you generated it elsewhere):
Last token saved:
PostgreSQL tick stream DSN
When Kite is active, the backend reads live tick prices from this Postgres DB instead of the slower Yahoo source. Pre-existing zerodha_pg_stream_worker writes to this DB — paste the same DSN it uses.
Firebase Cloud Messaging
Firebase Console → Project Settings → Service accounts → Generate new private key.
Firebase Console → Project Settings → Your apps → Android app → Download google-services.json. We store it here so the Android build can fetch it.
✓ Stored. Download for the Android build.