this post was submitted on 29 Jun 2023
3 points (100.0% liked)

Data and Glitches

4 readers
1 users here now

GameStop Data, Tables, and Glitches

founded 1 year ago
MODERATORS
 

Updating with additional info. I had hashed out what the other poster(s) on /stonk had done to get this seismic graph print out for price volatility as related to daily volume over time. Here's an update on the graph excel produces over the life of GME:

Zoomed in to just the past months since Jan 2023:

The function it uses to calculate (B4, in this cell, is the previous day's Close price):

=([@[Close/Last]]-B4)/(0.5*([@[Close/Last]]+B4))/[@Volume]*100000000

A sample of the data (the bulk of it was pulled from yahoo finance historic data, I go in daily and update the new day's data manually):

I've been considering adding in some indicators on this.. but I'm not real sure what, if any, would help to make any inferences.. maybe some moving averages? I'm open to any suggestions.

Peace.

Buy, Hodl, DRS.

No Cell? NO SELL!

top 3 comments
sorted by: hot top controversial new old
[–] [email protected] 1 points 1 year ago

Wow, this graph really shows that DRS is working, just as foretold in the DD. It's real nice to actually see it in action.

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago) (1 children)

Thank you for posting this!

pro tip on the chart, to decrease the thickness of the line to make it a bit more legible, right click on the line and select "Format Data Series"

then select the first icon and adjust width

[–] [email protected] 1 points 1 year ago

oh that's waaay better. thanks.