Auroracoin (AUR) price, charts, market cap, and other ...

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]

How to transfer Litecoin or Bitcoin from Coinbase to Binance Binance Bitcoin exchange - (BTC ETH LTC BCH XRP) Binance.com Binance Coin (BNB) makes new all-time high against Bitcoin I’ve Changed My Mind on Binance!! BNB #1 Altcoin!? Bitcoin Back to $5400, Binance Coin (BNB) Pumps  Bitcoin and Cryptocurrency News How to buy and sell Cryptocurrencys on Binance. BitCoin ... How to Transfer Bitcoin From Coinbase to Binance!  QUICK TUTORIAL!

Binance kriptopara borsası - Dünyanın en yüksek hacimli bitcoin ve altcoin borsasını işletiyoruz Binance cryptocurrency exchange - We operate the worlds biggest bitcoin exchange and altcoin crypto exchange in the world by volume Aurora price today is $0.001655 USD with a 24-hour trading volume of $1,600,157 USD. Aurora is up 11.22% in the last 24 hours. The current CoinMarketCap ranking is #477, with a market cap of $10,826,436 USD. It has a circulating supply of 6,542,330,148 AOA coins and the max. supply is not available. The top exchanges for trading in Aurora are currently Bithumb, MXC.COM, KuCoin, Coinone, and ... Step by step overview on how to deposit Bitcoin on Binance. Adding funds into your Binance account can be done by depositing cryptocurrencies like Bitcoin. After making sure that your Binance account is safe to use and is fully verified, you can proceed with performing deposit transactions. Here, you will find steps that you can follow in funding your Binance account. Click this to access the ... Binance’s technology is used by more than 30 exchanges around the world today, including Binance Uganda. Binance Jersey brings a world-class trading experience. Binance – Exchange And Login For Trade. Here are a few reasons why Binance is the best place to start. Secure and Reliable State-of-the-art safe storage technology for maximum ... No change in the last 24 hours Down -99.96% since all time high Auroracoin to USD Price Converter. 24 Hour Low/High: Low 24h: $0 High 24h: $0 All Time High: $97 (March 4th, 2014) Auroracoin price prediction in 24 hours time: No Price Prediction BTCBitcoin. $10,549.83 +0.24%. ETHEthereum. $345.00-1.4%. USDTTether. $1.00 +0.32%. XRPXRP. $0.2328520000-1.35%. BCHBitcoin Cash. $219.12-2.15% ... Comment acheter Aurora en 2020? Trouverez ici le guide complet pour l'achat de la crypto-monnaie. Courtiers Échanges Modes de paiement Prix . Bitcoin. €8,200.00. 2.13. Ethereum. €189.77. 1.42. Bitcoin Cash. €224.22. 0.60. Altcoins Ethereum Ripple NEO Tron EOS Litecoin IOTA Dash Bitcoin Cash Cardano Zcash Bitcoin Gold Ethereum Classic Binance Coin Bitcoin Acheter Bitcoin Bitcoin Prix ... Coin Mineable Hybrid - PoW & PoS Scrypt; Charts; Market Pairs. Social; Tools; Historical Data; Ratings; On-Chain Analysis; News ; About Auroracoin. Auroracoin price today is $0.069857 USD with a 24-hour trading volume of $211.75 USD. Auroracoin is down 0.22% in the last 24 hours. The current CoinMarketCap ranking is #1091, with a market cap of $1,262,905 USD. It has a circulating supply of ... Benutze den Investing.com Währungsrechner um die Konversion von BNB zu BTC Binance zu berechnen. Der Preis ist an den Echtzeitkurs gebunden. Binance, the #1 spot cryptocurrency exchange in the world with USD 0.5-1 billion of daily trading volume, will launch the Binance decentralized exchange (DEX) in early 2019.. A video preview and the launch of its own blockchain has seen a major rally for its native token, BNB, with its market cap increasing USD 150 million, rocketing it to #13 on CoinMarketCap with a market cap of USD 800 million.

[index] [12056] [23668] [1617] [21117] [15815] [17984] [9451] [5529] [10929] [3241]

How to transfer Litecoin or Bitcoin from Coinbase to Binance

Chico Crypto has changed his heart regarding Binance? The exchange just acquired Coinmarketcap, and now controls crypto largest data aggregator!! Is 2020 the year Binance gets complete control ... I walk you through how to transfer bitcoin from coinbase to Binance in a few, easy steps! If you are wondering how to move bitcoin from coinbase to binance, or vice versa, then I have you covered. Bitcoin's Price is back to $5400. The market is shaking off the Tether FUD. Let's discuss and also take a look at BNB. Become a CryptosRus INSIDER to gain exclusive insight on the market, get ... Welcome back to Coin Rivet TV! In this video, Oliver and Nawaz take a look at the Binance Coin chart. Thanks for watching, we will see you again next time! #BNBUSD #BNBBTC #BNB #Binance # ... How to transfer Litecoin from Coinbase to Binance Check out my no.1 recommended platform to invest in Bitcoin instantly with ZERO fees: https://coinjolt.com ... How to buy and sell Cryptocurrencys on Binance. BitCoin and Ripple Binance https://goo.gl/AzWFhh Once you buy or sell $100 of digital currency or more will g... Bitcoin is a storm now. will it be 2M USD 2020!? The price is rising. 10x in 2017 (wow) If you want to buy/sell bit coin BTC ETH, LTC and so all you can use Binance that one of the best exchange ...

http://binance-review.forexshop.eu