UPD 10.12.2017
The new Fund Edition Spreadsheet is ready. You can learn more in new thread:
https://bitcointalksearch.org/topic/google-spreadsheet-to-manage-and-automate-your-crypto-fund-2559144
Topic: Google Spreadsheet for Crypto Investing.Realtime Portfolio monitoring/management (Read 6889 times)
December 10, 2017, 04:41:40 AM
November 23, 2017, 09:01:35 PM
UPD 24.11.2017
- Universal Data Writer functionality is added. Now you can just build the row (or rows) with data and formulas which you want to record and set a Timer (reference is updated). You have 3 copies of writer function (writer, writer_2, writer_3). Why? Just for Timer flexibility.
- Balancing sheet is upgraded. Now you can disable any assets from re-balancing calculations
- TICKER function now more reliable. It get's median price from 3 data providers: coinmarketcap, cryptocompare, cryptonator
If any of the source is down - it still works
- TICKER_4 added as "cryptocompare only" price function
- SPECIFIC_PRICE is fixed (parseFloat added)
- IFERROR handlers added to avoid "erroneous views"
- Telegram triggers minor fixes and 3 copies added (for timers flexibility)
Announcement:
- Free Google Spreadsheet Add-on is almost production-ready. Just need to brush HTML popups and tutorial
- Fund Edition version is ready. Here is a short description. Demo video will be soon.
Fund Edition is advanced spreadsheet which helps to organize and manage your own small fund. All Fund's internal processes as automated as possible and as transparent as possible:
* Internal Token Issuance to account all shares of your investors properly;
* Easy accounting to accept the money (entrance) and withdraw the money (redeem internal tokens) in any cryptocurrency with one-click automatic calculations and recording of operations on the Issuance tab;
* Accounting of "Success fee" for all your investors with recording on the Issuance tab;
* Asset Scoring model;
* Special tab for rebalancing calculations with Telegram notifications for "Timer" and "Deviation" approaches;
* Easy way to create a "public" version for your fund's spreadsheet and setup automatic synchronization between private and public spreadsheets;
* "Exchanges Balance Synchronization" feature is included;
* "Telegram Triggers" feature is included;
* "Historical Data Writer" feature is included;
* Automatic writing of all fund's performance and history as well;
My Telegram https://t.me/acosmos
- Universal Data Writer functionality is added. Now you can just build the row (or rows) with data and formulas which you want to record and set a Timer (reference is updated). You have 3 copies of writer function (writer, writer_2, writer_3). Why? Just for Timer flexibility.
- Balancing sheet is upgraded. Now you can disable any assets from re-balancing calculations
- TICKER function now more reliable. It get's median price from 3 data providers: coinmarketcap, cryptocompare, cryptonator
If any of the source is down - it still works
- TICKER_4 added as "cryptocompare only" price function
- SPECIFIC_PRICE is fixed (parseFloat added)
- IFERROR handlers added to avoid "erroneous views"
- Telegram triggers minor fixes and 3 copies added (for timers flexibility)
Announcement:
- Free Google Spreadsheet Add-on is almost production-ready. Just need to brush HTML popups and tutorial
- Fund Edition version is ready. Here is a short description. Demo video will be soon.
Fund Edition is advanced spreadsheet which helps to organize and manage your own small fund. All Fund's internal processes as automated as possible and as transparent as possible:
* Internal Token Issuance to account all shares of your investors properly;
* Easy accounting to accept the money (entrance) and withdraw the money (redeem internal tokens) in any cryptocurrency with one-click automatic calculations and recording of operations on the Issuance tab;
* Accounting of "Success fee" for all your investors with recording on the Issuance tab;
* Asset Scoring model;
* Special tab for rebalancing calculations with Telegram notifications for "Timer" and "Deviation" approaches;
* Easy way to create a "public" version for your fund's spreadsheet and setup automatic synchronization between private and public spreadsheets;
* "Exchanges Balance Synchronization" feature is included;
* "Telegram Triggers" feature is included;
* "Historical Data Writer" feature is included;
* Automatic writing of all fund's performance and history as well;
My Telegram https://t.me/acosmos
November 23, 2017, 10:11:56 AM
Thank you for understanding!
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters
Any news from here? 😁
October 29, 2017, 02:35:09 PM
Thank you for understanding!
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters
Checked OP bro. Awesome project you are doing. If you need to person to help in macro and make a script for you please contact me anytime. I am currently looking out for the project such as web maintenance, front end development and Macro works since I have experience in all these fields I have mentioned.
October 29, 2017, 12:38:41 PM
Thank you for understanding!
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters
Actually I am going to share this spreadsheet as a free Add-on for google spreadsheets, but with some paid-features like a balance sync, telegram alerts, historical data wirters
October 29, 2017, 12:02:35 AM
I think you have done a good job with the spreadsheet. I have developed my own, although not as sophisticated as yours, but still gets the job done. I will patiently take a look at your video, because I could learn some things for you. Also, thank you for sharing with the community your work, I think it helps a lot of folks out there.
October 28, 2017, 10:22:37 AM
Yes it is real-time. Yes you can setup triggers and timers to update spreadsheet (even when it closed) every 1 minute.
I am do not use any plugin. This is a separate spreadsheet.
I will update the "genesis spreadsheet" where you will have access (with "make copy" right) forever.You need to make your own copy to your Google drive. File > Create a copy.
I am do not use any plugin. This is a separate spreadsheet.
I will update the "genesis spreadsheet" where you will have access (with "make copy" right) forever.You need to make your own copy to your Google drive. File > Create a copy.
October 28, 2017, 09:29:28 AM
So what plugin are you using for this?
There is a plugin freely availabel but it doesn't update fast enough, it only updates at certain times.
IS your spreadsheet dynamic (real-time) ?
There is a plugin freely availabel but it doesn't update fast enough, it only updates at certain times.
IS your spreadsheet dynamic (real-time) ?
October 27, 2017, 10:37:19 AM
what is the price now for this app. Bitcoin is going up and i think 0.02 is a big amount.
Can you send me a price on PM?
Can you send me a price on PM?
October 02, 2017, 09:18:06 PM
Very nice spreadsheet and author is very helpful if needed!
September 30, 2017, 04:31:12 AM
It is a very interesting thing. Have you no any demo options to try? With limited edit access or something. I need this and i plan to make my own app, but seems this is much easier
September 23, 2017, 12:49:32 PM
UPDATE 22.09.2017
1. One click balance synchronization for Bittrex, Poloniex, Liqui added
2. 24h change % in BTC added on Portfolio sheet
1. One click balance synchronization for Bittrex, Poloniex, Liqui added
2. 24h change % in BTC added on Portfolio sheet
August 30, 2017, 03:44:14 PM
Now the price is 0.02 btc
August 30, 2017, 03:04:12 PM
Price only in PM? It's very hight? Discounts are available? I'm only start trading cryptocurrency.
August 30, 2017, 11:34:51 AM
UPDATE
July 09, 2017, 08:42:10 AM
Please PM me the price
July 06, 2017, 01:52:45 AM
UPD:
1. CMGR function added.
Now you can see CMGR (Compound Month Growth Rate) for your assets
2. Automatic performance logging added.
Now you set a Timer to write your Portfolio Performance
New screenshots:
http://imgur.com/7P4lD8I.png
http://imgur.com/l8PUqPr.png
1. CMGR function added.
Now you can see CMGR (Compound Month Growth Rate) for your assets
2. Automatic performance logging added.
Now you set a Timer to write your Portfolio Performance
New screenshots:
http://imgur.com/7P4lD8I.png
http://imgur.com/l8PUqPr.png
How do I get the spreadsheet?
Thanks
July 05, 2017, 10:22:44 AM
UPD 05.07.2017
Ticker function updates and fixes:
- More reliable and fast work
- Crypto to Crypto conversion. For example =ticker("EOS";"ETH")
Ticker function updates and fixes:
- More reliable and fast work
- Crypto to Crypto conversion. For example =ticker("EOS";"ETH")
June 16, 2017, 12:59:30 PM
UPD:
1. CMGR function added.
Now you can see CMGR (Compound Month Growth Rate) for your assets
2. Automatic performance logging added.
Now you set a Timer to write your Portfolio Performance
New screenshots:
http://imgur.com/7P4lD8I.png
http://imgur.com/l8PUqPr.png
1. CMGR function added.
Now you can see CMGR (Compound Month Growth Rate) for your assets
2. Automatic performance logging added.
Now you set a Timer to write your Portfolio Performance
New screenshots:
http://imgur.com/7P4lD8I.png
http://imgur.com/l8PUqPr.png
April 25, 2017, 05:37:05 AM
How a google sheet will get update when my portfolio get changed ? DO I need to enter every time I make a change with my portfolio ?
I guess your coverage on wide range of exchanges seems good but are you using any api to get auto update functionality into spread sheet ?
If you take time to explain more on the purpose and real time application of your sheet will be good to understand the use of your hard work.
I guess your coverage on wide range of exchanges seems good but are you using any api to get auto update functionality into spread sheet ?
If you take time to explain more on the purpose and real time application of your sheet will be good to understand the use of your hard work.
I strongly recommend what sonder (or @acosmos on Telegram) did.
This will save me a lot of time.
Vouches from newbie never counts. Better luck next time.This will save me a lot of time.
There are fields that needs to be entered manually: SYMBOL, avg. buy price and amount (but if you store all your wealth (not recommended) on Poloniex - there is a synchronisation using polo API. Yes you need to enable API key in your settings. Make sure that you forbid trades and withdrawals through API key.
Anyway you need to trust Google services because you will store your API key on their cloud servers.
=ticker(asset,main) - function to get coin price. Returns a ticker price. The price is average value aggregated from 52 exchanges using special API
=specific_price(asset,main,exchange) - can get a ticker from specific exchange using specific API
=cmc(asset,option) - return data for one of 700+ coins from coinmarketcap. Available data: d,name,symbol,rank,price_usd,price_btc,24h_volume_usd,market_cap_usd,available_supply,total_supply,percent_change_1h,percent_change_24h,percent_change_7d,last_updated
=get_balance_data() - return a stringified json with all your balances from poloniex
=balance(data,asset) - parse the cell with stringified json and return specific balance
Jump to: