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…
that’s how it ends.