Connect Google Sheet

Publish your Google Sheet as CSV and paste the URLs below. Positions and rebalance history refresh automatically on your chosen schedule.

How to publish your Google Sheet as CSV

  1. Open your Google Sheet → File → Share → Publish to web
  2. Select the correct tab → choose Comma-separated values (.csv)
  3. Click Publish → copy the URL → paste above
  4. For a second sheet/tab, publish it separately and paste as the Rebalance URL
Positions tab — column headers (Row 1):
Script  Sector  Purchase Date  Avg Price  Month Start Price  Current Price  Daily Change%  Qty

Rebalance tab — column headers (Row 1):
Month  Stocks (comma-separated in one cell)  Return%  Notes

Live Portfolio Tracker

Live Connect Google Sheets to load live data

Portfolio Value
—
Total current value
Avg Overall Return
—
Since purchase
Avg MTD Change
—
Month to date
Avg Daily Change
—
Today's change
Nifty 500
—
Loading…
Open Positions
—
Active holdings
Tq iDeA$ vs Nifty 500
Tq iDeA$ (High Octane)
Nifty 500
Tq iDeA$ Return
—
for selected period
Nifty 500 Return
—
same period
Outperformance
—
alpha generated
Period
—
live track record
TurtleQuants · Tq iDeA$
Monthly Returns Heatmap
Win rate: —  ·  Live since Apr 2021
Scale:
>+10%
+5–10%
0–5%
0 to −5%
<−5%
Current Open Positions
Connect Google Sheet to load live holdings
Script Purchase Date Avg Price ₹ Month Start ₹ Current Price ₹ Overall Return MTD Change Daily Change

No positions loaded yet.
Connect your Google Sheet to see live holdings.
Monthly Rebalance History
First trading day of each month · 12 trades/year

No rebalance history loaded.
Connect your Google Sheet to see monthly stock lists.