_ 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.This fits the bill for what you need.up 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.

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 miner live cdBrowse other questions tagged value btce live-data or ask your own question.bitcoin burning manAnother source for free historical bitcoin data is Quandl: Bitcoin Prices and Charts .cat coin bitcoin

We consolidate prices, volumes, transaction activity, mining activity and other indicators from dozens of primary sources and aggregators.There's also a free API if you want structured data.Disclaimer: I'm the co-founder of Quandl.Bitcoin Charts - Blockchain.info  Tread carefully, their data tracking seems to have momentary (like a couple of days) pauses.litecoin coming to coinbase ebooks give great value to our readers.litecoin hash rateThe low price is just the start.buy bitcoin myceliumThere’s also free updates to the book available to past and new customers.bitcoin orange countyReal-Time Excel has just been updated to include more chapters and example documents.buy xrp with bitcoin

The update is available now to past purchasers who login to their ebook account and download a complete replacement.New customers get the complete book immediately on purchase.How to get the latest price, volume and other details for Bitcoin and other virtual currencies compared to US, Canadian or Aussie dollars, UK Sterling, Euro and other real currencies.bitcoin miner 6 th/sReal-Time Excel has a sample worksheet and query ready to use in your own spreadsheets.Some readers asked if they can share information making their own data feeds – sure!Small businesses can make a product catalog that can be used in Excel by customers and agents.One reader asked about publishing sports results as data for club members to import and analyze.In an entirely new chapter, Real-Time Excel shows how to format data that other people can use with Get & Transform / Power Query.There are two simple options, a web page table or an XML file.

We show how to use either method including how to make an XML file from an Excel table (which is more complicated than you’d expect).Put the latest stock prices, exchange rates, Bitcoin even weather details automatically into Excel, Word and PowerPoint.There’s no need to retype details from a web site or (shock!)a newspaper when Office can do the job in the blink of an eye.Windows 10 Creators from people 'in the know' A detailed and independent look at Windows 10, especially written for the many people who use Microsoft Office.Fully up-to-date with coverage of the Creators edition 2016 major update of Windows 10.This 720 page book shows you important features and details for all serious Windows 10 users.Real-Time Excel shows how to get ‘live’ or real-time data automatically into your Office documents.Getting those details into Excel, Word and PowerPoint is possible and now easier than before.Not only do we show you how to do it, we’ll give you the worksheet, document and presentation files explained in the book.