Bitcoin Forum

Other => Beginners & Help => Topic started by: benyben123456 on December 08, 2014, 12:34:42 PM



Title: Can you help me get BTC-E Average into a Google Sheet?
Post by: benyben123456 on December 08, 2014, 12:34:42 PM
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


Title: Re: Can you help me get BTC-E Average into a Google Sheet?
Post by: iluvpie60 on December 08, 2014, 01:56:48 PM
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.


Title: Re: Can you help me get BTC-E Average into a Google Sheet?
Post by: fast2fix on December 08, 2014, 05:51:03 PM
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. 


Title: Re: Can you help me get BTC-E Average into a Google Sheet?
Post by: SirChiko on December 08, 2014, 08:31:10 PM
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.


Title: Re: Can you help me get BTC-E Average into a Google Sheet?
Post by: ikydesu on December 09, 2014, 07:00:11 AM
are you looking for average function ???
http://spreadsheets.about.com/od/googlespreadsheets/ss/2013-07-07-google-spreadsheet-average-function.htm


Title: Re: Can you help me get BTC-E Average into a Google Sheet?
Post by: Peter882 on December 10, 2014, 08:40:34 AM
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.