Cola's Stocks 3.0 Spreadsheet

WSU dividend is education length reduction, so has no actual money value. Therefor it's not in the sheet.

GRN is definitely in there.

I don't know about the issue of the amount of increments, as I don't have any 2nd increments yet.

Do you have enough shares to make a GRN block? That may be why it doesnt show

Can this be used on mobile, can't seem to do anything using Google sheets app

Is it correct that the sheed doesnt show dividend income?

I don't know how to math. PTS is great ROI no?

Maybe I'm being dumb and missed something but saving to my drive then running the script, it requires permission, but when I go to sign into my account to give permissions it tells me "Google hasn’t verified this app", and doesn't give any other options.

Ahh perfect I didn't notice this before, works now, thanks!

Extremely helpful. Thank you!

thanks man.

Saved

Why does this copy of the spreadsheet come with a bunch of warnings about the script and things being unverified that the last version didn't have?

I like the icons helping clarify what the stock acronyms are, but other than that, what are the significant changes to the previous version?

It's literally the same script, the icon change didn't change anything on the script.

Every version has came with the same warnings and unverified message from google, I believe this might be due to the conecction it makes to torn API being an external service.

The script itself is pretty straightforward, get API info->paste API info on sheet->do stuff inside the sheet to sort it.

If you still have doubts about it, just ask anyone with coding experience to review it.

Hi, so I did as explained, but when i click on the big "Click" i only get this msg TypeError: Cannot read properties of undefined (reading '364')
What am I doing wrong?

That error is usually tied to API being down, try again later and if it persists chat me so we can troubleshoot.

Thank you, Its working now :)

I would add to the sheet (and I actually added to my copy) the sign "By colaman32 [2091413]", and a link to this thread.
Otherwise, when I make a copy of the sheet and bookmark it, I have no way to return here

Thats something I could add, as it doesnt change the functionality of the sheet

Great tool to have plus Colaman32 was super friendly and helpful when I needed assistance

same for me.

Nvm it works now !! It's top notch. Great work