Then whenever you want to update go to Data > Refresh
Or use the down arrow under the Refresh button to set it to auto refresh every few minutes or refresh every time you open the spreadsheet.
Topic: Bitcoin Spreadsheet (Read 1285 times)
Go to a blank sheet, ie. Sheet2. On the ribbon go to Data > From Web
A small browser window will pop up. In the address bar input a site that displays the price. Here's one that seems to work pretty well -- http://bitcoinprices.com/
Click the little yellow arrow in the top left corner, click the Import button, then when it asks for the cell just use the default (A1).
You should see the USD bid price somewhere around row 15.
A small browser window will pop up. In the address bar input a site that displays the price. Here's one that seems to work pretty well -- http://bitcoinprices.com/
Click the little yellow arrow in the top left corner, click the Import button, then when it asks for the cell just use the default (A1).
You should see the USD bid price somewhere around row 15.
Try This
=ImportHtml("http://bitcoinity.org/markets", "table",3)
Fine tune sometimes the number in bold to find the correct table.
=ImportHtml("http://bitcoinity.org/markets", "table",3)
Fine tune sometimes the number in bold to find the correct table.
Appreicated but its giving me this error:
#name?
Any ideas?
thank you
.Try with google drive sheet. It's free.
You can also go to 'Data' tab in the ribbon and click on the button 'From Web'. If you import a site (e.g. http://bitcoincharts.com/markets/mtgoxUSD.html), you'll be able to get some data. I hope I helped
Unfortunately Im runnog office 2012 for OSX and none of these funtions appear. I appreciate the link though. I can't believe this is that hard to do
.
You can also go to 'Data' tab in the ribbon and click on the button 'From Web'. If you import a site (e.g. http://bitcoincharts.com/markets/mtgoxUSD.html), you'll be able to get some data. I hope I helped
Try This
=ImportHtml("http://bitcoinity.org/markets", "table",3)
Fine tune sometimes the number in bold to find the correct table.
=ImportHtml("http://bitcoinity.org/markets", "table",3)
Fine tune sometimes the number in bold to find the correct table.
Appreicated but its giving me this error:
#name?
Any ideas?
thank you
.
Try This
=ImportHtml("http://bitcoinity.org/markets", "table",3)
Fine tune sometimes the number in bold to find the correct table.
=ImportHtml("http://bitcoinity.org/markets", "table",3)
Fine tune sometimes the number in bold to find the correct table.
I've read through several threads and google docs and still can't make this work:
Can someone please give me a cut and paste formula I can introduce to an Excel cel (not google docs) that will pull the current bid value from mtgox or another reliable party at btc/usd?
At least a step by step approach if cut and paste is unrealistic.
Much appreciated!
Paul.
Can someone please give me a cut and paste formula I can introduce to an Excel cel (not google docs) that will pull the current bid value from mtgox or another reliable party at btc/usd?
At least a step by step approach if cut and paste is unrealistic.
Much appreciated!
Paul.
Jump to: