bitcoinexchangerate.org/price is new to me and I like it. The importXML command I was also unaware of. I'll be adding those to my spreadsheet.
I've been using a couple methods to get the price myself.
1. The first thing I used was =ImportData("
http://blockchain.info/q/24hrprice") to get a 24-hour average price. The webpage is just the price text. But I found at least once a week, the price would be totally messed. Once it was $14 when Bitcoin had been $20-$30 in the past week.
2. I found this command that I can't quite figure out:
=Index(ImportHTML("
http://bitcoincharts.com/"&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0),"table",4),2,2)
But he seems to be importing the latest price from bitcoincharts and somehow forcing it to update faster than the standard ~1 hour updates of docs.
3. I wanted the latest mtgox price from mtgox so I whipped up a quick bash script on my centos webserver:
stop=$(<stop.txt)
while [ "$stop" = 0 ];
do
stop=$(<stop.txt)
wget -q https://mtgox.com/code/data/ticker.php
cat ticker.php | cut -d',' -f8 | cut -d':' -f2 > last.htm
cat ticker.php | cut -d',' -f5 | cut -d':' -f2 > vol.htm
cat ticker.php | cut -d',' -f3 | cut -d':' -f2 > avg.htm
cat ticker.php | cut -d',' -f2 | cut -d':' -f2 > low.htm
cat ticker.php | cut -d',' -f1 | cut -d':' -f3 > high.htm
date > lastupdated.htm
rm -rf ticker.php
sleep 5
done
then I just ran it:
./update.sh&
disown [job#]
Then I just point docs to the webpage with =ImportData("
http://mysite.com/last.htm")
I know I could have done parsing in some other web language or something and made a script there but I'm way more familiar with bash shell scripting so this was much quicker for me.
The wallet contents are easy to fetch from blockexplorer.com/q/
I make a chart like this:
A | B
wallet address | =ImportData("
http://blockexplorer.com/q/addressbalance/"&A1)
...[for however many addresses are in your wallet]
total | =sum(B2:B12)
I created a public spreadsheet that I planned to put all kinds of data in but there was no interest so I abandoned it and just keep updating my personal one.
