Crypto Function

CRYPTO() Description

The CRYPTO() function is designed for automatic retrieval of 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 convenient for creating crypto trackers in Excel (LibreOffice Calc) spreadsheets and will be useful for investors, analysts, and everyone who monitors the market.

Main Characteristics of the CRYPTO Function

Syntax:

=CRYPTO(Symbol; [Date])

Parameters:

• Symbol: Exchange symbol of the cryptocurrency.
• [Date]: (Optional) Date of price setting. By default, today's date is used.

Example of Use

Example 1

The CRYPTO() function is simple to use. You just need to specify the cell with the cryptocurrency code and Excel (Calc) automatically imports its price for the given date:

=CRYPTO(Symbol; Date)

We will have the following result:

In this example, the following values are used:

• Symbol: A2 - Cell containing the cryptocurrency code ("BTC").
• Date: D1 - Date of price setting ("30/06/2025").

Example 2

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 that will be opened in Excel (LibreOffice Calc).