Added columns with $
https://ibb.co/z8MmXjf.
So if eth's reward downed on near 40%, then earnings in $ fell by 20% for 14 days!!!
That isn't even accurate and their is no way you can keep a 100% accurate data about mining reward
I made two scripts on JS and VBA.
1. First script scraping data from etherscan.io into txt file.
For example how it is look like:
"
12009388;2021-03-10 7:15:20291;0;Ethermine;12,494,026 (99.95%);12,499,875;75.92 Gwei;2.94848 Ether
12009387;2021-03-10 7:15:04483;0;0x3f0ee622f9e89df9db62c35cae55d57c56fd56f6;12,486,062 (99.99%);12,487,681;133.00 Gwei;3.66067 Ether
12009386;2021-03-10 7:15:02194;0;0x2f731c3e8cd264371ffdb635d07c14a6303df52a;12,473,390 (99.79%);12,499,886;110.57 Gwei;3.37912 Ether
12009385;2021-03-10 7:14:38252;1;MiningPoolHub;12,486,909 (99.99%);12,487,692;114.55 Gwei;3.49282 Ether
12009384;2021-03-10 7:14:32153;0;F2Pool;12,487,134 (99.90%);12,499,897;90.56 Gwei;3.13086 Ether
"
So it is consists of 350000 rows or more (all blocks) if i'll need. And have full data of number of block, date, pool, reward for the block.
2. Second VBA script calculate all the data from txt file to excel table.
So all eth's rewards in table are 100% accurate!!!