_ Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top up vote 7 down vote favorite 1 I'm trying to so some maths calculations with Excel but I need to get the current btc value from any website that can provide it in any format but simple as possible.Do you have any idea to get the current btc value (usd) and update it in real time in an excel sheet?value btce live-data up vote 7 down vote This more of a question about excel than it is actually about Bitcoin.But the answer is actually pretty easy.The first thing is that the data that you want to import from the web may not be easily isolated, so you might have to import much more data than you want into a second excel sheet, then link the cell with the data you are interested to a cell in your actual sheet.Follow these steps: Find a site that has the dynamic data you are looking for.Copy the data that you want and paste it into excel.

You can't miss the current price right at the top.After you paste it into excel the little paste options icon will popup next to it.Click it then select Refreshable Web Query.A new window will popup that will load the whole page.You might get some script errors; you can ignore those.The window directs you to click the arrow icon next to the table that you want to import.Unfortunately, with BitStamp, the only option is the whole page.Click the arrow then click import.Excel will now import a load of data from the webpage.The second cell is the one we are looking for; that is the current Bitcoin price in USD.This is where have a separate sheet for this import data is convenient.Go to the sheet where you want to use that data and link the cell you want to the other by first clicking = then clicking the cell in the sheet with all the data from bitstamp.You will see something like =Sheet1!A2 in the formula bar.That's all there really is to it.Microsoft has an extensive article on the topic complete with all the technical details.

up vote 1 down vote Here is the link.Just insert this into your excel file =/currencies/bitcoin/","//span[@id='quote_price']") up vote 0 down vote Start here: /neo/groups/smf_addin/info While it is a stock market add-in, it works with Yahoo Finanace and since Yahoo now lists Bitcoin (Symbol: BTCUSD=X) Yes, that is the symbol you use to get the price, it will update your spreadsheet every time there is a change made to the spreadsheet or when you force the sheet to recalculate.bitcoin spdThis fits the bill for what you need.bitcoin startup valuationup vote 0 down vote Here's a simplified macro that works as far back as Excel 2007, original credit Samir Khan: Sub GetBTCUSD() Range("BTCUSD").Select Selection.ClearContents With ActiveSheet.QueryTables.Add(Connection:= _ "/ticker/USD/last", Destination:=Range("BTCUSD")) .Name = "BTCUSD field that will pollute your Name Manager but I don't know how to get rid of" .AdjustColumnWidth = False .PreserveFormatting = True .RefreshOnFileOpen = True .BackgroundQuery = True .RefreshStyle = xlOverwriteCells .SaveData = False .RefreshPeriod = 0 .WebSingleBlockTextImport = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With End Sub To use the macro: Name a column in your spreadsheet "BTCUSD" (just click in the Name Box in the top left and type "BTCUSD" Add a button to the sheet (you can name it "Get BTCUSD") Create a new Macro and paste the code above Right click the button, choose Assign macro, and pick the GetBTCUSD macro.law ethereal gloves

up vote 0 down vote I tried this with Excel 2016: /v1/public/yql?q= /currencies/bitcoin/' and xpath='//span[@id="quote_price"]' /alltableswithkeys Insert the following into the Cell where you want the actual price: =XMLFILTERN(WEBDIENST($J$2&URLCODIEREN($J$3)&$J$4);"//span") Your Answer Sign up or log in Sign up using Google Sign up using Email and Password Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service.bitcoin luaBrowse other questions tagged value btce live-data or ask your own question.bitcoin 6 gpu motherboardMicrosoft’s latest upgrade roadmap for MS Office, includes four entries for bitcoin support into the four different platform version of their popular Excel spreadsheet software.bitcoin value nz

The changes allow for Bitcoin data to be used in their spreadsheets and calculations, making the task of doing budgeting with bitcoins far easier.The changes support bitcoin currency formatting on Windows desktop, Windows web, Android, and a universal Microsoft platform.The feature is unique to Microsoft office 2016’s version of Excel, and is expected to be available sometime in the first half of 2017.The changes involve a new pair of formatCode attributes for Microsoft’s Schema, or programming tags.These development tools, named x-xbt1 and x-xbt2, will be useful throughout the Microsoft codebase.With such a base level addition to the company’s underlying programming platform, it will be far simpler for Microsoft developers to include Bitcoin support in all future Microsoft products, including all future versions of its Office suite, and perhaps future Operating Systems.Microsoft launched the latest version of Excel as part of the Microsoft Office Suite 2016, in July 2015, to coincide with their launch of Windows 10.

Unfortunately, Windows 10 has been criticized in the privacy community for various inherent platform security concerns.While there are far more secure Operating Systems to run a bitcoin wallet on, such as Linux, Microsoft Window 10 will be the first to include support for Bitcoin number formatting, starting with Excel.In December 2014, Microsoft’s gaming platform, the Xbox, added bitcoin support for gamers Microsoft Account balances, which could then be used to buy licenses and in-game purchases.Microsoft stated that they had removed bitcoin support in March, although the announcement was later described as an error.While the payment processor helping Microsoft accept bitcoin, Bitpay, won’t disclose figures about Microsoft’s sales specifically, the company stated in January 2015 that they, “saw record months for bitcoin transactions in November and December, with more than 100,000 BitPay invoices processed each month.” Ethereum has had a much closer relationship with Microsoft.

In December 2015, the software giant added several Ethereum platform packages for download on Microsoft Azure.Ethereum became oneof the cloud platforms staple “Blockchain as a Service” offerings, which they refer to as “ETH BaaS.” Since then, Azure has added many other similar BaaS packages, from blockchain companies including Ripple, Monax, Coinprism, and Factom.The following March, ConsenSys and Ethereum teamed up to roll out another Microsoft project, a Windows toolkit to help developers build decentralized applications with Ethereum.The service helps developers build, test and deploy decentralized applications, known as ‘dapps,’ and even helps write smart contracts directly into MS Visual Studio.In September, Microsoft used some of its newfound blockchain prowess to step it’s big toe into the world of high finance.Bank of America and Microsoft Treasury announced that they would build blockchain applications on Azure for the purpose of facilitating trade finance.Amy Hood, the executive vice president and chief financial officer at Microsoft stated, “By working with Bank of America Merrill Lynch on cloud-based blockchain technology, we aim to increase efficiency and reduce risk in our own treasury operations.” Microsoft then launched the Ethereum Consortium Blockchain Network in November.