Bitcoin Spreadsheet

[fible1]

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.

[StarenseN]

Try This

=ImportHtml("http://bitcoinity.org/markets", "table",3)

Fine tune sometimes the number in bold to find the correct table.

[fible1]

Try This

=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 .

[wev]

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

[fible1]

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  .

[StarenseN]

Try This

=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.

[theFed]

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.   

[theFed]

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.