Skip Navigation

Seismic Graph and data update 20230629

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!

3

You're viewing a single thread.

3 comments
  • 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