Hello everyone!

I have a ready-made system in Google Sheet that completely automates the processes of managing paid subscriptions to private telegram channels and chats.

What can it do?

• Easy setup of individual Telegram bot, that will receive payments and kick/invite subscribers, notify about the upcoming end of a subscription.
• Keep a record of active users
• Keep an editable record of all transactions and summarize the date of active subscription for each subscriber
• Receiving of payments through Telegram Payments: Yandex, Sberbank, Tranzzo, Stripe, Paycom.uz, CLICK Uzbekistan, Rave by Flutterware, LiqPay
• Keep a record of all transactions and calculates dates of active subscription for each subsciber
• Sending the invite link hidden by button
• Automatic kicking (banning) of subscribers if a subscription is ended
• Customization of all texts, button, prices, subscription plans inside the bot through editing cells in the Google Sheets

I am selling the copy with the setup and support for 150$.
Also, I can help you to scrape and fill the Google Sheet with your existing subscribers and their payments.
Touch me in telegram https://t.me/acosmos if you are interested  

Hi,

I have built the Google Spreadsheet for Historical Market Data Recording & Strategy Backtesting and Telegram signaling. All processes are 100% automated.

Features:

- Load historical cryptocurrency market data from 22 exchanges: Binance, Bisq, Bit-Z, BitBay, Bitfinex, bitFlyer, Bithumb, BitMEX, Bitstamp, Bittrex, CEX.IO, Coinbase Pro, Coinone, CryptoFacilities, Gate.io, Gemini, HitBTC, Huobi, Kraken, Liquid, Luno, OKCoin, Okex, Poloniex, Quoine

- Historical OHLCV data for all available cryptocurrency trading pairs from the time a pair is started trading on the particular exchange. Timeframes: 5m, 15m, 30, 1H, 2H, 4H, 1D, 1W

- The spreadsheet will continue to append new data automatically every 5 min and send notifications. All market data is provided without delays

- Build your strategy with formulas (just insert your formulas in columns near data) and formulas will continue to be added automatically and generate your signals. Perfect for running powerful strategies without any coding!

- Instant notifications to Telegram. Get custom text messages by any event/signal/trigger. Easy setup. Just type the text you want and reference to the cell with (true/false) value to monitor. The spreadsheet will check your triggers every 5 minutes and send messages to your Telegram chat, group chat or channel automatically. Perfect for signaling!

- Strategy Backtesting.  Click the button and get the backtesting performance report with charts for your strategy in seconds. Compare your strategy vs Buy & Hold, see PL, trades count, fees paid and other statistics

Demo video:
https://www.youtube.com/watch?v=92Hw4zuy5vQ

To get the copy - leave your request by the link:
https://spreadsheet.fund/crypto-historical-data-recorder

The number of copies - is limited!

Check out the video "How to setup the Spreadsheet Fund Add-on for Google Sheets"

https://www.youtube.com/watch?v=K10sfTCsERo

UPD

I have released it as a free Gsheet Addon. Install here:
https://chrome.google.com/webstore/detail/spreadsheet-fund/pkjmaijhdpkmfogpmfaennidncpdgmbl

UPD 23 February 2019

1. Ethereum cold wallets parser added
2. Proper Success Fee mechanism (individual accounting of success fee for each customer, a transaction in internal token)

UPD 25 November 2018

Fixes caused by Coinmarketcap API changes.
The completely new and reliable mechanism of getting the median price from six sources.

1. The "ticker" function firstly retrieve data from: binance, okex and cryptocompare.
2. If none of them returns data, the script tries to get data from: kucoin, bittrex and coinmarketcap (new api version)
3. If none of them returns data - the ticker function will return 0

UPD 21 September 2018

Added multiple balance sync from the same exchange.

Now you can setup any number of accounts (API keys pair) for the same exchange. For example three account for Binance, two accounts for Kraken, etc
And synchronize all accounts in one total balance

UPD 13 May 2018

Get stats about your Fund in Telegram, as often as you set the Timer.

UPD 27 April 2018

• No "dust" synchronization.
To avoid synchronization of small amounts (dust) in the spreadsheet - now you can set a minimum USD balance that must be synced from exchanges.

UPD 20 April 2018
- Added 7d mini graphs on Portfolio Tab (to USD)

https://imgur.com/8Y5ox8z.jpg


