DRS Your GME

1232 readers

1 users here now

ΔΡΣ Central

Community to discuss the DRSGME.org project and resources, and how to spread DRS advocacy and information to GameStop investors around the world.

Have a great idea to spread the word? There are some resources here to get started!

https://www.drsgme.org/free-resources

founded 2 years ago

MODERATORS

[email protected]

That seismic chart I'd seen floating around on stonk.. (lemmy.whynotdrs.org)

submitted 2 years ago by [email protected] to c/[email protected]

10 comments fedilink hide all child comments

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..

top 9 comments

sorted by: hot top controversial new old

[–] [email protected] 2 points 2 years ago (1 children)

if you ever update the data/graphs, I made a community for Data I'd love for you to share it in!

[–] [email protected] 2 points 2 years ago

I just did. :)

[–] [email protected] 0 points 2 years ago (1 children)

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

[–] [email protected] 1 points 2 years ago

that's how it ends.

[–] [email protected] 0 points 2 years ago (1 children)

That's the graph I get from this formula in Excel: =([@[Close/Last]]-[@Open])/(0.5*([@[Close/Last]]+[@Open])/[@Volume]/(1*10^-8))

[–] [email protected] 1 points 2 years ago (1 children)

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?

[–] [email protected] 1 points 2 years ago (1 children)

yes. See further down this chain of replies to myself.

[–] [email protected] 1 points 2 years ago (1 children)

Yup, I thought so, just wanted to err on the side of confirming rather than silence, and to have a nice lemmy chat :)

[–] [email protected] 1 points 2 years ago

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.

load more comments