show fees paid for past transactions

[RoxxR]

Is there any way of adding a "fee paid" column to the history view?

Or alternatively, a console script to get fees paid for your past transactions?

Couldn't find anything in the forum.

Thanks!

[1715181900]

1715181900

[1715181900]

1715181900

[1715181900]

1715181900

[1715181900]

1715181900

[1715181900]

1715181900

[Charles-Tim]

Which wallet are you using? If it is Electrum, I do not think the fee can be added as an additional column. But on the transaction history, you can just select the transaction, right click on it and click on 'view transaction'. If the fee is not shown, you can click on 'view on block explorer' instead, but which will connect to blockstream, one of the blockchain explorers that details you the transaction in which the fee is included.

[RoxxR]

Which wallet are you using? If it is Electrum, I do not think the fee can be added as an additional column. But on the transaction history, you can just select the transaction, right click on it and click on 'view transaction'. If the fee is not shown, you can click on 'view on block explorer' instead, but which will connect to blockstream, one of the blockchain explorers that details you the transaction in which the fee is included.

I'm using Electrum on Windows.
I know I can view the fee for any transaction as you have mentioned, but I would like to view the fees for my entire transaction history at a glance, or be able to export this information to some type of text-based extract (csv or other).

[OmegaStarScream]

I'm using Electrum on Windows.
I know I can view the fee for any transaction as you have mentioned, but I would like to view the fees for my entire transaction history at a glance, or be able to export this information to some type of text-based extract (csv or other).

I'm not really that familiar with Electrum's scripts, but it should be possible to write something that does that. I found this[1].

Alternatively (if you have the technical knowledge) you can always use a blockexplorer's API[2] to watch your addresses and retrieve the transactions history (with the fees).

[1] https://gist.github.com/chill117/58f22c073db8f9d230ae
[2] https://developers.cryptoapis.io/technical-documentation/blockchain-data/unified-endpoints/get-transaction-details-by-transaction-id

[Pmalek]

I have never seen a proposal such as yours before. Can you tell me what you were planning to use the data for if it's not a secret?
If it has something to do with using the historical records to try and predict future fees, you are not going to find any correlation there because history doesn't repeat itself when it comes to fees. 

[nc50lc]

-snip-
I'm using Electrum on Windows.
I know I can view the fee for any transaction as you have mentioned, but I would like to view the fees for my entire transaction history at a glance, or be able to export this information to some type of text-based extract (csv or other).

You can only export the entire transaction history in ".json" format, that includes a "fee" and "fee_sat" names and values.
Inbound transactions will show "null" values for the fee.

Go to the menu "Wallet->History->Export" and select "json", or CSV if want it to be compact but it doesn't have "names", just values.

Here's a 'Notepad++' trick to filter the export file:

• Open 'electrum-history.json' file using Notepad++
• Use 'Find' (CTRL+F), go to 'Mark' tab and tick "bookmark line".
• Type "fee_sat" then click "Mark all", all lines with "fee_sat" will have blue-circle next to the line's number.
• Exit 'Find' dialogue box and click the menu "Search->Bookmark->Remove Unbookmarked Lines", and only "fee_sat" lines will be left.
  
  

If you want to remove the 'null' values, re-do all the steps but use "Clear all marks" in 'Find' first (to remove the current bookmarks),
bookmark lines with "null", then use "Search->Bookmark->Remove Bookmarked Lines" instead.

[RoxxR]

-snip-
I'm using Electrum on Windows.
I know I can view the fee for any transaction as you have mentioned, but I would like to view the fees for my entire transaction history at a glance, or be able to export this information to some type of text-based extract (csv or other).

You can only export the entire transaction history in ".json" format, that includes a "fee" and "fee_sat" names and values.
Inbound transactions will show "null" values for the fee.

Go to the menu "Wallet->History->Export" and select "json", or CSV if want it to be compact but it doesn't have "names", just values.

Here's a 'Notepad++' trick to filter the export file:

• Open 'electrum-history.json' file using Notepad++
• Use 'Find' (CTRL+F), go to 'Mark' tab and tick "bookmark line".
• Type "fee_sat" then click "Mark all", all lines with "fee_sat" will have blue-circle next to the line's number.
• Exit 'Find' dialogue box and click the menu "Search->Bookmark->Remove Unbookmarked Lines", and only "fee_sat" lines will be left.
  
  

If you want to remove the 'null' values, re-do all the steps but use "Clear all marks" in 'Find' first (to remove the current bookmarks),
bookmark lines with "null", then use "Search->Bookmark->Remove Bookmarked Lines" instead.

Thanks a lot, that was very helpful.

I have never seen a proposal such as yours before. Can you tell me what you were planning to use the data for if it's not a secret?
If it has something to do with using the historical records to try and predict future fees, you are not going to find any correlation there because history doesn't repeat itself when it comes to fees.  

I just wanted to get an idea of how much I paid in fees over the last few months.

[NeuroticFish]

You can only export the entire transaction history in ".json" format, that includes a "fee" and "fee_sat" names and values.
Inbound transactions will show "null" values for the fee.

Go to the menu "Wallet->History->Export" and select "json", or CSV if want it to be compact but it doesn't have "names", just values.

The direction is pretty good, but I don't understand why CSV is not good, really.
I've exported CSV and opened with Excel/LibreOffice Calc and it looks great, it has headers, one can use mathematical operations on it:

[nc50lc]

-snip-
Go to the menu "Wallet->History->Export" and select "json", or CSV if want it to be compact but it doesn't have "names", just values.

The direction is pretty good, but I don't understand why CSV is not good, really.
I've exported CSV and opened with Excel/LibreOffice Calc and it looks great, it has headers, one can use mathematical operations on it:

It's just my personal preference and to be honest, I haven't used the CSV format.
Plus the next part of my reply wont work with "electrum-history.csv" export.

[Lucius]

In the Android version, there is fee information next to each outgoing transaction in sats, but if the $ view is selected, there is no value display. Would creating a watch-only wallet on Android would make that info displayed?

[Pmalek]

In the Android version, there is fee information next to each outgoing transaction in sats, but if the $ view is selected, there is no value display. Would creating a watch-only wallet on Android would make that info displayed?

That works. I just tried it by importing a random address from mempool.space. The thing is, for some reason it doesn't display the fees for all outgoing transactions. I had to browse down a bit and as you can see, it's visible for outgoing transactions. But for the most recent ones that were made, the info is not there.