How to get data from Google Finance to Google sheets?

0 votes

I want to get data of bitcoin prices from google finance and store it in google sheets. How can I do it?

Aug 21, 2018 in Blockchain by digger
• 27,630 points
110 views

1 answer to this question.

0 votes

You need to have a from and to currency like this:


=GoogleFinance("CURRENCY:USDBTC")

For historic close price use:

=GoogleFinance("CURRENCY:USDBTC","close","07/07/2017")

If you want only the price returned use:

=iferror(index(GoogleFinance("CURRENCY:USDBTC","close","07/07/2017"),2,2))
answered Aug 21, 2018 by slayer
• 29,050 points

Related Questions In Blockchain

0 votes
1 answer

How to input realtime data from google sheets into urlfetch google scripts?

Based on your title I hope to ...READ MORE

answered Oct 12, 2018 in Blockchain by Perry
• 17,010 points
63 views
0 votes
1 answer

How to retrieve data from a block to a blockchain?

web3.eth.getTransaction(txHash) will returns transaction details like blockHash, transactionIndex, ...READ MORE

answered Jun 26, 2018 in Blockchain by Perry
• 17,010 points
79 views
0 votes
1 answer

How to retrieve data from an Ethereum Block?

To get transaction details like Block Hash ...READ MORE

answered Jul 19, 2018 in Blockchain by Perry
• 17,010 points
36 views
0 votes
1 answer

How to parse Json data from remote server?

Yes, you can do it use the ...READ MORE

answered Aug 17, 2018 in Blockchain by digger
• 27,630 points
28 views
0 votes
1 answer

Protocols used in a distributed/dlt system for the nodes to establish communication

yes all are over TCP/IP connections secured by TLS encryption in hashgraph architecture-hashgraph, ...READ MORE

answered Aug 6, 2018 in Blockchain by ariaholic
• 7,340 points
63 views
0 votes
1 answer

Truffle tests not running after truffle init

This was a bug. They've fixed it. ...READ MORE

answered Sep 11, 2018 in Blockchain by Christine
• 15,790 points
126 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to get return value from solidity contract?

Once you call a constant function, you ...READ MORE

answered Aug 16, 2018 in Blockchain by slayer
• 29,050 points
431 views