Crypto Function

CRYPTO() Description

The CRYPTO() function is designed for automatically getting cryptocurrency prices directly from the Yahoo Finance website (finance.yahoo.com) for a specified ticker symbol (for example, BTC, ETH) and a selected date. It supports both historical data and real-time values.

This function is useful for creating crypto trackers in LibreOffice Calc tables and will be helpful for investors, analysts, and anyone following the market.

Main Features of the CRYPTO Function

Syntax:

=CRYPTO(Symbol; [Date])

Parameters:

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

Usage Example

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

=CRYPTO(Symbol; Date)

We will get the following result:

In this example, the following values are used:

• Symbol: A2 - The cell containing the cryptocurrency code ("BTC").
• Date: D1 - The date the price was set ("30/06/2025").

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 LibreOffice Calc.