Guys thank you for your interest! I will make English subtitles on theese Video tutorials soon:

https://www.youtube.com/watch?v=DsUIZHrcmuw
https://www.youtube.com/watch?v=Wi_YTnJzqKw
https://www.youtube.com/watch?v=elhsQiWg094
https://www.youtube.com/watch?v=tIOrs--WZGk

UPD 11 April 2018

Bitfinex balance synchronization is added.

To this moment you can sync balances from 10 exchanges:
- Binance
- Bittrex
- Bitfinex
- Kraken
- Poloniex
- Liqui
- HitBTC
- Bitstamp
- KuCoin

No you don't need to be online. The idea will not work if you must be online:)

The usage is something like:
1. Install bot
2. Send your ETH address
3. Forgive
4. Meanwhile Bot will check your balances every 30 seconds
5. If any incoming/outgoing transactions of ETH or ERC20 tokens occurs - you will get instant notification

We use Google Cloud Engine to host backend. The CPU usage of Google Cloud Services increasing in linear with every new addresses.

Thank you for feedback!
/addToGroup is the command to setup notifications for group chats. Need to forward the message to the group you want to get alerts.

We can not provide multiple addresses now, because the monitoring of one address takes a significant amount of CPU resources. Because the bot is free - we can provide only one address. Perhaps in the future the number of addresses will increase.

Good request for BTC addresses - we will think about more powerfull bot with BTC and altcoins monitoring. Thank you!

Here is the app https://myeth.io/ which will watch your wallet's addresses 24/7 and notify you in case of any movements of funds.

Also the app can send custom webhook along with notification

UPD 24 March

- Kraken balance sync added
- Bitstamp balance sync added
- KuCoin balance sync added

Below is a screenshot of Google Spreadsheet which helped me to create my investment portfolio for 2018.
I want to share this tool with community
https://docs.google.com/spreadsheets/d/1wNWU8DtdO9LqajZW6egKt5r7TTqBvvjvm-5QtSsEo3M/edit?usp=sharing

Go to File > Create a copy to get editable copy to your Gdrive

https://imgur.com/ThwTxw7.jpg

How can this spreadsheet be useful for a novice and experienced investor?

1.The investor can classify blockchain assets into different sections (add his own sections) and evaluate these classes.

Example of classifications I used:

by directions: currency, smart-contracts platforms, privacy, dex, funds/investments, payments, lending, governance, VPN, identity, stable coins, decentralized computing, decentralized storage, mesh networks, energy, others. Of course, this is not a complete list, this classification is partially taken from here https://techcrunch.com/2017/10/16/mapping-the-blockchain-project-ecosystem/
by token type: equity the token security token, the token utility, base level, pegged token, asset-backed token
by consensus algorithm: Proof-of-Stake, Proof-Of-Work, dPoS, PoW+PoS, Proof-of-Importance, DAG, Loop-Fault-Tolerance, Byzantine-Fault-Tolerance, Proof-of-Authority, Proof-of - Weight, Federated Byzantine Agreement
by risk: storage facility, medium risk, high risk, extreme risk, Fiat
by age of the project: from 5 years, 2-5 years, 6 months-2 years, up to 6 months, ICO
by market capitalization: TOP 10, TOP 10-50, 50-150 TOP, TOP 301-600, TOP 600+
by turnover: 50%+, 30-50%, 10-30%, 5-10%, 2-5%, 0,5-2%, 0-0,5%
The idea is to give fundamental estimates and plan a portfolio within frames of each classification. It is easier not to look away at the name and brand of coins, and focus on specific fundamental ideas. For example, I allocate 26.9% for smart-contracts platforms, and 13.8% for currencies, 7.2% for privacy and etc.

It's all subjective, so you can (and good) to change the classification in your own way.

2. As the classifications are ready, the next step is to match blockchain assets to them.

Here you will find a painstaking intellectual work. For example, I made a classification for the first 20 assets by capitalization (see screen) - NOTE there are subjective errors!

https://imgur.com/eoZn2f2.jpg

The good news is that classifications for capitalization and turnover - works in automatic mode. Up-to-date data is taken from coinmarketcap at each launch, and assets are sorted by capitalization and trading volume data is also updated.

However, this can cause failures in the classification, because the assets change their positions! Therefore it is necessary to check everything before the third step

3.The idea is to sum up all the scores by classifications and get a total score for each asset that has ON (i.e. selected for portfolio)

