1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Google Spreadsheet for real time market data from 52 exchanges and coinmarketcap

Discussion in 'CryptoCurrency' started by bondoleg, Apr 20, 2017.

  1. bondoleg

    bondoleg Newbie

    Joined:
    Jan 12, 2017
    Messages:
    2
    Likes Received:
    0
    Recently I made a Google Spreadsheet for myself to monitor my portfolio of cryptocurrencies and market data .
    What it can do:

    1. Monitoring of prices in real time. 14 exchanges are supported: BitFinex, Bitstamp,Bittrex,Bleutrade,BTC-E,C-Cex,Cex IO,Exmo,HitBTC,Indacoin,Kraken,Kuna,Livecoin,Poloniex,YoBit - You can get average price or "specific exchange" price.
    2. Send message to Telegram in case if the price hits the "goal"
    3. Have functions to convert to any Ticker to currency: "AUD", "BRL", "CAD", "CHF", "CNY", "EUR", "GBP", "HKD", "IDR", "INR", "JPY", "KRW", "MXN", "RUB"
    4. Pulls up the current table for all currencies from coinmarketcap
    5. Pulls up a list of new coins that appear on exchanges (from coinmarketcap)
    6. Get market data for 700+ coins from coinmarketcap. You can easy get these data for any coin using simple function =cmc(asset,option): id,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
    7. Get a real time balances from poloniex (polo only)

    Google Spreadsheet works in the cloud (for free). There is no need to have a server. The entire installation is to just make a copy of table to your Google Drive.

    I have tried to did everything as simple as possible. Everyone will be able to reconfigure by itself. Who wants the same spreadsheet - touch me in PM

    Screenshots:
    [​IMG]
    [​IMG]
    [​IMG]
     
  2. blogzandstuff

    blogzandstuff Elite Member

    Joined:
    Jan 1, 2015
    Messages:
    5,172
    Likes Received:
    2,388
    Occupation:
    blog creator
    Location:
    UK
    Shouldn't this be in the giveaway section?
     
  3. tb303

    tb303 Power Member

    Joined:
    Dec 18, 2011
    Messages:
    734
    Likes Received:
    388
    Im interested for a look. But whats the point in PMing you for the link as you cant do PM's yet?

    Can you post the link here instead?
     
  4. TheFreshPrince

    TheFreshPrince Jr. VIP Jr. VIP

    Joined:
    Jan 11, 2014
    Messages:
    519
    Likes Received:
    246
    Gender:
    Male
    Occupation:
    Student / Entrepreneur
    Location:
    Boston, MA
    Home Page:
    I really want thisz
     
  5. luke6966

    luke6966 Regular Member

    Joined:
    Sep 30, 2013
    Messages:
    395
    Likes Received:
    40
    Nice, pming you
     
  6. bmanfacts

    bmanfacts Registered Member

    Joined:
    Jul 29, 2015
    Messages:
    98
    Likes Received:
    38
    Sending a PM to you!