Binance Coin Calculator Convert Binance Coin into any ...

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]

Bitcoin Might Soon How to Exchange Litecoin for Bitcoin BINANCE EXCHANGE TUTORIAL REVIEW - HOW TO USE AND BUY/SELL COINS Buy/sell Bitcoin with Euros and Pounds on Binance Binance Jersey BINANCE  Einführung und Anleitung  Deutsch How to SHORT or LONG Bitcoin with Leverage  BINANCE ... Get Bitcoin Exchange Rates using PHP API - YouTube Binance Announces US Coins, Mastercard + R3, ECB Negative Rate Cut & German Recession Alternative Crypto Exchanges after Binance

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 Exchange rate of Binance Coin to Aud dollar (BNB in AUD) with latest cryptocurrency price. On the page are today and 24 hours historical chart of BNB/AUD exchange rate. This is live currency market price of BNB in Australia. BitcoinsPrice — fiat money and cryptocurrency converter The current rate Aurora AOA is 0.02 zł.In the last 24 hours, the price of Aurora increased by 186.36% and the 24-hour volume of this cryptocurrency is 34 582 642.00 zł.The cryptocurrency in the last 24 hours recorded the highest price at the 0.01 zł, while its lowest was 0.01 zł.The highest Aurora price in the last 7 days was 0.01 zł, and the lowest price was 0.01 zł. Get IDEX (IDEX) price, charts, volume, market cap, exchange list and more. 🎉 Our October 2020 Monthly Cryptocurrency Report is here🎉 The rise of Bitcoin, total crypto market cap yearly-high & much more! CoinSwitch is the largest cryptocurrency exchange supporting more than 300 cryptocurrencies and altcoins, thereby allowing you to sell, buy AuroraCoins and even do a swap or exchange of Aurora coin value to coins like the Bitcoin. Global reliable exchanges like BitSwap, Cryptopia, ShapeShift and many more are supported and integrated with the protocol based CoinSwitch which compares and gets ... Auroracoin (AUR) Currency Exchange Rate Conversion Calculator This currency convertor is up to date with exchange rates from November 4, 2020. Enter the amount to be converted in the box to the left of the currency and press the "convert" button. DC Forecasts Binance Coin Calculator lets you convert BNB Coin to fiat in real time. Check the live Bitcoin rate with EUR, USD, GBP, CAD, JPY, AED, and more To show Binance Coins and just one other currency click on any other currency. The Binance Coin is the currency in no countries. The symbol for BNB can be written BNB. The exchange rate for the Binance Coin was last updated on November 4, 2020 from coinmarketcap.com. The BNB conversion factor has 15 significant digits. Add your comment to this page

[index] [23947] [11116] [4180] [21698] [23839] [1361] [19981] [4763] [7001] [1182]

Bitcoin Might Soon "Implode", Binance Coin Delistings And Bitcoin Cash Exchange

🟡Binance Futures 10% Off Fees Code: https://accounts.binance.com/en/register?source=futures&ref=sunnydecree 🟡Binance Signup 20% Off Fees for Altcoins: https:... Bitcoin AIR-DROP and Halving - Bitcoin 比特币 Latest News Binance English 16,284 watching Live now How The Economic Machine Works by Ray Dalio - Duration: 31:00. Since Binance is not going to be available in the US anymore after September 12th, here are some alternative exchanges to use. ----- Get Brave a... Binance is also offering a reward of 20 EURO to the first 5000 users to register at www.binance.je.so go ahead guys and grab the opportunity to be in the first 5000 users but users has to complete ... This video shows you how to buy/sell coins and use https://www.binance.com It's very easy. Just remember to load some Bitcoin or coins before you start trying to buy things on there because that's ... A simple PHP script to get current Bitcoin exchange rates in US Dollar, Pound Sterling and many other currencies. Basic PHP API for cryptocurrency exchange r... Binance findest du hier - https://goo.gl/86HNDK Krypto verstehen lernen - https://goo.gl/hGPpnE Bitcoin.de Wallet - https://goo.gl/s6wMpq Folge mir auf T... How to Use Shapeshift to Exchange One Type of Coin for Another - Duration: 9 ... How to transfer Litecoin or Bitcoin from Coinbase to Binance - Duration: 10:57. Jermaine Ellis 213,682 views. 10:57 ... Support Me On Patreon! https://www.patreon.com/TheModernInvestor ----- Protect And Sto...

#