How to use Excel to import sosobtc market data for Bitcoin analysis?

Bitcoin has developed rapidly in the past year. Considering the role of Bitcoin in protecting family and business property, Microsoft decided to list Bitcoin as a currency in the Office office suite used by millions of people every day. It also officially announced that Excel 2017 will widely support Bitcoin, allowing users to count and analyze Bitcoin data on Excel.

So, what can we do with Excel? Below we will take Excel 2007 as an example and get market data from sosobtc to share with you.

Before getting the data, you should first learn about sosobtc, a service provider focusing on digital currency market data. Its official website is https://www.sosobtc.com/. The [K-line chart plug-in] it provides has currently covered the entire industry. Plug-in: https://www.sosobtc.com/plugin/demo#market

How to obtain sosobtc market data

1. First, [Create] a blank Excel file, select the "A1" cell, click [Data]--[From Website], and enter in the pop-up address bar:

http://static2.sosobtc.com/plugin/market?btc=btc38<c=btc38&alt=xrp&short_tip=1&show_tip=0&td_height=&row=price|vol|buy|sell|high|low

Parameter description (see sosobtc website: https://www.sosobtc.com/plugin/demo)

2. Click the [Go] button, click the "yellow arrow" next to the table you want to select, and then click [Import].

Note: If you cannot obtain data, please check the security warning, click [Options], select "Enable this content", and click [OK].

This article is adapted from the sharing of Zhihu netizen @VitaminM. Please indicate the source as sosobtc when reprinting this article. For the original article, please see: https://zhuanlan.zhihu.com/p/26673333