Worldcore price today, WRC marketcap, chart, and info ...

updating a .gs to retrieve CoinMarketCap data following their transition to new API

Hi, I have been using the following simple .gs to pull CoinMarketCap prices but it is broken now with their migration to their new API. I believe the issue lies with "function getCoins()" but I'm not sure how to proceed given CoinMarketCap's guide here: https://coinmarketcap.com/api/documentation/v1/#section/Quick-Start-Guide
var queryString = Math.random();
var ss = SpreadsheetApp.getActiveSpreadsheet(); var ssRates = ss.getSheetByName('Rates'); if (ssRates === null) { ssRates = ss.insertSheet('Rates'); }
var targetCurrency = 'usd'
// Grabs all CoinMarketCap data if (typeof targetCurrency == 'undefined' || targetCurrency == '') {targetCurrency = 'usd'}; var coins = getCoins();
function getCryptoData() {
// Use the value in the 'id' field here: https://api.coinmarketcap.com/v1/ticke?limit=0 // If you're getting errors, you may be using the wrong 'id'
var myCoins = [ '0x', 'adelphoi', 'adx-net', 'aeternity', 'aion', 'aigang', 'airswap', 'appcoins', 'aeron', 'aragon', 'ardor', 'ark', 'aurora-dao', 'banyan-network', 'bitclave', 'bancor', 'basic-attention-token', 'binance-coin', 'bitcoin', 'bitcoin-cash', 'bitcoin-god', 'bitcoin-gold', 'bitcoin-interest', 'bitcoin-token', 'bitcoin-private', 'bitcoinx', 'bitcore', 'bitdegree', 'bitsend', 'bitshares', 'block-array', 'blockmason', 'bytecoin-bcn', 'c20', 'canyacoin', 'cardano', 'chatcoin', 'cheesecoin', 'cindicator', 'civic', 'cofound-it', 'counterparty', 'coss', 'cpchain', 'cybermiles', 'dash', 'datum', 'decred', 'digibyte', 'digixdao', 'district0x', 'dogecoin', 'dragonchain', 'edgeless', 'enjin-coin', 'eboostcoin', 'enjin-coin', 'eos', 'eosdac', 'ethereum-classic', 'ethereum', 'ethlend', 'everex', 'factom', 'filecoin', 'funfair', 'gas', 'gnosis-gno', 'golem-network-tokens', 'groestlcoin', 'guppy', 'havven', 'huobi-token', 'icon', 'iconomi', 'ignis', 'invictus-hyperion-fund', 'iostoken', 'iot-chain', 'iota', 'internet-of-people', 'ixledger', 'kucoin-shares', 'kyber-network', 'legolas-exchange', 'library-credit', 'litecoin', 'lightning-bitcoin', 'maker', 'medical-chain', 'mercury', 'metronome', 'monero', 'nano', 'neo', 'newton-coin-project', 'nexus', 'oax', 'omisego', 'omni', 'odyssey', 'origintrail', 'patientory', 'pivx', 'phore', 'polymath-network', 'power-ledger', 'qash', 'qtum', 'quantstamp', 'raiden-network-token', 'ravencoin', 'rchain', 'reddcoin', 'republic-protocol', 'rialto', 'ripio-credit-network', 'ripple', 'rise', 'rlc', 'salt', 'semux', 'siacoin', 'singulardtv', 'snovio', 'solaris', 'spreadcoin', 'steem', 'stellar', 'storj', 'stratis', 'streamr-datacoin', 'suncontract', 'syscoin', 'telcoin', 'tenx', 'tezos', 'theta-token', 'time-new-bank', 'tron', 'turtlecoin', 'ubiq', 'ultranote-coin', 'vechain', 'verge', 'veriumreserve', 'vertcoin', 'viacoin', 'vibe', 'viberate', 'vinchain', 'wabi', 'waves', 'wax', 'worldcore', 'zcash', 'zclassic', 'zcoin', 'zencash', ]
ssRates.getRange('A1').setValue("ID"); ssRates.getRange('B1').setValue("Symbol"); ssRates.getRange('C1').setValue("Price USD"); ssRates.getRange('D1').setValue("Price BTC");
var myCoinsObj = {}; var myCoinsCount = myCoins.length; for (var i = 0; i < myCoinsCount; i++) { var c = i+2; var n = 0; while (coins[n]['id'] !== myCoins[i]) { n++; }
myCoinsObj[coins[n]['id']] = coins[n]; ssRates.getRange('A'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['id']); ssRates.getRange('B'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['symbol']); ssRates.getRange('C'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['price_usd']); ssRates.getRange('D'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['price_btc']); 
}
// ================================= // // WALLET BALANCE CONFIGURATION // // =================================
// ===== Wallet Sheet Creator ======================================== // Uncomment the lines of code below // It will create the Wallets sheet for you // If using the Wallets sheet ALWAYS leave it uncommented // ===================================================================
//var ssWallets = activeSpreadsheet.getSheetByName('Wallets'); //if (ssWallets === null) {ssWallets = activeSpreadsheet.insertSheet('Wallets');}
// ===== BCH Wallet Balances ========================================= // Uncomment the lines of code below // Set the variable by pasting your Address inside of the ("") // Change getRange('A1') and getRange('B1') to match the row you want // ===================================================================
//var bchWallet = getBchBalance("Your BCH Address"); //ssWallets.getRange('A1').setValue("BCH Wallet"); //ssWallets.getRange('B1').setValue(bchWallet);
// ===== BTC Wallet Balances ========================================= // Uncomment the lines of code below // Set the variable by pasting your Address inside of the ("") // Change getRange('A2') and getRange('B2') to match the row you want // ===================================================================
//var btcWallet = getBtcBalance("Your BTC Address"); //ssWallets.getRange('A2').setValue("BTC Wallet"); //ssWallets.getRange('B2').setValue(btcWallet);
// ===== Ethereum Wallet Balances ==================================== // Create an account on Etherscan.io // Create an API key at https://etherscan.io/myapikey // Uncomment the lines of code below // Set the API key variable by pasting your API key inside of the ("") // Set the address variable by pasting your Address inside of the ("") // Change getRange('A3') and getRange('B3') to match the row you want // ===================================================================
//var ethApiKey = "Your Etherscan API Key"; //var ethWallet = getEthBalance(ethApiKey,"Your ETH Address"); //ssWallets.getRange('A3').setValue("ETH Wallet"); //ssWallets.getRange('B3').setValue(ethWallet);
// ===== DGB wallet balances ========================================= // Uncomment the lines of code below // Set the variable by pasting your Address inside of the ("") // Change getRange('A4') and getRange('B4') to match the row you want // ===================================================================
//var dgbWallet = getDgbBalance("Your DGB Address"); //ssWallets.getRange('A4').setValue("DGB Wallet"); //ssWallets.getRange('B4').setValue(dgbWallet);
// ===== LTC wallet balances ========================================= // Uncomment the lines of code below // Set the variable by pasting your Address inside of the ("") // Change getRange('A5') and getRange('B5') to match the row you want // ===================================================================
//var ltcWallet = getLtcBalance("Your LTC Address"); //ssWallets.getRange('A5').setValue("LTC Wallet"); //ssWallets.getRange('B5').setValue(ltcWallet);
// ===== VTC wallet balances ========================================= // Uncomment the lines of code below // Set the variable by pasting your Address inside of the ("") // Change getRange('A5') and getRange('B5') to match the row you want // ===================================================================
//var vtcWallet = getVtcBalance("Your VTC Address"); //ssWallets.getRange('A6').setValue("VTC Wallet"); //ssWallets.getRange('B6').setValue(vtcWallet); }
function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var menubuttons = [ {name: "clearRates", functionName: "clearRates"},{name: "getCryptoData", functionName: "getCryptoData"}]; ss.addMenu("crypto", menubuttons); }
function clearRates() { var sheet = SpreadsheetApp.getActive().getSheetByName('Rates'); sheet.getRange('A1:D1000').clearContent(); }
function getCoins() {
var url = 'https://api.coinmarketcap.com/v1/ticke?limit=0&convert='+targetCurrency; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var json = response.getContentText(); var data = JSON.parse(json);
return data; }
function getBchBalance(bchAddress) {
var url = 'https://bitcoincash.blockexplorer.com/api/add'+bchAddress+'/balance'; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var balance = response.getContentText(); //Pause to not trigger API limit for multiple wallets Utilities.sleep(300);
return balance * Math.pow(10,-8); }
function getBtcBalance(btcAddress) {
var url = 'https://blockexplorer.com/api/add'+btcAddress+'/balance'; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var balance = response.getContentText(); //Pause to not trigger API limit for multiple wallets Utilities.sleep(300);
return balance * Math.pow(10,-8); }
function getEthBalance(ethApiKey,ethAddress) {
var url = 'https://api.etherscan.io/api?module=account&action=balance&address='+ethAddress+'&tag=latest&apikey='+ethApiKey; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var json = response.getContentText(); var obj = JSON.parse(json); var balance = obj.result; //Pause to not trigger API limit for multiple wallets Utilities.sleep(300);
return balance * Math.pow(10,-18); }
function getDgbBalance(dgbAddress) {
var url = 'https://chainz.cryptoid.info/dgb/api.dws?q=getbalance&a='+dgbAddress; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var balance = response.getContentText(); //Pause to not trigger API limit for multiple wallets Utilities.sleep(300);
return balance; }
function getLtcBalance(ltcAddress) {
var url = 'https://chainz.cryptoid.info/ltc/api.dws?q=getbalance&a='+ltcAddress; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var balance = response.getContentText(); //Pause to not trigger API limit for multiple wallets Utilities.sleep(300);
return balance; }
function getVtcBalance(vtcAddress) {
var url = 'http://explorer.vertcoin.info/ext/getbalance/'+vtcAddress; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var balance = response.getContentText(); //Pause to not trigger API limit for multiple wallets Utilities.sleep(300);
return balance; }
// USE AT YOUR OWN RISK function getRate(currencyId) {
if (typeof targetCurrency !== 'undefined') {conversionRate = 'usd'};
var url = 'https://api.coinmarketcap.com/v1/ticke' + currencyId + '/?convert=' + targetCurrency; var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var json = response.getContentText(); var data = JSON.parse(json); var obj = parseFloat(data[0]['price_' + targetCurrency]);
return obj; }
function getWebRate(currencyId) { //Example Output: // '=IMPORTXML("https://coinmarketcap.com/currencies/zeeyx?3908288283","//span[@id=\'quote_price\']")';
var coinScrape1 = '=IMPORTXML("https://coinmarketcap.com/currencies/'; var coinScrape2 = '","//span[@id=\'quote_price\']")';
return coinScrape1 + currencyId + '?' + queryString + coinScrape2; }
function getCurrencyConversion(currencyOne, currencyTwo) {
var url = 'https://api.fixer.io/latest?symbols='+currencyOne.toUpperCase()+','+currencyTwo.toUpperCase(); var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true}); var json = response.getContentText(); var data = JSON.parse(json);
return parseFloat(data['rates'][currencyTwo]); }
submitted by neekolas86 to GoogleAppsScript [link] [comments]