Because not all classifications are equivalent. You can adjust the "weight" of each classification by simply selecting a different scale for the scores. For example, for "by directions" use from 1 to 100, and for "by turnover" from 1 to 10.

After pressing the button "Recalculate points" on the "Builder" tab will appear this final table.

https://imgur.com/fdhkfhb.jpg

As can be seen here:

all assets that are included in the portfolio are their total score.
share % in the portfolio
current price (from coinmarketcap)
the quantity of asset, how much the actual pieces to buy
The value in $
The value in someothercurrency.
Exchange name
Why we need exchange name and volume in someothercurrency? Well, a typical situation, your first BTC lie on localbitcoins or on your wallet and in waiting until you spend them for your portfolio. And here it is necessary to understand exactly how many BTC on every exchange need to be sent? Columns (I) and (J) refer to this point.
And since the BTC is not the cheapest transaction currency, it is possible to calculate in any other crypto. For example, in ETH

Like if it turned out to be useful for you!
We're in Telegram https://t.me/encryptmymoney

The link here. Need to make a copy of itself using the File > make a copy.
https://docs.google.com/spreadsheets/d/1wNWU8DtdO9LqajZW6egKt5r7TTqBvvjvm-5QtSsEo3M/edit?usp=sharing

UPD 24 January 2018

1. API Balance synchronization for Binance and HitBTC added
2. SuccessFee is automatically calculated for specific period (from and till date)
3. Internal tokens transfer functionality added. Now you can just send tokens from one client to another.
4. Quick 3rd currency change. Change only one cell - all others will apply automatically

Bugs fixed:
- Price function =ticker is improved. Now it more pretty and try to get price directly from bittrex, if no - from cryptocompare, if no - from coinmarketcap, if no - from cryptonator. For example: prices for RDN and AST is working correctly now
- Exchange balance sync is enhanced
- Performance K column bug is fixed
- Minor code optimizations

To get the spreadsheet - make order on the Gumroad: https://gum.co/UMxwE

UPD 10.12.2017

The new Fund Edition Spreadsheet is ready. You can learn more in new thread:
https://bitcointalk.org/index.php?topic=2559144

I have faced with the lack of tool to manage my own small family crypto-investment fund.
The main problem was in complexity to calculate all shares of investors properly, especially in the conditions of constant input and withdrawal of funds.

I decided to build a special Google Spreadsheet which helps to organize and manage your own small fund (thanks to google apps script language) with internal token issuance. All Fund's internal processes as automated as possible and as transparent as possible.

Functionality:
• Internal Token Issuance to account all shares of your investors properly (like Satoshi Pie);
• Easy entrance and withdrawal in any cryptocurrency with one-click automatic calculations, tokens emission/redeem and recording of operations on the Issuance tab;
• Easy management of your fund's cold wallets/exchange storages. Automatic balance synchronization for Poloniex, Bittrex, Liqui, HitBTC, Binance, Kraken, KuCoin, Bitstamp
• Real-time exchange rates for 1200+ crypto and 32 fiat currencies. 5 different sources of data + function to get a median price;
• Tab to account all investor's shares, balances and profit stats;
• Accounting of "Success fee";
• Accounting of Entrance/Redeem/Referal fee with customization;
• Asset Scoring model;
• Tab for rebalancing calculations with Telegram notifications for "Timing" and "Deviation" approaches;
• Easy way to create a "public" version for your fund's spreadsheet and setup automatic synchronization between private and public spreadsheets;
• Automatic Triggers to get "custom-text" notifications about any custom event in your Spreadsheet to your Telegram chat, group chat or channel
• "Historical Data Writer" is a flexible way to write any custom historical data in any time you want;
• Automatic writing of all fund's performance and history as well;
• Real-time portfolio value & internal token price monitoring;
• Easy fund initialization and setup. No coding skills required;

I have recorded video tutorials to describe the most important processes. Check it to get more insights:
General review: https://www.youtube.com/watch?v=DsUIZHrcmuw
Initial setup: https://www.youtube.com/watch?v=Wi_YTnJzqKw
Entrance/Redeem: https://www.youtube.com/watch?v=elhsQiWg094
Success fee: https://www.youtube.com/watch?v=tIOrs--WZGk

UPD
I have released it as a free Gsheet Addon. Find more here:
https://spreadsheet.fund/