I was asked if it was possible to audit ethereum blockchain data with Excel. The simple answer is yes, but it depends on the scope of the audit. Auditing wallet transactions in Excel is easy enough, but auditing the code of a smart contract created on the ether blockchain requires a little coding knowledge. In this video, we will look at connecting Excel to the etherscan API. We will look at the etherscan API documentation and creating endpoints to be used in Excel with a Web query https://youtu.be/jOC3rLVFbyw
| author | paulag |
|---|---|
| permlink | yes-you-can-analyze-and-audit-ethereum-blockchain-data-in-excel |
| category | hive-167922 |
| json_metadata | {"app":"peakd/2020.09.4","format":"markdown","tags":["ethereum","excel","blockchain-audit","blockchaindata","blockcahin-api","palnet"]} |
| created | 2020-09-21 13:14:03 |
| last_update | 2020-09-21 13:14:03 |
| depth | 0 |
| children | 3 |
| last_payout | 2020-09-28 13:14:03 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 2.568 HBD |
| curator_payout_value | 2.244 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 521 |
| author_reputation | 274,264,287,951,003 |
| root_title | "Yes you can analyze and audit Ethereum blockchain data in Excel" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,743,130 |
| net_rshares | 19,661,436,035,700 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| nanzo-scoop | 0 | 344,945,336,447 | 50% | ||
| mummyimperfect | 0 | 49,857,801,045 | 50% | ||
| ak2020 | 0 | 19,881,703,075 | 50% | ||
| emily-cook | 0 | 1,523,963,230 | 50% | ||
| livingfree | 0 | 539,460,499,290 | 6% | ||
| nascimentoab | 0 | 5,186,748,286 | 100% | ||
| arcange | 0 | 68,793,380,827 | 2% | ||
| demotruk | 0 | 4,261,522,994,945 | 100% | ||
| raphaelle | 0 | 1,824,429,926 | 2% | ||
| ace108 | 0 | 180,041,177,667 | 5% | ||
| jschindler | 0 | 549,896,354,316 | 100% | ||
| solar | 0 | 11,481,022,710 | 25% | ||
| shadowspub | 0 | 82,870,225,504 | 50% | ||
| solrasol | 0 | 15,287,076,946 | 100% | ||
| por500bolos | 0 | 29,080,603,839 | 75% | ||
| abh12345 | 0 | 669,844,498,775 | 20% | ||
| t-bot | 0 | 934,037,932 | 50% | ||
| slider2990 | 0 | 6,904,532,969 | 20% | ||
| created | 0 | 1,276,628,523,966 | 6% | ||
| felix.herrmann | 0 | 118,066,271,596 | 100% | ||
| mafeeva | 0 | 60,340,352,235 | 50% | ||
| dreemsteem | 0 | 1,777,157,978 | 25% | ||
| steemitboard | 0 | 3,254,345,799 | 2% | ||
| danielsaori | 0 | 178,660,678,345 | 100% | ||
| oluwoleolaide | 0 | 57,585,829,778 | 70% | ||
| freebornsociety | 0 | 1,781,237,431 | 10% | ||
| tamaralovelace | 0 | 115,482,631,767 | 100% | ||
| clixmoney | 0 | 20,429,838,202 | 50% | ||
| stevelivingston | 0 | 52,315,912,192 | 25% | ||
| flauwy | 0 | 175,967,021,753 | 100% | ||
| spectrumecons | 0 | 1,435,288,192,157 | 30% | ||
| wesphilbin | 0 | 3,242,190,602 | 9% | ||
| binkyprod | 0 | 36,407,393,727 | 50% | ||
| vallesleoruther | 0 | 91,989,713,337 | 100% | ||
| jacekw | 0 | 47,903,196,823 | 100% | ||
| dernan | 0 | 849,619,558 | 100% | ||
| pixelfan | 0 | 13,129,464,291 | 2% | ||
| krazypoet | 0 | 1,325,152,207 | 5% | ||
| doktormuslem | 0 | 48,602,235,582 | 58% | ||
| nascimentocb | 0 | 1,447,998,759 | 100% | ||
| rehan12 | 0 | 5,309,983,426 | 5% | ||
| bashadow | 0 | 55,969,521,038 | 25% | ||
| lmon | 0 | 3,640,547 | 45% | ||
| niallon11 | 0 | 780,697,174,197 | 100% | ||
| aneukpineung78 | 0 | 3,861,132,641 | 100% | ||
| adi.pisces | 0 | 2,602,941,433 | 100% | ||
| crokkon | 0 | 52,870,543,901 | 100% | ||
| eastmael | 0 | 99,464,871,109 | 100% | ||
| roleerob | 0 | 177,711,058,895 | 20% | ||
| revisesociology | 0 | 379,733,225,628 | 25% | ||
| espoem | 0 | 16,654,400,821 | 5% | ||
| msp-foundation | 0 | 0 | 89.49% | ||
| afukichi | 0 | 4,696,990,632 | 100% | ||
| happydolphin | 0 | 17,358,651,610 | 10% | ||
| vegoutt-travel | 0 | 16,772,324,182 | 30% | ||
| phoenixwren | 0 | 106,048,944,158 | 100% | ||
| traciyork | 0 | 864,006,055,531 | 100% | ||
| paintingangels | 0 | 55,762,360,062 | 100% | ||
| johnspalding | 0 | 55,022,262,154 | 100% | ||
| mytechtrail | 0 | 40,955,825,211 | 15% | ||
| steeminer4up | 0 | 1,414,845,785 | 100% | ||
| ravenruis | 0 | 23,019,071,848 | 75% | ||
| crookshanks | 0 | 1,298,115,740 | 50% | ||
| luoq | 0 | 17,110,724,971 | 100% | ||
| mmmmkkkk311 | 0 | 162,067,812,246 | 2% | ||
| bennettitalia | 0 | 23,624,324,458 | 25% | ||
| tryskele | 0 | 3,714,907,672 | 4% | ||
| chrismadcboy2016 | 0 | 8,024,621,138 | 100% | ||
| philnewton | 0 | 664,333,663 | 10% | ||
| newageinv | 0 | 744,732,688 | 20% | ||
| icuz | 0 | 287,650,144 | 100% | ||
| twanz | 0 | 545,749,953 | 100% | ||
| organicgardener | 0 | 1,238,637,990 | 50% | ||
| orlandumike | 0 | 10,077,523,972 | 25% | ||
| east.autovote | 0 | 776,226,709 | 100% | ||
| beeyou | 0 | 37,953,193,449 | 100% | ||
| richatvns | 0 | 681,811,794 | 0.5% | ||
| simplymike | 0 | 80,717,292,272 | 50% | ||
| lauchmelder | 0 | 2,428,880,621 | 50% | ||
| nervi | 0 | 2,406,145,908 | 100% | ||
| scottshots | 0 | 2,678,830,919 | 4% | ||
| stmdev | 0 | 386,883,945 | 10% | ||
| wolfhart | 0 | 6,835,806,977 | 17% | ||
| prettynicevideo | 0 | 23,851,078,512 | 15% | ||
| gadrian | 0 | 2,881,793,297 | 1.92% | ||
| peekbit | 0 | 26,808,463,340 | 99.88% | ||
| legendchew | 0 | 33,660,047,580 | 100% | ||
| thegoldencobra | 0 | 6,504,948,138 | 100% | ||
| payroll | 0 | 103,762,639,105 | 2% | ||
| we-are | 0 | 0 | 16.57% | ||
| sbi3 | 0 | 987,787,795,062 | 97.07% | ||
| enforcer48 | 0 | 125,150,694,772 | 15% | ||
| akdx | 0 | 14,517,534,109 | 25% | ||
| pupu93 | 0 | 6,618,379,493 | 100% | ||
| simplegame | 0 | 33,385,341,281 | 100% | ||
| fitat40 | 0 | 9,311,285,911 | 50% | ||
| cmplxty | 0 | 89,547,053,794 | 30% | ||
| thehive | 0 | 78,651,690,909 | 50% | ||
| dalz | 0 | 165,346,953,608 | 50% | ||
| jk6276 | 0 | 0 | 1% | ||
| dcooperation | 0 | 8,529,675,058 | 2% | ||
| theexcelclub | 0 | 238,667,609,921 | 100% | ||
| laissez-faire | 0 | 43,872,959 | 100% | ||
| lion200 | 0 | 13,186,908,901 | 50% | ||
| communityaction | 0 | 5,078,449,488 | 100% | ||
| brianoflondon | 0 | 1,314,275,579,692 | 100% | ||
| arteem | 0 | 5,320,491,840 | 75% | ||
| deepsouthpiddlin | 0 | 8,868,962,747 | 50% | ||
| xcountytravelers | 0 | 5,735,654,040 | 15% | ||
| olivier.jacobs | 0 | 584,566,373 | 100% | ||
| bluerobo | 0 | 109,502,769,762 | 100% | ||
| princessamber | 0 | 2,091,389,548 | 100% | ||
| ctime | 0 | 785,894,299,931 | 5% | ||
| thekillingqueen | 0 | 598,954,433 | 50% | ||
| ghostdylan | 0 | 2,099,517,016 | 100% | ||
| battlemaster | 0 | 3,088,479,918 | 50% | ||
| scoopstakes | 0 | 13,182,663,863 | 50% | ||
| nanzo-snaps | 0 | 8,733,358,308 | 50% | ||
| hanke | 0 | 7,128,312,581 | 100% | ||
| heyhaveyamet | 0 | 111,417,213,595 | 60% | ||
| sm-skynet | 0 | 1,331,495,120 | 100% | ||
| kharma.scribbles | 0 | 1,488,629,518 | 37.5% | ||
| src3 | 0 | 15,732,793,234 | 25% | ||
| beamentor | 0 | 7,143,613,600 | 100% | ||
| itisjustme | 0 | 1,084,263,437 | 50% | ||
| engrsayful | 0 | 2,261,344,747 | 3% | ||
| raspibot | 0 | 3,613,842,883 | 100% | ||
| dtrade | 0 | 581,492,330 | 20% | ||
| scholaris | 0 | 139,819,118,245 | 50% | ||
| lordoffaux | 0 | 665,749,993 | 0.5% | ||
| kendra19 | 0 | 4,031,995,029 | 100% | ||
| hgn66 | 0 | 1,924,762,387 | 100% | ||
| we-are-palcoin | 0 | 1,503,501 | 12% | ||
| lookplz | 0 | 4,153,474,410 | 100% | ||
| strongwoman | 0 | 1,303,125,174 | 100% | ||
| ssiena | 0 | 4,960,077,536 | 30% | ||
| leo.voter | 0 | 792,855,092,405 | 6% | ||
| sbi-tokens | 0 | 4,098,520,331 | 12.05% | ||
| mk-sports-token | 0 | 48,047,495 | 50% | ||
| ctl001 | 0 | 592,313,223 | 100% | ||
| blocktvnews | 0 | 809,359,105 | 50% | ||
| steemlondon | 0 | 560,921,372 | 6% | ||
| flauwy.apx | 0 | 2,519,976,068 | 100% | ||
| gmlrecordz | 0 | 4,970,804,336 | 50% | ||
| journeyofanomad | 0 | 4,777,976,332 | 40% | ||
| fengchao | 0 | 2,531,873,949 | 2% | ||
| leofinance | 0 | 5,591,603,331 | 6% | ||
| blue-witness | 0 | 3,386,162,903 | 100% | ||
| hiveyoda | 0 | 11,683,391,872 | 6% | ||
| captainhive | 0 | 558,833,106,205 | 30% | ||
| localgrower | 0 | 8,614,720,604 | 10% | ||
| adamsidney | 0 | 30,653,985 | 8% | ||
| greentealover | 0 | 1,397,863,821 | 100% | ||
| godapp76 | 0 | 827,003,986 | 100% | ||
| hive-108278 | 0 | 8,322,944,329 | 25% | ||
| hivve | 0 | 1,060,612,167 | 100% |
Congratulations @paulag! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) : <table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@paulag/upvotes.png?202010041523"></td><td>You distributed more than 64000 upvotes. Your next target is to reach 65000 upvotes.</td></tr> </table> <sub>_You can view your badges on [your board](https://hivebuzz.me/@paulag) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> **Do not miss the last post from @hivebuzz:** <table><tr><td><a href="/hivebuzz/@hivebuzz/feedback-from-the-october-1st-hive-power-up-day"><img src="https://images.hive.blog/64x128/https://i.imgur.com/lZQYVmN.png"></a></td><td><a href="/hivebuzz/@hivebuzz/feedback-from-the-october-1st-hive-power-up-day">Feedback from the October 1st Hive Power Up Day</a></td></tr><tr><td><a href="/hivebuzz/@hivebuzz/pud-helper"><img src="https://images.hive.blog/64x128/https://i.imgur.com/Fg3dhfw.png"></a></td><td><a href="/hivebuzz/@hivebuzz/pud-helper">Hive Power Up Day - Introducing the Power Up Helper!</a></td></tr></table>
| author | hivebuzz |
|---|---|
| permlink | hivebuzz-notify-paulag-20201004t153156000z |
| category | hive-167922 |
| json_metadata | {"image":["http://hivebuzz.me/notify.t6.png"]} |
| created | 2020-10-04 15:31:54 |
| last_update | 2020-10-04 15:31:54 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-10-11 15:31:54 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 1,245 |
| author_reputation | 368,218,101,992,765 |
| root_title | "Yes you can analyze and audit Ethereum blockchain data in Excel" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,959,685 |
| net_rshares | 0 |
https://twitter.com/ProfTAcademy/status/1308033013540950019
| author | poshbot |
|---|---|
| permlink | re-yes-you-can-analyze-and-audit-ethereum-blockchain-data-in-excel-20200921t131943z |
| category | hive-167922 |
| json_metadata | "{"app": "beem/0.24.8"}" |
| created | 2020-09-21 13:19:42 |
| last_update | 2020-09-21 13:19:42 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-09-28 13:19:42 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 59 |
| author_reputation | 5,554,335,374,496 |
| root_title | "Yes you can analyze and audit Ethereum blockchain data in Excel" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,743,212 |
| net_rshares | 0 |
https://twitter.com/TraciYorkWriter/status/1308082299209220101
| author | poshbot |
|---|---|
| permlink | re-yes-you-can-analyze-and-audit-ethereum-blockchain-data-in-excel-20200921t163504z |
| category | hive-167922 |
| json_metadata | "{"app": "beem/0.24.8"}" |
| created | 2020-09-21 16:35:03 |
| last_update | 2020-09-21 16:35:03 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-09-28 16:35:03 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 62 |
| author_reputation | 5,554,335,374,496 |
| root_title | "Yes you can analyze and audit Ethereum blockchain data in Excel" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,746,133 |
| net_rshares | 0 |
hiveblocks