PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul
===================================================================================

| Author       | Source       | 
| :-------------: |:-------------:|
|  [u/G_KG](https://www.reddit.com/user/G_KG/) | [Reddit](https://www.reddit.com/r/Superstonk/comments/n0a0hf/proof_of_artificial_price_movement_spreadsheets/) | 

---


[DD 👨‍🔬](https://www.reddit.com/r/Superstonk/search?q=flair_name%3A%22DD%20%F0%9F%91%A8%E2%80%8D%F0%9F%94%AC%22&restrict_sr=1)

Edit/Update: Thank you for the love and awards!!! I have posted a question about this to Dr. Timbrath's AMA, [here](https://www.reddit.com/r/Superstonk/comments/mzknu6/official_ama_dr_susanne_trimbath_phd_thursday/gw7acv0?utm_source=share&utm_medium=web2x&context=3), if anyone else is interested on her opinion of this.

Apes, our primate community has gone through a lot in the last 4 months. We've been called names, lied to, and manipulated through the same PsyOps techniques typically used on extremist groups. Throughout everything you beautiful people have remained stubborn and hyper-rational while never losing your love of crayons, and I have never been more proud to be an ape. Therefore, before we completely undress GME time and sales data, I would like to dedicate this research to:

Shills. Thank you shills everywhere, for making this research possible.

You've made sure I stay good and motivated (pissed off) by harassing my online friends, name-calling good people for no reason, and attacking my computer with malware after every stats-based post I've made public. (I may an idiot, but after the third time this happened, I was fairly sure it wasn't random bad luck.) Thanks for the 100s of subscriptions to random-ass pron sites, much appreciated. You've also provided LITERALLY the best peer-review system I've ever experienced. Never has someone caught my tiny mistakes SO quickly- your hard work and diligence has enabled me to very quickly correct and refine my research, drastically improving the quality of the final product. THANKS.

NOW, time to strip time and sales data down to nothing but binary code and statistics. All methods, raw datasets, and completed analyses can be found here: [Materials, Methods, and Madness](https://www.reddit.com/user/G_KG/comments/mwckki/detecting_monkey_business_materials_and_methods/). Briefly: I have created a spreadsheet analysis that runs on only one source of data, time and sales, exported from Fidelity Active Trader Pro. The spreadsheet reports whether each trade had a POSITIVE or NEGATIVE effect on the price, and thus designates the trade a "BUY" or a "SELL." Many trades have no effect on the price: these shares have been included in the total counts but not towards any buy or sell total. This is an imperfect method to calculating total buy and sell volume, but as you will see, correlates well to overall price movement of the stock and therefore provides a statistically significant buy:sell ratio that we can use. The opening and closing prices are summed, and if the overall price movement does not match the net buy/sell pressure, the spreadsheed tells you IN REALLY BIG LETTERS. The spreadsheet also flags trades priced outside the bid-ask range, with a special check for prices that are crazy high (to catch odd price spikes as I did in [my first rant with statistics](https://www.reddit.com/r/Superstonk/comments/mvzj1f/price_anomalies_are_real_spreadsheet_analysis/) here). I also have it check for "odd lots" from options-based exchanges- if a trade comes from a bid or ask exchange that specializes in options only, it should really be 100 shares traded or a multiple (1 options contract = 100 shares). I've relaxed the tolerance a bit, and the check is only for things that are non-divisible by 10 originating from an options-based trade.

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/mfxrzw5idvv61.png?width=248&format=png&auto=webp&s=00273ee93764d1245e198aa32048dca8bd2c2619)](https://preview.redd.it/mfxrzw5idvv61.png?width=248&format=png&auto=webp&s=00273ee93764d1245e198aa32048dca8bd2c2619)

fidelity loves acronyms

First, let me show you some "controls;" aka super "boring" stocks that we are assuming are NOT manipulated and therefore do NOT have artificial price movement: their price movement is natural and expected based on buy and sell volumes. And the most boring stock prize goes to....

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/l3asexnldvv61.png?width=1092&format=png&auto=webp&s=3f91e2414449f35170a991454bb641dc5ff8334f)](https://preview.redd.it/l3asexnldvv61.png?width=1092&format=png&auto=webp&s=3f91e2414449f35170a991454bb641dc5ff8334f)

Nokia of course!!

This is the "summary sheet" that gets printed with all the nifty info. This is what "normal" looks like- more buy volume than sell volume detected matches with the closing price going up. Pathetically small number of trades were flagged as unusual, all having to do with odd lots being traded by options exchanges. Looks good. Next control, the SPY-

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/kra2b9dsdvv61.png?width=1127&format=png&auto=webp&s=8c018ac8a92ff1b2f5c712043a1563072f7fe95d)](https://preview.redd.it/kra2b9dsdvv61.png?width=1127&format=png&auto=webp&s=8c018ac8a92ff1b2f5c712043a1563072f7fe95d)

wait what

Everything looks great, happy spreadsheet, except for four really weird trades I totally did not expect to find. Here's the full mind-fuck analysis on this data:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/4ggf4tb1evv61.png?width=1960&format=png&auto=webp&s=f7b624928360652e0d3931742c8d277264d9df50)](https://preview.redd.it/4ggf4tb1evv61.png?width=1960&format=png&auto=webp&s=f7b624928360652e0d3931742c8d277264d9df50)

color-coded fuckery!

The "main offenders" are listed at the bottom- Options and dark pools. This is my surprised face. Let's look at those crazy prices up close:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/ybdxyphjevv61.png?width=774&format=png&auto=webp&s=7ee75133cfce6484723a94858c43258815346a7a)](https://preview.redd.it/ybdxyphjevv61.png?width=774&format=png&auto=webp&s=7ee75133cfce6484723a94858c43258815346a7a)

some ETF action

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/6pticp4mevv61.png?width=777&format=png&auto=webp&s=388a01573b0735b7e291afed6d3dee41d9baee12)](https://preview.redd.it/6pticp4mevv61.png?width=777&format=png&auto=webp&s=388a01573b0735b7e291afed6d3dee41d9baee12)

dark pools and options

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/1grnfzdoevv61.png?width=777&format=png&auto=webp&s=3668ecf3b347eeab6406ea494d165655b7d3cfca)](https://preview.redd.it/1grnfzdoevv61.png?width=777&format=png&auto=webp&s=3668ecf3b347eeab6406ea494d165655b7d3cfca)

dark pool party

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/cq0xp3cqevv61.png?width=786&format=png&auto=webp&s=b78aa58f3d8a5144cac028d4723b883c21375e6d)](https://preview.redd.it/cq0xp3cqevv61.png?width=786&format=png&auto=webp&s=b78aa58f3d8a5144cac028d4723b883c21375e6d)

Can I please have shares for $20 under the going price?? I said please.

Except for those crazy trades, pretty normal. Here's another SPY, this time from 4/26:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/6y1mpi9zevv61.png?width=1127&format=png&auto=webp&s=1a79efed30fed6127f34bfd7b9ac3d18fa2072ae)](https://preview.redd.it/6y1mpi9zevv61.png?width=1127&format=png&auto=webp&s=1a79efed30fed6127f34bfd7b9ac3d18fa2072ae)

happy spreadsheet!

No wacky trades on this day for the SPY. How about one more control analysis:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/r78vp364fvv61.png?width=1127&format=png&auto=webp&s=de13233086dafd1e43d545783604a89579aca061)](https://preview.redd.it/r78vp364fvv61.png?width=1127&format=png&auto=webp&s=de13233086dafd1e43d545783604a89579aca061)

Overall, more shares detected were sold than bought, and the price for the day went down. Lovely! Now, on to the main event. Let's plug and chug some GME! We start with 4/12. Why? Because I was pissed that day.

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/1vyo6cyefvv61.png?width=1037&format=png&auto=webp&s=f66625bceaeadd317c8b79528d5958a9e621990c)](https://preview.redd.it/1vyo6cyefvv61.png?width=1037&format=png&auto=webp&s=f66625bceaeadd317c8b79528d5958a9e621990c)

I ate a lot of crayons later that night

So I was very interested in looking at this dataset. Lo and behold....

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/916ot1cmfvv61.png?width=1127&format=png&auto=webp&s=858129070b215598da23a57a784c56cc96f1484b)](https://preview.redd.it/916ot1cmfvv61.png?width=1127&format=png&auto=webp&s=858129070b215598da23a57a784c56cc96f1484b)

more surprise face

My beautiful spreadsheet telling me exactly what my eyes saw that day. There were more shares bought than sold, yet somehow the price drops $17. Queue mind-fuck:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/ivmrjsh3gvv61.png?width=2024&format=png&auto=webp&s=e31fd587bc5474035ab029a9cf825e3625a29ccb)](https://preview.redd.it/ivmrjsh3gvv61.png?width=2024&format=png&auto=webp&s=e31fd587bc5474035ab029a9cf825e3625a29ccb)

EDGX and dark pool buddies. But of course. These high numbers make me giggle, which offsets some of the freshly pissed-off I am at this concentrated fuckery. I know your brains are tender, but how about one last GME analysis- 4/21 because dyslexia:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/kn9d95nlgvv61.png?width=1127&format=png&auto=webp&s=f7d0f2c14c49886035922cc7388704858676fef2)](https://preview.redd.it/kn9d95nlgvv61.png?width=1127&format=png&auto=webp&s=f7d0f2c14c49886035922cc7388704858676fef2)

omfg?

Well $28 outside the bid-ask range seems..... excessive? That's like if some dude said "I'll sell this thing for $158," everyone agrees, and then somehow he gets $186. Why doesn't my life work like that? Let's see all of these crazy trades up close:

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/sb3ee192hvv61.png?width=778&format=png&auto=webp&s=7827df5d1a3a34bf556762b6d0d3b1ffa63ad606)](https://preview.redd.it/sb3ee192hvv61.png?width=778&format=png&auto=webp&s=7827df5d1a3a34bf556762b6d0d3b1ffa63ad606)

[![r/Superstonk - PROOF of Artificial Price Movement: Spreadsheets with Statistics to Soothe the Soul](https://preview.redd.it/5on6gfv2hvv61.png?width=776&format=png&auto=webp&s=178400aad26bf5189a509760e8947da9e7bdd544)](https://preview.redd.it/5on6gfv2hvv61.png?width=776&format=png&auto=webp&s=178400aad26bf5189a509760e8947da9e7bdd544)

nothing to see here?

That's all I've got for today. But now that I've got my spreadsheets all set up, I think I will continue to post revealing statistics until GME blasts off to the moon. Seems like a good way to pass the time?? 😈

TLDR: Either the matrix is glitching out or there's some really fucky shit going on.🚀🚀🚀

Selling puts on my computer's CPU.
