Viewing a response to: @cmplxty/re-theexcelclub-202093t214827876z
The answer is yes, there are Hive API,s but I have not looked at them. There is also the SQL which is even easier to get data from, however you have to pay a sub for the SQL data on hive. From the hive SQL you can chart and track all movement from the internal market, in which the price feed comes from the witnesses and exchanges. I use to do posts on it.
| author | theexcelclub |
|---|---|
| permlink | re-cmplxty-qg4ox8 |
| category | excel |
| json_metadata | {"tags":["excel"],"app":"peakd/2020.08.3"} |
| created | 2020-09-04 09:55:57 |
| last_update | 2020-09-04 09:55:57 |
| depth | 2 |
| children | 5 |
| last_payout | 2020-09-11 09:55:57 |
| 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 | 360 |
| author_reputation | 49,417,421,433,400 |
| root_title | "How to connect Excel to Coinmarketcap API" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,443,455 |
| net_rshares | 275,527,269 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| oakshieldholding | 0 | 74,870,852 | 33% | ||
| abh12345.stem | 0 | 200,656,417 | 33% |
Oh you have to pay who for the hive data? That’s kind of a pain!
| author | cmplxty |
|---|---|
| permlink | re-theexcelclub-202094t64116742z |
| category | excel |
| json_metadata | {"tags":["excel"],"app":"ecency/3.0.3-mobile","format":"markdown+html"} |
| created | 2020-09-04 10:41:18 |
| last_update | 2020-09-04 10:41:18 |
| depth | 3 |
| children | 4 |
| last_payout | 2020-09-11 10:41:18 |
| 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 | 64 |
| author_reputation | 787,492,477,114,625 |
| root_title | "How to connect Excel to Coinmarketcap API" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,443,959 |
| net_rshares | 0 |
@hivesql - 4 HBD/day or 40 for the month :)
| author | abh12345.stem |
|---|---|
| permlink | qg945v |
| category | excel |
| json_metadata | {"tags":["stem"],"users":["hivesql"],"app":"stemgeeks/0.1","canonical_url":"https://stemgeeks.net/@abh12345.stem/qg945v"} |
| created | 2020-09-06 19:15:30 |
| last_update | 2020-09-06 19:15:30 |
| depth | 4 |
| children | 3 |
| last_payout | 2020-09-13 19:15:30 |
| 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 | 43 |
| author_reputation | 410,560,470,359 |
| root_title | "How to connect Excel to Coinmarketcap API" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,487,112 |
| net_rshares | 0 |
Oh man thanks, I don’t know if I’ll be spending that until I can have the ability to do consistent pulls! I guess it makes sense to charge for it lol
| author | cmplxty |
|---|---|
| permlink | re-abh12345stem-202096t152227611z |
| category | excel |
| json_metadata | {"tags":["ecency"],"app":"ecency/3.0.3-mobile","format":"markdown+html"} |
| created | 2020-09-06 19:22:27 |
| last_update | 2020-09-06 19:22:27 |
| depth | 5 |
| children | 2 |
| last_payout | 2020-09-13 19:22:27 |
| 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 | 149 |
| author_reputation | 787,492,477,114,625 |
| root_title | "How to connect Excel to Coinmarketcap API" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 99,487,208 |
| net_rshares | 138,447,363 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| oakshieldholding | 0 | 31,832,921 | 20% | ||
| abh12345.stem | 0 | 106,614,442 | 20% |
hiveblocks