Bitcoin Forum
June 26, 2024, 08:39:30 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Can you help me get BTC-E Average into a Google Sheet?  (Read 1095 times)
benyben123456 (OP)
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile
December 08, 2014, 12:34:42 PM
 #1

Hi.
I am really off when it comes to this, but would really be great if you guys know how to show (in google spreadsheets) the current average of BTC-E BTC-USD?

I won't know how to use scripts, so if there's a copy paste way (right into the cell), that would be amazing !

Thanks so much
iluvpie60
Hero Member
*****
Offline Offline

Activity: 700
Merit: 500


View Profile
December 08, 2014, 01:56:48 PM
 #2

There are other websites that let you look at all past prices of btc. I think its like bitfinex or something? i can't remeber the one people always throw around but someone will tell you.
fast2fix
Legendary
*
Offline Offline

Activity: 1612
Merit: 1001


View Profile
December 08, 2014, 05:51:03 PM
 #3

Hi.
I am really off when it comes to this, but would really be great if you guys know how to show (in google spreadsheets) the current average of BTC-E BTC-USD?

I won't know how to use scripts, so if there's a copy paste way (right into the cell), that would be amazing !

Thanks so much
you want to log price of bitcoin on daily basis in excel sheet or you just want see the price of bitcoin in excel?? i don't think so that's possible in excel. 
SirChiko
Legendary
*
Offline Offline

Activity: 966
Merit: 1000



View Profile
December 08, 2014, 08:31:10 PM
 #4

Hi.
I am really off when it comes to this, but would really be great if you guys know how to show (in google spreadsheets) the current average of BTC-E BTC-USD?

I won't know how to use scripts, so if there's a copy paste way (right into the cell), that would be amazing !

Thanks so much
you want to log price of bitcoin on daily basis in excel sheet or you just want see the price of bitcoin in excel?? i don't think so that's possible in excel. 
It's possible in numbers in excel, and that't probably what OP wants.

The only online casino on which i won something. I made 17mBTC from 1mBTC in like 15 minutes.  This is not paid AD!

▀Check it out yourself▀
ikydesu
Hero Member
*****
Offline Offline

Activity: 686
Merit: 500

fb.com/Bitky.shop | Bitcoin Merch!Premium Quality!


View Profile WWW
December 09, 2014, 07:00:11 AM
 #5

are you looking for average function Huh
http://spreadsheets.about.com/od/googlespreadsheets/ss/2013-07-07-google-spreadsheet-average-function.htm
Peter882
Hero Member
*****
Offline Offline

Activity: 543
Merit: 500



View Profile
December 10, 2014, 08:40:34 AM
 #6

If you simply want to log the bitcoin price, you can just use http://www.coindesk.com/price/ and download the datapoints as CSV.
If you want to get the current price shown on google doc, http://www.reddit.com/r/Bitcoin/comments/18gglz/one_bitcoin_google_spreadsheetscripts_api_to_rule/ should be helpful to you.

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!