Skip to content

Cola's Stocks 3.0 Spreadsheet

Source: colaman32 [2091413], thread t=16224439. Karma 1,670. Wiki Contributor. Last updated March 2026. Endorsed by Baldr.

What It Is

A Google Sheets spreadsheet that tells you what stock to buy next based on what you already own, sorted by ROI. Pulls live data from the Torn API automatically.

Link: Find the Google Sheets link in the forum thread (t=16224439). You must save your own copy.

How to Use

  1. Open the thread and click the Google Sheets link
  2. File > Make a copy (save to your own Google Drive)
  3. Allow script permissions when prompted
  4. Add your Torn API key (Limited Access is enough)
  5. Click the big "Click!" button to refresh and sort

What It Shows

  • All stocks and their current ROI, auto-sorted highest first
  • Color coded: orange shades = different increment tiers, red = bank investments, green = already owned
  • Bank entry accounts for best APR investment (usually 2 or 3 month term)
  • Updates in real time from the API

Key Notes

  • Does NOT work on mobile Google Sheets (AppScript limitation). Set up auto-update every 5 minutes on PC if you want to check on phone
  • ROI from a fully loaded PI is ~19% ($900k/day rent / $1.7B cost). Use this as a benchmark for whether a stock is worth buying
  • The spreadsheet won't tell you WHAT to buy from scratch, it tells you what's highest ROI given your current holdings

Practical Use

This is the fastest way to answer "what should I invest in next?" without doing the maths manually. Run it after every major purchase or once a week.

  • Passive Income Investment Guide (Deadringers)
  • Bank Interest and Stocks
  • Money Making Overview