This article describes invalid transactions caused by "Price lookup unavailable".
Contents:
- What is "Invalid transaction"?
- What is "Price lookup unavailable"?
- Checking "Price lookup unavailable" and their causes
- How to fix "Price lookup unavailable"
STEP1 Check "Price lookup unavailable"
STEP2 Enter price (using our "assistant" feature)
STEP3 Set a price for DeFi transactions
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. For crypto-to-crypto trades and swaps, if the system cannot look up a price for the settlement currency, it calculates the market value from the price of the base currency (Base) instead, and a note is shown in the transaction details. If prices are unavailable for both the settlement currency and the base currency, the system 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 this link.
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.
For DeFi tokens, "Price lookup unavailable" is caused by different reasons. For more details, please refer this link.
4. How to fix "Price lookup unavailable"
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.
▼ Click "TIMESTAMP" to sort transactions in chronological order.
▼ Click the transaction to check the details.
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 this link.
STEP2.2
Click "Fix invalid transactions" → "Repair Wizard".
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".
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".
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 price of the coins that are not listed on Coinmarketcap.
* 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, please refer to STEP3 Set a price for DeFi transactions.
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".
▼ Please check the price yourself, enter it into the screen and click "Add price".
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, please refer to STEP3 Set a price for DeFi transactions.
STEP3 Set a price for DeFi transactions
For "Price lookup unavailable" in DeFi transactions, you can set a price directly with "Set a price" shown on the transaction detail screen, without converting the transaction.
▼ In the transaction detail screen, click "Set a price".
▼ Under "Valid for", choose "This minute" or "The whole hour", enter the price you looked up yourself, and click "Save".
▼ You can review, edit or delete the prices you set in the "Custom prices" tab of the DeFi screen.
・Your price is used only when no market price is available.
・It values every DeFi transaction with that coin in the minute or hour you set, including transactions imported after re-syncing your wallet address.
・Setting and editing prices is available on plans that include DeFi features.
・Prices are saved per coin and time (one minute or one hour), not per transaction. To set a price for one transaction only, see How to edit DeFi transactions (convert function).
・"The whole hour" covers the hour that contains the transaction time (from :00 to :59).
・Transactions are valued with prices in this order:
1. Market price of the settlement currency
2. Market price of the base currency
3. Your price for the settlement currency
4. Your price for the base currency
5. If none of these is available: 0 if Attempt Best-Effort Fallback to Zero for Price Lookups is turned on; otherwise the transaction becomes an "Invalid transaction" caused by "Price lookup unavailable".
・Your prices are not used for exchange files or API imports, custom files, or manually added transactions.
・Your prices are kept when you re-sync your wallet address.
・If a market price becomes available later, it is used from the next recalculation. Your price stays in the "Custom prices" tab but is no longer used.
・You cannot set prices for dates on or before your lock date.
・Bulk registration (e.g. by CSV file) is not supported.
[Related Articles]
■ A coin was previously not supported by cryptact but now it is
■ How to fix invalid transactions caused by "Insufficient position"