Ninjastic
Home
Search
Users
Boards
Addresses
Ctrl + K
Toggle theme
Open menu
Post
Edited versions
Quotes to this post
Post
2811083
Topic
6411
Board
Service Discussion
Re: Getting mtgox values into google spreadsheets
by
LevLion
on
26/07/2013, 21:48:35 UTC
Quote from: John (John K.) on July 17, 2012, 08:08:25 AM
I use bitcoincharts with the function:
Code:
=Index(ImportHTML("http://bitcoincharts.com/"&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0),"table",4),2,2)
That'll cause the newest price to be downloaded, and be refreshed damn fast.
SO MANY THANKS!
Have a great day! Will tip soon when I get my next reward!
l.