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 stock 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) tables and will be useful for investors, analysts, and everyone who monitors the market.

Key Features of the CRYPTO Function

Syntax:

=CRYPTO(Token; [Date])

Parameters:

• Token: Cryptocurrency stock symbol.
• [Date]: (Optional) Price setting 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".

Usage Example

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 specified date:

=CRYPTO(Token; Date)

We will get the following result:

The following values are used in this example:

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

Example 2

The following values are used in this example:

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

Corresponding data from Yahoo Finance:

How It Works?

The CRYPTO() function can work both in normal mode and as an array function.

To use it as an array, simply enter the function into any cell, specifying the appropriate parameters. Then press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with data.

To select all cells associated with the array formula, simply select any array cell and press Ctrl+/.

If you need to convert an array formula to values - select the entire array and in the menu Data > Calculate choose Formula to Value.

When using a date as text, it must first be converted into a real date, for example: DATEVALUE("2026-01-25").

Ready-made Templates

You can also use ready-made templates to retrieve historical data, financial indicators, or a company's profile.

To do this, go to the menu YLC Utilities > Template > Company screener and select one of the following reports:

• Profile data ("Profile data")
• Financial data ("Financial data")
• Statistical data ("Statistical data")
• Dividend data ("Dividend data")
• Historical data ("Historical data")

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).