Is there a way to have an updated BTC price in my Excel Worksheet?

[VolanicEruptor]

I'm trying to organize my BTC financial info into a spreadsheet, and I am rather new to Excel.  I do understand a little bit about fetching information via API (I would like to pull the info off Bitstamp), but not sure how to import this info into Excel without having to manually type it in...

[VolanicEruptor]

I guess not, lol

[grue]

use a vb.net macro

[The General]

I've got something that I developed for myself that I'm considering making commercial (although at the moment it covers BTC-e and GOX only).

By all means shoot me a PM and we can see what we can come up with.

[Abdussamad]

The simplest solution is to enter it manually. Just one number in one cell should reflect in all the other calculations in your spreadsheet. Just refer to that cell in this fashion

$A$2

The $ ensures that the reference remains constant as you copy/paste functions.

[bitpop]

http://stackoverflow.com/questions/8044423/json-import-to-excel

[hdbuck]

Bump,

been trying to do so as well, but without any luck since i'm no vba expert too.
isnt there some neat guide to fetch those API tickers on excel by now?

[greenlion]

The link bitpop posted explains exactly how to do it.

There's no built-in easy way using the interface like with other canned data types, you have to code it in VBA.

[hdbuck]

erf this link is pure chinese to me.
anyone would be keen enough to share his spreadsheet so i can use it as a template and check how it's done properly?

[bitpop]

Check fiver

[hdbuck]

Check fiver

uh? 

[bitpop]

Check fiver

uh? 

http://www.fiverr.com/excelguruguy/create-a-custom-excel-macro

[hdbuck]

Check fiver

uh? 

http://www.fiverr.com/excelguruguy/create-a-custom-excel-macro

oh i see, thx

[bitpop]

Check fiver

uh? 

http://www.fiverr.com/excelguruguy/create-a-custom-excel-macro

oh i see, thx

http://www.fiverr.com/search/gigs?utf8=%E2%9C%93&search_in=everywhere&query=macro&jls_se99912_1_auto=1&jls_se99912_2_auto=1