As the title suggests, I want to manage my portfolio in a simple to use Google Sheets with Script.
https://docs.google.com/spreadsheets/d/1zRhpZh4WQC5ldua5Ljw4Qfv5kdLzfg1DpMPY1AYI7mc/edit?usp=sharing
Instructions are on the first tab.
So far I'm able to:
1. Automatically pull the balance for a few coins (need more work)
2. Send emails when prices drop below pre-set limits
3. Log my portfolio total, investment total and profit total each day
I'd like to hear what you think of this project and how it can be improved - let's build the perfect free portfolio manager together. If you're good with =IMPORTDATA, JSON, API etc. please join the project
I know there are apps and paid services that can do some or all of this, but I believe Google Sheets and Script together can do all we need for free!
Good luck, Sam
Topic: My goal: make the perfect portfolio management Google Sheet! (Read 365 times)
Jump to: