Symbol naming convention

Sometimes new cryptocurrencies use the same symbol as an existing coin. An example of this would be RETH, which could be "Rocket Pool ETH", "StaFI Staked ETH", or "Realms of Ethernity".

When producing the output file, coins will be added in the order of their global rank. To ensure symbol uniqueness, in the case of a conflict the symbol will have an ID number appended to it.

This is usually a rare occurance, as the more popular coins are higher ranked, and therefore do not have naming conflicts.

Using the RETH example above, if StaFI Staked ETH (RETH) was ranked highest, when Rocket Pool ETH (RETH) is added to the list its symbol will become RETH_15060.

In this case, instead of searching by symbol you might find it easier to search by name:

=QUERY(IMPORTDATA("https://cryptorates.ai/files/full.csv", ",", "en_US"), "SELECT * WHERE Col2='Rocket Pool ETH'")