← Back to the library

ARCHIVE ENTRY / 75Data & charts

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

u/G_KG4 min readView original post ↗

Historical community research · 2021 The author’s claims and predictions are preserved as written. This is historical material, not current financial advice.

DD 👨‍🔬

Edit/Update: Thank you for the love and awards!!! I have posted a question about this to Dr. Timbrath’s AMA, here, 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. 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 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.

Original source image. Select to enlarge. 75 / 13126
Original source image. Select to enlarge.

fidelity loves acronyms

First, let me show you some “controls;” aka super “boring” stocks that we are assuming are NOTmanipulated 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....

Original source image. Select to enlarge. 75 / 13131
Original source image. Select to enlarge.

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-

Original source image. Select to enlarge. 75 / 13137
Original source image. Select to enlarge.

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:

Original source image. Select to enlarge. 75 / 13141
Original source image. Select to enlarge.

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:

Original source image. Select to enlarge. 75 / 13145
Original source image. Select to enlarge.

some ETF action

Original source image. Select to enlarge. 75 / 13147
Original source image. Select to enlarge.

dark pools and options

Original source image. Select to enlarge. 75 / 13149
Original source image. Select to enlarge.

dark pool party

Original source image. Select to enlarge. 75 / 13151
Original source image. Select to enlarge.

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:

Original source image. Select to enlarge. 75 / 13154
Original source image. Select to enlarge.

happy spreadsheet!

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

Original source image. Select to enlarge. 75 / 13157
Original source image. Select to enlarge.

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.

Original source image. Select to enlarge. 75 / 13161
Original source image. Select to enlarge.

I ate a lot of crayons later that night

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

Original source image. Select to enlarge. 75 / 13164
Original source image. Select to enlarge.

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:

Original source image. Select to enlarge. 75 / 13168
Original source image. Select to enlarge.

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:

Original source image. Select to enlarge. 75 / 13172
Original source image. Select to enlarge.

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:

Original source image. Select to enlarge. 75 / 13177
Original source image. Select to enlarge.
Original source image. Select to enlarge. 75 / 13178
Original source image. Select to enlarge.

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.

You’ve reached the end of this entry.

View original post ↗
Open full-size image ↗
Original source image. Select to enlarge.

20 languages to explore

Language

The starting language is based on your approximate country when available. Your chosen language is remembered in this browser for one year using a preference cookie.

العربيةArabic简体中文Chinese (Mandarin, Simplified)繁體中文Chinese (Mandarin, Traditional)NederlandsDutchEnglishEnglish (UK)FrançaisFrenchDeutschGermanहिन्दीHindiBahasa IndonesiaIndonesianItalianoItalian日本語Japanese한국어KoreanPolskiPolishPortuguêsPortuguese (Brazil)РусскийRussianEspañolSpanish (Spain)ไทยThaiTürkçeTurkishУкраїнськаUkrainianTiếng ViệtVietnamese