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". 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.
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.
A second option, for stocks, is: Download Ninjatrader NT8 (FOR FREE). Install NT8. Select under CONNECTION the link KINETICK-End of day FREE Download the data you need. Create a chart and add all the indicators you wish. 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:
Correct information for NT8: cost is $50. http://www.indicatormall.com/export-to-excel-ninja-trader-8/
For bitcoin this link gives you the BTC data since september 2014: https://finance.yahoo.com/quote/BTC-USD?p=BTC-USD&.tsrc=fin-srch&guccounter=1