Skip to content
TORNLIFE More

Cola's Stocks 3.0 Spreadsheet

Started by colaman32 [2091413] Wiki Contributor on in Tutorials & Guides.

571 replies · 125k views · thread synced · 2 days ago · View on torn.com
About this thread

Posts archived: 572 / 572 posts (100%) · the total is Torn's reply count + the opening post at the last fetch

Counted by TornLife from the archived posts.

Archived posts
572
Discussion span
→
Authority score
78 / 100
Historical score
77 / 100
Story score
68 / 100
Engagement score
93 / 100

People posting, likes and official posts are not counted for this thread yet: on threads longer than one page they come from a periodic pass over the archive, which has not covered it.

Most-liked replies

Mentioned in this thread

colaman32 [2091413] ×2 AutoPilot [2426505] ×1

colaman32 [2091413] Wiki Contributor

Hello fellow torn citizens, today I bring you yet another Stocks 3.0 spreadsheet. This one focuses on telling you what to buy next based on what you already have purchased. The format is based on this spreadsheet by Autopilot [2426505].

I hope you find it useful.

LINK: GOOGLE SHEETS

Some things to take into account:

  • It takes all the necessary information from the torn API, you shouldn't need to manually add anything.
  • Everytime you click the big "Click!" button it updates the values and auto-sorts by ROI (the highest, the most profitable)
  • Bank takes into account the best APR investment (usually 2 or 3 months).
  • Different shades of orange are for different increments, and red is for bank related investments.
  • All the stocks/increments you already have will be highlighted on green color.

How to use:

  • Save a copy in your Google drive account
  • It will probably ask you to give script running permission, say yes
  • Add your API (make it Limited Access, or create a custom one following this link)



[image: i.gyazo.com]

  • Click the big button that says "Click!"




[image: i.gyazo.com]


This is how it looks like:

[image: i.gyazo.com]


For issues, questions and suggestions don't hesitate to chat or pm me.

Mentions: AutoPilot [2426505] · Stocks 3.0 Purchase Priority Guide

Ariston [2322328] Wiki Contributor
Helpful - thank you!

If I may make a small suggestion (I am doing this for my own copy) - a[background color=var(--bbc-body-bg-color)]llow a customizable ROI% trigger for color coding and "what-if" buying scenarios, ex: the current ROI for a fully-loaded PI is ~19% (900,000/day rent x 365 / PI cost of 1.7B) - I want to see everything above that[/background][background color=var(--bbc-body-bg-color)] amount, etc.[/background]
colaman32 [2091413] Wiki Contributor
I appreciate your suggestion, but I'd rather keep it neutral as it is, because different people have different needs.

As you said, anyone that wants to can change the spreadsheet at their convenience, as it is stored locally.
colaman32 [2091413] Wiki Contributor
Unfortunately appscript won't work on mobile Google Sheets. There is an alternative if you usually will use it on phone, you can set it up to autoupdate every 5 minutes on pc, so when you open it on phone it is updated.

Let me know if you need some help with setting it up.
colaman32 [2091413] Wiki Contributor
The first step of how to use clearly says:
  • Save a copy in your Google drive account
What you are trying to do is edit MY COPY of the spreadsheet instead of creaing your own copy.