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…

  • armbrar
    link
    English
    11 year ago

    I totally missed this post! Thanks for sharing, I’ll dive in later today.

    also, does your post end with “I’m using…” or is it cut off? just want to check and make sure Lemmy didn’t do anything screwy