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…
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
Fixed: