How can I use Google finance to find highest bitcoin price in a date range?

M

MrAgi1

To find the maximum price of a stock within a date range using Google finance
on Google sheets I use:
=MAX(INDEX(GOOGLEFINANCE("TICKER","high",”start date”,”end date”), ,2))

The formula works for stocks and ETFs. That formula however does not work for bitcoin or currencies. It gives an error message.

However using parts of the formula to get current price works: =GOOGLEFINANCE(“BTCUSD”)

How can I solve that problem?
 
I don't believe you can use "high" but you can use "close".

upload_2022-12-9_21-17-14.png


Items in yellow are parts of the formula, note the colon between currency and BTCUSD (cell B2)
 
You can use Coinbase's chart manually. Just move the cursor to the highest price on the chart in your timeframe and voila!!!
 
Just download all data, put it in Excel and you have what you need with the max on flexibility. You can then search on Open, High, Low, Close, Volume or any combination.
And you can even do any other mathematical calculation.
 
virtusa said:
Just download all data, put it in Excel and you have what you need with the max on flexibility. You can then search on Open, High, Low, Close, Volume or any combination.
And you can even do any other mathematical calculation.
More...
No you can't, stop lying to people
 
stochastix said:
No you can't, stop lying to people
More...

You should take a basic course : how to use a computer with excel.

It takes 2 minutes to download years of data. It works for anything that you can download from Yahoo. BTC, JPY, USD...
I download BTC on a regular basis without any problem at all.

msft.jpg
 
Last edited:
A second option, for stocks, is:
  1. Download Ninjatrader NT8 (FOR FREE).
  2. Install NT8.
  3. Select under CONNECTION the link KINETICK-End of day FREE
  4. Download the data you need.
  5. Create a chart and add all the indicators you wish.
  6. If you wish you can then export all data and values of all indicators to Excel. License costs $20 ( one time payment). https://sites.google.com/a/indicatormall.com/v1/export-to-excel
This is an example:
MSFT (Daily).png

msftdata.jpg
 
Last edited:
You must log in or register to reply here.
Back
Top