Binance API Documentation

A Python Script for Live XRP Price Ticker (Using Exchange Websockets)

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.
Install Library
We will need to install the following library.
pip install shrimpy-python 
Script
Once the library has finished installing, you can run this simple script to begin streaming live XRP ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "xrp-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
Automating Crypto Portfolios with Trading Scripts
submitted by ShrimpyApp to Ripple [link] [comments]

A Python Script for Live Bitcoin Price Ticker

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.

Install Library

We will need to install the following library.
pip install shrimpy-python 

Script

Once the library has finished installing, you can run this simple script to begin streaming live Bitcoin ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "btc-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
submitted by ShrimpyApp to Bitcoin [link] [comments]

A Python Script for Live Bitcoin Price Ticker

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.

Install Library

We will need to install the following library.
pip install shrimpy-python 

Script

Once the library has finished installing, you can run this simple script to begin streaming live Bitcoin ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "btc-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
submitted by ShrimpyApp to CryptoCurrency [link] [comments]

A Python Script for Live Bitcoin Price Ticker (Using Exchange Websockets)

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.
Install Library
We will need to install the following library.
pip install shrimpy-python 
Script
Once the library has finished installing, you can run this simple script to begin streaming live Bitcoin ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "btc-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
Automating Crypto Portfolios with Trading Scripts
submitted by ShrimpyApp to CryptoCurrency [link] [comments]

A Python Script for Live Crypto Price Ticker

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.
Install Library
We will need to install the following library.
pip install shrimpy-python 
Script
Once the library has finished installing, you can run this simple script to begin streaming live Bitcoin ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "btc-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
Automating Crypto Portfolios with Trading Scripts
submitted by ShrimpyApp to CryptoCurrencyTrading [link] [comments]

A Python Script for Live Bitcoin Price Ticker

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.

Install Library

We will need to install the following library.
pip install shrimpy-python 

Script

Once the library has finished installing, you can run this simple script to begin streaming live Bitcoin ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "btc-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
submitted by ShrimpyApp to CryptoCurrencyTrading [link] [comments]

A Python Script for Live Bitcoin Price Ticker (Using Exchange Websockets)

Hi Everyone!
I've seen that people in this group have been interested in scripting and building simple things to interact with the cryptocurrency markets.
To help everyone out, I wrote up a brief script which will connect to the websocket for any major exchange and start streaming price data from the exchange.
It's so easy to do anyone could do it. All you need is Python and the ability to copy and paste code. Let's quickly walk through how we can get started.

Install Library

We will need to install the following library.
pip install shrimpy-python 

Script

Once the library has finished installing, you can run this simple script to begin streaming live Bitcoin ticker data.
# import the Shrimpy library for free crypto exchange websockets import shrimpy # create the Shrimpy websocket client client = shrimpy.ShrimpyWsClient() # define the handler to manage the output stream def handler(msg): # multiple trades can be returned in each message, so take the last one ticker = msg['content'][len(msg['content']) - 1]['price'] print(ticker) # construct the subscription object subscribe_data = { "type": "subscribe", "exchange": "binance", "pair": "btc-usdt", "channel": "trade" } # connect to the Shrimpy websocket and subscribe client.connect() client.subscribe(subscribe_data, handler) # disconnect from the websocket once data collection is complete client.disconnect() 
That's it! Let me know if you have any questions. You can find the documentation for these APIs here. I also wrote up a few example articles to provide more information:
Script for Cryptocurrency Price Charts
Script for Bitcoin Price Live Ticker
submitted by ShrimpyApp to CryptoCurrencies [link] [comments]

CryptoPort - Coin portfolio tracker (Android App) - I love this portfolio tracker!

