Crypto feature

Crypto () Description

Crypto () function is intended to automatically obtain cryptocurrency prices directly from Yahoo Finance site (Finance.yahoo.com) according to the specified exchange symbol (eg BTC, ETH) and the chosen date. It supports both historical data and real time.

This feature is convenient for creating crypto trackers in Excel tables and will be useful for investors, analysts and all who follow the market.

The main characteristics of Crypto function

Syntax:

=CRYPTO(Symbol; [Date])

Parameters:

• Symbol: Exchange symbol of cryptocurrency.
• [Date]: (Optional) Price setting date. The default value of today's date is used.

Example of use

Example 1

Crypto () is easy to use. It is enough for you to specify a cell with the cryptocurrency code and Excel Automatically imports its price at a given date:

=CRYPTO(Symbol; Date)

We will have the following result:

This example uses the following values:

• Symbol: A2 - the cell with which the cryptocurrency code is contained ("BTC") .
• Date: D1 - the price setting date ("30/06/2025") .

Example 2

Relevant data from the site Yahoo Finance :

Download extensions

You can take advantage of the feature Crypto () by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel.