-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.
