Exporting token price details from Etherscan

vv181

legendary

Activity: 1932

Merit: 1273

Quote from: erikalui on April 03, 2022, 05:22:02 AM

I need to find a way to export the price price at the time of the transaction which is "Estimated value on day of transfer" from an address.

Please let me know how to get these details in an excel sheet along with the other transaction details.

One option I could think of is to fetch the price API using CMC or Coingecko, then calculate and match with the transaction value and datetime.

Roughly speaking, to get the full data you can export the csv from the address main page, and add some additional column for the price at the time of the transaction. That will require you to make some formulas to make the process easier. I don't know if there is another option.

Tytanowy Janusz

legendary

Activity: 2156

Merit: 1622

Quote from: erikalui on April 03, 2022, 05:22:02 AM

I exported the transaction details from Etherscan in a CSV file but this data doesn't show the price of the token at the time of transfer which I can get by checking the transaction URL.

For example: 0xd42dd724baf890a981fc013c40f83553dba53b51145869d56b4eb14fcb72d156

Here I can see "Tokens Transferred" "From" "To" "For" values and here, the token price is " 12.40 ".

I need to find a way to export the price price at the time of the transaction which is "Estimated value on day of transfer" from an address.

Please let me know how to get these details in an excel sheet along with the other transaction details.

There is no way to extract it from etherscan but there is an easy solution. If you have amount of token send and amount of token recived all in one CSV file than all you have to do to get price is divide both numbers by one another.

example:

erikalui

legendary

Activity: 2632

Merit: 1094

I exported the transaction details from Etherscan in a CSV file but this data doesn't show the price of the token at the time of transfer which I can get by checking the transaction URL.

For example: 0xd42dd724baf890a981fc013c40f83553dba53b51145869d56b4eb14fcb72d156

Here I can see "Tokens Transferred" "From" "To" "For" values and here, the token price is " 12.40 ".

I need to find a way to export the price price at the time of the transaction which is "Estimated value on day of transfer" from an address.

Please let me know how to get these details in an excel sheet along with the other transaction details.

Topic: Exporting token price details from Etherscan (Read 63 times)