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.

Crazy stuff happens here

My own copy still works fine and there were no changes, try making a new copy and see if that fixes it

Probably yes, if it changes anything it would be number format and it should be easily fixed. Let me know if it breaks

No checkpoints failed level 8

[image: i.gyazo.com]

Thats my bad, I got rid of @onlycurrentdoc while testing and never put it back, now it should be reverted

Its not adding or removing something specific, changing anything in the code and saving fixes it. Firefox has some weird problem with appscript.

I got it working on my end, could you please check if its working on firefox for you?

so thats why I couldnt replicate the issues on chrome...

Im on vacation right now, will look into any issues happening once I have access to a computer again. 

If adding more people to attacks is imposible, how about implementing a "Join queue"? You hit Join and get placed into queue for when a spot is available, if you refresh the page you lose your place on the queue, and it would show your place. 

I think this would significantly reduce the strain on the servers.

I like the RW filter, rest is meh

swipe it right or left, cant remember the direction

I actually have a complaint, the bar looks way better on light mode than dark mode. I feel the separation between the pips (specially the blank ones) and the green shades need some tweaking.

[image: i.gyazo.com]

[image: i.gyazo.com]

Always happens the people complaining are the loudest, while the mayority of us just play the game and are happy about it

Tested it, still needs a pc to setup

"Add your API (make it Limited Access, or create a custom one following this link)" 

Quoted from the instructions on the first post =) 

Nope, still working

Thats huge!

I use this sheet on a day to day basis, so if you get an error and theres no update, just assume the API was down at the time

You need enough shares to acivate the passive benefit, otherwise you receive nothing from stocks