How to fix invalid transactions caused by "Price lookup unavailable"

This article describes invalid transactions caused by "Price lookup unavailable".

Contents:

  1. What is "Invalid transaction"?
  2. What is "Price lookup unavailable"?
  3. Checking "Price lookup unavailable" and their causes
  4. How to fix "Price lookup unavailable"

STEP1 Check "Price lookup unavailable"

STEP2 Enter price (using our "assistant" feature)

STEP2 Enter price

 

1. What is "Invalid transaction"?

Cryptact calculates the cryptocurrency PNL using the calculation methods which are publicly available and the market prices. In the process of aggregating all transaction history together, any transactions that cryptact could not correctly handle due to insufficient information are flagged as Invalid Transactions and excluded from the PNL calculation. These invalid transactions are displayed as warnings and not errors.

Even though these invalid transactions are warnings and not errors, they are excluded from the PNL calculation, so the calculated PNL may end up being significantly different from what it should be. You must resolve all invalid transactions.

 

2. What is "Price lookup unavailable"?

Even though they are supported by Cryptact, we have no price data available for some coins. When you upload a transaction for a coin for which price data is not available, the system displays the transaction as "Price lookup unavailable" as a warning, flags it as an "Invalid transaction" and excludes it from the PNL calculation. For the list of supported currencies/symbols and the period for which price data is available, please refer to Supported Coins.

* In addition, Cryptact calculates the PNL in the reporting currency (default is JPY), hence it looks up the price for the settlement currency (Counter) also. If the system cannot look up a price for the settlement currency, it displays the transaction as "Price lookup unavailable and flags it as an "Invalid transaction". 

For DeFi tokens, "Price lookup unavailable" is caused by different reasons. For more details, please refer here.

3. Checking "Price lookup unavailable" and their causes

1) Check if the price data is available or not in Cryptact

Search for the coin in the Supported Coins. If it displays "取引履歴の価格:データはありません/Prices for transaction history: No price available", it means the coin is supported by Cryptact but Cryptact does not have any price data for it.

In the example below, it displays "取引履歴の価格:2021-08-25~今日/Prices for transaction data: 2021-08-25 to Today". This means Cryptact has price data from 2021-08-28 to today, but not for earlier periods.

No price available I.png

For DeFi tokens, "Price lookup unavailable" is caused by different reasons. For more details, please refer here.

4. How to fix "Price lookup unavailable"

Please fix invalid transactions in chronological order, starting from the oldest date.

Invalid transactions are excluded from the PNL calculation, which means that one invalid transaction may have a knock-on effect and cause other transactions to become invalid. In this case, fixing the oldest invalid transaction may also fix the other invalid transactions.

STEP1 STEP1 Check "Price lookup unavailable"

▼ In the "Transactions" screen, click "Status" "Invalid" → "Price lookup unavailable" → "Apply" to apply the filter and show only invalid transactions.

No price available II.png

▼ Click "TIMESTAMP" to sort transactions in chronological order.

No price available III.png

▼ Click the transaction to check the details.

No price available IV.png

STEP2 Enter price (using our "assistant" feature)

STEP2.1

Click "Step ● of ●" on the top right corner or the "Let's troubleshoot" button to navigate to the assistant screen (*1). (*1) For more details on the assistant feature, please refer to here.

No price available V.png

STEP2.2

Click "Fix invalid transactions""Repair Wizard".

No price available VI.png

STEP2.3

Click "Launch the Repair Wizard".

▼ The below screen gives you an overview of the issues that are causing invalid transactions. In this example, it is telling you that you have invalid transactions due to "Price lookup unavailable".

No price available VII.png

STEP2.4

The "Repair Wizard" automatically displays each Invalid transaction one by one on the screen in chronological order, starting from the oldest transaction date and time, and it prompts you to enter the price for one transaction at a time.

▼ Please check the price yourself, enter it into the screen and click "Add price".

No price available VIII.png

If you can wait some time, you can raise a support request to add price data from the Cryptact help page by clicking the "Support" button at the bottom right. Once the price data for the relevant coin is added, the invalid transaction due to "Price lookup unavailable" automatically disappears. (*However, if there are periods when we are unable to retrieve the price, you will need to look up the price and enter the price yourself for those periods).

* Cryptact will not add coins that are not listed on Coinmarketcap or Cryptocompare.
* Please also note that we will not provide any details on when the coin will be added or notify you when it has been added. Please check Cryptact's Supported coins (updated as needed) yourself.


For "Price lookup unavailable" in DeFi transactions, you need to first convert the DeFi transaction. This is because Cryptact currently does not allow DeFi transactions to be directly edited from the screen.

▼ In the below example, there is an invalid transaction due to "Price lookup unavailable" in DeFi because Cryptact is missing price data for FRR. You need to first click "Convert into an editable transaction".

スクリーンショット

To check supported coins and prices, please refer here.

スクリーンショット

▼ This is another example. This transaction is flagged as an invalid transaction due to "Price lookup unavailable" because AC is a DeFi token and there is no price data available for DeFi tokens. Similarly, you need to first click "Convert into an editable transaction".

スクリーンショット

For more details on the convert function for DeFi transactions, please refer here.


▼ For both of the above cases, please check the price yourself, enter it into the screen and click "Add price".

スクリーンショット

スクリーンショット

 

STEP2 Enter price

If you prefer not to use the "Assistance" feature, you can also directly enter the price from the Transaction Detail screen.

▼ Click "Repair Ledger".

No price available IX.png

▼ Please check the price yourself, enter it into the screen and click "Add price".

No price available X.png

If you can wait some time, you can raise a support request to add price data from the Cryptact help page by clicking the "Support" button at the bottom right. Once the price data for the relevant coin is added, the invalid transaction due to "Price lookup unavailable" automatically disappears. (*However, if there are periods when we are unable to retrieve the price, you will need to look up the price and enter the price yourself for those periods).

* Cryptact will not add coins that are not listed on Coinmarketcap or Cryptocompare.
* Please also note that we will not provide any details on when the coin will be added or notify you when it has been added. Please check Cryptact's Supported coins (updated as needed) yourself.

スクリーンショット


For "Price lookup unavailable" in DeFi transactions, you need to first convert the DeFi transaction. This is because Cryptact currently does not allow DeFi transactions to be directly edited from the screen.

▼ In the Transaction Detail screen for the appropriate DeFi transaction, click "Convert into an editable transaction".

スクリーンショット

For more details on the convert function for DeFi transactions, please refer here.

 

[Related Articles]
■ A coin was previously not supported by Cryptact but now it is
■ How to fix invalid transactions caused by "Insufficient position"