So… I have an Excel workbook that I’ve been tracking gme and my investment in since January. Right now it’s using the stock symbol data type to update open/close/high/low/etc along with my total investment and current holdings value. Has some pretty graphs and such… anyway, I downloaded the historic chart to get real volumes and not just where I cut it off for the day before going home and tried to make a graph like the seismic one that gets posted to stonk… basically a ratio between high and low values for the day and volume… the ones posted on stonk make a nice, increasingly volatile line, for the most part. I wrote my formula for the calculation the exact way they describe in the poat where they talked about revsions to their calculation, but the graph for mine only looks like a huge spike right at the sneeze and goes back to pretty much zero after that…

Has anyone else tried to recreate that graph? Or even recall having seen it?

When I get to work in the morning, I can post a screenshot of the graph i get and the formula I’m using…

  • doing_donutsOP
    link
    fedilink
    English
    arrow-up
    2
    ·
    1 year ago

    It obviously doesn’t look even remotely like this one floating around on /stonk… (search “seismic” on /stonk to find the discussions about it)

    • doing_donutsOP
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      I guess my issue is that I wasn’t using the previous close… This formula gets close… but it’s still not quite the same:

      =((B3-[@[Close/Last]])/(0.5*([@Open]+B3)))/[@Volume]

      B3 is the previous close.

      Sample of my data: Date Close/Last Volume Open High Low Volatility 6/15/2023 $24.84 5473100 $25.41 $26.17 $24.64 0.0000000061487832 6/14/2023 $25.70 7230900 $25.41 $26.17 $24.64 0.0000000066031021 6/13/2023 $26.95 17137000 $26.20 $27.65 $25.03 -0.0000000061242046 6/12/2023 $24.30 7131400 $22.85 $24.30 $22.74 -0.0000000099786678 6/9/2023 $22.68 10321200 $21.78 $23.43 $21.50 -0.0000000055595127 6/8/2023 $21.44 19213300 $20.30 $22.00 $20.10 0.0000000104745010 6/7/2023 $26.11 18001100 $26.20 $26.55 $25.07 -0.0000000031001795 6/6/2023 $24.69 3954600 $24.01 $25.25 $24.00 -0.0000000039772611 6/5/2023 $24.31 4193200 $24.53 $25.84 $24.16 0.0000000032010920 6/2/2023 $24.64 3293100 $24.29 $24.93 $24.28 -0.0000000067774015