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…
You must log in or register to comment.
if you ever update the data/graphs, I made a community for Data I’d love for you to share it in!
I just did. :)
That’s the graph I get from this formula in Excel: =([@[Close/Last]]-[@Open])/(0.5*([@[Close/Last]]+[@Open])/[@Volume]/(1*10^-8))
Seems like due to division order of operations, you somehow got volume into the numerator, and they are probably doing the opposite. Did you get it all worked out?
yes. See further down this chain of replies to myself.
Yup, I thought so, just wanted to err on the side of confirming rather than silence, and to have a nice lemmy chat :)
word. yah… I’m not too sure if this is an indicator of anything… but seeing as how the magnitude of it increased and then died down before the sneeze, and has gotten progressively greater since then, I thought it wouldn’t hurt to track it on my own, too.
It obviously doesn’t look even remotely like this one floating around on /stonk… (search “seismic” on /stonk to find the discussions about it)
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:
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
that’s how it ends.
