Bitcoin Forum
May 02, 2024, 10:19:52 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: My goal: make the perfect portfolio management Google Sheet!  (Read 345 times)
crypto_wisdom (OP)
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile WWW
September 04, 2017, 04:19:15 AM
 #1

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
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!