CryptoPort - Coin portfolio tracker
https://play.google.com/store/apps/details?id=com.jsd.cryptoport&hl=en
I can't stress enough how happy I am with this Android app. This tracking software is top notch. I have 5 exchanges and numerous private wallets automatically linked to this portfolio app. The app has API support for all of the big exchanges.
If you have an Android device, I highly recommend giving this app a chance. There is no need to wait for coins to get listed for apps like Blockfolio.
Cryptoport is the easiest way to get overview all your cryptocurrency investment.
General - Effortlessly monitor and manage your cryptocurrency portfolio - Sync Account balance Across multiple Exchanges - Support several way to import data - Realize your wallets values into your local currency - Real-time calculate with up to date coin price - Support all popular coins
Ticker - Show coin price in Bitcoin, USD and your local currency - Market cap and ranking - Customize coin list - Coin details and price chart
Portfolio - Sync account balance across multiple exchanges - Sync private wallet balance for (BTC, ETH) - Sync mining unpaid balance from mining pool - Support manual input in case of your exchange is not supported yet - Summarize the total value entire of your investment - realize loss/profit for each coin, wallet - Switch among altcoin holding, bitcoin price, and your local currency price - Pie chart for holding percentage analysis
Supported Market. - Binance - Bitfinex - Poloniex - Bittrex - Cryptopia - BX - Bithumb - HitBTC - Kraken - YoBIT - CoinCheck - EXMO - GDAX - Coinbase - Coincheck - CEX - BTCMarket - Liqui - Kucoin
submitted by wettch to CryptoCurrency [link] [comments]

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]

A helpful Excel spreadsheet to help automate and monitor your assets - including historical metrics on profitability and asset holdings

