Bitcoin Forum
November 20, 2017, 07:50:37 PM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: My goal: make the perfect portfolio management Google Sheet!  (Read 245 times)
crypto_wisdom
Newbie
*
Offline Offline

Activity: 2


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

Genesis Mining Promo: QNifrD
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!