Access Binance in Excel

by Dovydas M

Binance is the biggest cryptocurrency exchange in the world. Use this connector in Excel to access public exchange information, as well as your personal trading data. Exchange Info List all available trading pairs on the exchange, as well as additional trading info for each pair. Fields Symbol - symbol for the trading pair, e.g. ETHBTC Status - trading status for the pair - PRETRADING / TRADING / POSTTRADING / ENDOFDAY / HALT / AUCTIONMATCH /BREAK. Base Asset - base asset...

Access Alpha Vantage in Excel

by Dovydas M

Alpha Vantage is an excellent free API that offers a variety of stock, foreign exchange and crypto/digital currency data. Stock Time Series Retrieves realtime and historical equity data. Parameters: Symbol (aka ticker) Function - Intraday, Daily, Daily Adjusted, Weekly, Weekly Adjusted, Monthly, Monthly Adjusted Interval - Time interval between two consecutive data points in the time series. 1min, 5min, 15min, 30min, 60min. Batch Stock Quotes Returns multiple (up to 100) real-time stock quotes. Parameters: Stock symbols (aka tickers) - list...