Crypto Function

CRYPTO() Description

The CRYPTO() function is designed to automatically retrieve cryptocurrency prices directly from the Yahoo Finance website (finance.yahoo.com) by the specified exchange symbol (e.g., BTC, ETH) and selected date. It supports both historical data and real-time values.

This function is useful for creating crypto trackers in Excel (LibreOffice Calc) spreadsheets and will be useful for investors, analysts, and anyone monitoring the market.

Key Features of the CRYPTO Function

Syntax:

=CRYPTO(Token; [Date])

Parameters:

• Token: Cryptocurrency exchange symbol.
• [Date]: (Optional) Price date. By default, today's date is used.
• [Indicator]: (Optional) Cryptocurrency price indicator or its trading volume ("open", "high", "low", "close", "volume"). By default, the closing price is used, i.e., the value "close".

Example Usage

Example 1

The CRYPTO() function is easy to use. You just need to specify the cell with the cryptocurrency code and Excel (Calc) will automatically import its price for the specified date:

=CRYPTO(Token; Date)

We will get the following result:

In this example, the following values are used:

• Token: A2 - Cell containing the cryptocurrency code ("BTC").
• Date: D1 - Price date ("01/07/2025").

Example 2

In this example, the following values are used:

• Token: B1 - Cell containing the cryptocurrency code ("BTC").
• Date: A5 - Price date ("Aug 4, 2025").
• Indicator: F4 - Value type (trading volume) ("volume").

Corresponding data from the Yahoo Finance website:

Download extension

You can use the CRYPTO() function by installing the YLC Utilities extension.

After that, this function will be available in all files opened in Excel (LibreOffice Calc).