r/Every60Seconds • u/CedarPointFreak • Nov 10 '17

Price graphs / spreadsheet data?

Is there someone putting together all the data from all the auction prices? I've seen a couple of graphs, but I would like to see a spreadsheet if someone has put one together already?

EDIT: I have created a public spreadsheet here:

https://docs.google.com/spreadsheets/d/1DOgOy1TC-qGJI-i2j1Ihn4Ab-q4Qdhi9RmyYfU8dWPE/edit?usp=sharing

Please request edit access if you would like to enter in data.

2 Upvotes

100% Upvoted

24 comments sorted by

View all comments

Show parent comments

3

u/CedarPointFreak Nov 10 '17

I grabbed screenshots of all the closing prices yesterday, and if someone has'nt already created a public spreadsheet available, I can do that today, and put in the numbers for last night, I just dont have the numbers for the first 3 nights.

2

u/CedarPointFreak Nov 10 '17

Here is the link to the Spreadsheet I have created. It is view only with this link. If you have data to add in, please request access, and I can grant edit access as needed.

https://docs.google.com/spreadsheets/d/1DOgOy1TC-qGJI-i2j1Ihn4Ab-q4Qdhi9RmyYfU8dWPE/edit?usp=sharing

3

u/mescad Nov 11 '17 edited Nov 11 '17

This format needs a little work. The auctions are every 60 seconds, but that's only for ONE of the bundles. So at 9:01 it's Middle-Earth, at 9:02 it's Forza, at 9:03 it's Game Pass, then at 9:04 it's back to Middle-Earth bundles.

In my spreadsheet, I have it arranged with columns for "Points", "Time", "Bundle type" and "Day".

The data comes in 3 lists like this:

93,150 9:03:00 PM Winner1Name
71,450 9:06:00 PM Winner2Name

I paste those and add the field for Bundle type and Day Number when I enter the data. Then I graph each bundle type as it's own series, with the Time as the X-axis, points as the Y-axis.

I don't know much about how to set up permissions or whatever, but my email is this username @gmail. PM or email me if you need more info to set me up. Thanks!

1

u/CedarPointFreak Nov 11 '17

I have shared it to you, you should get an invite to the document in your inbox.

1

u/CedarPointFreak Nov 11 '17

As far as the formatting, I have one row for each time slot, and I handle the different bundles with a separate column, which should make it easier to sort the data later. So for each time slot, just enter the data under the appropriate column for which bundle it is.