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,713
    Likes Received:
    2,639
    Occupation:
    blog creator
    Location:
    UK
    Shouldn't this be in the giveaway section?
     
  3. tb303

    tb303 Power Member

    Joined:
    Dec 18, 2011
    Messages:
    764
    Likes Received:
    436
    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:
    521
    Likes Received:
    247
    Gender:
    Male
    Occupation:
    Student / Entrepreneur
    Location:
    Boston, MA
    Home Page:
    I really want thisz
     
  5. luke6966

    luke6966 Regular Member

    Joined:
    Sep 30, 2013
    Messages:
    405
    Likes Received:
    42
    Nice, pming you
     
  6. bmanfacts

    bmanfacts Junior Member

    Joined:
    Jul 29, 2015
    Messages:
    120
    Likes Received:
    34
    Occupation:
    Blogging, Content Creating, Thinking, Doing.
    Location:
    Somewhere Intelligent
    Sending a PM to you!
     
  7. Riders On The Storm

    Riders On The Storm Jr. VIP Jr. VIP

    Joined:
    Feb 27, 2012
    Messages:
    1,267
    Likes Received:
    513
    Why the link is not posted?
     
  8. omoba4real

    omoba4real Newbie

    Joined:
    Nov 6, 2015
    Messages:
    1
    Likes Received:
    0
    Please can you send me the links to download this?
     
  9. joeb1ow

    joeb1ow Regular Member

    Joined:
    Oct 26, 2014
    Messages:
    397
    Likes Received:
    119
    @bondoleg Y u no comment? making it pointless to pm you

    List your skype on your profile or another way to contact you
    You can always post here or in download or giveaway section
     
  10. baong1212

    baong1212 Newbie

    Joined:
    Feb 27, 2014
    Messages:
    33
    Likes Received:
    9
    Please send me the link
     
  11. Simply Social

    Simply Social Jr. VIP Jr. VIP

    Joined:
    Aug 28, 2010
    Messages:
    838
    Likes Received:
    85
    upload the link here
     
  12. Nitefawkes

    Nitefawkes Newbie

    Joined:
    Oct 26, 2015
    Messages:
    1
    Likes Received:
    0
    I would love a link to this. I was looking to modify an older one that was on Github but this fits the bill perfectly.