Another day, another post asking how much Steem Power is behind bid bots and how they are the death of Steem.

But I thought it was over 50%?

Nope. Not even close.

But trending sucks!

Yes, it does, always has. Bots haven't changed that, it just changed who can get there. Instead of a handful of whales and select few friends of the whales, everyone has access to trending. Like before bid bots, everyone still has access to flagging, but hey who flags right? If you listen to this idiot no one.

I call bullshit, bid bots are more than 50% and that's what I'm going to tell everyone.

Suit yourself, there has never really been much truth on Steemit, it's far easier to just make shit up than do the research.

Prove it then

First I got a list of all the bid bots on @yabapmatt's SteemBotTracker site via the /bid_bots endpoint.

This gave me this list:

buildawhale
boomerang
minnowhelper
lovejuice
sneaky-ninja
appreciator
pushup
aksdwi
msp-bidbot
upme
postpromoter
upgoater
allaz
smartsteem
mercurybot
upmewhale
sleeplesswhale
steembloggers
adriatik
seakraken
voterunner
bid4joy
nado.bot
shares
whalebuilder
redlambo
inciter
therising
luckyvotes
postdoctor
brupvoter
isotonic
chronocrypto
spydo
onlyprofitbot
mitsuko
sunrawhale
foxyd
honestbot
upboater
promobot
ebargains
dailyupvotes
bluebot
estream.studios
singing.beauty
megabot
slimwhale
lightningbolt
booster
thebot
minnowvotes
estabond
rocky1
dolphinbot
lost-ninja
redwhale
noicebot
flymehigh
authors.league
brandonfrye
peace-bot
fishbaitbot
bodzila
lrd
proffit
emperorofnaps
dlivepromoter
pushbot
ubot
steemerap
profitvote
cabbage-dealer
siditech
automation
ecotrain
themoneytree
profitbot
whalecreator
botox
oceanwhale
edensgarden
bearwards
th3voter
ptbot
sureshot
stef
moneymatchgaming
t50
francophonie
votepower
peoplesbot
steemcreators
joeparys
whalepromobot
alfanso
haveaheart
brotherhood
tainika
pwrup
upyourpost
jerrybanfield
boinger
a-bot
alliedforces
weupvote
getkarma
chronoboost

For those who are wondering, there are 108 bid bots.

I then added minnowbooster because it listed under promotional bots and not bid bots.

I then took this list and ran two queries on SteemSQL. The first gives me the total Steem Power allocated to bid bots in this list. The formula is simple, Steem Power + Delegation In - Delegation Out.

select sum(cast(substring(vesting_shares, 1, CHARINDEX(' ', vesting_shares)-1) as Decimal(20,6)))
+ sum(cast(substring(received_vesting_shares, 1, CHARINDEX(' ', received_vesting_shares)-1) as Decimal(20,6))) 
- sum(cast(substring(delegated_vesting_shares, 1, CHARINDEX(' ', delegated_vesting_shares)-1) as Decimal(20,6)))
from accounts
where name in (
'buildawhale',
'boomerang',
'minnowbooster',
'minnowhelper',
'lovejuice',
'sneaky-ninja',
'appreciator',
'pushup',
'aksdwi',
'msp-bidbot',
'upme',
'postpromoter',
'upgoater',
'allaz',
'smartsteem',
'mercurybot',
'upmewhale',
'sleeplesswhale',
'steembloggers',
'adriatik',
'seakraken',
'voterunner',
'bid4joy',
'nado.bot',
'shares',
'whalebuilder',
'redlambo',
'inciter',
'therising',
'luckyvotes',
'postdoctor',
'brupvoter',
'isotonic',
'chronocrypto',
'spydo',
'onlyprofitbot',
'mitsuko',
'sunrawhale',
'foxyd',
'honestbot',
'upboater',
'promobot',
'ebargains',
'dailyupvotes',
'bluebot',
'estream.studios',
'singing.beauty',
'megabot',
'slimwhale',
'lightningbolt',
'booster',
'thebot',
'minnowvotes',
'estabond',
'rocky1',
'dolphinbot',
'lost-ninja',
'redwhale',
'noicebot',
'flymehigh',
'authors.league',
'brandonfrye',
'peace-bot',
'fishbaitbot',
'bodzila',
'lrd',
'proffit',
'emperorofnaps',
'dlivepromoter',
'pushbot',
'ubot',
'steemerap',
'profitvote',
'cabbage-dealer',
'siditech',
'automation',
'ecotrain',
'themoneytree',
'profitbot',
'whalecreator',
'botox',
'oceanwhale',
'edensgarden',
'bearwards',
'th3voter',
'ptbot',
'sureshot',
'stef',
'moneymatchgaming',
't50',
'francophonie',
'votepower',
'peoplesbot',
'steemcreators',
'joeparys',
'whalepromobot',
'alfanso',
'haveaheart',
'brotherhood',
'tainika',
'pwrup',
'upyourpost',
'jerrybanfield',
'boinger',
'a-bot',
'alliedforces',
'weupvote',
'getkarma',
'chronoboost'
)

