Topic: Is there a way to have an updated BTC price in my Excel Worksheet? (Read 6328 times)
April 03, 2014, 12:30:57 PM
April 03, 2014, 10:08:44 AM
April 03, 2014, 10:04:40 AM
Check fiver
April 03, 2014, 08:31:23 AM
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?
anyone would be keen enough to share his spreadsheet so i can use it as a template and check how it's done properly?
April 01, 2014, 08:57:34 PM
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.
There's no built-in easy way using the interface like with other canned data types, you have to code it in VBA.
April 01, 2014, 06:06:23 PM
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?
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?
August 04, 2013, 09:24:04 PM
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.
$A$2
The $ ensures that the reference remains constant as you copy/paste functions.
August 04, 2013, 09:00:35 PM
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.
By all means shoot me a PM and we can see what we can come up with.
August 02, 2013, 07:17:45 PM
use a vb.net macro
August 02, 2013, 06:16:39 PM
I guess not, lol
August 02, 2013, 04:38:51 PM
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...
Jump to: