Crypto OHLCV history in Google Sheets and CSV

By CryptoTrackPro · Published 9 September 2026 · Examples checked against the current formula implementation

Enter =cryptotrackproHistory("BTC",30,"USD") in an empty tab to request up to 30 recent daily candles. The result expands into six columns: Date, Open, High, Low, Close and Volume. This workflow is useful when you need a series to inspect or export, rather than one historical price for a selected date.

Give the result enough space

Install and connect CryptoTrackPro through Extensions → CryptoTrackPro → Open CryptoTrackPro. History tables require Base or Pro, including the Base trial. Create a blank tab called BTC daily and place the formula in A1. Leave A1:F31 clear for a 30-day request, including the header row. Do not type your own headings over the cells the function fills.

=cryptotrackproHistory("BTC",30,"USD")

The day count defaults to 30 and supports 1 through 365. For a larger sample use =cryptotrackproHistory("BTC",365,"USD") and allow 366 rows. The count is a request for available recent daily rows; an asset with a shorter market history can return fewer. The function does not accept start and end dates or an hourly interval.

Read each field with its units

Open, High, Low and Close are prices in the requested quote currency. Volume represents the base asset traded on the selected Kraken market, not a market-wide USD volume total. For a BTC-USD table, price columns use USD and the volume column represents BTC. Keep the ticker and quote in the tab name or in a separate notes area outside the spill range.

Dates are formatted from candle timestamps in UTC. The displayed row label does not adopt your spreadsheet's local trading-day boundary. That matters when comparing with another dataset that groups trades using a different timezone. Use the same interval and date convention before interpreting discrepancies.

Inspect the final row before analysis

Kraken's OHLC response includes an unfinished current candle. CryptoTrackPro currently retains it, so the newest row's prices and volume can change before that day closes. Exclude that row when your analysis requires only completed days. Kraken's OHLC reference also explains that its endpoint is limited to recent candles; changing a request parameter does not provide unlimited archive access.

Indicator and history coverage depends on available Kraken pairs. A coin that works in the current-price function may lack history in your requested quote currency. The USD lookup can fall back to a USDT pair when a direct USD market is unavailable. Do not present that fallback as an exact USD exchange market when source precision matters.

Calculate a return without editing the raw series

Keep the returned A:F data intact. On a separate review tab, paste the table as values and remove any unfinished final candle after checking its date. Add a G1 heading called Close-to-close return. If the first two completed closes are in E2 and E3, put this in G3:

=E3/E2-1

Format G as a percentage and fill through the reviewed rows. With the illustrative first two closes, 105 divided by 102 minus one is approximately 2.94%. G2 stays blank because there is no previous close in the table. Missing rows or nonnumeric errors need inspection before you fill the calculation; replacing them with zero would distort returns.

For a chart, select the date and close columns from the reviewed copy. Confirm the date ordering and the first and last dates before interpreting the line. A chart can conceal a missing observation or an incomplete final row if you only look at its shape.

Export a reproducible CSV

Use a dedicated values-only export tab containing just the reviewed table and any derived columns you need. In Sheets, choose File → Download → Comma-separated values (.csv, current sheet). Record the export date, asset, quote, source and treatment of the unfinished candle in a companion note. Open the downloaded file and verify the headers and row count.

CSV preserves values, not the add-on formula, formatting or a future refresh schedule. Retain the original workbook to document the workflow. For selected older dates rather than a rolling window, use historical single-date prices; their fallback sources and methodology can differ from this Kraken candle table.

Frequently asked questions

Why does the history formula show a spill error?

Its six-column result needs empty cells below and to the right of the formula. Move existing content or place the formula in a blank tab, allowing one header row plus the requested daily rows.

Can I request hourly candles or a custom date range?

The current history function returns recent daily candles, up to 365 requested rows. It does not take an hourly interval or custom start and end dates.

Continue with: Look up selected dates · Understand daily MACD · All guides