This gives me the result of 43,124,045,125.085064 Vests.

1,000,000 vests equal 492.539 Steem, so that means 21,240,294.1576 Steem Power is controlled by bots.

Next, we need to find how much Steem Power is not controlled by bots.

Running the same query but excluding the previous data set will give us the rest of the community.

select sum(cast(substring(vesting_shares, 1, CHARINDEX(' ', vesting_shares)-1) as Decimal(20,6)))
+ sum(cast(substring(received_vesting_shares, 1, CHARINDEX(' ', received_vesting_shares)-1) as Decimal(20,6))) 
- sum(cast(substring(delegated_vesting_shares, 1, CHARINDEX(' ', delegated_vesting_shares)-1) as Decimal(20,6)))
from accounts
where name not in (
'buildawhale',
'boomerang',
'minnowbooster',
'minnowhelper',
'lovejuice',
'sneaky-ninja',
'appreciator',
'pushup',
'aksdwi',
'msp-bidbot',
'upme',
'postpromoter',
'upgoater',
'allaz',
'smartsteem',
'mercurybot',
'upmewhale',
'sleeplesswhale',
'steembloggers',
'adriatik',
'seakraken',
'voterunner',
'bid4joy',
'nado.bot',
'shares',
'whalebuilder',
'redlambo',
'inciter',
'therising',
'luckyvotes',
'postdoctor',
'brupvoter',
'isotonic',
'chronocrypto',
'spydo',
'onlyprofitbot',
'mitsuko',
'sunrawhale',
'foxyd',
'honestbot',
'upboater',
'promobot',
'ebargains',
'dailyupvotes',
'bluebot',
'estream.studios',
'singing.beauty',
'megabot',
'slimwhale',
'lightningbolt',
'booster',
'thebot',
'minnowvotes',
'estabond',
'rocky1',
'dolphinbot',
'lost-ninja',
'redwhale',
'noicebot',
'flymehigh',
'authors.league',
'brandonfrye',
'peace-bot',
'fishbaitbot',
'bodzila',
'lrd',
'proffit',
'emperorofnaps',
'dlivepromoter',
'pushbot',
'ubot',
'steemerap',
'profitvote',
'cabbage-dealer',
'siditech',
'automation',
'ecotrain',
'themoneytree',
'profitbot',
'whalecreator',
'botox',
'oceanwhale',
'edensgarden',
'bearwards',
'th3voter',
'ptbot',
'sureshot',
'stef',
'moneymatchgaming',
't50',
'francophonie',
'votepower',
'peoplesbot',
'steemcreators',
'joeparys',
'whalepromobot',
'alfanso',
'haveaheart',
'brotherhood',
'tainika',
'pwrup',
'upyourpost',
'jerrybanfield',
'boinger',
'a-bot',
'alliedforces',
'weupvote',
'getkarma',
'chronoboost'
)

The result is 344,466,605,247.887549 Vests, or 169,663,397.8027 Steem Power.

All that is left now is to determine what percentage of total Steem Power is 21,240,294.1576 Steem Power.

21,240,294.1576 (21,240,294.1576 + 169,663,397.8027) = 11.112%.

This number will change a little when you factor in bots who execute votes via a users account (like MinnowBooster and SteemMarket) but won't be too far off.