Well... I put this together because it was fun (excel? fun?), but I figured I may as well share what I got- someone else out there might have some ideas to make it better, or might find it useful. It's a macro enabled excel spreadsheet which is understandably sketchy AF, so I included a 'dumb' .xlsx version and the actual macro in txt format if you're not comfortable downloading the macro version (I wouldn't blame you!)
Also: as you can see I'm pretty new and I bought a bunch during the bubble this Decembeearly January. I also may have picked some longer-term holds than I was expecting... Looks like it'll be a while before I recoup my capital investments, help a dude out with some BTC or ETH if you think this is useful (or if you're just feeling charitable)
Send me some BTC? 16W8XG2hXAmL1HJTzs5wWWoG8AUkyabdbT
Send me some ETH? 0x48dAbF6c5B02C4f9E09E2f5B95bb231C7e9f6049
DOWNLOAD HERE! https://www.dropbox.com/sh/68se9vl6dujcf3x/AADk6NlfkDdR-6WO1WeBl4QSa?dl=0
Let me know if you have any questions- I included instructions in the document on how to interact with it also see below:
Thanks for the great community, and I look forward to the rest of the year!
Also: If you just wanna make fun of my stupid investments, I fully deserve it. :)
Instructions (not great documentation, sorry)
WARNINGS
Purchases
  1. Any time you buy using Fiat currency you should add the purchase to the Purchases tab
  2. I tend to use coinbase/gdax to purchase, so I simply insert the date, the amount paid, the # of coin I got, and the fees paid, etc.
  3. Fiat purchase total will be flooded to the Assets tab as the capital investment
Adding a new Coin API call
  1. In Excel use the Data tab to add a new API call (from web)
  2. I'm just using CoinMarketCap until a better API comes up… use the documentation at https://coinmarketcap.com/api/
  3. Use the name for your new coin - ex: https://api.coinmarketcap.com/v1/tickeEthereum
  4. Here's the resource I used to figure it out
  5. It will create a new tab automatically but I thought that was annoying- copy the content of the new sheet into the "Data" tab (paste at the bottom)
  6. Delete the newly created sheet and the existing connection for it sheet…
  7. Rename the new data connection from "Ethereum(2)" to "Ethereum" if you want.
Add the Coin to Assets
  1. I have it split up by exchange for tracking where my assets are, where I bought them etc… not really necessary
  2. Add the new exchange, or simply use the TOTALS at the very top and get rid of the references to the exchanges
  3. Binance really screwed me with dust (I get it… buy BNB- bleh)… so I list those fractions as nLiq (non Liquid assets) so it's not counted in my actual return
  4. Reference the Data sheet for the BTC amount and the USD amount. Carry and calculations over. The IF logic was to handle zero values so it was easier to read.
  5. You'll probably need to add new coins to the TOTALS section- simply add a new record, name it, and reference the exchange below (or skip the exchange stuff and just list Totals) 5a. NOTE: The Bitcoin and Eth totals are summed from each exchange… I tend to use this as a worksheet for where I want to allocate resources too.
IMPORTANT:
  1. You'll need to manually add your new coins to the Historic Data sheet as a new column, it should be the same column order as the row order in the Assets TOTAL section WARNING: DO NOT SORT ANY TABLE or it'll screw up the Historic Data and macro stuff (see below)
Fees
  1. I got kind of lazy, and went with Bitcoin as the fee structure for each exchange… about .001 BTC for withdrawing funds back to a Fiat exchange.
  2. this is translated into USD fees and added up, you'll see the total fees in the TOTALS section at top
Asset Graphs
They should update automatically, but you might need to make sure they follow newly added rows in the tables.
Profits
  1. These are calculated for every trade and takes an average based on the existing price… 1a. It's a little janky, because if you buy some with BTC and some with ETH you can find the % away from each, but you have to adjust the formulas for each row accordingly
  2. the Average is taken for the Delta of each transaction from the current BTC or ETH price
  3. This data is compiled in the Historic Data sheet
Historic Stuff
On the Historical Assets tab there's a graph and it's derived from Historic Data sheet On the Historical Assets tab you'll see a button that says Start Macro and End Macro…
On the Historical Profit tab there's a graph which is derived from the Histroric Data sheet The Historic Data sheet is populated by a macro which basically just copies a bunch of stuff.
Macro does the following: (READ THE CODE COMMENTS)
  1. Refresh the data without locking up the application
  2. Copies the Liquid BTC column from the TOTALS table
  3. Pastes the current # of BTC for each coin in the next row of Historic Data sheet
  4. Get the Profit Analysis data and pastes it to a new row in its section of Historic Data sheet
  5. Waits 30 minutes (1800 seconds)
  6. Repeat
  7. ???
  8. Profit
submitted by ThaGuvNa to CryptoCurrency [link] [comments]

API: How to know what coin a symbol is associated with?

Hi,
I'm currently trying to understand how the API works and I'm having trouble with this... Say I request:
https://api.binance.com/api/v1/ticke24hr
And I go to "BTGBTC"
{"symbol":"BTGBTC","priceChange":"-0.00032100", ...}
Now, how do I know if BTG refers to "BitcoinGem", or "Bitcoin Gold"?
Most other exchanges offer an api call to get the available currencies, which would return something like:
{"id":"BTG","fullName":"Bitcoin Gold","crypto":true", ...}
But I can't find something similar on binance... Any idea? Thanks for your help!
submitted by desksquad to BinanceExchange [link] [comments]

[uncensored-r/CryptoCurrency] CryptoPort - Coin portfolio tracker (Android App) - I love this portfolio tracker!

The following post by wettch is being replicated because some comments within the post(but not the post itself) have been openly removed.
The original post can be found(in censored form) at this link:
np.reddit.com/ CryptoCurrency/comments/7odi7l
The original post's content was as follows:
CryptoPort - Coin portfolio tracker
https://play.google.com/store/apps/details?id=com.jsd.cryptoport&hl=en
I can't stress enough how happy I am with this Android app. This tracking software is top notch. I have 5 exchanges and numerous private wallets automatically linked to this portfolio app. The app has API support for all of the big exchanges.
If you have an Android device, I highly recommend giving this app a chance. There is no need to wait for coins to get listed for apps like Blockfolio.
Cryptoport is the easiest way to get overview all your cryptocurrency investment.
General - Effortlessly monitor and manage your cryptocurrency portfolio - Sync Account balance Across multiple Exchanges - Support several way to import data - Realize your wallets values into your local currency - Real-time calculate with up to date coin price - Support all popular coins
Ticker - Show coin price in Bitcoin, USD and your local currency - Market cap and ranking - Customize coin list - Coin details and price chart
Portfolio - Sync account balance across multiple exchanges - Sync private wallet balance for (BTC, ETH) - Sync mining unpaid balance from mining pool - Support manual input in case of your exchange is not supported yet - Summarize the total value entire of your investment - realize loss/profit for each coin, wallet - Switch among altcoin holding, bitcoin price, and your local currency price - Pie chart for holding percentage analysis
Supported Market. - Binance - Bitfinex - Poloniex - Bittrex - Cryptopia - BX - Bithumb - HitBTC - Kraken - YoBIT - CoinCheck - EXMO - GDAX - Coinbase - Coincheck - CEX - BTCMarket - Liqui - Kucoin
submitted by censorship_notifier to noncensored_bitcoin [link] [comments]

Binance API Keys Hacked Bitcoin 101 - Calling All APIs - Coding Live Price Data ... Python Requests Tutorial - Bitcoin Price API Python Binance API, Dashboards & Data Science Tutorial ... [Tutoriel] Créer des clés d'API sur Binance Bitcoin API - Bitcoin, Crypto currency live and historical ... Binance API Tutorial (Part 2) - Real-Time Crypto Price Data over Websockets Binance API and SECRET KEY Tutorial - YouTube Howto code Binance API price tickers in Google Sheets ... DERS 1(Devam) - Binance api kullanimi - Bitcoin bot yapımı

The simplest one involves using the get_symbol_ticker function. You can pass through any ticker here as opposed to BTCUSDT if you’re after another asset. # get latest price from Binance API btc_price = client.get_symbol_ticker(symbol="BTCUSDT") # print full output (dictionary) print(btc_price) The code above will print out a dictionary file that contains the symbol and the price. Here is an ... Message Format - see Binance API docs for all types. start_miniticker_socket (callback, update_time=1000) [source] ¶ Start a miniticker websocket for all trades. This is not in the official Binance api docs, but this is what feeds the right column on a ticker page on Binance. 24hr ticker price change statistics GET /api/v3/ticker/24hr 24 hour rolling window price change statistics. Careful when accessing this with no symbol. Weight: 1 for a single symbol; 40 when the symbol parameter is omitted. Parameters: CoinDesk provides a simple and free API to make its Bitcoin Price Index (BPI) data programmatically available to others. Find out how to use it here. Bitcoin Ticker - Tick by tick, real time updates. All data is indicative. Options Last Updated: seconds : Time between graph updates : ms: Play sound on each trade . Round Bids/Asks to 0.500 . Animate Depth Movements . Highlight BTC bids/asks above : Alert if price falls below: Alert if price climbs above: Alert if price change +/- : Sound Alert . Desktop Alert . Show Personalized Content ... I'm sure many Binance Futures customers, like me, would like clarification of the company's plans, following the UK Financial Conduct Authority’s (FCA) ban, which comes into effect on 6 January 2021, on firms that market or sell cryptocurrency derivatives. The best free 🚀 cryptocurrency and bitcoin API. Programmatically access current and historical price, markets, and exchange rate data from exchanges like Binance, Gemini, GDAX, and Poloniex. Quickly create mobile apps, charts, and pricing websites with our lightning fast RESTful JSON API. Binance cryptocurrency exchange - We operate the worlds biggest bitcoin exchange and altcoin crypto exchange in the world by volume Some API calls are available with CORS headers if you add a &cors=true paramter to the GET request . URL: https://blockchain.info/ticker No Parameters. Returns a JSON object with the currency codes as keys. "15m" is the 15 minutes delayed market price, "last" is the most recent market price, "symbol" is the currency symbol. 2020-05-01. From 2020-05-01 UTC 00:00, all symbols will have a limit of 200 open orders using the MAX_NUM_ORDERS filter.. No existing orders will be removed or canceled.

[index] [9773] [14742] [13257] [8302] [6573] [520] [10926] [11874] [17839] [14439]

Binance API Keys Hacked

In this video, we retrieve bitcoin price data over Websockets in 2 ways. First, we use wscat to receive the information from the command line and save the price data to a file. Second, we use ... How To Actually Double Your Bitcoin https://youtu.be/GjSccTfM-WU This video will help you make a Binance API and SECRET KEY How To Get A Binance API kEY Join... Confused about APIs and JSON? Looking to run an arbitrage business or build a data intensive site? Well this video is for you. This is the first of our video... Binance API Keys Hacked Firstly, thanks for watching I appreciate your support! Please like, share and subscribe for more crypto news! In this video I will show you how to import live data and Historical data for Bitcoin, Ethereum, Ripple and other 1384 coins from web to excel. Data is refre... In this video I talk about the basics of using Python requests by showing you how to call the Coinbase Bitcoin Price Index API. You can see the API docs here... sheet + script on: https://docs.google.com/spreadsheets/d/11tclKqh5PLQiO-aSbbLwZ9cam4_q7HYHj8DwV86o3k4 Explained and technical background: https://redd.it/8p... Check Out the Complete Udemy Course: https://www.udemy.com/course/plotly-dash/?referralCode=16FC11D8981E0863E557 Have Questions check out our discord: https:... Petit tutoriel pour créer des clés d'API sur Binance. Avec ces clés d'API, vous pouvez connecter des services tiers à votre compte Binance, et décupler ainsi votre potentiel de trading. Python Binance API, Dashboards & Data Science Tutorial - Duration: 1:00:57. ... Bitcoin 101 - Calling All APIs - Coding Live Price Data From Bitcoin Exchanges - Duration: 10:53. CRI Recommended ...

#