RoxxR (OP)
|
|
June 06, 2022, 04:03:22 PM |
|
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!
|
|
|
|
Charles-Tim
Legendary
Offline
Activity: 1708
Merit: 5179
Leading Crypto Sports Betting & Casino Platform
|
|
June 06, 2022, 04:20:47 PM |
|
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.
|
..Stake.com.. | | | ▄████████████████████████████████████▄ ██ ▄▄▄▄▄▄▄▄▄▄ ▄▄▄▄▄▄▄▄▄▄ ██ ▄████▄ ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██ ██████ ██ ██████████ ██ ██ ██████████ ██ ▀██▀ ██ ██ ██ ██████ ██ ██ ██ ██ ██ ██ ██████ ██ █████ ███ ██████ ██ ████▄ ██ ██ █████ ███ ████ ████ █████ ███ ████████ ██ ████ ████ ██████████ ████ ████ ████▀ ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██ ██ ▀▀▀▀▀▀▀▀▀▀ ██ ▀█████████▀ ▄████████████▄ ▀█████████▀ ▄▄▄▄▄▄▄▄▄▄▄▄███ ██ ██ ███▄▄▄▄▄▄▄▄▄▄▄▄ ██████████████████████████████████████████ | | | | | | ▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄ █ ▄▀▄ █▀▀█▀▄▄ █ █▀█ █ ▐ ▐▌ █ ▄██▄ █ ▌ █ █ ▄██████▄ █ ▌ ▐▌ █ ██████████ █ ▐ █ █ ▐██████████▌ █ ▐ ▐▌ █ ▀▀██████▀▀ █ ▌ █ █ ▄▄▄██▄▄▄ █ ▌▐▌ █ █▐ █ █ █▐▐▌ █ █▐█ ▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█ | | | | | | ▄▄█████████▄▄ ▄██▀▀▀▀█████▀▀▀▀██▄ ▄█▀ ▐█▌ ▀█▄ ██ ▐█▌ ██ ████▄ ▄█████▄ ▄████ ████████▄███████████▄████████ ███▀ █████████████ ▀███ ██ ███████████ ██ ▀█▄ █████████ ▄█▀ ▀█▄ ▄██▀▀▀▀▀▀▀██▄ ▄▄▄█▀ ▀███████ ███████▀ ▀█████▄ ▄█████▀ ▀▀▀███▄▄▄███▀▀▀ | | | ..PLAY NOW.. |
|
|
|
RoxxR (OP)
|
|
June 06, 2022, 04:42:11 PM |
|
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).
|
|
|
|
|
Pmalek
Legendary
Offline
Activity: 2926
Merit: 7522
Playgram - The Telegram Casino
|
|
June 06, 2022, 05:59:14 PM |
|
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.
|
|
|
|
▄▄███████▄▄███████ ▄███████████████▄▄▄▄▄ ▄████████████████████▀░ ▄█████████████████████▄░ ▄█████████▀▀████████████▄ ██████████████▀▀█████████ █████████████████████████ ██████████████▄▄█████████ ▀█████████▄▄████████████▀ ▀█████████████████████▀░ ▀████████████████████▄░ ▀███████████████▀▀▀▀▀ ▀▀███████▀▀███████ | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ Playgram.io ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ | ▄▄▄░░ ▀▄ █ █ █ █ █ █ █ ▄▀ ▀▀▀░░
| │ | ▄▄▄███████▄▄▄ ▄▄███████████████▄▄ ▄███████████████████▄ ▄██████████████▀▀█████▄ ▄██████████▀▀███▄██▐████▄ ██████▀▀████▄▄▀▀█████████ ████▄▄███▄██▀█████▐██████ ██████████▀██████████████ ▀███████▌▐██▄████▐██████▀ ▀███████▄▄███▄████████▀ ▀███████████████████▀ ▀▀███████████████▀▀ ▀▀▀███████▀▀▀ | | │ | ██████▄▄███████▄▄████████ ███▄███████████████▄░░▀█▀ ███████████░█████████░░█ ░█████▀██▄▄░▄▄██▀█████░█ █████▄░▄███▄███▄░▄██████ ████████████████████████ ████████████████████████ ██░▄▄▄░██░▄▄▄░██░▄▄▄░███ ██░░░█░██░░░█░██░░░█░████ ██░░█░░██░░█░░██░░█░░████ ██▄▄▄▄▄██▄▄▄▄▄██▄▄▄▄▄████ ███████████████████████ ███████████████████████ | | │ | ► | |
|
|
|
nc50lc
Legendary
Offline
Activity: 2576
Merit: 6257
Self-proclaimed Genius
|
|
June 07, 2022, 04:03:45 AM |
|
-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 (OP)
|
|
June 07, 2022, 10:05:36 AM Last edit: June 07, 2022, 12:35:24 PM by Mr. Big |
|
-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
Legendary
Offline
Activity: 3836
Merit: 6570
Looking for campaign manager? Contact icopress!
|
|
June 07, 2022, 10:27:25 AM Last edit: May 14, 2023, 02:55:05 PM by 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
Legendary
Offline
Activity: 2576
Merit: 6257
Self-proclaimed Genius
|
|
June 07, 2022, 10:38:05 AM |
|
-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
Legendary
Offline
Activity: 3402
Merit: 6112
Crypto Swap Exchange🈺
|
|
June 07, 2022, 11:03:33 AM |
|
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
Legendary
Offline
Activity: 2926
Merit: 7522
Playgram - The Telegram Casino
|
|
June 07, 2022, 01:24:25 PM Last edit: November 12, 2023, 09:38:00 AM by 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.
|
|
|
|
▄▄███████▄▄███████ ▄███████████████▄▄▄▄▄ ▄████████████████████▀░ ▄█████████████████████▄░ ▄█████████▀▀████████████▄ ██████████████▀▀█████████ █████████████████████████ ██████████████▄▄█████████ ▀█████████▄▄████████████▀ ▀█████████████████████▀░ ▀████████████████████▄░ ▀███████████████▀▀▀▀▀ ▀▀███████▀▀███████ | ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ Playgram.io ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ | ▄▄▄░░ ▀▄ █ █ █ █ █ █ █ ▄▀ ▀▀▀░░
| │ | ▄▄▄███████▄▄▄ ▄▄███████████████▄▄ ▄███████████████████▄ ▄██████████████▀▀█████▄ ▄██████████▀▀███▄██▐████▄ ██████▀▀████▄▄▀▀█████████ ████▄▄███▄██▀█████▐██████ ██████████▀██████████████ ▀███████▌▐██▄████▐██████▀ ▀███████▄▄███▄████████▀ ▀███████████████████▀ ▀▀███████████████▀▀ ▀▀▀███████▀▀▀ | | │ | ██████▄▄███████▄▄████████ ███▄███████████████▄░░▀█▀ ███████████░█████████░░█ ░█████▀██▄▄░▄▄██▀█████░█ █████▄░▄███▄███▄░▄██████ ████████████████████████ ████████████████████████ ██░▄▄▄░██░▄▄▄░██░▄▄▄░███ ██░░░█░██░░░█░██░░░█░████ ██░░█░░██░░█░░██░░█░░████ ██▄▄▄▄▄██▄▄▄▄▄██▄▄▄▄▄████ ███████████████████████ ███████████████████████ | | │ | ► | |
|
|
|
|