The Scenario
You've been running a simple moving-average crossover strategy on paper for three months. The thesis is solid, but when you try to back-test it properly you realize all the price data you have is a partial export from six weeks ago that a colleague downloaded and then left in a folder called "misc." The coin is Bitcoin. The timeframe is a year. The data you need is 365 daily closing prices, clean, in two columns.
The bad version:
- Search for a Coinranking CSV export of historical BTC data — there isn't a clean one-click download for the specific date range and resolution you need.
- Try to scrape the chart by hand: note the price at the end of each week from the Coinranking UI, enter it into the workbook row by row, and accept that you'll only get weekly granularity and your arm will hurt.
- Pull from a different source that has the export but uses a different price methodology, then spend an afternoon reconciling why the numbers don't match Coinranking's live feed.
Your back-test is only as credible as the data behind it. A cobbled-together price series with gaps and methodology mismatches doesn't tell you anything useful — it just creates confidence where none is warranted.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside Excel and talks directly to the Coinranking API through its built-in integration. You describe the data you need in plain language and it handles the endpoint, the pagination, and the column writes.
Fetch Bitcoin's daily price history for the last 365 days from Coinranking and put date in column A and closing price in USD in column B, starting at row 2
What You Get
- 365 rows, one per day, with date in column A (formatted YYYY-MM-DD) and closing price in column B as a plain number
- Data ordered chronologically from oldest to newest, ready for a chart or rolling-average formula
- No gaps for weekends — crypto markets run continuously, so every calendar day is present
What If the Data Is Not Quite Ready
You need a longer lookback or a different coin
Fetch Ethereum's daily price history for the past 2 years from Coinranking and write date into column A and closing price in USD into column B starting at row 2
You want the rolling average added as a third column
Get Bitcoin's daily price history for the last 365 days from Coinranking, put date in column A and closing price in column B starting at row 2, then add column C with a 30-day rolling average price
You want weekly resolution instead of daily
Fetch Ethereum's weekly closing prices for the past 2 years from Coinranking, write date in column A and price in column B starting at row 2, then add column C as a 4-week rolling average
Full back-test setup in one shot
Clear any existing data in columns A through D from row 2 downward, fetch 365 days of daily Bitcoin prices from Coinranking, write date in column A and closing price in column B, add a 30-day rolling average in column C and a 90-day rolling average in column D, then apply conditional formatting to column B that highlights cells green where the 30-day average is above the 90-day average and red where it's below
The rolling averages, the color signal, and the fresh data all land in one request.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you're building your strategy back-test, then ask it to pull 365 days of daily prices from Coinranking. When you're ready for the next layer, see Compute Portfolio Basket Stats for a Coin Watchlist in an Excel workbook and the Coinranking Excel overview.