Cola's Stocks 3.0 Spreadsheet

I'm also having this problem when updating the stock. How'd you fix it?

For the people struggling with errors, I updated the API call to a limited key (i.e. not using the 'custom' key option), and the error is gone. Worth a try if you're also struggling to find the problem :)

IDK if youve already gone past this request, but im using a version thats still a few years old, so no ILL included. I have however annotated my version heavily to include ILL, PI, and other helpful things for myself. before i switch over, does your newest version have all of these included?

Esp for ILL, does it give the correct virus to code, since now Firewalks have crashed (my personal calcs are showing tunneling is the best way to go)

ILL yes, PI not so far

Addint when to purchase you own PI would be a huge update,
Thanks for all the work so far

.

Not working :( put right APi but still have "not owned" near stock i have owned

i liked the old sheet where you could see actual income generated. the link in this new sheet to the old does not seem to work.

Does anybody have a sheet that calculate income generated?

Thanks for your hard work

I am having this same issue.

How can i setup autoupdate evey 5mins on mobile?

same

Will check on it. Great help. Thanks!

It it possible to request a change to the sheet where the value of energy and nerve are used?

I think all that is required is editing near where the code defines the values for the user stocks to include an estimate of how much to value energy and how much to value nerve. The price of energy can be estimated by an e-can. The value of nerve can be estimated via a daily refill. 

The sheet by Adobi: https://docs.google.com/spreadsheets/u/0/d/13A9nH67J-8XM6-czAQu4MqtXvYmT9UQLpP0v9AJEM4A/htmlview#gid=2123361143

is slightly better at pricing some of the less conventional stocks, including the stocks for mission rewards.

I'm also experiencing this problem. How do you fix it?

Bump it, i just discovered how amazing and fun could be stock market, thanks for the help man

thanks

Great spreadsheet! thank you for hard work

Im really bad at spreadsheets, so here are my 4 thousand questions if anyone knows how to answer these. thanks :)

1. Does anyone have any tips on how to change the colors. Mines all orange. Like how to make the highest ROI green, and the lowest red. Or the least useful red, and most green ect. Basically how to change color coding, as well as what i should color code it as, thanks

2. What does it mean by increment, when it says like 1, 2 or 10 merits?

3. Whats days to break even, like once you buy a block, how much time to make your money back??

Also great spreadsheet!!! (i think, again, no clue what it says lol) #technologically challenged

1. You can change the colors by going to "Format -> Conditional Formatting". It'll display the rules that are setting colors, but they aren't currently set by ROI.

2. Increments is the amount of active benefits you have in that stock. So for IOU, a "1" means that you have 3 million shares (enough to redeem $12 million every 31 days), a "2" would mean that you have 9 million shares (enough to redeem $24 million every 31 days).

3. That column displays the % you'll get back in 365 days. So the bank with 10 merits will make back 69.11% (as of right now) the 2b after 365 days. That doesn't include the original amount, so it'll all be profit.