colaman32: forum

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.

this was how stocks 2.0 worked vs what we have now (3.0) 

https://wiki.torn.com/wiki/Stocks_2.0

ILL yes, PI not so far

When I first made this tool that option wasnt in the api, now it seems v2 has it, so I will consider adding it if theres enough interest. 

update the sheet to the new version! (be sure to also update the api)

The bank is really just there for comparison purposes.

If there’s enough interest, I could make it call the API to check the actual amount of merits and make it dynamic. However, I didn’t see a need for that when I created the sheet, since everyone should aim to get 10 merits as soon as possible anyway.

you dont own enough of any stock to make a block

Due to popular demand I have added IIL to the base sheet, this will tell you which virus to do for most profit and current ROI. For those that want to use this new sheet they will need to make a new API key from the main post link, as this checks for educations done and wether or not you are in a virus coding company.

If something is broken please chat me directly =)

1 gasoline + FT + FT stoke seems to way go over the %

adding 1 lighter stoke took it to 100% this time around

[image: i.gyazo.com]

4 gasoline + thermite + FT can fail this

[image: i.gyazo.com]

1 gasoline + FT + dampen at 24% fails this

4 kerosene + lighter fail

[image: i.gyazo.com]

The only thing I took from Autopilot is the format of the sheet, and I'm still playing the game =)

I was less lucky

 [image: i.gyazo.com]

you can add it in your own copy!

yes

Yes, someone a few pages back found that it will work on desktop mode, I just never added it to the main post

https://www.torn.com/forums.php#/p=threads&f=61&t=16224439&b=0&a=0&start=220&to=23855725

Something like this?

Oh wow this actually works!!

I copied the link from drive app and opened it on kiwi, on destkop mode the click button did work.

I very much approve this

13:57:44 - 22/04/25 You used a Black Easter Egg gaining $31,523,442

Thats...very weird, my own copy does pull points api, did you change anything on your sheet? I could take a look if you share the sheet with me. Chat me if you want.