#WRC #worldcore token trading is now live on #OkCoinKorea Okcoinkr exchange

WRC #worldcore token trading is now live on #OkCoinKorea Okcoinkr exchange (https://www.okcoinkr.com/\). Great news for Korean community #blockchain #bitcoin #ethereum #fintech #crypto #bittrex #binance #ico #tokensale #crowdsale

submitted by wcore to worldcore [link] [comments]

Buying bitcoin: Binance or Coinbase?  Bitcoin Basics (86 ... Bitcoin Trading Guide If You're Trading Indian Market ... how to open Binance exchange to buy bitcoin&cryptocurrency ... Warren Buffet + Bitcoin, Crypto Goes Sideways, Bitcoin Paradigm Shift & US Crypto Bank BITCOIN Outperforms Nasdaq & S&P - Bitmex Bitcoin Bond - IMF World Bank Learning Coin - Binance Data Ted Lin - Binance: Record $816M in Bitcoin leaves Binance — Are whales ... 60 New Abra Coins, Binance Chain Phone, Crypto APR & Bitcoin Fork Price Manipulation Binance New Lending Coins, ETH On BitPay, Fiat To Crypto & Bitcoin ETF SEC Report

Since the launch of Binance.com in July 2017, we have been continuously working hard to increase the freedom of money for people around the world. Overcoming obstacles, building new solutions, and growing our community, we have rarely stopped to put into words what drives us as an organization at our core. Today, as we reflect on Year 3 and look ahead with an infinite mindset, we want to share ... Worldcore price today is $0.000137 USD with a 24-hour trading volume of $0.205172 USD. Worldcore is up 1.30% in the last 24 hours. The current CoinMarketCap ranking is #2078, with a market cap of $24,359.90 USD. It has a circulating supply of 178,103,291 WRC coins and the max. supply is not available. The top exchanges for trading in Worldcore are currently Worldcore. Menü . Suche. Suche nach: ... (NFT), een Bitcoin Code (Bitcoin Code) geïnspireerd kunstwerk van Robert Alice, veilen. Zoals Cointelegraph al aangaf, inspireerde Robert Alice, een kunsthistoricus, zich op de codebase van Bitcoin Code om een serie van 40 schilderijen te maken die zich over 50 meter uitstrekken. Het Portret dat Portrait of a Mind wordt genoemd, is een handgemaakt ... "Bitcoin is digital cash, stored as records in electronic form, just like the money on debit or credit cards. You can't physically hold them, but you can use them to pay for goods and services, transfer money globally, or invest in them. This all happens on a virtual network called the blockchain, operated by individuals and businesses called miners. Die Börse unterstützt derzeit Bitcoin, Ethereum, Bitcoin Cash, DASH, Litecoin und natürlich Worldcores WRC-Token. Der Austausch ist die Entwicklung der produktivsten und innovativsten Programmiersprache Golan (auch Go genannt), die 2009 von Google für die Entwicklung eigener Software entwickelt wurde. Die Website von Worldcore.trade funktioniert als Einzelseitenanwendung ohne erneutes ... CZ Binance, CEO of Binance, twitted: “#Bitcoin was conceived (not born) 12 years ago on this day. A 9 page white paper evolved into $250 billion dollars in market cap today, with no fund raising, no marketing budget, no office, and no paid staff.” Many people believe the best is yet to come for Bitcoin. Tyler Winklevoss, Co-founder and CEO of Gemini, believes Bitcoin price will hit an all ... Some blockchains keep their most of their development private, such as the Binance Chain.↩ 7-day average between August 14 2019 and August 20 2019. Data from Coinmetrics and Blockchair.↩ Data as of August 12th 2019.↩ Data as of August 12th 2019.↩ Sources: Binance DEX, Binance Chain explorer↩ Der aktuelle Binance Coin/Worldcore Kurs BNB/WRC - Währunsgrechner für den Wechselkurs von Binance Coin in Worldcore. Binance CEO Denies 'Tai Chi' Bitcoin Regulation Evasion Scheme A leaked document purportedly from Binance senior executives outlines a plan to use a US subsidiary to evade regulators. By Jeff Benson. 4 min read. Oct 29, 2020 Oct 30, 2020. Binance is one of the largest cryptocurrency exchanges in the world (Image: Shutterstock) In brief . Forbes has reported that Binance had a secret plan to ... Withdrawing Bitcoin from your Binance account is very straight-forward. After making sure that your Binance account is safe to use and is fully verified, you can proceed with performing deposit and withdrawal transactions. Here, you will find steps that you can follow in withdrawing Bitcoin from your Binance account. Click this to access the platform. Once the site is up, log-in with your ...

[index] [18784] [632] [258] [22085] [7214] [8548] [3561] [16305] [24105] [9298]

Buying bitcoin: Binance or Coinbase? Bitcoin Basics (86 ...

Buy Bitcoin on: https://coincompass.com/binance https://coincompass.com/coinbase Should I buy bitcoin on Coinbase or Binance? A comprehensive, pragmatic & be... My Second Channel: https://www.youtube.com/channel/UCvXjP6h0_4CSBPVgHqfO-UA ----- Supp... Bitcoin Trading Guide If You're Trading Indian Market Binance ***** More Info ***** Website Link: https://nextlevelbot.com/ Binance... - Bitcoin Outperforms Nasdaq 100, S&P 500, Grows Whopping 37% in 2019 - Arthur Hayes: BitMEX Is Considering Issuing Short Term Bitcoin Bonds - Cryptocurrency Price Trends Could Signal End of Bear ... Off The Chain #238: PlanB on Why Bitcoin’s Stock-To-Flow Model Is Becoming More Accurate Over Time - Duration: 1:05:59. Anthony Pompliano 41,748 views 1:05:59 My Second Channel: https://www.youtube.com/channel/UCvXjP6h0_4CSBPVgHqfO-UA ----- Supp... Welcome back to the no BS blockchain channel covering bitcoin, cryptocurrency and everything around FinTech. Episode 9 is with the Ted Lin, CGO of Binance, the most popular and innovating crypto ... Binance saw its biggest Bitcoin ( BTC ) outflow in history on Nov. 3, according to data from CryptoQuant. A total of 58,861 BTC were withdrawn on a single da... how to open Binance exchange to buy bitcoin #cryptotradingexchange #binance # howtoopen Binance link: https://www.binancezh.pro/en/register?ref=XW91KRSO buyi...

#